| 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_BB_DEPND_HISTORY Query
When to use this query
- Query: CSU_BAS_BB_DEPND_HISTORY
- Shows dependent changes tied to benefit plan transactions that occurred in the Base Benefits module.
What you can see
- Dependent adds, deletes, and changes associated with Base Benefits processing.
- Useful for researching enrollment history and dependent coverage updates.
How it works
- A row is inserted in the audit table whenever a dependent add, delete, or change occurs in Base Benefits.
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.
How to access 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.
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 does not have any dependents 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_BB_DEPND_HISTORY Query
| Field | Description |
|---|---|
| Empl ID | The PeopleSoft employee ID. |
| Empl Record | The job employment record associated with the transaction. |
| CBR Evt ID | This is the COBRA Event ID. |
| Plan Typ | Indicates the benefit Plan Type:
|
| Benefit Record Number (Always = 0) | The Benefit Record Number. This is always 0 in CHRS. |
| Eff Date | The effective date of the dependent update. |
| Dep/Benef | The dependent/beneficiary ID. |
| Provider ID | Not used at this time at CSU. Ignore this field. |
| Prev Seen | Not used at this time at CSU. Ignore this field. |
| Other Insur? | Not used at this time at CSU. Ignore this field. |
| Other Insur Name | Not used at this time at CSU. Ignore this field. |
| Audit Operid | The PeopleSoft User ID who processed the change in Ben
Admin.
|
| Audit Stamp | The date and time the transaction processed in PeopleSoft. |
| Audit Action | Indicates the audit action: Change - New Value, Change - Old Values, Delete, or Add. |
| Sort Date/Time | Used to sort the audit data so the most recent row appears at the top. |
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