| 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 |
6.0 Run the CSU_BAS_LIFE_BENPLAN_HISTORY Query
When to use this query
- Query: CSU_BAS_LIFE_BENPLAN_HISTORY
- Shows Life and AD/D benefit plan transactions entered on the Life and AD/D page in the Base Benefits module.
- Applies to Plan Types:
- 20 = Life
- 23 = AD/D
What you can see
- Benefit elections that were added to the Life and AD/D 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.
How it works
- A row is inserted in the audit table whenever an add, delete, or change occurs on the Life and AD/D 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 Life and AD/D Plan Type of 20 or 23.
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 Life and AD/D and/or did 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_LIFE_BENPLAN_HISTORY Query
| Term | Definition |
|---|---|
Empl ID |
The PeopleSoft employee ID. |
| Plan Type | Indicates the benefit Plan Type. 20 and 23 is Life and AD/D. |
| 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 Begin Date | Shows the date the plan type deduction begins or ends, based on the Coverage Elect values on the row. |
| 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