Target Column	Business Name	Business Definition	Database Data Type	Source Name	Source Column
ADMINISTRATIVE_GROUP	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	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	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 Mailing Priority Description	Combined spousal mailing priority description.	VARCHAR2(255)	CALCULATION	DECODE(APRXREF_CM_PRI_IND,'P','PRIMARY','S','SECONDARY')
EMPLOYER_IND	Employer Indicator	Indicates if this cross reference code represents an employer relation.	VARCHAR2(1)	APVXREF	APVXREF_EMPLOYER_IND
ENTITY_IND	Entity Indicator	Indicates whether this entity is a person or organization.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
ENTITY_UID	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	Household Indicator	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	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	Related Marital Status	Current marital status of the relation.	VARCHAR2(63)	SPBPERS	SPBPERS_MRTL_CODE
MARITAL_STATUS_DESC	Related Marital Status Description	Marital status description.	VARCHAR2(255)	STVMRTL	STVMRTL_DESC
MARRIAGE_END_DATE	Marriage End Date	For spousal relations, date the marriage ended.	DATE	APRCSPS	APRCSPS_MRTL_END_DATE
MARRIAGE_START_DATE	Marriage Start Date	For spousal relations, date of the marriage.	DATE	APRCSPS	APRCSPS_MRTL_START_DATE
MATCHING_GIFT_IND	Matching Gift Indicator	Indicates if this cross referenced employer or organization matches gifts.	VARCHAR2(1)	ATVXREF	ATVXREF_MATCH_GIFT_IND
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
NAME	Name	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
PROCESS_GROUP	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	Related Birth Date	Date of birth of the related person.	DATE	SPBPERS	SPBPERS_BIRTH_DATE
RELATED_CHILD_ADDR_TYPE	Related Child Address 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	Related Child Address Type Description	Address type description for the related child.	VARCHAR2(255)	STVATYP	STVATYP_DESC
RELATED_CHILD_TAX_ID	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	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	Related Comment	Comments about the related child or spouse.	CLOB	APRCHLD APRCSPS	APRCHLD_COMMENT APRCSPS_SPS_COMMENT
RELATED_CROSS_REFERENCE	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	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	Related Deceased Indicator	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	Related Entity Indicator	Indicates whether the related entity is a person or organization.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
RELATED_FIRST_NAME	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	Related Gender	Gender of the related person.	VARCHAR2(63)	SPBPERS	SPBPERS_SEX
RELATED_GENDER_DESC	Related Gender Description	Gender description of the related person.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
RELATED_ID	Related ID	Current identification number of the cross referenced person or organization.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
RELATED_LAST_NAME	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	Related Maiden Name	Maiden name of a spousal relation.	VARCHAR2(63)	APRCSPS SPRIDEN	APRCSPS_MAIDEN_NAME SPRIDEN_LAST_NAME
RELATED_MATCHING_GIFT_ID	Related Matching Gift Organization 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	Related Matching Gift Organziation Name	Name of the matching gift organization for the related organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
RELATED_MATCHING_GIFT_UID	Related Matching Gift Organization 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 of the related person.	VARCHAR2(63)	APRCHLD APRCSPS SPRIDEN	APRCHLD_MI APRCSPS_MI SPRIDEN_MI
RELATED_PREFIX	Related Prefix	Prefix associated with the related person's name.	VARCHAR2(63)	APRCSPS SPBPERS	APRCSPS_NAME_PREFIX SPBPERS_NAME_PREFIX
RELATED_REFERENCE_DESC	Related Cross Reference Description	Description of the cross reference relationship.	VARCHAR2(255)	ATVXREF	ATVXREF_DESC
RELATED_SUFFIX	Related Suffix	Suffix for the related person's name.	VARCHAR2(63)	APRCSPS SPBPERS	APRCSPS_NAME_SUFFIX SPBPERS_NAME_SUFFIX
RELATED_UID	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	Relationship 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	Relationship Source Description	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 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	Reverse Cross Reference Description	Description of the reverse cross reference relationship.	VARCHAR2(255)	ATVXREF	ATVXREF_DESC
SPOUSE_IND	Spouse Indicator	Indicates if this cross reference code represents a spousal relation.	VARCHAR2(1)	ATVXREF	ATVXREF_SPOUSE_IND
SPOUSE_STATUS	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	Spouse Status Description	Spousal relation status description.	VARCHAR2(255)	CALCULATION	DECODE(APRCSPS_MARS_IND,'A','ACTIVE','I','INACTIVE')

Ver: 9.2