Target Column	Business Definition	Database Data Type	Source Name	Source Column
CHILD_ORDER_NUMBER	System generated internal sequence number assigned to the child record. Does not indicate the birth order of a child.	NUMBER	APRCHLD APVCHLD	APRCHLD_SEQ_NO APVCHLD_SEQ_NO
COMBINED_MAILING_PRIORITY	For spousal relations, designates the prioity order in which the cross reference and reverse cross reference names will display for combined mailings. Valid values are P for primary and S for secondary.	VARCHAR2(1)	APRXREF	APRXREF_CM_PRI_IND
COMBINED_MAILING_PRIORITY_DESC	Combined spousal mailing priority description.	VARCHAR2(9)	CALCULATION	DECODE(APRXREF_CM_PRI_IND,'P','PRIMARY','S','SECONDARY')
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)	NA	NA
EMPLOYER_IND	Indicates if this cross reference code represents an employer relation.	VARCHAR2(1)	APVXREF	APVXREF_EMPLOYER_IND
ENTITY_UID	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER	APVCHLD APVCSPS APVXREF	APVCHLD_PIDM APVCSPS_PIDM APVXREF_PIDM
HOUSEHOLD_IND	Indicates if the person associated by this cross reference code resides in the same household as the reverse cross reference.	VARCHAR2(1)	ATVXREF	ATVXREF_HOUSEHOLD_IND
MARITAL_STATUS	Current marital status of the relation.	VARCHAR2(1)	APVCSPS APVXREF	APVCSPS_MRTL_CODE APVXREF_XREF_MRTL_CODE
MARITAL_STATUS_DESC	Marital status description.	VARCHAR2(30)	STVMRTL	STVMRTL_DESC
MARRIAGE_END_DATE	For spousal relations, date the marriage ended.	DATE	APVCSPS	APVCSPS_MRTL_END_DATE
MARRIAGE_START_DATE	For spousal relations, date of the marriage.	DATE	APVCSPS	APVCSPS_MRTL_START_DATE
MATCHING_GIFT_IND	Indicates if this cross referenced employer or organization matches gifts.	VARCHAR2(1)	APVXREF	APVXREF_MATCH_GIFT_IND
MIF_DESC	Institution description for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(30)	NA	NA
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)	NA	NA
RELATED_BIRTH_DATE	Date of birth of the related person.	DATE	APVCHLD APVCSPS APVXREF	APVCHLD_BIRTH_DATE APVCSPS_BIRTH_DATE APVXREF_XREF_BIRTH_DATE
RELATED_CHILD_ADDR_TYPE	For child relations only. The address type of the reverse cross reference where the child resides or for use in corresponding with the child.	VARCHAR2(6)	APRCHLD	APRCHLD_ATYP_CODE
RELATED_CHILD_ADDR_TYPE_DESC	Address type description for the related child.	VARCHAR2(30)	STVATYP	STVATYP_DESC
RELATED_CHILD_TAX_ID	Identification assigned by the federal governtment for tax purposes. For child relations only if the child does not have a separate UID in the source system.	VARCHAR2(15)	APRCHLD SPBPERS	APRCHLD_SSN SPBPERS_SSN
RELATED_COMBINED_NAME	Combined name of the related person (last name, first name, middle name/initial) or name of related organization.	VARCHAR2(183)	APVCHLD APVCSPS APVXREF	APVCHLD_CHLD_NAME APVCSPS_SPOUSE_NAME APVXREF_XREF_FULL_NAME
RELATED_COMMENT	Comments about the relation.	CLOB	APVCHLD APVCSPS	APVCHLD_COMMENT APVCSPS_SPS_COMMENT
RELATED_CROSS_REFERENCE	Defines the relationship between the person or organization to the cross referenced person or organization.	VARCHAR2(3)	APVCHLD APVCSPS APVXREF	APVCHLD_XREF_CODE APVCSPS_XREF_CODE APVXREF_XREF_CODE
RELATED_DECEASED_DATE	Deceased date for the related person.	DATE	APVCHLD APVCSPS APVXREF	APVCHLD_DEAD_DATE APVCSPS_DEAD_DATE APVXREF_XREF_DEAD_DATE
RELATED_DECEASED_IND	Deceased indicator. Y indicates the related person is deceased.	VARCHAR2(1)	APVCHLD APVCSPS APVXREF	APVCHLD_DEAD_IND APVCSPS_DEAD_IND APVXREF_XREF_DEAD_IND
RELATED_FIRST_NAME	First name of the related person.	VARCHAR2(60)	APVCHLD APVCSPS APVXREF	APVCHLD_FIRST_NAME APVCSPS_FIRST_NAME APVXREF_XREF_FIRST_NAME
RELATED_GENDER	Gender of the related person.	VARCHAR2(1)	APVCHLD APVCSPS APVXREF	APVCHLD_SEX APVCSPS_SEX APVXREF_XREF_SEX
RELATED_GENDER_DESC	Gender description of the related person.	VARCHAR2(12)	CALCULATION	DECODE(SPBPERS_SEX,'M','MALE','F','FEMALE','N','NOT REPORTED')
RELATED_LAST_NAME	Last name of the related person or the related organization name.	VARCHAR2(60)	APVCHLD APVCSPS APVXREF	APVCHLD_LAST_NAME APVCSPS_LAST_NAME APVXREF_XREF_LAST_NAME
RELATED_MAIDEN_NAME	Maiden name of a spousal relation.	VARCHAR2(60)	APVCHLD APVCSPS APVXREF	APVCHLD_MAIDEN_NAME APVCSPS_MAIDEN_NAME APVXREF_XREF_MAIDEN_LAST_NAME
RELATED_MATCHING_GIFT_UID	System generated, unique internal identification number assigned to the organization. For organizations that match gifts this will be either the organization's UID or the UID of an alternate/parent organization that matches gifts.	NUMBER	AOBORGN	AOBORGN_MG_PIDM
RELATED_MIDDLE_INITIAL	Middle name or initial of the related person.	VARCHAR2(60)	APVCHLD APVCSPS APVXREF	APVCHLD_MI APVCSPS_MI APVXREF_XREF_MI
RELATED_PREFIX	Prefix associated with the related person's name.	VARCHAR2(20)	APVCHLD APVCSPS APVXREF	AVPCHLS_NAME_PREFIX APVCSPS_NAME_PREFIX APVXREF_XREF_NAME_PREFIX
RELATED_REFERENCE_DESC	Description of the cross reference relationship.	VARCHAR2(30)	ATVXREF	ATVXREF_DESC
RELATED_SUFFIX	Suffix for the related person's name.	VARCHAR2(20)	APVCHLD APVCSPS APVXREF	APVCHLD_NAME_SUFFIX APVCSPS_NAME_SUFFIX APVXREF_XREF_NAME_SUFFIX
RELATED_UID	System generated, unique, internal identification number assigned to this cross referenced person or organization.	NUMBER	APVCHLD APVCSPS APVXREF	APVCHLD_CHLD_PIDM APVCSPS_SPS_PIDM APVXREF_XREF_PIDM
RELATION_SOURCE	Origin of the relationship in the source system. Assigned values include C for child, CX for combined child/cross reference, S for spouse, SX for combined spouse/cross reference and X for cross reference.	VARCHAR2(2)	CONSTANT	SOURCE APRCHLD AND APRXREF THEN 'CX'; SOURCE APRCHLD THEN 'C'; SOURCE APRCSPS AND APRXREF THEN 'SX'; SOURCE APRCSPS THEN 'S'; SOURCE APRXREF THEN 'X'
RELATION_SOURCE_DESC	Description of the origin of the relationship in the source system.	VARCHAR2(22)	CONSTANT	SOURCE APRCHLD AND APRXREF THEN 'CHILD/CROSS REFERENCE'; APRCHLD THEN 'CHILD'; APRCSPS AND APRXREF THEN 'SPOUSE/CROSS REFERENCE'; APRCSPS THEN 'SPOUSE'; APRXREF THEN 'CROSS REFERENCE'
REVERSE_CROSS_REFERENCE	Reverse relationship of the initial cross reference. For example if the cross reference from a person to an organization is employer, the reverse cross reference from the organization to the person is employee.	VARCHAR2(3)	APVXREF	APVXREF_REVERSE_XREF
REVERSE_REFERENCE_DESC	Description of the reverse cross reference relationship.	VARCHAR2(30)	ATVXREF	ATVXREF_DESC
SPOUSE_IND	Indicates if this cross reference code represents a spousal relation.	VARCHAR2(1)	APVXREF	APVXREF_SPOUSE_IND
SPOUSE_STATUS	For spousal relations only. Valid values are for 'A' this is an active spousal relationship, or 'I' this is an inactive spousal relationship.	VARCHAR2(1)	APRCSPS	APRCSPS_MARS_IND
SPOUSE_STATUS_DESC	Spousal relation status description.	VARCHAR2(8)	CALCULATION	DECODE(APRCSPS_MARS_IND,'A','ACTIVE','I','INACTIVE')
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA

Ver: