CHRS Knowledge Base

Baseline Queries to Run: Open Enrollment

Updated on

Revision Date Revised By Summary of Revisions Section(s) Revised
06/12/25
Sande Meith
Original User Guide updated for formatting and security roles, previous updates on original document Throughout document
08/21/25 Training Separated original user guide into separate KB Articles,  updates will now be documented in KB platform.

Queries

All campuses, whether they are View-Only eBenefits Self Service or Full eBenefits Self Service, should run the CHRS Benefits Baseline queries listed below to help manage the Open Enrollment process in CHRS.

These queries are available in Query Manager, Query Viewer, and on the CSU Benefits Administrator Tile.

CHRS Benefits Baseline Query Name Query Explanation Use if View-Only eBenefits Self Service campus?
CSU_BAS_SS_Events Shows employees with an OE BAS event and the OE BAS event Process Status and Event Status. Yes
CSU_BAS_SS_NT Shows employees who have looked at the OE BAS event in Full eBenefits self-service, and who may have entered benefit elections in Full eBenefits self-service but have not submitted their benefit enrollments. Benefit enrollments not submitted are not processed (finalized-enrolled) in CHRS. Follow-up with employees who have an OE BAS event Process Status of NT. No
CSU_BAS_ELECTRONIC_ESIGNATURE Displays the employee’s electronic signature for benefit enrollments if the employee has submitted their open enrollment electronic signature.
Follow-up with employees who have submitted their OE benefit changes but have not submitted their electronic signature.
No

Review the Schedule Summary page daily to monitor the OE Schedule ID for your campus

  • Navigation
    • NavBar Icon > Menu > Benefits > Manage Automated Enrollment > Review Processing Results > Schedule Summary
schedule summary page

Daily Benefits Review - Job Aids

The following job aids show Benefits Officers what and how to review daily campus specific CSUBASDL and CSUBASOE process logs from the nightly Ben Admin processing, daily CHRS baseline queries and daily campus specific reports.

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) Configure BAS Group ID
Next Article (job aid) Create OE BAS Event After Finalization
Do you need an article? Contact Us