RELATIONSHIP - Report
| Data Element |
Business Definition |
Data Type |
Source Name |
Source Data Element |
Form Name |
| ENTITY_UID |
SYSTEM INTERNALLY GENERATED TO UNIQUELY IDENTIFY THE PERSON OR ENTITY. |
|
APRCHLD |
APRCHLD_PIDM |
UNKNOWN |
| ENTITY_UID |
SYSTEM INTERNALLY GENERATED TO UNIQUELY IDENTIFY THE PERSON OR ENTITY. |
|
APRCSPS |
APRCSPS_PIDM |
UNKNOWN |
| ENTITY_UID |
SYSTEM INTERNALLY GENERATED TO UNIQUELY IDENTIFY THE PERSON OR ENTITY. |
|
APRXREF |
APRXREF_PIDM |
UNKNOWN |
| RELATION_TYPE_IND |
|
|
FUNCTION |
? |
UNKNOWN |
| RELATED_UID |
SYSTEM INTERNALLY GENERATED TO UNIQUELY IDENTIFY THE PERSON OR ENTITY. |
|
APRCHLD |
APRCHLD_CHLD_PIDM |
UNKNOWN |
| RELATED_UID |
SYSTEM INTERNALLY GENERATED TO UNIQUELY IDENTIFY THE PERSON OR ENTITY. |
|
APRCSPS |
APRCSPS_SPS_PIDM |
UNKNOWN |
| RELATED_UID |
SYSTEM INTERNALLY GENERATED TO UNIQUELY IDENTIFY THE PERSON OR ENTITY. |
|
APRXREF |
APRXREF_XREF_PIDM |
UNKNOWN |
| RELATED_CROSS_REFERENCE |
USED TO IDENTIFY THE CROSS REFERENCE RECORD RELATIONSHIP CREATED FOR THE IDENTIFICATION AND RELATED IDENTIFICATION. |
|
APRCHLD |
APRCHLD_XREF_CODE |
UNKNOWN |
| RELATED_CROSS_REFERENCE |
USED TO IDENTIFY THE CROSS REFERENCE RECORD RELATIONSHIP CREATED FOR THE IDENTIFICATION AND RELATED IDENTIFICATION. |
|
APRCSPS |
APRCSPS_XREF_CODE |
UNKNOWN |
| RELATED_CROSS_REFERENCE |
USED TO IDENTIFY THE CROSS REFERENCE RECORD RELATIONSHIP CREATED FOR THE IDENTIFICATION AND RELATED IDENTIFICATION. |
|
APRXREF |
APRXREF_XREF_CODE |
UNKNOWN |
| RELATED_REFERENCE_DESC |
SPECIFIES THE NAME OF THE CROSS REFERENCE CODE. |
|
ATVXREF |
ATVXREF_DESC |
UNKNOWN |
| REVERSE_CROSS_REFERENCE |
SPECIFIES THE REVERSE OF THE INITIAL REFERENCE |
|
ATVXREF |
ATVXREF_REVERSE_XREF |
UNKNOWN |
| REVERSE_REFERENCE_DESC |
NAME OF THE CROSS REFERENCE CODE. |
|
ATVXREF |
ATVXREF_DESC |
UNKNOWN |
| RELATED_PREFIX |
PREFIX TO THE NAME OF THE RELATED PERSON. |
|
APRCSPS |
APRCSPS_NAME_PREFIX |
UNKNOWN |
| RELATED_PREFIX |
PREFIX TO THE NAME OF THE RELATED PERSON. |
|
APRCSPS |
NOT AVAILABLE |
UNKNOWN |
| RELATED_PREFIX |
PREFIX TO THE NAME OF THE RELATED PERSON. |
|
SPBPERS |
SPBPERS_NAME_PREFIX |
UNKNOWN |
| RELATED_FIRST_NAME |
FIRST NAME OF THE RELATED PERSON. |
|
APRCHLD |
APRCHLD_FIRST_NAME |
UNKNOWN |
| RELATED_FIRST_NAME |
FIRST NAME OF THE RELATED PERSON. |
|
SPRIDEN |
SPRIDEN_FIRST_NAME |
UNKNOWN |
| RELATED_FIRST_NAME |
FIRST NAME OF THE RELATED PERSON. |
|
APRCSPS |
APRCHLD_FIRST_NAME |
UNKNOWN |
| RELATED_MIDDLE_INITIAL |
MIDDLE NAME OF THE RELATED PERSON. |
|
APRCHLD |
NOT AVAILABLE |
UNKNOWN |
| RELATED_MIDDLE_INITIAL |
MIDDLE NAME OF THE RELATED PERSON. |
|
FUNCTION |
SPRIDEN_MIDDLE_NAME |
UNKNOWN |
| RELATED_MIDDLE_INITIAL |
MIDDLE NAME OF THE RELATED PERSON. |
|
APRCSPS |
APRCHLD_MI |
UNKNOWN |
| RELATED_LAST_NAME |
LAST NAME OF THE RELATED PERSON OR THE RELATED ORGANIZATION NAME. |
|
APRCHLD |
APRCHLD_LAST_NAME |
UNKNOWN |
| RELATED_LAST_NAME |
LAST NAME OF THE RELATED PERSON OR THE RELATED ORGANIZATION NAME. |
|
APRCSPS |
NOT AVAILABLE |
UNKNOWN |
| RELATED_LAST_NAME |
LAST NAME OF THE RELATED PERSON OR THE RELATED ORGANIZATION NAME. |
|
SPRIDEN |
SPRIDEN_LAST_NAME |
UNKNOWN |
| RELATED_SUFFIX |
SUFFIX FOR THE RELATED PERSON. |
|
APRCSPS |
APRCSPS_NAME_SUFFIX |
UNKNOWN |
| RELATED_SUFFIX |
SUFFIX FOR THE RELATED PERSON. |
|
SPBPERS |
SPBPERS_NAME_SUFFIX |
UNKNOWN |
| RELATED_SUFFIX |
SUFFIX FOR THE RELATED PERSON. |
|
SPRIDEN |
NOT AVAILABLE |
UNKNOWN |
| RELATED_COMBINED_NAME |
FULL NAME OF THE PERSON OR ENTITY THAT HAS A RELATIONSHIP TO THE PERSON OR ENTITY FOR THIS RECORD. |
|
FUNCTION |
2ND FUNCTION? |
UNKNOWN |
| RELATED_COMBINED_NAME |
FULL NAME OF THE PERSON OR ENTITY THAT HAS A RELATIONSHIP TO THE PERSON OR ENTITY FOR THIS RECORD. |
|
FUNCTION |
3RD FUNCTION? |
UNKNOWN |
| RELATED_COMBINED_NAME |
FULL NAME OF THE PERSON OR ENTITY THAT HAS A RELATIONSHIP TO THE PERSON OR ENTITY FOR THIS RECORD. |
|
FUNCTION |
? |
UNKNOWN |
| RELATED_BIRTH_DATE |
DATE OF BIRTH RECORDED FOR THE RELATED PERSON. |
|
SPRIDEN |
SPRIDEN_BIRTH_DATE |
UNKNOWN |
| RELATED_DECEASED_IND |
INDICATES THE PERSON WITH THE RELATIONSHIP IS DECEASED. |
|
APRCHLD |
APRCHLD_DECEASED_IND |
UNKNOWN |
| RELATED_DECEASED_IND |
INDICATES THE PERSON WITH THE RELATIONSHIP IS DECEASED. |
|
APRCSPS |
APRCSPS_DEAD_IND |
UNKNOWN |
| RELATED_DECEASED_IND |
INDICATES THE PERSON WITH THE RELATIONSHIP IS DECEASED. |
|
SPAPERS |
SPBPERS_DEAD_IND |
UNKNOWN |
| RELATED_DECEASED_DATE |
DATE ON WHICH THE RELATED PERSON DIED. |
|
APRCHLD |
APRCHLD_DECEASED_DATE |
UNKNOWN |
| RELATED_DECEASED_DATE |
DATE ON WHICH THE RELATED PERSON DIED. |
|
SPBPERS |
SPBPERS_DEAD_DATE |
UNKNOWN |
| RELATED_DECEASED_DATE |
DATE ON WHICH THE RELATED PERSON DIED. |
|
APRCSPS |
APRCSPS_DEAD_DATE |
UNKNOWN |
| RELATED_GENDER |
SEX RECORDED FOR THE RELATED PERSON. VALUES ARE M FOR MALE AND F FOR FEMALE OR N FOR NOT REPORTED. |
|
SPAPERS |
SPBPERS_GENDER |
UNKNOWN |
| RELATED_GENDER_DESC |
"M FOR MALE, F FOR FEMALE" |
|
FUNCTION |
NOT AVAILABLE |
UNKNOWN |
| RELATED_ID |
IDENTIFICATION NUMBER RECORDED FOR THE RELATED PERSON. |
|
APRCHLD |
? |
UNKNOWN |
| RELATED_ID |
IDENTIFICATION NUMBER RECORDED FOR THE RELATED PERSON. |
|
APRCSPS |
? |
UNKNOWN |
| RELATED_ID |
IDENTIFICATION NUMBER RECORDED FOR THE RELATED PERSON. |
|
SPRIDEN |
SPRIDEN_ID |
UNKNOWN |
| RELATED_TAX_ID |
TAX IDENTIFICATION NUMBER FOR THE RELATED PERSON. |
|
SPBPERS |
SPBPERS_SSN |
UNKNOWN |
| RELATED_ADDRESS_TYPE |
ADDRESS TYPE TO USED WHEN CORRESPONDING WITH THE RELATED PERSON. |
|
APRCHLD |
APRCHLD_ATYP_CODE |
UNKNOWN |
| RELATED_ADDRESS_TYPE_DESC |
DESCRIPTION ASSOCIATED WITH THE RELATED PERSON'S ADDRESS TYPE CODE. |
|
STVATYP |
STVATYP_DESC |
UNKNOWN |
| RELATED_COMMENT |
|
|
APRCHLD |
APRCHLD_SPS_COMMENT |
UNKNOWN |
| RELATED_COMMENT |
|
|
APRCSPS |
APRCSPS_SPS_COMMENT |
UNKNOWN |
| PRIMARY_IND |
RELATIONSHIP OF THE INTERNAL ID TO THE CROSS REFERENCE INTERNAL ID FOR SPOUSAL RELATIONS. |
|
APRXREF |
APRXREF_CM_PRI_IND |
UNKNOWN |
| SPOUSE_IND |
SPECIFIES THE REVERSE OF THE INITIAL REFERENCE |
|
ATVXREF |
ATVXREF_SPOUSE_IND |
UNKNOWN |
| RELATED_MAIDEN_NAME |
MAIDEN NAME OF THE RELATED PERSON. |
|
APRCSPS |
APRCSPS_MAIDEN_NAME |
UNKNOWN |
| RELATED_MAIDEN_NAME |
MAIDEN NAME OF THE RELATED PERSON. |
|
FUNCTION |
SPRIDEN_LAST_NAME |
UNKNOWN |
| MARRIAGE_STATUS_IND |
MARRIAGE STATUS INDICATOR. VALID VALUES ARE A FOR ACTIVE AND I FOR INACTIVE. EACH CONSTITUENT IS ALLOWED ONLY ONE SPOUSE RECORD WITH A MARRIAGE STATUS OF A. |
|
APRCSPS |
APRCSPS_MARS_IND |
UNKNOWN |
| MARITAL_STATUS |
MARITAL STATUS CODE OF THE PERSON. |
|
SPBPERS |
SPBPERS_MRTL_CODE |
UNKNOWN |
| MARITAL_STATUS_DESC |
DESCRIPTION FOR THE MARITAL STATUS OF THE PERSON. |
|
STVMRTL |
STVMRTL_DESC |
UNKNOWN |
| MARRIAGE_START_DATE |
START DATE OF THE MARRIAGE. |
|
APRCSPS |
APRCSPS_MRTL_START_DATE |
UNKNOWN |
| MARRIAGE_END_DATE |
END DATE OF THE MARRIAGE. IT WILL DEFAULT TO THE CURRENT DATE WHEN AN INACTIVE STATUS IS ENTERED. IT IS BLANK FOR ACTIVE MARRIAGES. |
|
APRCSPS |
APRCSPS_MRTL_END_DATE |
UNKNOWN |
| CHILD_ORDER_NUMBER |
INTERNAL SEQUENCE NUMBER. |
|
APRCHLD |
APRCHLD_SEQ_NO |
UNKNOWN |
| EMPLOYER_IND |
|
|
NA |
NOT AVAILABLE |
UNKNOWN |
| MATCHING_GIFT_IND |
SPECIFIES WHETHER A RELATED REFERENCE HAS A MATCHING GIFT ASSOCIATED WITH IT. |
|
ATVXREF |
ATVXREF_MATCH_GIFT_IND |
UNKNOWN |