Target Column	Business Definition	Database Data Type	Source Name	Source Column
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)
ENTITY_UID	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER(8, )
MIF_DESC	Institution description for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(30)
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)
PROPOSAL	Proposal code associated to the prospect.	VARCHAR2(6)
PROPOSAL_PROJECT	Project code associated to the proposal.	VARCHAR2(6)
PROPOSAL_RESULT_ACTIVITY_DATE	Date the record was inserted or last modified.	DATE
PROPOSAL_RESULT_AMOUNT	Amount associated with the proposal result.	NUMBER( , )
PROPOSAL_RESULT_CAMPAIGN	Campaign associated with the proposal result.	VARCHAR2(5)
PROPOSAL_RESULT_COMMENT	Free form comment about the proposal result.	VARCHAR2(2000)
PROPOSAL_RESULT_DATA_ORIGIN	Source system that generated the data.	VARCHAR2(30)
PROPOSAL_RESULT_DATE	Date the proposal result was recorded.	DATE
PROPOSAL_RESULT_DESIGNATION	Designation associated with the proposal result.	VARCHAR2(10)
PROPOSAL_RESULT_GIFT_NUMBER	Gift number associated with the proposal result.	VARCHAR2(7)
PROPOSAL_RESULT_PLEDGE_NUMBER	Pledge number associated with the proposal result.	VARCHAR2(7)
PROPOSAL_RESULT_SEQUENCE	Prospect proposal result sequence number.	NUMBER(3, )
PROPOSAL_RESULT_USER_ID	Unique identification code of the user who entered or last updated the proposal project.	VARCHAR2(30)
PROPOSAL_SEQUENCE_NUMBER	Prospect proposal code sequence number.	NUMBER(3, )
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)

Ver: