Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
CURRENT_DATE	Current Date	System current date (sysdate), or date the data was extracted.	DATE		NA	SYSDATE
DOMAIN_VALUE	Domain Value	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)		NA	NA
ENTITY_UID	Entity UID	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER(8)		AMRPROP	AMRPROP_PIDM
MIF_DESC	MIF Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)		NA	NA
MIF_VALUE	MIF Value	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)		NA	NA
PROJECT_ASSIGNED_PROSPECT_IND	Project Assigned Prospect Indicator	Determines if the project was assigned to the prospect. (Y)es, the project was assigned to the project, (N)o, the project was not assigned to the prospect.	VARCHAR2(1)		FUNCTION	AOKODSF.F_GET_PROJ_ASSIGN_PROS_IND(AMRPROP_PIDM, AMRPROP_PROJ_CODE)
PROJECT_GIVING_VEHICLE	Project Giving Vehicle	Giving vehicle for the proposal's project.	VARCHAR2(2)		AMRPROP	AMRPROP_GIVH_CODE
PROJECT_GIVING_VEHICLE_DESC	Project Giving Vehicle Description	Proposal's project giving vehicle code description.	VARCHAR2(30)		FUNCTION	GOKODSF.F_GET_DESC
PROJECT_TARGET_ASK_AMOUNT	Project Target Ask Amount	Targeted ask amount for the proposal's project.	NUMBER		AMRPROP	AMRPROP_TARGET_ASK_AMOUNT
PROJECT_TARGET_ASK_DATE	Project Target Ask Date	Date by which the target ask amount will be solicited for the proposal's project.	DATE		AMRPROP	AMRPROP_TARGET_ASK_DATE
PROPOSAL	Proposal	Proposal code associated to the prospect.	VARCHAR2(6)		AMRPROP	AMRPROP_PROP_CODE
PROPOSAL_PROJECT	Proposal Project	Project code associated to the proposal.	VARCHAR2(6)		AMRPROP	AMRPROP_PROJ_CODE
PROPOSAL_PROJECT_ACTIVE_IND	Proposal Project Active Indicator	Proposal's project status active indicator. Determines if the project status is active (Y)es, or inactive (N)o.	VARCHAR2(1)		ATVPRST	ATVPRST_ACTIVE_IND
PROPOSAL_PROJECT_ACTIVITY_DATE	Proposal Project Activity Date	Date the record was inserted or last modified.	DATE		AMRPROP	AMRPROP_ACTIVITY_DATE
PROPOSAL_PROJECT_COMMENT	Proposal Project Comment	Free-form comment regarding the proposal project.	VARCHAR2(2000)		AMRPROP	AMRPROP_PROJ_TEXT
PROPOSAL_PROJECT_DESC	Proposal Project Description	Proposal project code description.	VARCHAR2(30)		FUNCTION	GOKODSF.F_GET_DESC
PROPOSAL_PROJECT_END_DATE	Proposal Project End Date	Date when the project ends for the proposal.	DATE		AMRPROP	AMRPROP_PROJ_EFF_TO_DATE
PROPOSAL_PROJECT_START_DATE	Proposal Project Start Date	Date when the project starts for the proposal.	DATE		AMRPROP	AMRPROP_PROJ_EFF_FROM_DATE
PROPOSAL_PROJECT_STATUS	Proposal Project Status	Status of the proposal's project for the prospect.	VARCHAR2(6)		AMRPROP	AMRPROP_PRST_CODE
PROPOSAL_PROJECT_STATUS_DATE	Proposal Project Status Date	Date the proposal status was created or last updated.	DATE		AMRPROP	AMRPROP_PRST_DATE
PROPOSAL_PROJECT_STATUS_DESC	Proposal Project Status Description	Status code description associated with the proposal's project.	VARCHAR2(30)		FUNCTION	GOKODSF.F_GET_DESC
PROPOSAL_PROJECT_USER_ID	Proposal Project User ID	Unique identification code of the user who entered or last updated the proposal project.	VARCHAR2(30)		AMRPROP	AMRPROP_USER
PROPOSAL_SEQUENCE_NUMBER	Proposal Sequence Number	Prospect proposal code sequence number.	NUMBER(3)		AMRPROP	AMRPROP_PROP_SEQ_NO
ZONE_VALUE	Zone Value	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)		NA	NA

Ver: