CHRS Knowledge Base

Benefits Delivered Queries for CHRS

Updated on

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.

Please note that not all delivered queries may be documented or identical, as modifications and ongoing development may result in differences.

Expand or collapse content CSU_BAS_CALPERS_ID_MISSING - Medical with no CalPers ID

Provides a list of employees who are missing CALPERS IDs.

Expand or collapse content CSU_BAS_CALPERS_ID_MISSING_DEP - Medical Dep with no CalPers Id

Provides a list of dependents by employee ID who are missing CALPERS ids.

Expand or collapse content CSU_BAS_HEALTH_PERM_AUDIT1 - Audit Health Perm Table

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.

Expand or collapse content CSU_BAS_HEALTH_PERM_MISSING - Health Perm missing

Provides list of employees missing Permitting Event Codes.

Expand or collapse content CSU_BAS_HEALTH_BENPLAN_HISTORY - Health Benefit Plan History

Audit benefit plan transactions in the Health Benefits page.

Expand or collapse content CSU_BAS_LIFE_BENPLAN_HISTORY - Life Benefits Plan History

Audit benefit plan transactions in the Life and AD/D page.

Expand or collapse content CSU_BAS_DISABILITY_BENPLAN_HISTORY- Disability Plan History

Audit benefit plan transactions in the Disability page.

Expand or collapse content CSU_BAS_DELETED_ACTIONS - Deleted BAS 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).

Expand or collapse content CSU_BAS_HEALTH_ELECT - Health by SchedID and Date

Lists employees with health benefit changes.

Expand or collapse content CSU_BAS_DISABILITY_ELECT - Disability by SchedID and Date

Lists employees with disability benefit changes.

Expand or collapse content CSU_BAS_LIFE_ELECT - Life by SchedID and Date

Lists employees with life benefit changes.

Expand or collapse content CSU_BAS_HCRADCRA_ELECT - HCRADCRA by SchedID and Date

Lists employees with HCRA/DCRA benefit changes.

Expand or collapse content CSU_BAS_SS_EVENTS - eBenefit events

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.(For Campuses w/ full eBenefits self-service.)

Expand or collapse content CSU_BAS_SS_NT - eBenefit Process Status 'NT'

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. (For Campuses w/ full eBenefits self-service.)

Expand or collapse content CSU_BAS_EVENT_CLASS_HISTORY - Event Class History Summary

Audit all Ben Admin transactions

Expand or collapse content CSU_BAS_HCRADCRA_HISTORY - HCRADCRA History

Audit benefit plan transactions in the Spending Accounts page.

Expand or collapse content CSU_BAS_ELECTRONIC_ESIGNATURE - eSignature with EMPLID Prompt

Lists all Benefits ESS esignatures from Life Event Activity Guides and OE Activity Guides.

Expand or collapse content CSU_BAS_NEW_NW1_ELECTRONIC_SGN - Electronic Signatures

Lists Benefits ESS esignatures from the NEW BAS event.

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) Benefits Troubleshooting Guide
Next Article (job aid) Daily Review and Troubleshooting User Guide (BA)
Do you need an article? Contact Us