Running Commitment Accounting Queries

Running Commitment Accounting Queries (Last Updated: 5/2/2019)

The System Manager Reporting Page allows you to access several queries relating to Commitment Accounting:

  • Combo Codes (180_CA_COMBO_CODES_PROMPT)
  • Positions Funded by Suspense (180_CA_SUSPENSE_FUNDED)
  • Payroll Expenses Detail (180_CA_PERS_SERV_BOR)
  • Personal Serv Encumbrance Dtl (180_CA_BUD_ACTUALS_SUM_POS)
  • Vacant Position Funding (180_CA_VACANT_POS_FUND)
  • Vacant Position No Funding (180_CA_VACANT_POS_NO_DBT)
  • Vacant Pos by Dept (180_CA_VACANT_POSITIONS)
  • Position Funding Details (180_CA_POSITION_FUNDING_V3)
  • Status of EDRs (BOR_CA_EDR_STATUS)
  • Approved but not processed (BOR_CA_EDR_APPR_NOT_PROCESSED)
  • Compare Before & After EDR (BOR_CA_EDR_COMPARE)
  • PSB Data for retro (BOR_CA_EDR_DATA_FOR_EDR)
  • Look up EDR transaction by JE (BOR_CA_EDR_LOOKUP_BY_JRNL_ID)
  • Denied but still locked (BOR_CA_EDR_DENIED_LOCKED)
  • All locked EMPLID/Positions (BOR_CA_EDR_LOCKS)
  • Submitted, not approved (BOR_CA_EDR_NOT_APPROVED)

Additional queries are continually added. Check the System Manager Reporting Page menu for the most up-to-date listing of available queries.

Print Article