Campuses can create their own private queries; however, they should first review the delivered queries to see if an existing one meets their needs before creating a new one.
Please note that not all delivered queries may be documented or identical, as modifications and ongoing development may result in differences.
Real-time audit query to capture employees with a blank Pay Group (PAYGROUP) that need to be fixed before proceeding with LCD processing.
Real-time audit query to capture employees with a blank Employee Classification (EMPL_CLASS) that need to be fixed before proceeding with LCD processing.
This real-time audit query identifies student employees who have been assigned a student Task Profile. Task Profiles determine which Time & Labor tasks users can select, and those selections drive the chartfields/Combo Code used for certain time entries.
These task-based funding selections flow into LCD through CSU TL Earnings Distribution (stored in CSU_TL_ERN_DIST) and can be adjusted using CSU Combo Code Override prior to downstream LCD distribution.
Real-time audit query to confirm no errors were missed before moving on to the next step in the LCD process when completing the Paycheck Error cleanup.
The report will have an Error Status column, that will allow campuses to find the rows that do not show as “M” for Modified.
Real-time audit query to help campuses confirm the GL Interface/Export Accounting Lines total for comparison between CHRS and CFS.
Released to campuses on 9/10/2025
Real-time audit query to help campuses confirm the LCD Table Refresh line count for comparison between CHRS and CFS.
Released to campuses on 9/10/2025
This query identifies active Combo Codes by department. Active Combo Codes are those that are effective and valid as of the date LCD uses them—typically the pay end date of the charge period—allowing distribution to assign them without error. These codes should pass CSU Combo Code Validation, confirming they exist in PS_VALID_COMBO_TBL for that effective date and that the associated chartfields are valid for journaling.
This query identifies inactive Combo Codes by department. These are codes that are not active or effective as of the date needed by LCD—typically the pay end date of the charge period—which can prevent LCD from assigning them during distribution. As a result, they may appear as distribution errors or be flagged during Combo Code Validation when the code is not valid in PS_VALID_COMBO_TBL for that effective date.
End of Article