Target Column	Business Name	Business Definition	Database Data Type	Domain Value	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(8)		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	Related Child Address 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	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	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	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	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	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	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(8)		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: