Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
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	NO	NO
ACTIVITY_DATE	Date that information for this record in the table was entered or last updated.	DATE	AMRPRIN	AMRPRIN_ACTIVITY_DATE	NO	NO
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE	NO	NO
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO
ENTITY_UID	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER	AMRPRIN	AMRPRIN_PIDM	NO	NO
GIVING_VEHICLE	Method by which the prospect is expected to donate to the project or interest area.	VARCHAR2(2)	AMRPRIN	AMRPRIN_GIVH_CODE	NO	NO
GIVING_VEHICLE_DESC	Giving vehicle code description.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
LAST_UPDATE_USER_ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(30)	AMRPRIN	AMRPRIN_USER	NO	NO
MIF_DESC	Institution description for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(30)	NA	NA	NO	NO
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)	NA	NA	NO	NO
PROJECT	Project or interest area.	VARCHAR2(6)	AMRPRIN	AMRPRIN_PROJ_CODE	NO	NO
PROJECT_COMMENT	Free-form text about the project.	VARCHAR2(2000)	AMRPRIN	AMRPRIN_PROJ_TEXT	NO	NO
PROJECT_DESC	Project or interest area description.	VARCHAR2(30)	ATVPROJ	ATVPROJ_DESC	NO	NO
PROJECT_END_DATE	Date when the project ends for the prospect.	DATE	AMRPRIN	AMRPRIN_PROJ_EFF_TO_DATE	NO	NO
PROJECT_START_DATE	Date when the project starts for the prospect.	DATE	AMRPRIN	AMRPRIN_PROJ_EFF_FROM_DATE	NO	NO
PROJECT_STATUS	Current project status for the prospect.	VARCHAR2(6)	AMRPRIN	AMRPRIN_PRST_CODE	NO	NO
PROJECT_STATUS_DATE	Date the status was created or last updated.	DATE	AMRPRIN	AMRPRIN_PRST_DATE	NO	NO
PROJECT_STATUS_DESC	Prospect status description.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
PROJECT_TARGET_ASK_AMOUNT	Target ask amount for the constituent for the project.	NUMBER	AMRPRIN	AMRPRIN_TARGET_ASK_AMT	NO	NO
PROJECT_TARGET_ASK_DATE	Target ask date for the constituent for the project.	DATE	AMRPRIN	AMRPRIN_TARGET_ASK_DATE	NO	NO
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO

Ver: