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)		AMRPRIN AORFUND	AMRPRIN_PIDM AORFUND_PIDM
GIVING_VEHICLE		Giving vehicle code.	VARCHAR2(2)		AMRPRIN	AMRPRIN_GIVH_CODE
GIVING_VEHICLE_DESC		Giving vehicle code description.	VARCHAR2(30)		FUNCTION	GOKODSF.F_GET_DESC
INTEREST		Fund code.	VARCHAR2(6)		AMRPRIN AORFUND	AMRPRIN_PROJ_CODE AORFUND_FUND_CODE
INTEREST_COMMENT		Fund comment.	VARCHAR2(2000)		AMRPRIN AORFUND	AMRPRIN_PROJ_TEXT AORFUND_COMMENT
INTEREST_DESC		Fund interest code description.	VARCHAR2(30)		FUNCTION	GOKODSF.F_GET_DESC
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
PROJECT_COMMENT		Text about the project.	VARCHAR2(2000)		AMRPRIN	AMRPRIN_PROJ_TEXT
PROJECT_STATUS		Status of the project for the prospect.	VARCHAR2(6)		AMRPRIN	AMRPRIN_PRST_CODE
PROJECT_STATUS_DATE		Date of the project status for the prospect.	DATE		AMRPRIN	AMRPRIN_PRST_DATE
PROJECT_STATUS_DESC		Prospect status code description.	VARCHAR2(30)		FUNCTION	GOKODSF.F_GET_DESC
TARGET_ASK_AMOUNT		Target ask amount for the constituent for the project.	NUMBER		AMRPRIN	AMRPRIN_TARGET_ASK_AMT
TARGET_ASK_DATE		Target ask date for the constituent for the project.	DATE		AMRPRIN	AMRPRIN_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: