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			AMRPRRS	AMRPRRS_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)			AMRPRRS	AMRPRRS_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			AMRPRRS	AMRPRRS_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_PROJECT	Proposal Project	Project code associated with the proposal.	VARCHAR2(63)			AMRPRRS	AMRPRRS_PROJ_CODE	NO	NO
PROPOSAL_PROJECT_DESC	Proposal Project Description	Proposal project 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_RESULT_SEQUENCE	Proposal Result Sequence	Prospect proposal result sequence number.	NUMBER			AMRPRRS	AMRPRRS_SEQ_NO	NO	NO
PROPOSAL_RESULT_DATE	Proposal Result Date	Date the proposal result was recorded.	DATE			AMRPRRS	AMRPRRS_RESULT_DATE	NO	NO
PROPOSAL_RESULT_GIFT_NUMBER	Proposal Result Gift Number	Gift number associated with the proposal result.	VARCHAR2(63)			AMRPRRS	AMRPRRS_GIFT_NO	NO	NO
PROPOSAL_RESULT_PLEDGE_NUMBER	Proposal Result Pledge Number	Pledge number associated with the proposal result.	VARCHAR2(63)			AMRPRRS	AMRPRRS_PLEDGE_NO	NO	NO
PROPOSAL_RESULT_CAMPAIGN	Proposal Result Campaign	Campaign associated with the proposal result.	VARCHAR2(63)			AMRPRRS	AMRPRRS_CAMPAIGN	NO	NO
PROPOSAL_RESULT_CAMPAIGN_NAME	Proposal Result Campaign Name	Campaign name.	VARCHAR2(255)			AFBCAMP	AFBCAMP_NAME	NO	NO
PROPOSAL_RESULT_DESIGNATION	Proposal Result Designation	Designation associated with the proposal result.	VARCHAR2(63)			AMRPRRS	AMRPRRS_DESG	NO	NO
PROPOSAL_RESULT_DESG_NAME	Proposal Result Designation Name	Designation name.	VARCHAR2(255)			ADBDESG	ADBDESG_NAME	NO	NO
PROPOSAL_RESULT_AMOUNT	Proposal Result Amount	Amount associated with the proposal result.	NUMBER			AMRPRRS	NVL(AMRPRRS_VALUE,0)	NO	NO
TRANSACTION_TYPE	Transaction Type	Determines if the transaction result was an outright gift, pledge payment, pledge, or unknown.	VARCHAR2(63)			FUNCTION	CASE WHEN PROPOSAL_RESULT_PLEDGE_NUMBER	NO	NO
TRANSACTION_TYPE_DESC	Transaction Type Description	Transaction type description.	VARCHAR2(255)			FUNCTION	CASE WHEN PROPOSAL_RESULT_PLEDGE_NUMBER	NO	NO
PROPOSAL_RESULT_COMMENT	Proposal Result Comment	Free form comment about the proposal result.	VARCHAR2(4000)			AMRPRRS	AMRPRRS_COMMENT	NO	NO
PROPOSAL_RESULT_USER_ID	Proposal Result User ID	Unique identification code of the user who entered or last updated the proposal project.	VARCHAR2(63)			AMRPRRS	AMRPRRS_USER	NO	NO
PROPOSAL_RESULT_ACTIVITY_DATE	Proposal Result Activity Date	Date the record was inserted or last modified.	DATE			AMRPRRS	AMRPRRS_ACTIVITY_DATE	NO	NO
PROPOSAL_RESULT_DATA_ORIGIN	Proposal Result Data Origin	Source system that generated the data.	VARCHAR2(63)			AMRPRRS	AMRPRRS_DATA_ORIGIN	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

Ver: 9.2