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

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: