Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
ADMINISTRATIVE_GROUP
|
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
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
|
NO
|
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
|
NO
|
NO
|
COMBINED_MAILING_PRIORITY_DESC
|
Combined spousal mailing priority description.
|
VARCHAR2(255)
|
CALCULATION
|
DECODE(APRXREF_CM_PRI_IND,'P','PRIMARY','S','SECONDARY')
|
NO
|
NO
|
EMPLOYER_IND
|
Indicates if this cross reference code represents an employer relation.
|
VARCHAR2(1)
|
APVXREF
|
APVXREF_EMPLOYER_IND
|
NO
|
NO
|
ENTITY_IND
|
Indicates whether this entity is a person or organization.
|
VARCHAR2(63)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
NO
|
NO
|
ENTITY_UID
|
System generated, unique, internal identification number assigned to this person or organization.
|
NUMBER
|
APRCHLD APRCSPS APRXREF
|
APRCHLD_PIDM APRCSPS_PIDM APRXREF_PIDM
|
NO NO NO
|
NO
|
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
|
NO
|
NO
|
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
|
NO
|
NO
|
MARITAL_STATUS
|
Current marital status of the relation.
|
VARCHAR2(63)
|
SPBPERS
|
SPBPERS_MRTL_CODE
|
NO
|
NO
|
MARITAL_STATUS_DESC
|
Marital status description.
|
VARCHAR2(255)
|
STVMRTL
|
STVMRTL_DESC
|
NO
|
NO
|
MARRIAGE_END_DATE
|
For spousal relations, date the marriage ended.
|
DATE
|
APRCSPS
|
APRCSPS_MRTL_END_DATE
|
NO
|
NO
|
MARRIAGE_START_DATE
|
For spousal relations, date of the marriage.
|
DATE
|
APRCSPS
|
APRCSPS_MRTL_START_DATE
|
NO
|
NO
|
MATCHING_GIFT_IND
|
Indicates if this cross referenced employer or organization matches gifts.
|
VARCHAR2(1)
|
ATVXREF
|
ATVXREF_MATCH_GIFT_IND
|
NO
|
NO
|
MULTI_SOURCE
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(63)
|
NA
|
NA
|
NO
|
NO
|
MULTI_SOURCE_DESC
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
NAME
|
Name of the person (last name, first name, middle initial) or organization.
|
VARCHAR2(255)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
NO
|
NO
|
PROCESS_GROUP
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
RELATED_BIRTH_DATE
|
Date of birth of the related person.
|
DATE
|
SPBPERS
|
SPBPERS_BIRTH_DATE
|
NO
|
NO
|
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
|
NO
|
NO
|
RELATED_CHILD_ADDR_TYPE_DESC
|
Address type description for the related child.
|
VARCHAR2(255)
|
STVATYP
|
STVATYP_DESC
|
NO
|
NO
|
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
|
NO NO
|
NO
|
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
|
NO NO NO
|
NO
|
RELATED_COMMENT
|
Comments about the related child or spouse.
|
CLOB
|
APRCHLD APRCSPS
|
APRCHLD_COMMENT APRCSPS_SPS_COMMENT
|
NO NO
|
NO
|
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
|
NO NO NO
|
NO
|
RELATED_DECEASED_DATE
|
Deceased date for the related person.
|
DATE
|
APRCHLD APRCSPS SPBPERS
|
APRCHLD_DECEASED_DATE APRCSPS_DEAD_DATE SPBPERS_DEAD_DATE
|
NO NO NO
|
NO
|
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
|
NO NO NO
|
NO
|
RELATED_ENTITY_IND
|
Indicates whether the related entity is a person or organization.
|
VARCHAR2(63)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
NO
|
NO
|
RELATED_FIRST_NAME
|
First name of the related person.
|
VARCHAR2(63)
|
APRCHLD APRCSPS SPRIDEN
|
APRCHLD_FIRST_NAME APRCSPS_FIRST_NAME SPRIDEN_FIRST_NAME
|
NO NO NO
|
NO
|
RELATED_GENDER
|
Gender of the related person.
|
VARCHAR2(63)
|
SPBPERS
|
SPBPERS_SEX
|
NO
|
NO
|
RELATED_GENDER_DESC
|
Gender description of the related person.
|
VARCHAR2(255)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
NO
|
NO
|
RELATED_ID
|
Current identification number of the cross referenced person or organization.
|
VARCHAR2(63)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
NO
|
NO
|
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
|
NO NO NO
|
NO
|
RELATED_MAIDEN_NAME
|
Maiden name of a spousal relation.
|
VARCHAR2(63)
|
APRCSPS SPRIDEN
|
APRCSPS_MAIDEN_NAME SPRIDEN_LAST_NAME
|
NO NO
|
NO
|
RELATED_MATCHING_GIFT_ID
|
Current identification number of the matching gift organization for the related organization.
|
VARCHAR2(63)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
NO
|
NO
|
RELATED_MATCHING_GIFT_NAME
|
Name of the matching gift organization for the related organization.
|
VARCHAR2(255)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
NO
|
NO
|
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
|
NO
|
NO
|
RELATED_MIDDLE_INITIAL
|
Middle name of the related person.
|
VARCHAR2(63)
|
APRCHLD APRCSPS SPRIDEN
|
APRCHLD_MI APRCSPS_MI SPRIDEN_MI
|
NO NO NO
|
NO
|
RELATED_PREFIX
|
Prefix associated with the related person's name.
|
VARCHAR2(63)
|
APRCSPS SPBPERS
|
APRCSPS_NAME_PREFIX SPBPERS_NAME_PREFIX
|
NO NO
|
NO
|
RELATED_REFERENCE_DESC
|
Description of the cross reference relationship.
|
VARCHAR2(255)
|
ATVXREF
|
ATVXREF_DESC
|
NO
|
NO
|
RELATED_SUFFIX
|
Suffix for the related person's name.
|
VARCHAR2(63)
|
APRCSPS SPBPERS
|
APRCSPS_NAME_SUFFIX SPBPERS_NAME_SUFFIX
|
NO NO
|
NO
|
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
|
NO NO NO
|
NO
|
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'
|
NO
|
NO
|
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'
|
NO
|
NO
|
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
|
NO
|
NO
|
REVERSE_REFERENCE_DESC
|
Description of the reverse cross reference relationship.
|
VARCHAR2(255)
|
ATVXREF
|
ATVXREF_DESC
|
NO
|
NO
|
SPOUSE_IND
|
Indicates if this cross reference code represents a spousal relation.
|
VARCHAR2(1)
|
ATVXREF
|
ATVXREF_SPOUSE_IND
|
NO
|
NO
|
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
|
NO
|
NO
|
SPOUSE_STATUS_DESC
|
Spousal relation status description.
|
VARCHAR2(255)
|
CALCULATION
|
DECODE(APRCSPS_MARS_IND,'A','ACTIVE','I','INACTIVE')
|
NO
|
NO
|