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 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_DESG_STATUS Campaign Designation Status Designation status for the campaign. VARCHAR2(1)      
CAMPAIGN_DESG_STATUS_DESC Campaign Designation Status Description Designation status description. VARCHAR2(30)      
CAMPAIGN_DESIGNATION_GOAL Campaign Designation Goal Amount of the designation goal for the campaign. NUMBER( , )      
CURRENT_DATE Current Date This is a the system current date (sysdate). DATE      
DESG_STATUS_ACTIVE_IND Designation Status Active Indicator Designation status active indicator. Determines if the status is active (Y)es, or inactive (N)o. VARCHAR2(1)      
DESIGNATION Designation User defined code for a designation. VARCHAR2(10)      
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)      
ZONE_VALUE Zone Value Zone column for future use, not currently populated. VARCHAR2(6)      


Ver: