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 Definition Database Data Type Source Name Source Column Local Source Local Target
ACCOUNT Code representing an account, such as revenue, labor, expenditure or transfer. VARCHAR2(63)

FBBBLIN

FBBBLIN_ACCT_CODE

NO

NO
ACCOUNTING_ID Accounting identification number. VARCHAR2(63)

NA

NA

NO

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

FTVACCT

FTVACCT_ACCT_CLASS_CODE

NO

NO
ACCOUNT_CLASS_DESC Account class description. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_SDAT_TITLE

NO

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

FUNCTION

F_GET_FINANCE_DESC

NO

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

FUNCTION

FOKODSF.F_GET_ACCT_HIER

NO

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

FUNCTION

FOKODSF.F_GET_ACCT_HIER

NO

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

FUNCTION

FOKODSF.F_GET_ACCT_HIER

NO

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

FUNCTION

FOKODSF.F_GET_ACCT_HIER

NO

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

FUNCTION

FOKODSF.F_GET_ACCT_HIER

NO

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

FUNCTION

FOKODSF.F_GET_ACCT_HIER

NO

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

FUNCTION

FOKODSF.F_GET_ACCT_HIER

NO

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

FTVACCT

FTVACCT_ACCT_CODE

NO

NO
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)

NO

NO
ACCOUNT_POOL_DESC 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

NO

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

FUNCTION

F_GET_FINANCE_STATUS

NO

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

FUNCTION

FOKODSF.F_GET_ACCT_HIER

NO

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

FUNCTION

FOKODSF.F_GET_ACCT_HIER

NO

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

FUNCTION

FOKODSF.F_GET_ACCT_HIER

NO

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

FUNCTION

FOKODSF.F_GET_ACCT_HIER

NO

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

FTVATYP

FTVATYP_TITLE

NO

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

FTVATYP

FTVATYP_TITLE

NO

NO
ACCOUNT_TYPE_LEVEL_1 Retrieves level 1 account type grouping within this account type hierarchy. VARCHAR2(63)

FTVATYP

FTVATYP_ATYP_CODE

NO

NO
ACCOUNT_TYPE_LEVEL_2 Retrieves level 2 account type grouping within this account type hierarchy. VARCHAR2(63)

FTVATYP

FTVATYP_ATYP_CODE

NO

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

FTVATYP

FTVATYP_STATUS_IND

NO

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

FTVATYP

FTVATYP_STATUS_IND

NO

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

FBBBLIN

FBBBLIN_ACTV_CODE

NO

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

FUNCTION

F_GET_FINANCE_DESC

NO

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

FUNCTION

F_GET_FINANCE_STATUS

NO

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

NA

NA

NO

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

FBBBLIN

FBBBLIN_AUDIT_EXISTS_IND

NO

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

FBBBLIN

FBBBLIN_ADOPT_BUD_AMT

NO

NO
BASE_BUDGETED_AMOUNT Base budget amount at the time of budget build. NUMBER

FBBBLIN

FBBBLIN_BASE_BUDG_AMT

NO

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

FBBBLIN

FBBBLIN_ADJT_BUD_AMT

NO

NO
BASE_CHART_OF_ACCOUNTS Source chart of accounts from which the budget was rolled. VARCHAR2(63)

FBBBLIN

FBBBLIN_BASE_COAS_CODE

NO

NO
BASE_CHART_OF_ACCOUNTS_DESC Hierarchy description or title appropriate for this level. VARCHAR2(255)

FTVCOAS

FTVCOAS_TITLE

NO

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

FTVCOAS

FTVCOAS_STATUS_IND

NO

NO
BASE_FISCAL_YEAR Source fiscal year from which the budget was rolled. VARCHAR2(63)

FUNCTION

FOFYCNV

NO

NO
BASE_TEMP_ADOPTED_BUDGET Temporary changes to adopted budget from operating ledger at the time of budget build. NUMBER

FBBBLIN

FBBBLIN_TEMP_ADOPT_AMT

NO

NO
BASE_TEMP_BUDGET_ADJUSTMENTS Temporary budget adjustments from operating ledger at the time of budget build. NUMBER

FBBBLIN

FBBBLIN_TEMP_ADJT_AMT

NO

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

FBBBLIN

FBBBLIN_ADJT_AMT

NO

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

CALCULATION

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

NO

NO
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

NO

NO
BUDGET_IDENTIFIER_DESC Budget description. VARCHAR2(255)

FTVOBUD

FTVOBUD_BUDG_TITLE

NO

NO
BUDGET_LINE_ITEM_ID System assigned budget line item identification code. VARCHAR2(63)

FBBBLIN

FBBBLIN_TEXT_SEQ_NUM

NO

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

FBBBLIN

FBBBLIN_OBPH_CODE

NO

NO
BUDGET_PHASE_DESC Budget phase description. VARCHAR2(255)

FTVOBPH

FTVOBPH_BUDG_PHASE_TITLE

NO

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

FUNCTION

FOFYCNV

NO

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

FBBBLIN

FBBBLIN_COAS_CODE

NO

NO
CHART_OF_ACCOUNTS_DESC Chart of accounts code description or title. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

NO

NO
CHART_OF_ACCOUNTS_STATUS Extracted current status of the associated chart of accounts. VARCHAR2(63)

FUNCTION

F_GET_FINANCE_STATUS

NO

NO
CURRENT_ADOPTED_BUDGET Extracted current cumulative adopted budget. NUMBER

FUNCTION

FOKODSF.F_CONCAT_OP_AMTS

NO

NO
CURRENT_BUDGET Extracted current cumulative budget as adopted budget plus current budget adjustments. NUMBER

FUNCTION

FOKODSF.F_CONCAT_OP_AMTS

NO

NO
CURRENT_BUDGET_ADJUSTMENTS Extracted current cumulative budget adjustments. NUMBER

FUNCTION

FOKODSF.F_CONCAT_OP_AMTS

NO

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

FUNCTION

FOKODSF.F_CONCAT_OP_AMTS

NO

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

FBRAUDT

FBRAUDT_DELETED_IND

NO

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

FBBBLIN

FBBBLIN_BUDG_DUR_CODE

NO

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

FBBBLIN

FBBBLIN_FUND_CODE

NO

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

FUNCTION

F_GET_FINANCE_DESC

NO

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

FUNCTION

FOKODSF.F_GET_FUND_HIER

NO

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

FUNCTION

FOKODSF.F_GET_FUND_HIER

NO

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

FUNCTION

FOKODSF.F_GET_FUND_HIER

NO

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

FUNCTION

FOKODSF.F_GET_FUND_HIER

NO

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

FUNCTION

FOKODSF.F_GET_FUND_HIER

NO

NO
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

NO

NO

NO
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

NO

NO
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

NO

NO
FUND_FMGR_FIRST_NAME Fund financial manager's first or given name. VARCHAR2(63)

FUNCTION

SPRIDEN

MGKFUNC.F_GET_PERSON_INFO

SPRIDEN_FIRST_NAME

NO

NO

NO
FUND_FMGR_LAST_NAME Fund financial manager's last name or surname. VARCHAR2(63)

FUNCTION

SPRIDEN

MGKFUNC.F_GET_PERSON_INFO

SPRIDEN_LAST_NAME

NO

NO

NO
FUND_FMGR_MIDDLE_NAME Fund financial manager's middle name. VARCHAR2(63)

FUNCTION

SPRIDEN

MGKFUNC.F_GET_PERSON_INFO

SPRIDEN_MI

NO

NO

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

FUNCTION

FOKODSF.F_GET_FUND_HIER

NO

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

FUNCTION

FOKODSF.F_GET_FUND_HIER

NO

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

FUNCTION

FOKODSF.F_GET_FUND_HIER

NO

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

FUNCTION

FOKODSF.F_GET_FUND_HIER

NO

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

FUNCTION

FOKODSF.F_GET_FUND_HIER

NO

NO
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)

NO

NO
FUND_POOL_DESC 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

NO

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

FUNCTION

F_GET_FINANCE_STATUS

NO

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

FUNCTION

FOKODSF.F_GET_FUND_HIER

NO

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

FUNCTION

FOKODSF.F_GET_FUND_HIER

NO

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

FUNCTION

FOKODSF.F_GET_FUND_HIER

NO

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

FUNCTION

FOKODSF.F_GET_FUND_HIER

NO

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

FUNCTION

FOKODSF.F_GET_FUND_HIER

NO

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

FTVFTYP

FTVFTYP_TITLE

NO

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

FTVFTYP

FTVFTYP_TITLE

NO

NO
FUND_TYPE_LEVEL_1 Retrieves level 1 fund type grouping within this fund type hierarchy. VARCHAR2(63)

FTVFTYP

FTVFTYP_FTYP_CODE

NO

NO
FUND_TYPE_LEVEL_2 Retrieves level 2 fund type grouping within this fund type hierarchy. VARCHAR2(63)

FTVFTYP

FTVFTYP_FTYP_CODE

NO

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

FTVFTYP

FTVFTYP_STATUS_IND

NO

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

FTVFTYP

FTVFTYP_STATUS_IND

NO

NO
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

NO

NO
INTERNAL_ACCOUNT_TYPE_DESC Retrieves description for system account type. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_SDAT_TITLE

NO

NO
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

NO

NO
INTERNAL_FUND_TYPE_DESC Retrieves description or title of the system fund grouping code. VARCHAR2(255)

FUNCTION

FOKODSF.F_GET_SDAT_TITLE

NO

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

FBBBLIN

FBBBLIN_LOCN_CODE

NO

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

FUNCTION

F_GET_FINANCE_DESC

NO

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

FUNCTION

FOKODSF.F_GET_LOCN_HIER

NO

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

FUNCTION

FOKODSF.F_GET_LOCN_HIER

NO

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

FUNCTION

FOKODSF.F_GET_LOCN_HIER

NO

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

FUNCTION

FOKODSF.F_GET_LOCN_HIER

NO

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

FUNCTION

FOKODSF.F_GET_LOCN_HIER

NO

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

FUNCTION

FOKODSF.F_GET_LOCN_HIER

NO

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

FUNCTION

FOKODSF.F_GET_LOCN_HIER

NO

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

FUNCTION

FOKODSF.F_GET_LOCN_HIER

NO

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

FUNCTION

FOKODSF.F_GET_LOCN_HIER

NO

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

FUNCTION

FOKODSF.F_GET_LOCN_HIER

NO

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

FUNCTION

F_GET_FINANCE_STATUS

NO

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

FUNCTION

FOKODSF.F_GET_LOCN_HIER

NO

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

FUNCTION

FOKODSF.F_GET_LOCN_HIER

NO

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

FUNCTION

FOKODSF.F_GET_LOCN_HIER

NO

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

FUNCTION

FOKODSF.F_GET_LOCN_HIER

NO

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

FUNCTION

FOKODSF.F_GET_LOCN_HIER

NO

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

NA

NA

NO

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

NA

NA

NO

NO
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

NO

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

FBBBLIN

FBBBLIN_ORGN_CODE

NO

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

FUNCTION

F_GET_FINANCE_DESC

NO

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

NO

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

NO

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

NO

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

NO

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

NO

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

NO

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

NO

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

NO

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

NO

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

NO

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

NO

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

NO

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

NO

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

NO

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

NO

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

NO

NO
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

NO

NO
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)

NO

NO
ORGANIZATION_POOL_DESC 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

NO

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

FUNCTION

F_GET_FINANCE_STATUS

NO

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

NO

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

NO

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

NO

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

NO

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

NO

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

NO

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

NO

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

FUNCTION

FOKODSF.F_GET_ORGN_HIER

NO

NO
ORGN_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

NO

NO

NO
ORGN_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

NO

NO
ORGN_FINANCIAL_MANAGER_UID System generated unique internal identification number assigned to the financial manager associated with this organization. NUMBER

FTVORGN

FTVORGN_FMGR_CODE_PIDM

NO

NO
ORGN_FMGR_FIRST_NAME Organization financial manager's first or given name. VARCHAR2(63)

FUNCTION

SPRIDEN

MGKFUNC.F_GET_PERSON_INFO

SPRIDEN_FIRST_NAME

NO

NO

NO
ORGN_FMGR_LAST_NAME Organization financial manager's last name or surname. VARCHAR2(63)

FUNCTION

SPRIDEN

MGKFUNC.F_GET_PERSON_INFO

SPRIDEN_LAST_NAME

NO

NO

NO
ORGN_FMGR_MIDDLE_NAME Organization financial manager's middle name. VARCHAR2(63)

FUNCTION

SPRIDEN

MGKFUNC.F_GET_PERSON_INFO

SPRIDEN_MI

NO

NO

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

FBBBLIN

FBBBLIN_BUDG_AMT

NO

NO
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

NO

NO
PRIOR_YTD_ACTIVITY Calculated prior year to date activity. NUMBER

FUNCTION

FOKODSF.F_CONCAT_OP_AMTS

NO

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

NA

NA

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

FBBBLIN

FBBBLIN_PROG_CODE

NO

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

FUNCTION

F_GET_FINANCE_DESC

NO

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

FUNCTION

FOKODSF.F_GET_PROG_HIER

NO

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

FUNCTION

FOKODSF.F_GET_PROG_HIER

NO

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

FUNCTION

FOKODSF.F_GET_PROG_HIER

NO

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

FUNCTION

FOKODSF.F_GET_PROG_HIER

NO

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

FUNCTION

FOKODSF.F_GET_PROG_HIER

NO

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

FUNCTION

FOKODSF.F_GET_PROG_HIER

NO

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

FUNCTION

FOKODSF.F_GET_PROG_HIER

NO

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

FUNCTION

FOKODSF.F_GET_PROG_HIER

NO

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

FUNCTION

FOKODSF.F_GET_PROG_HIER

NO

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

FUNCTION

FOKODSF.F_GET_PROG_HIER

NO

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

FUNCTION

F_GET_FINANCE_STATUS

NO

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

FUNCTION

FOKODSF.F_GET_PROG_HIER

NO

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

FUNCTION

FOKODSF.F_GET_PROG_HIER

NO

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

FUNCTION

FOKODSF.F_GET_PROG_HIER

NO

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

FUNCTION

FOKODSF.F_GET_PROG_HIER

NO

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

FUNCTION

FOKODSF.F_GET_PROG_HIER

NO

NO


Ver: 9.2