CHRS Knowledge Base

LCD Delivered Queries for CHRS 

Updated on

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.

CHR_LCD_AUDIT_BLANK_PAYGROUP - Blank Paygroup

Real-time audit query to capture employees with a blank Pay Group (PAYGROUP) that need to be fixed before proceeding with LCD processing.

Released to campuses on 9/10/2025

CHR_LCD_AUDIT_BLANK_EMPL_CLASS - Blank Employee Classification

Real-time audit query to capture employees with a blank Employee Classification (EMPL_CLASS) that need to be fixed before proceeding with LCD processing.

Released to campuses on 9/10/2025

CHR_LCD_AUDIT_TL_EARNS_DIST - Student Employee Task Profile

Real-time audit query to capture student employees who have had a student task profile.

Released to campuses on 9/10/2025

CHR_LCD_CHECK_ERROR_CONFIRM - Paycheck Error Cleanup

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.

Released to campuses on 9/10/2025

CHR_LCD_HR_ACCTG_LINE_COUNT - Export Accounting Line Row Count

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

CHR_LCD_LABOR_DIST_COUNT - LCD Reporting Table Row Count

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

End of Article

0 Comments

Add your comment

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Previous Article (job aid) LCD Troubleshooting Guide
Next Article (job aid) LCD Flowchart
Do you need an article? Contact Us