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

SGHE Banner Operational Data Store
Composite View Target: AA_CAMPAIGN_SOLICITATION

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column
ACTIVITY_DATE Activity Date Date that information for this record in the table was entered or last updated. DATE      
CAMPAIGN Campaign User defined code for a campaign. VARCHAR2(5)      
CAMPAIGN_SOLICITATION_GOAL Campaign Solicitation Goal Monetary value of the solicitation goal for the campaign. NUMBER( , )      
CURRENT_DATE Current Date This is a the system current date (sysdate). DATE      
DOMAIN_VALUE Domain Value Domain column for future use, not currently populated. VARCHAR2(6)      
MIF_DESC MIF Description The institution description for the record when the optional multi-institution facility feature has been installed and applied for this table/column. VARCHAR2(30)      
MIF_VALUE MIF Value The institution value for the record when the optional multi-institution facility feature has been installed and applied for this table/column. VARCHAR2(6)      
SOLICITATION_TYPE Solicitation Type Campaign solicitation type. VARCHAR2(15)      
SOLICITATION_TYPE_DESC Solicitation Type Description Campaign solicitation type description. VARCHAR2(30)      
ZONE_VALUE Zone Value Zone column for future use, not currently populated. VARCHAR2(6)      


Ver: