Queries
Query | Query Description | Prompts |
---|---|---|
FSU_BUD_AVAIL_BAL | View Budget, Encumbrance, Expense, and Available Balance by department-fund-account |
|
FSU_BUD_AVAIL_BAL_DIM | View Division, School Area, DDDHC, Budget Manager, Budget, Encumbrance, Expense, and Available Balance by department-fund-account |
|
FSU_BUD_FSUF_AVAIL_BAL | View Budget, Encumbrance, Expense, and Available Balance by department-fund-project-account |
|
FSU_BUD_JRNL_NO_TYPE_PROMPT | View all budget adjustments within a date range |
|
FSU_BUD_JRNL_W_TYPE_PROMPT | View all budget adjustments or by specific entry type (e.g., recurring original, non-recurring adjustment, etc.) |
|
FSU_CF_DEPT_ATTRIB2 | View auxiliary-specific information including auxiliary class, overhead percent, mission statement, and fund group |
|
FSU_CF_DEPT_ALL_DESIGNATIONS | View DDDHC, Budget Manager, Authorized Signer, Salary Preparer, Budget Preparer by department |
|
FSU_DPT_CODES_DEPTID | View DDDHC, Short Description, Purpose and Department Area |
|
FSU_DPT_CASH_BALANCE | View departmental cash balance |
|
FSU_DPT_LEDGER_SUM_W_CF | View GL account ledger summary |
|
Training Presentations
The Budget Office provides the following classes (click the class title to view the training materials):
Budgeting (BTAC05) - Coming Soon
For Budget Managers and other fiscal personnel. Topics covered include the various types of budget entities at the University, policies and procedures related to each, Budget Manager responsibilities, Commitment Control ledgers, Budget Transfers, and general resources that Financials users may find helpful. Please note: Budgeting related to Sponsored Research or C&G departments are not specifically addressed.
Introduction to Auxiliary & Designated (BTBUD2)
For Budget Managers and other fiscal personnel. An introduction to Auxiliaries, including how to create a new auxiliary, classification of different auxiliary types, policies and procedures, rate methodology, audit expectations, and record retention requirements. Other topics covered include a timeline of important dates, overhead assessments, and available resources.
Auxiliary Rate Calculation (BTBUD3)
For budget managers and fiscal personnel who prepare University auxiliary rate calculations. This class covers regulatory framework for a rate calculation, Basic concepts for calculating a rate, an example of an auxiliary rate calculation along with reconciliation of expenses and an allowable cash balance worksheet using University financial records, documents and resources, and models for estimating auxiliary revenue hourly, cost plus and cost plus fixed.
E&G Rate Reconciliation Using BI Reports (BTRRR1)
For school E&G rate managers who balance E&G positions to E&G Allocations. This class covers basic rate reconciliation procedures using the E&G Allocations and E&G Rate Variance reports in BI.
E&G Rate and Salary Budgets (BTRSB1)
An overview of E&G rate, salary, and the resources available for managing E&G salary budgets.
Job Aids