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_MAIL

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)    
CURRENT_DATE This is a the system current date (sysdate). DATE    
DOMAIN_VALUE Domain column for future use, not currently populated. VARCHAR2(6)    
MAIL_CODE Type of mailings to be used with the campaign. VARCHAR2(3)    
MAIL_DATE Date when the item will be, or was, mailed. DATE    
MAIL_DESC Mail type description. VARCHAR2(30)    
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: