Target Column	Business Definition	Database Data Type	Source Name	Source Column
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
CHILD_ORDER_NUMBER	System generated internal sequence number assigned to the child record. Does not indicate the birth order of a child.	NUMBER	APRCHLD	APRCHLD_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(63)	APRXREF	APRXREF_CM_PRI_IND
COMBINED_MAILING_PRIORITY_DESC	Combined spousal mailing priority description.	VARCHAR2(255)	CALCULATION	DECODE(APRXREF_CM_PRI_IND,'P','PRIMARY','S','SECONDARY')
EMPLOYER_IND	Indicates if this cross reference code represents an employer relation.	VARCHAR2(1)	APVXREF	APVXREF_EMPLOYER_IND
ENTITY_IND	Indicates whether this entity is a person or organization.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
ENTITY_UID	System generated, unique, internal identification number assigned to this person or organization.	NUMBER	APRCHLD APRCSPS APRXREF	APRCHLD_PIDM APRCSPS_PIDM APRXREF_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)	APRXREF	APRXREF_HOUSEHOLD_IND
ID	Identification number assigned to a person that is used externally for all communication and correspondence with the person.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
MARITAL_STATUS	Current marital status of the relation.	VARCHAR2(63)	SPBPERS	SPBPERS_MRTL_CODE
MARITAL_STATUS_DESC	Marital status description.	VARCHAR2(255)	STVMRTL	STVMRTL_DESC
MARRIAGE_END_DATE	For spousal relations, date the marriage ended.	DATE	APRCSPS	APRCSPS_MRTL_END_DATE
MARRIAGE_START_DATE	For spousal relations, date of the marriage.	DATE	APRCSPS	APRCSPS_MRTL_START_DATE
MATCHING_GIFT_IND	Indicates if this cross referenced employer or organization matches gifts.	VARCHAR2(1)	ATVXREF	ATVXREF_MATCH_GIFT_IND
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
NAME	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
RELATED_BIRTH_DATE	Date of birth of the related person.	DATE	SPBPERS	SPBPERS_BIRTH_DATE
RELATED_CHILD_ADDR_TYPE	For child relations only. If the child has a separate UID in the source system this indicates the child's address associated to thie record, as applicable.	VARCHAR2(63)	APRCHLD	APRCHLD_ATYP_CODE
RELATED_CHILD_ADDR_TYPE_DESC	Address type description for the related child.	VARCHAR2(255)	STVATYP	STVATYP_DESC
RELATED_CHILD_TAX_ID	For child relations only. Identification assigned by the federal governtment for tax purposes.	VARCHAR2(63)	APRCHLD SPBPERS	APRCHLD_SSN SPBPERS_SSN
RELATED_COMBINED_NAME	Combined name of the related person (last name, first name, middle name/initial) or related organization.	VARCHAR2(255)	APVCHLD APVCSPS APVXREF	APVCHLD_CHLD_NAME APVCSPS_SPOUSE_NAME APVXREF_XREF_FULL_NAME
RELATED_COMMENT	Comments about the related child or spouse.	CLOB	APRCHLD APRCSPS	APRCHLD_COMMENT APRCSPS_SPS_COMMENT
RELATED_CROSS_REFERENCE	Defines the relationship between the person or organization to the cross referenced person or organization.	VARCHAR2(63)	APRCHLD APRCSPS APRXREF	APRCHLD_XREF_CODE APRCSPS_XREF_CODE APRXREF_XREF_CODE
RELATED_DECEASED_DATE	Deceased date for the related person.	DATE	APRCHLD APRCSPS SPBPERS	APRCHLD_DECEASED_DATE APRCSPS_DEAD_DATE SPBPERS_DEAD_DATE
RELATED_DECEASED_IND	Deceased indicator, Y indicates the related person is deceased.	VARCHAR2(1)	APRCHLD APRCSPS SPBPERS	APRCHLD_DECEASED_IND APRCSPS_DEAD_IND SPBPERS_DEAD_IND
RELATED_ENTITY_IND	Indicates whether the related entity is a person or organization.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
RELATED_FIRST_NAME	First name of the related person.	VARCHAR2(63)	APRCHLD APRCSPS SPRIDEN	APRCHLD_FIRST_NAME APRCSPS_FIRST_NAME SPRIDEN_FIRST_NAME
RELATED_GENDER	Gender of the related person.	VARCHAR2(63)	SPBPERS	SPBPERS_SEX
RELATED_GENDER_DESC	Gender description of the related person.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
RELATED_ID	Current identification number of the cross referenced person or organization.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
RELATED_LAST_NAME	Last name of the related person or the related organization name.	VARCHAR2(63)	APRCHLD APRCSPS SPRIDEN	APRCHLD_LAST_NAME APRCSPS_LAST_NAME SPRIDEN_LAST_NAME
RELATED_MAIDEN_NAME	Maiden name of a spousal relation.	VARCHAR2(63)	APRCSPS SPRIDEN	APRCSPS_MAIDEN_NAME SPRIDEN_LAST_NAME
RELATED_MATCHING_GIFT_ID	Current identification number of the matching gift organization for the related organization.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
RELATED_MATCHING_GIFT_NAME	Name of the matching gift organization for the related organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
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 of the related person.	VARCHAR2(63)	APRCHLD APRCSPS SPRIDEN	APRCHLD_MI APRCSPS_MI SPRIDEN_MI
RELATED_PREFIX	Prefix associated with the related person's name.	VARCHAR2(63)	APRCSPS SPBPERS	APRCSPS_NAME_PREFIX SPBPERS_NAME_PREFIX
RELATED_REFERENCE_DESC	Description of the cross reference relationship.	VARCHAR2(255)	ATVXREF	ATVXREF_DESC
RELATED_SUFFIX	Suffix for the related person's name.	VARCHAR2(63)	APRCSPS SPBPERS	APRCSPS_NAME_SUFFIX SPBPERS_NAME_SUFFIX
RELATED_UID	System generated, unique, internal identification number assigned to this cross referenced person or organization.	NUMBER	APRCHLD APRCSPS APRXREF	APRCHLD_CHLD_PIDM APRCSPS_SPS_PIDM APRXREF_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(63)	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(255)	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(63)	ATVXREF	ATVXREF_REVERSE_XREF
REVERSE_REFERENCE_DESC	Description of the reverse cross reference relationship.	VARCHAR2(255)	ATVXREF	ATVXREF_DESC
SPOUSE_IND	Indicates if this cross reference code represents a spousal relation.	VARCHAR2(1)	ATVXREF	ATVXREF_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(63)	APRCSPS	APRCSPS_MARS_IND
SPOUSE_STATUS_DESC	Spousal relation status description.	VARCHAR2(255)	CALCULATION	DECODE(APRCSPS_MARS_IND,'A','ACTIVE','I','INACTIVE')

Ver: 9.1