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

Banner Operational Data Store
Composite View Target: AA_CAMPAIGN_EXPENSE

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target
ACTIVITY_DATE Date that information for this record in the table was entered or last updated. DATE       NO
CAMPAIGN User defined code for a campaign. VARCHAR2(5)       NO
CHECK_NUMBER Number of the check written to cover the expenditure. VARCHAR2(10)       NO
CURRENT_DATE This is a the system current date (sysdate). DATE       NO
DOMAIN_VALUE Domain column for future use, not currently populated. VARCHAR2(6)       NO
EXPENSE_AMOUNT Amount of campaign expenditure. NUMBER(20, 2)       NO
EXPENSE_DATE Date of campaign expenditure. DATE       NO
EXPENSE_DESC Campaign expense description. VARCHAR2(30)       NO
EXPENSE_REASON Reason for campaign expenditure. VARCHAR2(30)       NO
EXPENSE_SEQUENCE Internal sequence number for campaign expenses. NUMBER(5, )       NO
EXPENSE_TYPE Type of expense. VARCHAR2(2)       NO
FISCAL_YEAR Unique identifier or code for the fiscal year. NUMBER(4, )       NO
FISCAL_YEAR_DESC Fiscal year description. VARCHAR2(30)       NO
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)       NO
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)       NO
ZONE_VALUE Zone column for future use, not currently populated. VARCHAR2(6)       NO


Ver: