Queries

Query Query Description Prompts
FSU_BUD_AVAIL_BAL View Budget, Encumbrance, Expense, and Available Balance by department-fund-account
  • Budget Period
  • Fund (%)
  • Department (%)
FSU_BUD_AVAIL_BAL_DIM View Division, School Area, DDDHC, Budget Manager, Budget, Encumbrance, Expense, and Available Balance by department-fund-account
  • Budget Period
  • Fund (%)
  • Department (%)
FSU_BUD_FSUF_AVAIL_BAL View Budget, Encumbrance, Expense, and Available Balance by department-fund-project-account
  • Department From
  • Department To
  • FSF Project (%)
FSU_BUD_JRNL_NO_TYPE_PROMPT View all budget adjustments within a date range
  • Journal ID (%)
  • Account (%)
  • Department (%)
  • Fund (%)
  • Ref (%)
  • Fiscal Year
  • Jrnl Date (from)
  • Jrnl Date (to)
FSU_BUD_JRNL_W_TYPE_PROMPT View all budget adjustments or by specific entry type (e.g., recurring original, non-recurring adjustment, etc.)
  • Journal ID (%)
  • Account (%)
  • Department (%)
  • Fund (%)
  • Ref (%)
  • Fiscal Year
  • Entry Type
FSU_CF_DEPT_ATTRIB2 View auxiliary-specific information including auxiliary class, overhead percent, mission statement, and fund group
  • Department (%)
FSU_CF_DEPT_ALL_DESIGNATIONS View DDDHC, Budget Manager, Authorized Signer, Salary Preparer, Budget Preparer by department
  • Department ID (%)
  • Last Name (%)
FSU_DPT_CODES_DEPTID View DDDHC, Short Description, Purpose and Department Area
  • Department ID (%)
FSU_DPT_CASH_BALANCE View departmental cash balance
  • Business Unit (FSU01)
  • Non E-G Fund (%)
  • Department ID (%)
  • As of Journal Date
FSU_DPT_LEDGER_SUM_W_CF View GL account ledger summary
  • Fiscal Year
  • Begin Period
  • End Period
  • Department ID (%)
  • Fund (%)
  • Project (%)
  • Account (%)
  • Business Unit (FSU01)