Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Advancement Composite View Reports

Banner Operational Data Store
Composite View Target: AA_PROSPECT_PROPOSAL_RESULT

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: