Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ACTIVE_PROJECT_IND	Active Project Indicator	Project status active indicator determining if the status is active (Y)es, or inactive (N)o.	VARCHAR2(1)		ATVPRST	ATVPRST_ACTIVE_IND
ACTIVITY_DATE	Activity Date	Date that information for this record in the table was entered or last updated.	DATE		AMRPRIN	AMRPRIN_ACTIVITY_DATE
CURRENT_DATE	Current Date	System current date (sysdate) or date the data was extracted.	DATE		NA	SYSDATE
DOMAIN_VALUE	Domain Value	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)		NA	NA
ENTITY_UID	Entity UID	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER(8)		AMRPRIN	AMRPRIN_PIDM
GIVING_VEHICLE	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 Description	Giving vehicle code description.	VARCHAR2(30)		FUNCTION	GOKODSF.F_GET_DESC
LAST_UPDATE_USER_ID	Last Update User ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(30)		AMRPRIN	AMRPRIN_USER
MIF_DESC	MIF Description	Institution description for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(30)		NA	NA
MIF_VALUE	MIF Value	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)		NA	NA
PROJECT	Project	Project or interest area.	VARCHAR2(6)		AMRPRIN	AMRPRIN_PROJ_CODE
PROJECT_COMMENT	Project Comment	Free-form text about the project.	VARCHAR2(2000)		AMRPRIN	AMRPRIN_PROJ_TEXT
PROJECT_DESC	Project Description	Project or interest area description.	VARCHAR2(30)		ATVPROJ	ATVPROJ_DESC
PROJECT_END_DATE	Project End Date	Date when the project ends for the prospect.	DATE		AMRPRIN	AMRPRIN_PROJ_EFF_TO_DATE
PROJECT_START_DATE	Project Start Date	Date when the project starts for the prospect.	DATE		AMRPRIN	AMRPRIN_PROJ_EFF_FROM_DATE
PROJECT_STATUS	Project Status	Current project status for the prospect.	VARCHAR2(6)		AMRPRIN	AMRPRIN_PRST_CODE
PROJECT_STATUS_DATE	Project Status Date	Date the status was created or last updated.	DATE		AMRPRIN	AMRPRIN_PRST_DATE
PROJECT_STATUS_DESC	Project Status Description	Prospect status description.	VARCHAR2(30)		FUNCTION	GOKODSF.F_GET_DESC
PROJECT_TARGET_ASK_AMOUNT	Project Target Ask Amount	Target ask amount for the constituent for the project.	NUMBER(10,2)		AMRPRIN	AMRPRIN_TARGET_ASK_AMT
PROJECT_TARGET_ASK_DATE	Project Target Ask Date	Target ask date for the constituent for the project.	DATE		AMRPRIN	AMRPRIN_TARGET_ASK_DATE
ZONE_VALUE	Zone Value	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)		NA	NA

Ver: