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.
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.
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.
CHR_LCD_AUDIT_TL_EARNS_DIST - Student Employee Task Profile
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.
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.
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_HR_ACCT_LN_JR_DT - HR ACCT Line Journal Date
This query retrieves data from the HR Accounting Line table and identifies the Journal Date previously used for an employee, Combo Code, or prior adjustment. This information can then be used to select a different Journal Date when creating a new adjustment.
Before running the query, enter the Business Unit, Fiscal Year, Accounting Period, and CHRS Employee ID.
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
CHR_LCD_ACTIVECOMBOCODE - Active Combo Codes
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.
CHR_LCD_COMBOCODE - Inactive Combo Codes
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