CHRS Knowledge Base

Daily Review BA Baseline Queries

Updated on

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
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

 

CSU Benefits administrator home tile

Step 2:  Navigate to Query

  • Use scroll bar to locate query name.
    • Queries [query name]
example of a list of queries

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. 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

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

Previous Article (job aid) Correct Base Benefits
Next Article (job aid) Daily Review CSUBAS logs and reports
Do you need an article? Contact Us