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(8)	AMRINFO	AMRINFO_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
PREF_GEO_REGION_ADDR_TYPE	Address type of the address to be used as the preferred geographic region address.	VARCHAR2(2)	APBCONS	APBCONS_ATYP_CODE_GEOR
PREF_GEO_REGION_ADDR_TYPE_DESC	Preferred geographic region address type.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC
PRIMARY_STAFF_ASSIGN_IDEN_CODE	Primary staff identification code.	VARCHAR2(5)	AMRSTAF	AMRSTAF_IDEN_CODE
PRIMARY_STAFF_ASSIGN_IDEN_DESC	Name of the primary staff identification code.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC
PRIMARY_STAFF_ASSIGN_TYPE	Primary staff type code.	VARCHAR2(4)	AMRSTAF	AMRSTAF_STFT_CODE
PRIMARY_STAFF_ASSIGN_TYPE_DESC	Primary staff type code description.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC
PROSPECT_AMOUNT	Manually entered or system calculated prospect amount.	NUMBER(11, 2)	AMRINFO	AMRINFO_PROSP_RATE
PROSPECT_STATUS	Status.	VARCHAR2(1)	AMRINFO	AMRINFO_STATUS
REFERENCE	Reference code.	VARCHAR2(2)	AMRINFO	AMRINFO_REFR_CODE
REFERENCE_DESC	Reference code description.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC
TARGET_ASK_DATE	Manually entered target asking date.	DATE	AMRINFO	AMRINFO_TARGET_ASK_DATE
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA

Ver: 8.1