Target Column	Business Definition	Database Data Type	Source Name	Source Column
ACTIVITY_DATE	Date record was inserted or updated	DATE	NA	SYSDATE
ADMINISTRATIVE_GROUP	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
CROSS_REFERENCE_RULE	RELATION_RULE is stored as MGRSDAX_INTERNAL_CODE column and is used to define a specific hierarchy or sequence for display of the values in a slotted reporting view. This may be used to specify the values for each slot or to select data through a reporting tool selection criteria.	VARCHAR2(63)	MGRSDAX	MGRSDAX_INTERNAL_CODE
ENTITY_UID	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER	APRCHLD APRCSPS APRXREF	APRCHLD_PIDM APRCSPS_PIDM APRXREF_PIDM
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
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
PROFILE_CODE	This BUSNIESS PROFILE code is stored as MGRSDAX_PROFILE_CODE column and is used to set up display rules specific to an institution office or role. This may be used to define security for the rows of data available to a reporting user, or to select data through a reporting tool selection criteria.	VARCHAR2(63)	MGRSDAX	MGRSDAX_PROFILE_CODE
RELATED_CROSS_REFERENCE1	Cross reference record relationship created for the identification and related identification.	VARCHAR2(63)	APRCHLD APRCSPS APRXREF	APRCHLD_XREF_CODE APRCSPS_XREF_CODE APRXREF_XREF_CODE
RELATED_CROSS_REFERENCE2	Cross reference record relationship created for the identification and related identification.	VARCHAR2(63)	APRCHLD APRCSPS APRXREF	APRCHLD_XREF_CODE APRCSPS_XREF_CODE APRXREF_XREF_CODE
RELATED_CROSS_REFERENCE3	Cross reference record relationship created for the identification and related identification.	VARCHAR2(63)	APRCHLD APRCSPS APRXREF	APRCHLD_XREF_CODE APRCSPS_XREF_CODE APRXREF_XREF_CODE
RELATED_CROSS_REFERENCE4	Cross reference record relationship created for the identification and related identification.	VARCHAR2(63)	APRCHLD APRCSPS APRXREF	APRCHLD_XREF_CODE APRCSPS_XREF_CODE APRXREF_XREF_CODE
RELATED_CROSS_REFERENCE5	Cross reference record relationship created for the identification and related identification.	VARCHAR2(63)	APRCHLD APRCSPS APRXREF	APRCHLD_XREF_CODE APRCSPS_XREF_CODE APRXREF_XREF_CODE
RELATED_FIRST_NAME1	First name of the related person.	VARCHAR2(63)	APRCHLD SPRIDEN	APRCHLD_FIRST_NAME SPRIDEN_FIRST_NAME
RELATED_FIRST_NAME2	First name of the related person.	VARCHAR2(63)	APRCHLD SPRIDEN	APRCHLD_FIRST_NAME SPRIDEN_FIRST_NAME
RELATED_FIRST_NAME3	First name of the related person.	VARCHAR2(63)	APRCHLD SPRIDEN	APRCHLD_FIRST_NAME SPRIDEN_FIRST_NAME
RELATED_FIRST_NAME4	First name of the related person.	VARCHAR2(63)	APRCHLD SPRIDEN	APRCHLD_FIRST_NAME SPRIDEN_FIRST_NAME
RELATED_FIRST_NAME5	First name of the related person.	VARCHAR2(63)	APRCHLD SPRIDEN	APRCHLD_FIRST_NAME SPRIDEN_FIRST_NAME
RELATED_LAST_NAME1	Last name of the related person or the related organization name.	VARCHAR2(63)	APRCHLD SPRIDEN	APRCHLD_LAST_NAME SPRIDEN_LAST_NAME
RELATED_LAST_NAME2	Last name of the related person or the related organization name.	VARCHAR2(63)	APRCHLD SPRIDEN	APRCHLD_LAST_NAME SPRIDEN_LAST_NAME
RELATED_LAST_NAME3	Last name of the related person or the related organization name.	VARCHAR2(63)	APRCHLD SPRIDEN	APRCHLD_LAST_NAME SPRIDEN_LAST_NAME
RELATED_LAST_NAME4	Last name of the related person or the related organization name.	VARCHAR2(63)	APRCHLD SPRIDEN	APRCHLD_LAST_NAME SPRIDEN_LAST_NAME
RELATED_LAST_NAME5	Last name of the related person or the related organization name.	VARCHAR2(63)	APRCHLD SPRIDEN	APRCHLD_LAST_NAME SPRIDEN_LAST_NAME
RELATED_MIDDLE_INITIAL1	Middle name of the related person.	VARCHAR2(63)	APRCHLD SPRIDEN	APRCHLD_MI SPRIDEN_MI
RELATED_MIDDLE_INITIAL2	Middle name of the related person.	VARCHAR2(63)	APRCHLD SPRIDEN	APRCHLD_MI SPRIDEN_MI
RELATED_MIDDLE_INITIAL3	Middle name of the related person.	VARCHAR2(63)	APRCHLD SPRIDEN	APRCHLD_MI SPRIDEN_MI
RELATED_MIDDLE_INITIAL4	Middle name of the related person.	VARCHAR2(63)	APRCHLD SPRIDEN	APRCHLD_MI SPRIDEN_MI
RELATED_MIDDLE_INITIAL5	Middle name of the related person.	VARCHAR2(63)	APRCHLD SPRIDEN	APRCHLD_MI SPRIDEN_MI
RELATED_REFERENCE_DESC1	Cross-reference code description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
RELATED_REFERENCE_DESC2	Cross-reference code description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
RELATED_REFERENCE_DESC3	Cross-reference code description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
RELATED_REFERENCE_DESC4	Cross-reference code description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
RELATED_REFERENCE_DESC5	Cross-reference code description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
RELATED_TAX_ID1	Person's identification assigned by their federal government for tax purposes.	VARCHAR2(63)	SPBPERS	SPBPERS_SSN
RELATED_TAX_ID2	Person's identification assigned by their federal government for tax purposes.	VARCHAR2(63)	SPBPERS	SPBPERS_SSN
RELATED_TAX_ID3	Person's identification assigned by their federal government for tax purposes.	VARCHAR2(63)	SPBPERS	SPBPERS_SSN
RELATED_TAX_ID4	Person's identification assigned by their federal government for tax purposes.	VARCHAR2(63)	SPBPERS	SPBPERS_SSN
RELATED_TAX_ID5	Person's identification assigned by their federal government for tax purposes.	VARCHAR2(63)	SPBPERS	SPBPERS_SSN
RELATED_UID1	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER	APRCHLD APRCSPS APRXREF	APRCHLD_CHLD_PIDM APRCSPS_SPS_PIDM APRXREF_XREF_PIDM
RELATED_UID2	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER	APRCHLD APRCSPS APRXREF	APRCHLD_CHLD_PIDM APRCSPS_SPS_PIDM APRXREF_XREF_PIDM
RELATED_UID3	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER	APRCHLD APRCSPS APRXREF	APRCHLD_CHLD_PIDM APRCSPS_SPS_PIDM APRXREF_XREF_PIDM
RELATED_UID4	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER	APRCHLD APRCSPS APRXREF	APRCHLD_CHLD_PIDM APRCSPS_SPS_PIDM APRXREF_XREF_PIDM
RELATED_UID5	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER	APRCHLD APRCSPS APRXREF	APRCHLD_CHLD_PIDM APRCSPS_SPS_PIDM APRXREF_XREF_PIDM

Ver: 8.1