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_DESIGNATION

Target Column Business Definition Database Data Type Source Name Source Column
ACTIVITY_DATE Date that information for this record in the table was entered or last updated. DATE    
CAMPAIGN User defined code for a campaign. VARCHAR2(5)    
CAMPAIGN_DESG_STATUS Designation status for the campaign. VARCHAR2(1)    
CAMPAIGN_DESG_STATUS_DESC Designation status description. VARCHAR2(30)    
CAMPAIGN_DESIGNATION_GOAL Amount of the designation goal for the campaign. NUMBER( , )    
CURRENT_DATE This is a the system current date (sysdate). DATE    
DESG_STATUS_ACTIVE_IND Designation status active indicator. Determines if the status is active (Y)es, or inactive (N)o. VARCHAR2(1)    
DESIGNATION User defined code for a designation. VARCHAR2(10)    
DOMAIN_VALUE Domain column for future use, not currently populated. VARCHAR2(6)    
MIF_DESC 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 The institution value for the record when the optional multi-institution facility feature has been installed and applied for this table/column. VARCHAR2(6)    
ZONE_VALUE Zone column for future use, not currently populated. VARCHAR2(6)    


Ver: