Target Column	Business Definition	Database Data Type	Source Name	Source Column
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
ENTITY_UID	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER	APRPROS APRVIPC	APRPROS_PIDM APRVIPC_PIDM
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
SPECIAL_PURPOSE_COMMENT	Free form text comment about the special purpose group code for this person or organization.	VARCHAR2(500)	APRPROS	APRPROS_COMMENT
SPECIAL_PURPOSE_DATE	Date associated with the special purpose group type.	DATE	APRPROS	APRPROS_DATE
SPECIAL_PURPOSE_GROUP	Special purpose group code.	VARCHAR2(5)	APRPROS APRVIPC	APRPROS_PRCD_CODE APRVIPC_VIPC_CODE
SPECIAL_PURPOSE_GROUP_DESC	Special purpose group code description.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC
SPECIAL_PURPOSE_TYPE	Classifies a person or organization by a special purpose group type.	VARCHAR2(5)	APRPROS	APRPROS_PRTP_CODE
SPECIAL_PURPOSE_TYPE_DESC	Special purpose group type code description.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA

Ver: