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.
Provides a list of employees who are missing CALPERS IDs.
Provides a list of dependents by employee ID who are missing CALPERS ids.
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.
Provides list of employees missing Permitting Event Codes.
Audit benefit plan transactions in the Health Benefits page.
Audit benefit plan transactions in the Life and AD/D page.
Audit benefit plan transactions in the Disability page.
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).
Lists employees with health benefit changes.
Lists employees with disability benefit changes.
Lists employees with life benefit changes.
Lists employees with HCRA/DCRA benefit changes.
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.)
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.)
Audit all Ben Admin transactions
Audit benefit plan transactions in the Spending Accounts page.
Lists all Benefits ESS esignatures from Life Event Activity Guides and OE Activity Guides.
Lists Benefits ESS esignatures from the NEW BAS event.
End of Article
0 Comments
Add your comment