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 Local Source Local Target
ACCOUNT Code representing an account, such as assets, liability, control, fund balance, revenue, labor, expenditure or transfer. VARCHAR2(6)

FTCRACTG

ACCT_CODE

NO

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

FTCRACTG

ID

NO

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

FTCRACTG

ACCI_CODE

NO

NO
ACCOUNT_INDEX_DESC Account index description. VARCHAR2(35)

FUNCTION

FOKODSF.F_GET_FINANCE_DESC

NO

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

FTCRACTG

ACTV_CODE

NO

NO
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

NO

NO
BANK Official banking institution. VARCHAR2(2)

FTCRACTG

BANK_CODE

NO

NO
BANK_DESC Official banking institution name. VARCHAR2(35)

GXVBANK

GXVBANK_ACCT_NAME

NO

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

GXVBANK

GXVBANK_BANK_CODE_PIDM

NO

NO
CALCULATED_AMOUNT_NO_TAX   NUMBER       NO
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

NO

NO
CHART_OF_ACCOUNTS_DESC Chart of accounts description. VARCHAR2(35)

FUNCTION

FOKODSF.F_GET_FINANCE_DESC

NO

NO
CURRENT_DATE SYSDATE. DATE

FUNCTION

SYSDATE

NO

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

FTCRACTG

PERCENT_OF_TOTAL

NO

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

NA

NA

NO

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

FTCRACTG

FTPREXPS_ID

NO

NO
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

NO

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

FTCRACTG

FUND_CODE

NO

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

FTCRACTG

ACTIVITY_DATE

NO

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

FTCRACTG

CREATE_DATE

NO

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

FTCRACTG

CREATE_SOURCE

NO

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

FTCRACTG

CREATE_USER

NO

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

FTCRACTG

DATA_ORIGIN

NO

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

FTCRACTG

USER_ID

NO

NO
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

NO

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

NA

NA

NO

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

NA

NA

NO

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

FTCRACTG

ORGN_CODE

NO

NO
PAY_CURRENCY_AMOUNT   NUMBER       NO
PAY_CURRENCY_AMOUNT_NO_TAX   NUMBER       NO
PORTFOLIO_KEY Unique internal identification number of the portfolio record. NUMBER

FTCRACTG

FTPBPORT_ID

NO

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

FTCRACTG

FTOBPROF_ID

NO

NO
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

NO

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

FTCRACTG

PROJ_CODE

NO

NO
PROJECT_DESC Project description. VARCHAR2(35)

FUNCTION

FOKODSF.F_GET_FINANCE_DESC

NO

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

NA

NA

NO

NO


Ver: