Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Finance Reporting View Reports

Banner Operational Data Store
Reporting View Target: BUDGET_DETAIL

Description Contains budget detail for a selected accounting distribution combination by budget id and budget phase. Additional reporting can be at the various hierarchy levels for fund, organization code, account, program and location.
Key & Frequency One row per budget ID per budget phase per budgeted line item ( chart of accounts, fund, organization code, account, program, activity, location).
Recommended Search Columns BUDGET_IDENTIFIER, BUDGET_PHASE, CHART_OF_ACCOUNTS, FUND, ORGANIZATION_CODE, ACCOUNT, PROGRAM, ACTIVITY, LOCATION
CHART_OF_ACCOUNTS, ORGANIZATION_CODE
CHART_OF_ACCOUNTS, PROGRAM
CHART_OF_ACCOUNTS, FUND
CHART_OF_ACCOUNTS, ACCOUNT
CHART_OF_ACCOUNTS, LOCATION

Target Column Business Name Business Definition Database Data Type Source Name Source Column
ACCOUNT Account Code representing an account, such as revenue, labor, expenditure or transfer. VARCHAR2(63)

FBBBLIN

FBBBLIN_ACCT_CODE

ACCOUNTING_ID Accounting ID Accounting identification number. VARCHAR2(63)

NA

NA

ACCOUNT_CLASS Account Class Class defines major accounting groups used in the system for fixed assets, endowments, sponsored research. VARCHAR2(63)

FTVACCT

FTVACCT_ACCT_CLASS_CODE

ACCOUNT_CLASS_DESC Account Class Description Account class description. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_SDAT_TITLE

ACCOUNT_DESC Account Description Account code description or title. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

ACCOUNT_DESC_1 Account Description 1 Retrieves description or title level 1 within this account hierarchy. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_ACCT_HIER

ACCOUNT_DESC_2 Account Description 2 Retrieves description or title level 2 within this account hierarchy. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_ACCT_HIER

ACCOUNT_DESC_3 Account Description 3 Retrieves description or title level 3 within this account hierarchy. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_ACCT_HIER

ACCOUNT_DESC_4 Account Description 4 Retrieves description or title level 4 within this account hierarchy. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_ACCT_HIER

ACCOUNT_LEVEL_1 Account Level 1 Retrieves level 1 account within this account hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_ACCT_HIER

ACCOUNT_LEVEL_2 Account Level 2 Retrieves level 2 account within this account hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_ACCT_HIER

ACCOUNT_LEVEL_3 Account Level 3 Retrieves level 3 account within this account hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_ACCT_HIER

ACCOUNT_LEVEL_4 Account Level 4 Retrieves level 4 account within this account hierarchy. VARCHAR2(63)

FTVACCT

FTVACCT_ACCT_CODE

ACCOUNT_POOL Account Pool Extracts the account pool and, if not found, replaces it with account for available balance checking. VARCHAR2(63)

CALCULATION

NVL(FTVACCT_ACCT_CODE_POOL,FTVACCT_ACCT_CODE)

ACCOUNT_POOL_DESC Account Pool Description Obtains account pool description and if the pool is not found, it replaces it with an account or title appropriate for this account description for available balance checking. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

ACCOUNT_STATUS Account Status Current status of the associated account. VARCHAR2(63)

FUNCTION

F_GET_FINANCE_STATUS

ACCOUNT_STATUS_1 Account Status 1 Retrieves status of level 1 account within this account hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_ACCT_HIER

ACCOUNT_STATUS_2 Account Status 2 Retrieves status of level 2 account within this account hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_ACCT_HIER

ACCOUNT_STATUS_3 Account Status 3 Retrieves status of level 3 account within this account hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_ACCT_HIER

ACCOUNT_STATUS_4 Account Status 4 Retrieves status of level 4 account within this account hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_ACCT_HIER

ACCOUNT_TYPE_DESC_1 Account Type Description 1 Retrieves description or title level 1 within this account type hierarchy. VARCHAR2(255)

FTVATYP

FTVATYP_TITLE

ACCOUNT_TYPE_DESC_2 Account Type Description 2 Retrieves description or title level 2 within this account type hierarchy. VARCHAR2(255)

FTVATYP

FTVATYP_TITLE

ACCOUNT_TYPE_LEVEL_1 Account Type Level 1 Retrieves level 1 account type grouping within this account type hierarchy. VARCHAR2(63)

FTVATYP

FTVATYP_ATYP_CODE

ACCOUNT_TYPE_LEVEL_2 Account Type Level 2 Retrieves level 2 account type grouping within this account type hierarchy. VARCHAR2(63)

FTVATYP

FTVATYP_ATYP_CODE

ACCOUNT_TYPE_STATUS_1 Account Type Status 1 Retrieves status of level 1 account type within this account type hierarchy. VARCHAR2(63)

FTVATYP

FTVATYP_STATUS_IND

ACCOUNT_TYPE_STATUS_2 Account Type Status 2 Retrieves status of level 2 account type within this account type hierarchy. VARCHAR2(63)

FTVATYP

FTVATYP_STATUS_IND

ACTIVITY Activity Code used to identify accounting data by activity. VARCHAR2(63)

FBBBLIN

FBBBLIN_ACTV_CODE

ACTIVITY_DESC Activity Description Activity code title or description. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

ACTIVITY_STATUS Activity Status Extracted current status of the associated activity. VARCHAR2(63)

FUNCTION

F_GET_FINANCE_STATUS

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

NA

NA

AUDIT_EXISTS_IND Audit Exists Indicator Indicates whether a row has any records in the audit table. Valid values are Y and N. VARCHAR2(63)

FBBBLIN

FBBBLIN_AUDIT_EXISTS_IND

BASE_ADOPTED_BUDGET Base Adopted Budget Adopted budget (original budget) amount from operating ledger at the time of budget build. NUMBER

FBBBLIN

FBBBLIN_ADOPT_BUD_AMT

BASE_BUDGETED_AMOUNT Base Budgeted Amount Base budget amount at the time of budget build. NUMBER

FBBBLIN

FBBBLIN_BASE_BUDG_AMT

BASE_BUDGET_ADJUSTMENTS Base Budget Adjustments Adjustments to budget from operating ledger at the time of budget build. NUMBER

FBBBLIN

FBBBLIN_ADJT_BUD_AMT

BASE_CHART_OF_ACCOUNTS Base Chart Of Accounts Source chart of accounts from which the budget was rolled. VARCHAR2(63)

FBBBLIN

FBBBLIN_BASE_COAS_CODE

BASE_CHART_OF_ACCOUNTS_DESC Base Chart Of Accounts Description Hierarchy description or title appropriate for this level. VARCHAR2(255)

FTVCOAS

FTVCOAS_TITLE

BASE_CHART_OF_ACCOUNTS_STATUS Base Chart Of Accounts Status Status of the Base Chart of Accounts. VARCHAR2(63)

FTVCOAS

FTVCOAS_STATUS_IND

BASE_FISCAL_YEAR Base Fiscal Year Source fiscal year from which the budget was rolled. VARCHAR2(63)

FUNCTION

FOFYCNV

BASE_TEMP_ADOPTED_BUDGET Base Temp Adopted Budget Temporary changes to adopted budget from operating ledger at the time of budget build. NUMBER

FBBBLIN

FBBBLIN_TEMP_ADOPT_AMT

BASE_TEMP_BUDGET_ADJUSTMENTS Base Temp Budget Adjustments Temporary budget adjustments from operating ledger at the time of budget build. NUMBER

FBBBLIN

FBBBLIN_TEMP_ADJT_AMT

BUDGET_ADJUSTMENT Budget Adjustment Adjusted budget that is the accumulation of all budget adjustments to this line item. NUMBER

FBBBLIN

FBBBLIN_ADJT_AMT

BUDGET_AMOUNT Budget Amount Calculated amount that includes the cumulative budget + budget adjustments. NUMBER

CALCULATION

(NVL(FBVBLDL_BUDG_AMT,0)+NVL(FBVBLDL_ADJT_AMT,0))

BUDGET_IDENTIFIER Budget Identifier User-defined unique identification of the budget. Generally Fiscal year for which the budget is being prepared. VARCHAR2(63)

FBBBLIN

FBBBLIN_OBUD_CODE

BUDGET_IDENTIFIER_DESC Budget Identifier Description Budget description. VARCHAR2(255)

FTVOBUD

FTVOBUD_BUDG_TITLE

BUDGET_LINE_ITEM_ID Budget Line Item ID System assigned budget line item identification code. VARCHAR2(63)

FBBBLIN

FBBBLIN_TEXT_SEQ_NUM

BUDGET_PHASE Budget Phase User-defined unique identifier of a budget phase identifier. VARCHAR2(63)

FBBBLIN

FBBBLIN_OBPH_CODE

BUDGET_PHASE_DESC Budget Phase Description Budget phase description. VARCHAR2(255)

FTVOBPH

FTVOBPH_BUDG_PHASE_TITLE

BUDGET_YEAR Budget Year Budget year defined for a budget identifier. VARCHAR2(63)

FUNCTION

FOFYCNV

CHART_OF_ACCOUNTS Chart Of Accounts Identifies the chart from other charts in a multi-chart environment. VARCHAR2(63)

FBBBLIN

FBBBLIN_COAS_CODE

CHART_OF_ACCOUNTS_DESC Chart Of Accounts Description Chart of accounts code description or title. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

CHART_OF_ACCOUNTS_STATUS Chart Of Accounts Status Extracted current status of the associated chart of accounts. VARCHAR2(63)

FUNCTION

F_GET_FINANCE_STATUS

CURRENT_ADOPTED_BUDGET Current Adopted Budget Extracted current cumulative adopted budget. NUMBER

FUNCTION

FOKODSF.F_CONCAT_OP_AMTS

CURRENT_BUDGET Current Budget Extracted current cumulative budget as adopted budget plus current budget adjustments. NUMBER

FUNCTION

FOKODSF.F_CONCAT_OP_AMTS

CURRENT_BUDGET_ADJUSTMENTS Current Budget Adjustments Extracted current cumulative budget adjustments. NUMBER

FUNCTION

FOKODSF.F_CONCAT_OP_AMTS

CURRENT_YTD_ACTIVITY Current Year to Date Activity Extracts cumulative year-to-date activity-using amounts calculated up through and including the current period. NUMBER

FUNCTION

FOKODSF.F_CONCAT_OP_AMTS

DELETED_IND Deleted Indicator Indicates that the record is in the audit table. VARCHAR2(63)

FBRAUDT

FBRAUDT_DELETED_IND

DURATION Duration Identifies the duration of the budget as either permanent or temporary. VARCHAR2(63)

FBBBLIN

FBBBLIN_BUDG_DUR_CODE

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

FBBBLIN

FBBBLIN_FUND_CODE

FUND_DESC Fund Description Description or title of the associated fund. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

FUND_DESC_1 Fund Description 1 Retrieves description or title level 1 within this fund hierarchy. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_FUND_HIER

FUND_DESC_2 Fund Description 2 Retrieves description or title level 2 within this fund hierarchy. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_FUND_HIER

FUND_DESC_3 Fund Description 3 Retrieves description or title level 3 within this fund hierarchy. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_FUND_HIER

FUND_DESC_4 Fund Description 4 Retrieves description or title level 4 within this fund hierarchy. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_FUND_HIER

FUND_DESC_5 Fund Description 5 Retrieves description or title level 5 within this fund hierarchy. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_FUND_HIER

FUND_FINANCIAL_MANAGER_ID Fund Financial Manager ID. System generated or manually assigned ID that uniquely identifies the financial manager. VARCHAR2(63)

FUNCTION

SPRIDEN

MGKFUNC.F_GET_PERSON_INFO

SPRIDEN_ID

FUND_FINANCIAL_MANAGER_NAME Fund Financial Manager Name Combination of the person's last name, first name, and middle initial into one value. VARCHAR2(255)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

FUND_FINANCIAL_MANAGER_UID Fund Financial Manager UID System generated, unique, internal identification number assigned to the financial manager associated with this fund. NUMBER

FTVFUND

FTVFUND_FMGR_CODE_PIDM

FUND_FMGR_FIRST_NAME Fund Financial Manager First Name Fund financial manager's first or given name. VARCHAR2(63)

FUNCTION

SPRIDEN

MGKFUNC.F_GET_PERSON_INFO

SPRIDEN_FIRST_NAME

FUND_FMGR_LAST_NAME Fund Financial Manager Last Name Fund financial manager's last name or surname. VARCHAR2(63)

FUNCTION

SPRIDEN

MGKFUNC.F_GET_PERSON_INFO

SPRIDEN_LAST_NAME

FUND_FMGR_MIDDLE_NAME Fund Financial Manager Middle Name Fund financial manager's middle name. VARCHAR2(63)

FUNCTION

SPRIDEN

MGKFUNC.F_GET_PERSON_INFO

SPRIDEN_MI

FUND_LEVEL_1 Fund Level 1 Retrieves level 1 fund within this fund hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_FUND_HIER

FUND_LEVEL_2 Fund Level 2 Retrieves level 2 fund within this fund hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_FUND_HIER

FUND_LEVEL_3 Fund Level 3 Retrieves level 3 fund within this fund hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_FUND_HIER

FUND_LEVEL_4 Fund Level 4 Retrieves level 4 fund within this fund hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_FUND_HIER

FUND_LEVEL_5 Fund Level 5 Retrieves level 5 fund within this fund hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_FUND_HIER

FUND_POOL Fund Pool Extracts fund pool and if not found, replaces with fund for available balance checking. VARCHAR2(63)

CALCULATION

NVL(FTVFUND_FUND_CODE_BAVL,FTVFUND_FUND_CODE)

FUND_POOL_DESC Fund Pool Description Obtains the budget fund description and if not found, replaces it with the fund description to be used for available balance checking. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

FUND_STATUS Fund Status Extracted current status of the associated fund. VARCHAR2(63)

FUNCTION

F_GET_FINANCE_STATUS

FUND_STATUS_1 Fund Status 1 Retrieves status of level 1 fund within this fund hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_FUND_HIER

FUND_STATUS_2 Fund Status 2 Retrieves status of level 2 fund within this fund hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_FUND_HIER

FUND_STATUS_3 Fund Status 3 Retrieves status of level 3 fund within this fund hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_FUND_HIER

FUND_STATUS_4 Fund Status 4 Retrieves status of level 4 fund within this fund hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_FUND_HIER

FUND_STATUS_5 Fund Status 5 Retrieves status of level 5 fund within this fund hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_FUND_HIER

FUND_TYPE_DESC_1 Fund Type Description 1 Retrieves description or title level 1 within this fund type hierarchy. VARCHAR2(255)

FTVFTYP

FTVFTYP_TITLE

FUND_TYPE_DESC_2 Fund Type Description 2 Retrieves description or title level 2 within this fund type hierarchy. VARCHAR2(255)

FTVFTYP

FTVFTYP_TITLE

FUND_TYPE_LEVEL_1 Fund Type Level 1 Retrieves level 1 fund type grouping within this fund type hierarchy. VARCHAR2(63)

FTVFTYP

FTVFTYP_FTYP_CODE

FUND_TYPE_LEVEL_2 Fund Type Level 2 Retrieves level 2 fund type grouping within this fund type hierarchy. VARCHAR2(63)

FTVFTYP

FTVFTYP_FTYP_CODE

FUND_TYPE_STATUS_1 Fund Type Status 1 Retrieves status of level 1 fund type within this fund type hierarchy. VARCHAR2(63)

FTVFTYP

FTVFTYP_STATUS_IND

FUND_TYPE_STATUS_2 Fund Type Status 2 Retrieves status of level 2 fund type within this fund type hierarchy. VARCHAR2(63)

FTVFTYP

FTVFTYP_STATUS_IND

INTERNAL_ACCOUNT_TYPE Internal Account Type Predefined values that represent account types linked to level one account types. Used to identify transactional data for processing and reporting purposes. VARCHAR2(63)

FTVATYP

FTVATYP_INTERNAL_ATYP_CODE

INTERNAL_ACCOUNT_TYPE_DESC Internal Account Type Description Retrieves description for system account type. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_SDAT_TITLE

INTERNAL_FUND_TYPE Internal Fund Type Predefined values representing fund types linked to level one fund types and are used to identify transactional data for processing and reporting purposes. VARCHAR2(63)

FTVFTYP

FTVFTYP_INTERNAL_FTYP_CODE

INTERNAL_FUND_TYPE_DESC Internal Fund Type Description Retrieves description or title of the system fund grouping code. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_SDAT_TITLE

LOCATION Location Identification accounting code of the physical location of the financial manager. VARCHAR2(63)

FBBBLIN

FBBBLIN_LOCN_CODE

LOCATION_DESC Location Description Extracted description or title of the associated location. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

LOCATION_DESC_1 Location Description 1 Retrieves description or title level 1 within this location hierarchy. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_LOCN_HIER

LOCATION_DESC_2 Location Description 2 Retrieves description or title level 2 within this location hierarchy. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_LOCN_HIER

LOCATION_DESC_3 Location Description 3 Retrieves description or title level 3 within this location hierarchy. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_LOCN_HIER

LOCATION_DESC_4 Location Description 4 Retrieves description or title level 4 within this location hierarchy. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_LOCN_HIER

LOCATION_DESC_5 Location Description 5 Retrieves description or title level 5 within this location hierarchy. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_LOCN_HIER

LOCATION_LEVEL_1 Location Level 1 Retrieves level 1 location within this location hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_LOCN_HIER

LOCATION_LEVEL_2 Location Level 2 Retrieves level 2 location within this location hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_LOCN_HIER

LOCATION_LEVEL_3 Location Level 3 Retrieves level 3 location within this location hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_LOCN_HIER

LOCATION_LEVEL_4 Location Level 4 Retrieves level 4 location within this location hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_LOCN_HIER

LOCATION_LEVEL_5 Location Level 5 Retrieves level 5 location within this location hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_LOCN_HIER

LOCATION_STATUS Location Status Extracted current status of the associated location. VARCHAR2(63)

FUNCTION

F_GET_FINANCE_STATUS

LOCATION_STATUS_1 Location Status 1 Retrieves status level 1 location within this location hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_LOCN_HIER

LOCATION_STATUS_2 Location Status 2 Retrieves status level 2 location within this location hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_LOCN_HIER

LOCATION_STATUS_3 Location Status 3 Retrieves status level 3 location within this location hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_LOCN_HIER

LOCATION_STATUS_4 Location Status 4 Retrieves status level 4 location within this location hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_LOCN_HIER

LOCATION_STATUS_5 Location Status 5 Retrieves status level 5 location within this location hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_LOCN_HIER

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

NORMAL_BALANCE Normal Balance Usual balance in the account as established by GAAP. For example, asset-debit, liability-credit, control-zero fund balance credit, revenues-credit, and expenditure-debit. VARCHAR2(63)

FTVACCT

FTVACCT_NORMAL_BAL

ORGANIZATION_CODE Organization Code Identification accounting code used for the department. VARCHAR2(63)

FBBBLIN

FBBBLIN_ORGN_CODE

ORGANIZATION_DESC Organization Description Extracted description or title associated with the organization code. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

ORGANIZATION_DESC_1 Organization Description 1 Retrieves description or title level 1 within this organization hierarchy. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_DESC_2 Organization Description 2 Retrieves description or title level 2 within this organization hierarchy. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_DESC_3 Organization Description 3 Retrieves description or title level 3 within this organization hierarchy. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_DESC_4 Organization Description 4 Retrieves description or title level 4 within this organization hierarchy. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_DESC_5 Organization Description 5 Retrieves description or title level 5 within this organization hierarchy. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_DESC_6 Organization Description 6 Retrieves description or title level 6 within this organization hierarchy. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_DESC_7 Organization Description 7 Retrieves description or title level 7 within this organization hierarchy. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_DESC_8 Organization Description 8 Retrieves description or title level 8 within this organization hierarchy. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_LEVEL_1 Organization Level 1 Retrieves level 1 organization within this organization hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_LEVEL_2 Organization Level 2 Retrieves level 2 organization within this organization hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_LEVEL_3 Organization Level 3 Retrieves level 3 organization within this organization hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_LEVEL_4 Organization Level 4 Retrieves level 4 organization within this organization hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_LEVEL_5 Organization Level 5 Retrieves level 5 organization within this organization hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_LEVEL_6 Organization Level 6 Retrieves level 6 organization within this organization hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_LEVEL_7 Organization Level 7 Retrieves level 7 organization within this organization hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_LEVEL_8 Organization Level 8 Retrieves level 8 organization within this organization hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_LOCK_STATUS Organization Lock Status Organization lock status. Possible values are UI for implicitly unlocked, UP for physically/explicitly unlocked, LI for implicitly locked and LP for physically/explicitly locked. Default value is UI. VARCHAR2(63)

FUNCTION

FBKBUDG.F_GETLOCKSTATUS

ORGANIZATION_POOL Organization Pool Extracts organization pool and if not found, replaces with organization for available balance checking. VARCHAR2(63)

CALCULATION

NVL(FTVORGN_ORGN_CODE_NSF,FTVORGN_ORGN_CODE)

ORGANIZATION_POOL_DESC Organization Pool Description Obtains organization pool description and if pool not found, replaces it with organization description for available balance checking. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

ORGANIZATION_STATUS Organization Status Extracted current status of the associated organization. VARCHAR2(63)

FUNCTION

F_GET_FINANCE_STATUS

ORGANIZATION_STATUS_1 Organization Status 1 Retrieves status of level 1 organization within this organization hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_STATUS_2 Organization Status 2 Retrieves status of level 2 organization within this organization hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_STATUS_3 Organization Status 3 Retrieves status of level 3 organization within this organization hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_STATUS_4 Organization Status 4 Retrieves status of level 4 organization within this organization hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_STATUS_5 Organization Status 5 Retrieves status of level 5 organization within this organization hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_STATUS_6 Organization Status 6 Retrieves status of level 6 organization within this organization hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_STATUS_7 Organization Status 7 Retrieves status of level 7 organization within this organization hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGANIZATION_STATUS_8 Organization Status 8 Retrieves status of level 8 organization within this organization hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_ORGN_HIER

ORGN_FINANCIAL_MANAGER_ID Orgnization Financial Manager ID System generated or manually assigned ID that uniquely identifies the financial manager. VARCHAR2(63)

FUNCTION

SPRIDEN

MGKFUNC.F_GET_PERSON_INFO

SPRIDEN_ID

ORGN_FINANCIAL_MANAGER_NAME Organization Financial Manager Name Combination of the person's last name, first name, and middle initial into one value. VARCHAR2(255)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

ORGN_FINANCIAL_MANAGER_UID Organization Financial Manager UID System generated unique internal identification number assigned to the financial manager associated with this organization. NUMBER

FTVORGN

FTVORGN_FMGR_CODE_PIDM

ORGN_FMGR_FIRST_NAME Organization Financial Manager First Name Organization financial manager's first or given name. VARCHAR2(63)

FUNCTION

SPRIDEN

MGKFUNC.F_GET_PERSON_INFO

SPRIDEN_FIRST_NAME

ORGN_FMGR_LAST_NAME Organization Financial Manager Last Name Organization financial manager's last name or surname. VARCHAR2(63)

FUNCTION

SPRIDEN

MGKFUNC.F_GET_PERSON_INFO

SPRIDEN_LAST_NAME

ORGN_FMGR_MIDDLE_NAME Organization Financial Manager Middle Name Organization financial manager's middle name. VARCHAR2(63)

FUNCTION

SPRIDEN

MGKFUNC.F_GET_PERSON_INFO

SPRIDEN_MI

ORIGINAL_BUDGET Original Budget This budget amount is the original amount entered for a given line item. NUMBER

FBBBLIN

FBBBLIN_BUDG_AMT

ORIGIN_POINT Origin Point Origin point from which the budget was originally copied. OPAL for rolled from operating ledger, NEW for newly created, or position for rolled from position control. VARCHAR2(63)

FBBBLIN

FBBBLIN_ORIGIN_POINT

PRIOR_YTD_ACTIVITY Prior Year to Date Activity Calculated prior year to date activity. NUMBER

FUNCTION

FOKODSF.F_CONCAT_OP_AMTS

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

NA

NA

PROGRAM 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(63)

FBBBLIN

FBBBLIN_PROG_CODE

PROGRAM_DESC Program Description Extracted description or title of the associated program. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

PROGRAM_DESC_1 Program Description 1 Retrieves description or title level 1 within this program hierarchy. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_PROG_HIER

PROGRAM_DESC_2 Program Description 2 Retrieves description or title level 2 within this program hierarchy. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_PROG_HIER

PROGRAM_DESC_3 Program Description 3 Retrieves description or title level 3 within this program hierarchy. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_PROG_HIER

PROGRAM_DESC_4 Program Description 4 Retrieves description or title level 4 within this program hierarchy. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_PROG_HIER

PROGRAM_DESC_5 Program Description 5 Retrieves description or title level 5 within this program hierarchy. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_PROG_HIER

PROGRAM_LEVEL_1 Program Level 1 Retrieves level 1 program within this program hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_PROG_HIER

PROGRAM_LEVEL_2 Program Level 2 Retrieves level 2 program within this program hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_PROG_HIER

PROGRAM_LEVEL_3 Program Level 3 Retrieves level 3 program within this program hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_PROG_HIER

PROGRAM_LEVEL_4 Program Level 4 Retrieves level 4 program within this program hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_PROG_HIER

PROGRAM_LEVEL_5 Program Level 5 Retrieves level 5 program within this program hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_PROG_HIER

PROGRAM_STATUS Program Status Extracted current status of the associated program. VARCHAR2(63)

FUNCTION

F_GET_FINANCE_STATUS

PROGRAM_STATUS_1 Program Status 1 Retrieves status of level 1 program within this program hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_PROG_HIER

PROGRAM_STATUS_2 Program Status 2 Retrieves status of level 2 program within this program hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_PROG_HIER

PROGRAM_STATUS_3 Program Status 3 Retrieves status of level 3 program within this program hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_PROG_HIER

PROGRAM_STATUS_4 Program Status 4 Retrieves status of level 4 program within this program hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_PROG_HIER

PROGRAM_STATUS_5 Program Status 5 Retrieves status of level 5 program within this program hierarchy. VARCHAR2(63)

FUNCTION

FOKODSF.F_GET_PROG_HIER



Ver: 9.2