Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ADMINISTRATIVE_GROUP	Administrative Group	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)		NA	NA
ENTITY_UID	Entity UID	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER		AMRPRRS	AMRPRRS_PIDM
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
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)		NA	NA
MULTI_SOURCE_DESC	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)		NA	NA
NAME	Name	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)		FUNCTION	MGKFUNC.F_GET_PERSON_INFO
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)		NA	NA
PROPOSAL	Proposal	Proposal code associated with the prospect.	VARCHAR2(63)		AMRPRRS	AMRPRRS_PROP_CODE
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
PROPOSAL_DESC	Proposal Description	Prospect's proposal code description.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
PROPOSAL_PROJECT	Proposal Project	Project code associated with the proposal.	VARCHAR2(63)		AMRPRRS	AMRPRRS_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_DESC	Proposal Project Description	Proposal project code description.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
PROPOSAL_RESULT_ACTIVITY_DATE	Proposal Result Activity Date	Date the record was inserted or last modified.	DATE		AMRPRRS	AMRPRRS_ACTIVITY_DATE
PROPOSAL_RESULT_AMOUNT	Proposal Result Amount	Amount associated with the proposal result.	NUMBER		AMRPRRS	NVL(AMRPRRS_VALUE,0)
PROPOSAL_RESULT_CAMPAIGN	Proposal Result Campaign	Campaign associated with the proposal result.	VARCHAR2(63)		AMRPRRS	AMRPRRS_CAMPAIGN
PROPOSAL_RESULT_CAMPAIGN_NAME	Proposal Result Campaign Name	Campaign name.	VARCHAR2(255)		AFBCAMP	AFBCAMP_NAME
PROPOSAL_RESULT_COMMENT	Proposal Result Comment	Free form comment about the proposal result.	VARCHAR2(4000)		AMRPRRS	AMRPRRS_COMMENT
PROPOSAL_RESULT_DATA_ORIGIN	Proposal Result Data Origin	Source system that generated the data.	VARCHAR2(63)		AMRPRRS	AMRPRRS_DATA_ORIGIN
PROPOSAL_RESULT_DATE	Proposal Result Date	Date the proposal result was recorded.	DATE		AMRPRRS	AMRPRRS_RESULT_DATE
PROPOSAL_RESULT_DESG_NAME	Proposal Result Designation Name	Designation name.	VARCHAR2(255)		ADBDESG	ADBDESG_NAME
PROPOSAL_RESULT_DESIGNATION	Proposal Result Designation	Designation associated with the proposal result.	VARCHAR2(63)		AMRPRRS	AMRPRRS_DESG
PROPOSAL_RESULT_GIFT_NUMBER	Proposal Result Gift Number	Gift number associated with the proposal result.	VARCHAR2(63)		AMRPRRS	AMRPRRS_GIFT_NO
PROPOSAL_RESULT_PLEDGE_NUMBER	Proposal Result Pledge Number	Pledge number associated with the proposal result.	VARCHAR2(63)		AMRPRRS	AMRPRRS_PLEDGE_NO
PROPOSAL_RESULT_SEQUENCE	Proposal Result Sequence	Prospect proposal result sequence number.	NUMBER		AMRPRRS	AMRPRRS_SEQ_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
PROPOSAL_SEQUENCE_NUMBER	Proposal Sequence Number	Prospect proposal code sequence number.	NUMBER		AMRPRRS	AMRPRRS_PROP_SEQ_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
TRANSACTION_TYPE_DESC	Transaction Type Description	Transaction type description.	VARCHAR2(255)		FUNCTION	CASE WHEN PROPOSAL_RESULT_PLEDGE_NUMBER

Ver: 9.0