Target Column	Business Name	Business Definition	Database Data Type	Domain Value	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(8)		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: