Reporting View Target: CAMPAIGN

Go To View:	RETURN TO BANNER ODS META DATA REPORTS LIST
	Advancement Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: CAMPAIGN_EXPENSE

Description Contains information about all campaign expenses.
Key & Frequency One occurrence per campaign per expense sequence number.
Recommended Search Columns CAMPAIGN_TYPE
CAMPAIGN, EXPENSE_SEQUENCE
EXPENSE_TYPE

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column

ACTIVITY_DATE Activity Date Date information for this record in the table was entered or last updated. DATE
AFREXPN

AFREXPN_ACTIVITY_DATE

ADMINISTRATIVE_GROUP Administrative Group Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)
NA

NA

CAMPAIGN Campaign User defined code for a campaign. VARCHAR2(63)
AFREXPN

AFREXPN_CAMPAIGN

CAMPAIGN_NAME Campaign Name Campaign name. VARCHAR2(255)
AFBCAMP

AFBCAMP_NAME

CAMPAIGN_TYPE Campaign Type Type of campaign recorded. VARCHAR2(63)
AFBCAMP

AFBCAMP_CMTP_CODE

CAMPAIGN_TYPE_DESC Campaign Type Description Campaign type description. VARCHAR2(255)
ATVCMTP

ATVCMTP_DESC

CHECK_NUMBER Check Number Number of the check written to cover the expenditure. VARCHAR2(63)
AFREXPN

AFREXPN_CHECK_NO

EXPENSE_AMOUNT Expense Amount Amount of campaign expenditure. NUMBER
AFREXPN

AFREXPN_AMT

EXPENSE_DATE Expense Date Campaign expense date. DATE
AFREXPN

AFREXPN_DATE

EXPENSE_DESC Expense Description Campaign expense description. VARCHAR2(255)
GTVEXPN

GTVEXPN_DESC

EXPENSE_REASON Expense Reason Reason for campaign expenditure. VARCHAR2(255)
AFREXPN

AFREXPN_REASON

EXPENSE_SEQUENCE Expense Sequence Internal sequence number for campaign expenses. NUMBER
AFREXPN

AFREXPN_SEQ_NO

EXPENSE_TYPE Expense Type Type of expense. VARCHAR2(63)
AFREXPN

AFREXPN_EXPN_CODE

FISCAL_YEAR Fiscal Year Unique identifier or code for the fiscal year. VARCHAR2(63)
AFREXPN

AFREXPN_FISCAL_CODE

FISCAL_YEAR_DESC Fiscal Year Description Fiscal year description. VARCHAR2(255)
ATVFISC

ATVFISC_DESC

MULTI_SOURCE Multi Source Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)
NA

NA

MULTI_SOURCE_DESC Multi Source Description Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)
NA

NA

PROCESS_GROUP Process Group Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)
NA

NA

Ver: 9.0

Description	Contains information about all campaign expenses.
Key & Frequency	One occurrence per campaign per expense sequence number.
Recommended Search Columns	CAMPAIGN_TYPE CAMPAIGN, EXPENSE_SEQUENCE EXPENSE_TYPE

Target Column	Business Name	Business Definition	Database Data Type	Source Name	Source Column
ACTIVITY_DATE	Activity Date	Date information for this record in the table was entered or last updated.	DATE	AFREXPN	AFREXPN_ACTIVITY_DATE
ADMINISTRATIVE_GROUP	Administrative Group	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
CAMPAIGN	Campaign	User defined code for a campaign.	VARCHAR2(63)	AFREXPN	AFREXPN_CAMPAIGN
CAMPAIGN_NAME	Campaign Name	Campaign name.	VARCHAR2(255)	AFBCAMP	AFBCAMP_NAME
CAMPAIGN_TYPE	Campaign Type	Type of campaign recorded.	VARCHAR2(63)	AFBCAMP	AFBCAMP_CMTP_CODE
CAMPAIGN_TYPE_DESC	Campaign Type Description	Campaign type description.	VARCHAR2(255)	ATVCMTP	ATVCMTP_DESC
CHECK_NUMBER	Check Number	Number of the check written to cover the expenditure.	VARCHAR2(63)	AFREXPN	AFREXPN_CHECK_NO
EXPENSE_AMOUNT	Expense Amount	Amount of campaign expenditure.	NUMBER	AFREXPN	AFREXPN_AMT
EXPENSE_DATE	Expense Date	Campaign expense date.	DATE	AFREXPN	AFREXPN_DATE
EXPENSE_DESC	Expense Description	Campaign expense description.	VARCHAR2(255)	GTVEXPN	GTVEXPN_DESC
EXPENSE_REASON	Expense Reason	Reason for campaign expenditure.	VARCHAR2(255)	AFREXPN	AFREXPN_REASON
EXPENSE_SEQUENCE	Expense Sequence	Internal sequence number for campaign expenses.	NUMBER	AFREXPN	AFREXPN_SEQ_NO
EXPENSE_TYPE	Expense Type	Type of expense.	VARCHAR2(63)	AFREXPN	AFREXPN_EXPN_CODE
FISCAL_YEAR	Fiscal Year	Unique identifier or code for the fiscal year.	VARCHAR2(63)	AFREXPN	AFREXPN_FISCAL_CODE
FISCAL_YEAR_DESC	Fiscal Year Description	Fiscal year description.	VARCHAR2(255)	ATVFISC	ATVFISC_DESC
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA