Daily Review BA Baseline Queries

Updated on Aug 09, 2024

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 Process Status Rpt CSU Snapshot Unique Constraint	Benefits > Reports > CSU Benefits Reports
Exceptions Reports	Invalid Elections Rpt Report on Flagged Items	Benefits > Manage Automated Enrollment > Investigate Exceptions
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

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

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. Event Detail page > enter employee ID > compare 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. Event Detail page > enter employee ID > compare ESS BAS Event date to current date.
CSU_BAS_HEALTH_PERM_AUDIT1	Run before the PSR interface. Provides preliminary information that identifies the transactions that will be part of the next interface file and indicates 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. Provides list of employees missing Permitting Event Codes.
CSU_BAS_CALPERS_ID_MISSING	Run before the PSR interface. Provides a list of employees who are missing CALPERS IDs.
CSU_BAS_CALPERS_ID_MISSING_DEP	Run before the PSR interface. Provides a list of dependents by employee ID who are missing CALPERS ids.

End of Article

0 Comments

Add your comment

Previous Article Process TBC Events

Next Article Daily Review CSUBAS logs and reports

CHRS Knowledge Base