Target Column	Business Definition	Database Data Type	Source Name	Source Column
ACTIVE_PROJECT_IND	Project status active indicator determining if the status is active (Y)es, or inactive (N)o.	VARCHAR2(1)	ATVPRST	ATVPRST_ACTIVE_IND
ACTIVITY_DATE	Date that information for this record in the table was entered or last updated.	DATE	AMRPRIN	AMRPRIN_ACTIVITY_DATE
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	AMRPRIN	AMRPRIN_PIDM
GIVING_VEHICLE	Method by which the prospect is expected to donate to the project or interest area.	VARCHAR2(2)	AMRPRIN	AMRPRIN_GIVH_CODE
GIVING_VEHICLE_DESC	Giving vehicle code description.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC
LAST_UPDATE_USER_ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(30)	AMRPRIN	AMRPRIN_USER
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	Project or interest area.	VARCHAR2(6)	AMRPRIN	AMRPRIN_PROJ_CODE
PROJECT_COMMENT	Free-form text about the project.	VARCHAR2(2000)	AMRPRIN	AMRPRIN_PROJ_TEXT
PROJECT_DESC	Project or interest area description.	VARCHAR2(30)	ATVPROJ	ATVPROJ_DESC
PROJECT_END_DATE	Date when the project ends for the prospect.	DATE	AMRPRIN	AMRPRIN_PROJ_EFF_TO_DATE
PROJECT_START_DATE	Date when the project starts for the prospect.	DATE	AMRPRIN	AMRPRIN_PROJ_EFF_FROM_DATE
PROJECT_STATUS	Current project status for the prospect.	VARCHAR2(6)	AMRPRIN	AMRPRIN_PRST_CODE
PROJECT_STATUS_DATE	Date the status was created or last updated.	DATE	AMRPRIN	AMRPRIN_PRST_DATE
PROJECT_STATUS_DESC	Prospect status description.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC
PROJECT_TARGET_ASK_AMOUNT	Target ask amount for the constituent for the project.	NUMBER	AMRPRIN	AMRPRIN_TARGET_ASK_AMT
PROJECT_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: