| 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 |
9. Run the CSU_BAS_BA_DEPND_HISTORY Query
When to use this query
- Query: CSU_BAS_BA_DEPND_HISTORY
- Shows dependent changes tied to benefit plan transactions that occurred in the Benefits Administration module.
What you can see
- Dependent adds, deletes, and changes associated with Ben Admin processing.
- Useful for researching why a dependent did or did not appear on a resulting enrollment or interface.
How it works
- A row is inserted in the audit table whenever a dependent add, delete, or change occurs in Ben Admin.
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 applicable Schedule ID, the PeopleSoft Employee ID and the Event ID for the applicable BAS event.
1. If you do not have the Event ID, click on the NavBar Icon
then go to Menu > Benefits > Manage Automated Enrollment > Events > Update Event Status. Enter the employee ID and locate the Event ID for the applicable BAS event. See the example below showing the Event ID of 5.
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_BA_DEPND_HISTORY Query
| Field | Description |
|---|---|
| Schedule ID | The BAS Schedule ID tied to the BAS event. |
| Empl ID | The PeopleSoft employee ID. |
| Ben Record | The Benefit Record Number. In CHRS, this is always 0. |
| Event ID | The BAS event ID. |
| Plan Type | Indicates the benefit Plan Type:
|
| Dep/Ben | The dependent/beneficiary ID. |
| Ben Program | The employee’s benefit program. |
| Event Date | The BAS event date. Either the original event date or updated date from the nightly submission process. |
| DispPlnSeq | Not used at this time at CSU. Ignore this field. |
| Enroll Action | Action taken for a plan type: E = Enroll (also used for Waives) N = None T = Terminate |
| BAS Error Type | Indicates if an error/warning occurred:
|
| Pct Paid | Not used at this time at CSU. Ignore this field. |
| Flat Amt | Not used at this time at CSU. Ignore this field. |
| Excess | Not used at this time at CSU. Ignore this field. |
| Contingent | Not used at this time at CSU. Ignore this field. |
| 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