Target Column	Business Definition	Database Data Type	Source Name	Source Column
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
ENTITY_UID	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER	AMRPRRS	AMRPRRS_PIDM
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	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
NAME	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
PROPOSAL	Proposal code associated with the prospect.	VARCHAR2(63)	AMRPRRS	AMRPRRS_PROP_CODE
PROPOSAL_ACTIVE_IND	Proposal status active indicator. Determines if the status is active (Y)es, or inactive (N)o.	VARCHAR2(1)	ATVPRST	ATVPRST_ACTIVE_IND
PROPOSAL_DESC	Prospect's proposal code description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
PROPOSAL_PROJECT	Project code associated with the proposal.	VARCHAR2(63)	AMRPRRS	AMRPRRS_PROJ_CODE
PROPOSAL_PROJECT_ACTIVE_IND	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 code description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
PROPOSAL_RESULT_ACTIVITY_DATE	Date the record was inserted or last modified.	DATE	AMRPRRS	AMRPRRS_ACTIVITY_DATE
PROPOSAL_RESULT_AMOUNT	Amount associated with the proposal result.	NUMBER	AMRPRRS	NVL(AMRPRRS_VALUE,0)
PROPOSAL_RESULT_CAMPAIGN	Campaign associated with the proposal result.	VARCHAR2(63)	AMRPRRS	AMRPRRS_CAMPAIGN
PROPOSAL_RESULT_CAMPAIGN_NAME	Campaign name.	VARCHAR2(255)	AFBCAMP	AFBCAMP_NAME
PROPOSAL_RESULT_COMMENT	Free form comment about the proposal result.	VARCHAR2(4000)	AMRPRRS	AMRPRRS_COMMENT
PROPOSAL_RESULT_DATA_ORIGIN	Source system that generated the data.	VARCHAR2(63)	AMRPRRS	AMRPRRS_DATA_ORIGIN
PROPOSAL_RESULT_DATE	Date the proposal result was recorded.	DATE	AMRPRRS	AMRPRRS_RESULT_DATE
PROPOSAL_RESULT_DESG_NAME	Designation name.	VARCHAR2(255)	ADBDESG	ADBDESG_NAME
PROPOSAL_RESULT_DESIGNATION	Designation associated with the proposal result.	VARCHAR2(63)	AMRPRRS	AMRPRRS_DESG
PROPOSAL_RESULT_GIFT_NUMBER	Gift number associated with the proposal result.	VARCHAR2(63)	AMRPRRS	AMRPRRS_GIFT_NO
PROPOSAL_RESULT_PLEDGE_NUMBER	Pledge number associated with the proposal result.	VARCHAR2(63)	AMRPRRS	AMRPRRS_PLEDGE_NO
PROPOSAL_RESULT_SEQUENCE	Prospect proposal result sequence number.	NUMBER	AMRPRRS	AMRPRRS_SEQ_NO
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	Prospect proposal code sequence number.	NUMBER	AMRPRRS	AMRPRRS_PROP_SEQ_NO
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.	VARCHAR2(255)	FUNCTION	CASE WHEN PROPOSAL_RESULT_PLEDGE_NUMBER

Ver: 8.5