Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Travel And Expense Reporting View Reports

Banner Operational Data Store
Reporting View Target: PROFILE_DEFAULT_ACCOUNTING

Description Contains default accounting information for a travel and expense owner profile.
Key & Frequency One row per profile owner per accounting distribution.
Recommended Search Columns PROFILE_KEY

Target Column Business Name Business Definition Database Data Type Source Name Source Column
ACCOUNT_DEFAULT Account Default Default account which is associated to the expense profile. VARCHAR2(63)

FTCRACTG

ACCT_CODE

ACCOUNT_DEFAULT_DESC Account Default Description Default account description. VARCHAR2(255)

FTVACCT

FTVACCT_TITLE

ACCOUNT_INDEX_DEFAULT Account INDEX Default Default account Index which is associated to the expense profile. VARCHAR2(63)

FTCRACTG

ACCI_CODE

ACCOUNT_INDEX_DEFAULT_DESC Account INDEX Default Description Default account index description. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_FINANCE_DESC

ACTIVITY_DEFAULT Activity Default Default accounting activity which is associated to the expense profile. VARCHAR2(63)

FTCRACTG

ACTV_CODE

ACTIVITY_DEFAULT_DESC Activity Default Description Default activity description. VARCHAR2(255)

FTVACTV

FTVACTV_TITLE

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

NA

NA

CHART_OF_ACCOUNTS_DEFAULT Chart Of Accounts Default Default chart of accounts which is associated to the expense profile. VARCHAR2(63)

FTCRACTG

COAS_CODE

CHART_OF_ACCOUNTS_DEFAULT_DESC Chart Of Accounts Default Description Default chart of accounts description. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_FINANCE_DESC

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

FTCRACTG

PERCENT_OF_TOTAL

FUND_DEFAULT Fund Default Default fiscal entity which is associated to the expense profile. VARCHAR2(63)

FTCRACTG

FUND_CODE

FUND_DEFAULT_DESC Fund Default Description Default fund description. VARCHAR2(255)

FTVFUND

FTVFUND_TITLE

LOCATION_DEFAULT Location Default Default accounting physical location which is associated to the expense profile. VARCHAR2(63)

FTCRACTG

LOCN_CODE

LOCATION_DEFAULT_DESC Location Default Description Default location description. VARCHAR2(255)

FTVLOCN

FTVLOCN_TITLE

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

ORGANIZATION_DEFAULT Organization Default Default department which is associated to the expense profile. VARCHAR2(63)

FTCRACTG

ORGN_CODE

ORGANIZATION_DEFAULT_DESC Organization Default Description Default department description. VARCHAR2(255)

FTVORGN

FTVORGN_TITLE

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

NA

NA

PROFILE_FUNDING_ACTIVITY_DATE Profile Funding Activity Date Date information for this record in the table was entered or last updated. DATE

FTCRACTG

ACTIVITY_DATE

PROFILE_FUNDING_DATA_ORIGIN Profile Funding Data Origin Source system that created or updated the data. VARCHAR2(63)

FTCRACTG

DATA_ORIGIN

PROFILE_FUNDING_USER_ID Profile Funding User ID Unique identification code of the user who entered or last touched the record. VARCHAR2(63)

FTCRACTG

USER_ID

PROFILE_KEY Profile KEY Unique internal identification number of the expense profile record. NUMBER

FTOBPROF

ID

PROGRAM_DEFAULT Program Default Default program classification which is associated to the expense profile. VARCHAR2(63)

FTCRACTG

PROG_CODE

PROGRAM_DEFAULT_DESC Program Default Description Default program description. VARCHAR2(255)

FTVPROG

FTVPROG_TITLE

PROJECT_DEFAULT Project Default Default project used in cost accounting. VARCHAR2(63)

FTCRACTG

PROJ_CODE

PROJECT_DEFAULT_DESC Project Default Description Default project description. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_FINANCE_DESC



Ver: 9.2