Daily Review BA Baseline Queries

Updated on Apr 17, 2025

Overview

This job aid shows Benefits Officers how to find Benefits baseline queries that they need to review daily.

Daily Review Items

A Benefits Officer must review the following items daily. Issues that are listed on these items must be corrected daily.

Review Item	Details	Navigation
CSUBASDL logs and reports	CSU_PERM_DEL CSU_BA18003 CSUBA01A CSU_BA_EV_DT PSPBARUN CSU_PERM_INS	Reporting tools > Report Manager
CSU Benefits Reports	CSU Benefits Termination Rpt CSU Benefits Transaction Rpt CSU Job Changes Prior Ben Admin CSU Snapshot Unique Constraint	Benefits > Reports > CSU Benefits Reports or on the CSU Benefits Administrator Tile > Reports
Exceptions Reports	Invalid Elections Rpt Report on Flagged Items CSU Process Status Rpt	Benefits > Manage Automated Enrollment > Investigate Exceptions or on the CSU Benefits Administrator Tile > Reports Download the reports to a shared drive. Compare new daily reports against prior run reports and reports to determine the items requiring action.
CHRS BA Baseline Queries	CSU_BAS_DELETED ACTIONS CSU_BAS_SS_NT CSU_BAS_SS_EVENTS CSU_BAS_HEALTH_PERM_AUDIT1 CSU_BAS_HEALTH_PERM_MISSING CSU_BAS_CALPERS_ID_MISSING CSU_BAS_CALPERS_ID_MISSING_DEP	Reporting Tools > Query > Query Viewer or on the CSU Benefits Administrator Tile > Queries

Find the CHRS BA Baseline Queries

Step 1: Open the CSU Benefits Administrator tile

Step 2: Navigate to Query

Use scroll bar to locate query name.
- Queries [query name]

Baseline Queries Table

Download the query to Excel and create a notes column, and enter the notes of your daily review and save the query on your local shared drive.

Compare new daily queries against prior run queries and reports to determine the items requiring action.

Query	Information
CSU-BAS_DELETED_ACTIONS	Shows BAS Actions that were deleted from the Review BAS Activity page that do not affect benefit eligibility (such as MSC, ACT, POS, DTA, PAY, JRC). BAS Actions are deleted by the nightly CSUBASDL scheduled jobs on the first run of CSU_BA18003 when the Fullerton campus jobs run. All other campuses must run this query to view the deleted BAS Actions.
CSU_BAS_SS_NT	Only for campuses that use full eBenefits self-service. This query shows employees who have viewed or changed their eBenefits enrollment options, but not submitted them. When an event is nearing the expiration time, reach out to the employee to remind them to submit their changes. Confirm if the ESS BAS event is nearing expiration date. On the Update Event Status page > enter employee ID > compare the ESS BAS Event date to current date. Go to the ODEM page to VOID Expired ESS BAS Events.
CSU_BAS_SS_EVENTS	Only for campuses that use full eBenefits self-service. This query monitors open eBenefits self-service events. When an event is nearing the expiration time, reach out to the employee to remind them to submit their changes. Confirm if the ESS BAS event is nearing expiration date. On the Update Event Status page > enter employee ID > compare the ESS BAS Event date to current date.
CSU_BAS_HEALTH_PERM_AUDIT1	Run before the PSR interface and resolve issues listed on the query. Provides preliminary information that identifies the transactions that will be part of the next interface file with issues such as missing zip codes, addresses missing counties, and effective dates before permitting event dates.
CSU_BAS_HEALTH_PERM_MISSING	Run before the PSR interface and resolve issues listed on the query. Provides list of employees missing Permitting Event Codes.
CSU_BAS_CALPERS_ID_MISSING	Run before the PSR interface and resolve issues listed on the query. Provides a list of employees who are missing CALPERS IDs.
CSU_BAS_CALPERS_ID_MISSING_DEP	Run before the PSR interface and resolve issues listed on the query. Provides a list of dependents by employee ID who are missing CALPERS ids.

End of Article

0 Comments

Add your comment

Previous Article (job aid) Research and Audit Queries

Next Article (job aid) Daily Review CSUBAS logs and reports

CHRS Knowledge Base