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

SGHE 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.

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
ACCOUNT_DEFAULT Default account which is associated to the expense profile.    

FTCRACTG

ACCT_CODE

 
ACCOUNT_DEFAULT_DESC Default account description.    

FTVACCT

FTVACCT_TITLE

 
ACCOUNT_INDEX_DEFAULT Default account Index which is associated to the expense profile.    

FTCRACTG

ACCI_CODE

 
ACCOUNT_INDEX_DEFAULT_DESC Default account index description.    

FUNCTION

FOKODSF.F_GET_FINANCE_DESC

 
ACTIVITY_DEFAULT Default accounting activity which is associated to the expense profile.    

FTCRACTG

ACTV_CODE

 
ACTIVITY_DEFAULT_DESC Default activity description.    

FTVACTV

FTVACTV_TITLE

 
ADMINISTRATIVE_GROUP Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.    

NA

NA

 
CHART_OF_ACCOUNTS_DEFAULT Default chart of accounts which is associated to the expense profile.    

FTCRACTG

COAS_CODE

 
CHART_OF_ACCOUNTS_DEFAULT_DESC Default chart of accounts description.    

FUNCTION

FOKODSF.F_GET_FINANCE_DESC

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

FTCRACTG

PERCENT_OF_TOTAL

 
FUND_DEFAULT Default fiscal entity which is associated to the expense profile.    

FTCRACTG

FUND_CODE

 
FUND_DEFAULT_DESC Default fund description.    

FTVFUND

FTVFUND_TITLE

 
LOCATION_DEFAULT Default accounting physical location which is associated to the expense profile.    

FTCRACTG

LOCN_CODE

 
LOCATION_DEFAULT_DESC Default location description.    

FTVLOCN

FTVLOCN_TITLE

 
MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied.    

NA

NA

 
MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied.    

NA

NA

 
ORGANIZATION_DEFAULT Default department which is associated to the expense profile.    

FTCRACTG

ORGN_CODE

 
ORGANIZATION_DEFAULT_DESC Default department description.    

FTVORGN

FTVORGN_TITLE

 
PROCESS_GROUP Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.    

NA

NA

 
PROFILE_FUNDING_ACTIVITY_DATE Date information for this record in the table was entered or last updated.    

FTCRACTG

ACTIVITY_DATE

 
PROFILE_FUNDING_DATA_ORIGIN Source system that created or updated the data.    

FTCRACTG

DATA_ORIGIN

 
PROFILE_FUNDING_USER_ID Unique identification code of the user who entered or last touched the record.    

FTCRACTG

USER_ID

 
PROFILE_KEY Unique internal identification number of the expense profile record.    

FTOBPROF

ID

 
PROGRAM_DEFAULT Default program classification which is associated to the expense profile.    

FTCRACTG

PROG_CODE

 
PROGRAM_DEFAULT_DESC Default program description.    

FTVPROG

FTVPROG_TITLE

 
PROJECT_DEFAULT Default project used in cost accounting.    

FTCRACTG

PROJ_CODE

 
PROJECT_DEFAULT_DESC Default project description.    

FUNCTION

FOKODSF.F_GET_FINANCE_DESC

 


Ver: 8.3