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.