| Revision Date | Revised By | Summary of Revisions | Section(s) Revised |
| 08/22/22 | Sande Meith |
Original User Guide last updated date, previous updates on original document | Throughout document |
| 09/15/25 | Training | Edited to created separate job aids. Updates will now be documented in KB platform. | Throughout document |
Run the CSU_BAS_HEALTH_BENPLAN_HISTORY Query
When to use this query
- Query: CSU_BAS_HEALTH_BENPLAN_HISTORY
- Shows health benefit plan transactions entered on the Health Benefits page in the Base Benefits module.
- Applies to Plan Types:
- 10 = Medical
- 11 = Dental
- 14 = Vision
- 1Y = Dental Flex Cash
- 1Z = Medical Flex Cash
What you can see
- Benefit elections that were added to the Health Benefits page.
- Benefit elections that were deleted due to reprocessing or voiding of BAS events.
- Audit OperID and Audit Stamp showing who made the change and when.
- This information helps explain why an employee’s benefit enrollment may not have appeared on a Benefits interface.
Related query
- CSU_BAS_BB_DEPND_HISTORY: shows which dependents were added or deleted from the Health Benefits page, by whom, and when.
How it works
- A row is inserted in the audit table whenever an add, delete, or change occurs on the Health Benefits page.
- Includes changes caused by reprocessing in the Ben Admin module.
Where to find the query
- CSU Benefits Administrator Tile → Queries
- Query Manager or Query Viewer (search by query name)
- Access depends on your PeopleSoft security definition.
To open the CSU Benefits Administrator Tile in CHRS:
- From the Home landing page, click the drop-down arrow.
- Select CSU Administrator Home.
- To access Query Manager or Query Viewer, click on the NavBar Icon
- Menu > Reporting Tools > Query.
To run the query, enter the PeopleSoft Employee ID and the Health Benefits Plan Type of 10, 11, 14, 1Y or 1Z. Plan Type 10 is Medical, 11 is Dental, 14 is Vision, 1Y is Dental Flex Cash, 1Z is Medical Flex Cash.
Step 1: Click on the View Results button. If the ‘No matching values were found’ message appears, no values were found in the audit table for the employee, which means that the employee is either not enrolled in Health Benefits and/or does not have a benefits transaction that wrote to the audit table.
Step 2: See the following example query output. Note that you can also download the query results to an Excel Spreadsheet and also a CSV Text File in addition to viewing online. Do not attempt to download the query results to an XML File.
- Example CSU_BAS_HEALTH_BENPLAN_HISTORY Query
| Term | Definition |
|---|---|
Empl ID |
The PeopleSoft employee ID. |
| Plan Type | Indicates the benefit Plan Type. 10 is Medical, 11 is Dental, 14 is Vision, 1Y is Dental Flex Cash and 1Z is Medical Flex Cash. |
| Name | The employee’s primary name. |
| Deduction Begin Date | Shows the date the plan type deduction begins or ends, based on the Coverage Elect values on the row. |
| Coverage Election | Indicates the end result for a plan type. E means Elect (or continue election), W means Waive and T means Terminate. |
Coverage Code |
1 for Employee Only,2 for Employee + Dependent, and 3 for Employee + Dependents. |
| Coverage Begin Date | 1 for Employee Only,2 for Employee + Dependent, and 3 for Employee + Dependents. |
| Coverage Elect Date | Shows the date the coverage was elected and processed via the Ben Admin module or the Base Benefits module if manually inserted. |
Benefit Plan |
The Benefit Plan code. |
Audit Operid |
The PeopleSoft User ID who processed the change in Ben Admin. The Audit Oper ID of CSU_SCHEDUCSU means the nightly batch process (CSUBAS) processed the change. The Audit Oper ID of !NoOper means the change was due to a SQL insert. |
Audit Stamp |
The date and time the transaction processed in PeopleSoft. |
Audit Action |
Indicates if the audit action is a Change - New Value, Change - Old Values, Delete or Add. |
Sort Date/Time |
This column is used to sort the audit data so the most recently added row appears at the top of the list. |
Available job aids/articles/resources
Access the job aids for the following queries as well as additional resources to complete tasks.
- Base Benefit Dependent History Query (CSU_BAS_BB_DEPND_HISTORY)
- Dependent History Query (CSU_BAS_BA_DEPND_HISTORY)
- Disability Benefits Plan History (SU_BAS_DISABILITY_BENPLAN_HISTORY)
- Electronic Signature Query (CSU_BAS_NEW_NW1)
- Event Class History Summary Query (CSU_BAS_EVENT)
- HCRA/DCRA History (CSU_BAS_HCRADCRA_HISTORY)
- Health Plan History Query (CSU_BAS_HEALTH_BENPLAN_HISTORY)
- Life Benefits Plan History Query (CSU_BAS_LIFE_BENPLAN_HISTORY)
- Employee Event Detail
- Overview of BAS Statuses
Important: Be sure to reference the Reprocessing a CHRS BAS Event document and the eBenefits OK to Reprocess Cheatsheet before reprocessing any BAS event in the On Demand Event Maintenance page.
End of Article
0 Comments
Add your comment