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)	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(1)	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: 8.1