Target Column	Business Name	Business Definition	Database Data Type	Business Data Type	Domain Value	Source Name	Source Column	Local Source	Local Target
ENTITY_UID	Entity UID	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER			AMRPROP	AMRPROP_PIDM	NO	NO
ID	ID	Identification number assigned to a person that is used externally for all communication and correspondence with the person.	VARCHAR2(63)			FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
NAME	Name	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)			FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
PROPOSAL	Proposal	Proposal code associated with the prospect.	VARCHAR2(63)			AMRPROP	AMRPROP_PROP_CODE	NO	NO
PROPOSAL_DESC	Proposal Description	Prospect's proposal code description.	VARCHAR2(255)			FUNCTION	GOKODSF.F_GET_DESC	NO	NO
PROPOSAL_SEQUENCE_NUMBER	Proposal Sequence Number	Prospect proposal code sequence number.	NUMBER			AMRPROP	AMRPROP_PROP_SEQ_NO	NO	NO
PROPOSAL_ACTIVE_IND	Proposal Active Indicator	Proposal status active indicator. Determines if the status is active (Y)es, or inactive (N)o.	VARCHAR2(1)			ATVPRST	ATVPRST_ACTIVE_IND	NO	NO
PROPOSAL_STATUS_DATE	Proposal Status Date	Date the proposal status was created or last updated.	DATE			AMBPROP	AMBPROP_PRST_DATE	NO	NO
PROPOSAL_STATUS	Proposal Status	Status of the proposal for the prospect.	VARCHAR2(63)			AMBPROP	AMBPROP_PRST_CODE	NO	NO
PROPOSAL_STATUS_DESC	Proposal Status Description	Status code description associated with the proposal.	VARCHAR2(255)			FUNCTION	GOKODSF.F_GET_DESC	NO	NO
PROPOSAL_PROJECT	Proposal Project	Project code associated with the proposal.	VARCHAR2(63)			AMRPROP	AMRPROP_PROJ_CODE	NO	NO
PROPOSAL_PROJECT_DESC	Proposal Project Description	Proposal project code description.	VARCHAR2(255)			FUNCTION	GOKODSF.F_GET_DESC	NO	NO
PROJECT_GIVING_VEHICLE	Project Giving Vehicle	Giving vehicle for the proposal's project.	VARCHAR2(63)			AMRPROP	AMRPROP_GIVH_CODE	NO	NO
PROJECT_GIVING_VEHICLE_DESC	Project Giving Vehicle Description	Proposal's project giving vehicle code description.	VARCHAR2(255)			FUNCTION	GOKODSF.F_GET_DESC	NO	NO
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	NO	NO
PROPOSAL_PROJECT_STATUS_DATE	Proposal Project Status Date	Date the proposal status was created or last updated.	DATE			AMRPROP	AMRPROP_PRST_DATE	NO	NO
PROPOSAL_PROJECT_STATUS	Proposal Project Status	Status of the proposal's project for the prospect.	VARCHAR2(63)			AMRPROP	AMRPROP_PRST_CODE	NO	NO
PROPOSAL_PROJECT_STATUS_DESC	Proposal Project Status Description	Status code description associated with the proposal's project.	VARCHAR2(255)			FUNCTION	GOKODSF.F_GET_DESC	NO	NO
PROPOSAL_PROJECT_START_DATE	Proposal Project Start Date	Date when the project starts for the proposal.	DATE			AMRPROP	AMRPROP_PROJ_EFF_FROM_DATE	NO	NO
PROPOSAL_PROJECT_END_DATE	Proposal Project End Date	Date when the project ends for the proposal.	DATE			AMRPROP	AMRPROP_PROJ_EFF_TO_DATE	NO	NO
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 prospect, (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)	NO	NO
PROJECT_TARGET_ASK_AMOUNT	Project Target Ask Amount	Targeted ask amount for the proposal's project.	NUMBER			AMRPROP	AMRPROP_TARGET_ASK_AMOUNT	NO	NO
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	NO	NO
PROPOSAL_PROJECT_COMMENT	Proposal Project Comment	Free-form comment regarding the proposal project.	VARCHAR2(2000)			AMRPROP	AMRPROP_PROJ_TEXT	NO	NO
PROPOSAL_PROJECT_USER_ID	Proposal Project User ID	Unique identification code of the user who entered or last updated the proposal project.	VARCHAR2(63)			AMRPROP	AMRPROP_USER	NO	NO
PROPOSAL_PROJECT_ACTIVITY_DATE	Proposal Project Activity Date	Date the record was inserted or last modified.	DATE			AMRPROP	AMRPROP_ACTIVITY_DATE	NO	NO
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)			NA	NA	NO	NO
MULTI_SOURCE_DESC	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)			NA	NA	NO	NO
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)			NA	NA	NO	NO
ADMINISTRATIVE_GROUP	Administrative Group	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)			NA	NA	NO	NO
PROJECT_TOTAL_RESULT	Project Total Result	Total of all result values for the proposal project.	NUMBER			FUNCTION	MAKFUNC.F_SUM_PROPOSAL_RESULT	NO	NO
PROJECT_RESULT_EXISTS_IND	Project Result Exists IND	Indicates whether the proposal project has a result recorded.	VARCHAR2(4000)			FUNCTION	MAKFUNC.F_PROPOSAL_RESULT_EXISTS	NO	NO

Ver: 9.2