Composite View Target: AE

Go To View:	RETURN TO BANNER COMP META DATA REPORTS LIST
	Travel And Expense Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AE_ACCOUNTING

Description Contains general expense authorization accounting data including, fiscal year/period, accounting distribution, and approved amount. Additional reporting can be by financial manager or the various hierarchy levels of the fund, organization code, account, program, and location.
Key & Frequency One row per accounting key.

Target Column Business Definition Database Data Type Source Name Source Column

ACCOUNT Code representing an account, such as assets, liability, control, fund balance, revenue, labor, expenditure or transfer. VARCHAR2(6)
FTCRACTG

ACCT_CODE

ACCOUNTING_KEY Unique internal identification number of the accounting record. NUMBER
FTCRACTG

ID

ACCOUNT_INDEX Account Index used to default an accounting distribution. VARCHAR2(6)
FTCRACTG

ACCI_CODE

ACCOUNT_INDEX_DESC Account index description. VARCHAR2(35)
FUNCTION

FOKODSF.F_GET_FINANCE_DESC

ACTIVITY Code used to identify accounting data by activity. VARCHAR2(6)
FTCRACTG

ACTV_CODE

AMOUNT Amount entered on the funding source to be used for the expense. The total of amount and percent (if any) must be equal to 100 percent for the expense item at final approval. NUMBER
FTCRACTG

AMOUNT

BANK Official banking institution. VARCHAR2(2)
FTCRACTG

BANK_CODE

BANK_DESC Official banking institution name. VARCHAR2(35)
GXVBANK

GXVBANK_ACCT_NAME

BANK_UID Internal identification number of the bank used at the time the transaction occurred. NUMBER
GXVBANK

GXVBANK_BANK_CODE_PIDM

CALCULATED_AMOUNT_NO_TAX NUMBER

CHART_OF_ACCOUNTS Represents a systematic classification of accounts. Identifies a separate and distinct entity-accounting relationship within a multi-chart environment. VARCHAR2(1)
FTCRACTG

COAS_CODE

CHART_OF_ACCOUNTS_DESC Chart of accounts description. VARCHAR2(35)
FUNCTION

FOKODSF.F_GET_FINANCE_DESC

CURRENT_DATE SYSDATE. DATE
FUNCTION

SYSDATE

DISTRIBUTION_PERCENT Percentage of the transaction total amount assigned to this accounting distribution. NUMBER
FTCRACTG

PERCENT_OF_TOTAL

DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(6)
NA

NA

EXPENSE_ITEM_KEY Unique internal identification number of the expense item record. NUMBER
FTCRACTG

FTPREXPS_ID

FINANCE_SECURITY_ID Oracle user ID linked to the expense owner PIDM when it is available. Used for fund organization security checking in the event a finance profile exists for the expense owner. VARCHAR2(30)
FTCRACTG

ORACLE_ID

FUND Financial Aid Fund code to be associated with information in this record. VARCHAR2(6)
FTCRACTG

FUND_CODE

FUNDING_ACTIVITY_DATE Date information for this record in the table was entered or last updated. DATE
FTCRACTG

ACTIVITY_DATE

FUNDING_CREATE_DATE Date and time when the new expense detail record was created. DATE
FTCRACTG

CREATE_DATE

FUNDING_CREATE_SOURCE Source system that created the data. VARCHAR2(30)
FTCRACTG

CREATE_SOURCE

FUNDING_CREATE_USER Banner ID of the person who created this new record. VARCHAR2(30)
FTCRACTG

CREATE_USER

FUNDING_DATA_ORIGIN Source system that created or updated the data. VARCHAR2(30)
FTCRACTG

DATA_ORIGIN

FUNDING_USER_ID Unique identification code of the user who entered or last touched the transaction. VARCHAR2(30)
FTCRACTG

USER_ID

LOCATION Identification accounting code of a physical location, used in fixed assets to define the location a fixed asset has been assigned to. VARCHAR2(6)
FTCRACTG

LOCN_CODE

MIF_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(30)
NA

NA

MIF_VALUE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(6)
NA

NA

ORGANIZATION_CODE Identification accounting code designating a department within the institution. VARCHAR2(6)
FTCRACTG

ORGN_CODE

PAY_CURRENCY_AMOUNT NUMBER

PAY_CURRENCY_AMOUNT_NO_TAX NUMBER

PORTFOLIO_KEY Unique internal identification number of the portfolio record. NUMBER
FTCRACTG

FTPBPORT_ID

PROFILE_KEY Unique internal identification number of the profile record. NUMBER
FTCRACTG

FTOBPROF_ID

PROGRAM Student's program, curriculum or course of study. This may be Data Not Available when program codes have not been defined by the institution. The alternate curriculum identification is by a combination of college, degree and major codes. VARCHAR2(6)
FTCRACTG

PROG_CODE

PROJECT Identification code for a project defined in cost accounting. VARCHAR2(8)
FTCRACTG

PROJ_CODE

PROJECT_DESC Project description. VARCHAR2(35)
FUNCTION

FOKODSF.F_GET_FINANCE_DESC

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

NA

Ver:

Description	Contains general expense authorization accounting data including, fiscal year/period, accounting distribution, and approved amount. Additional reporting can be by financial manager or the various hierarchy levels of the fund, organization code, account, program, and location.
Key & Frequency	One row per accounting key.

Target Column	Business Definition	Database Data Type	Source Name	Source Column
ACCOUNT	Code representing an account, such as assets, liability, control, fund balance, revenue, labor, expenditure or transfer.	VARCHAR2(6)	FTCRACTG	ACCT_CODE
ACCOUNTING_KEY	Unique internal identification number of the accounting record.	NUMBER	FTCRACTG	ID
ACCOUNT_INDEX	Account Index used to default an accounting distribution.	VARCHAR2(6)	FTCRACTG	ACCI_CODE
ACCOUNT_INDEX_DESC	Account index description.	VARCHAR2(35)	FUNCTION	FOKODSF.F_GET_FINANCE_DESC
ACTIVITY	Code used to identify accounting data by activity.	VARCHAR2(6)	FTCRACTG	ACTV_CODE
AMOUNT	Amount entered on the funding source to be used for the expense. The total of amount and percent (if any) must be equal to 100 percent for the expense item at final approval.	NUMBER	FTCRACTG	AMOUNT
BANK	Official banking institution.	VARCHAR2(2)	FTCRACTG	BANK_CODE
BANK_DESC	Official banking institution name.	VARCHAR2(35)	GXVBANK	GXVBANK_ACCT_NAME
BANK_UID	Internal identification number of the bank used at the time the transaction occurred.	NUMBER	GXVBANK	GXVBANK_BANK_CODE_PIDM
CALCULATED_AMOUNT_NO_TAX		NUMBER
CHART_OF_ACCOUNTS	Represents a systematic classification of accounts. Identifies a separate and distinct entity-accounting relationship within a multi-chart environment.	VARCHAR2(1)	FTCRACTG	COAS_CODE
CHART_OF_ACCOUNTS_DESC	Chart of accounts description.	VARCHAR2(35)	FUNCTION	FOKODSF.F_GET_FINANCE_DESC
CURRENT_DATE	SYSDATE.	DATE	FUNCTION	SYSDATE
DISTRIBUTION_PERCENT	Percentage of the transaction total amount assigned to this accounting distribution.	NUMBER	FTCRACTG	PERCENT_OF_TOTAL
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA
EXPENSE_ITEM_KEY	Unique internal identification number of the expense item record.	NUMBER	FTCRACTG	FTPREXPS_ID
FINANCE_SECURITY_ID	Oracle user ID linked to the expense owner PIDM when it is available. Used for fund organization security checking in the event a finance profile exists for the expense owner.	VARCHAR2(30)	FTCRACTG	ORACLE_ID
FUND	Financial Aid Fund code to be associated with information in this record.	VARCHAR2(6)	FTCRACTG	FUND_CODE
FUNDING_ACTIVITY_DATE	Date information for this record in the table was entered or last updated.	DATE	FTCRACTG	ACTIVITY_DATE
FUNDING_CREATE_DATE	Date and time when the new expense detail record was created.	DATE	FTCRACTG	CREATE_DATE
FUNDING_CREATE_SOURCE	Source system that created the data.	VARCHAR2(30)	FTCRACTG	CREATE_SOURCE
FUNDING_CREATE_USER	Banner ID of the person who created this new record.	VARCHAR2(30)	FTCRACTG	CREATE_USER
FUNDING_DATA_ORIGIN	Source system that created or updated the data.	VARCHAR2(30)	FTCRACTG	DATA_ORIGIN
FUNDING_USER_ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(30)	FTCRACTG	USER_ID
LOCATION	Identification accounting code of a physical location, used in fixed assets to define the location a fixed asset has been assigned to.	VARCHAR2(6)	FTCRACTG	LOCN_CODE
MIF_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)	NA	NA
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)	NA	NA
ORGANIZATION_CODE	Identification accounting code designating a department within the institution.	VARCHAR2(6)	FTCRACTG	ORGN_CODE
PAY_CURRENCY_AMOUNT		NUMBER
PAY_CURRENCY_AMOUNT_NO_TAX		NUMBER
PORTFOLIO_KEY	Unique internal identification number of the portfolio record.	NUMBER	FTCRACTG	FTPBPORT_ID
PROFILE_KEY	Unique internal identification number of the profile record.	NUMBER	FTCRACTG	FTOBPROF_ID
PROGRAM	Student's program, curriculum or course of study. This may be Data Not Available when program codes have not been defined by the institution. The alternate curriculum identification is by a combination of college, degree and major codes.	VARCHAR2(6)	FTCRACTG	PROG_CODE
PROJECT	Identification code for a project defined in cost accounting.	VARCHAR2(8)	FTCRACTG	PROJ_CODE
PROJECT_DESC	Project description.	VARCHAR2(35)	FUNCTION	FOKODSF.F_GET_FINANCE_DESC
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA