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. |
Troubleshooting
End of Article
0 Comments
Add your comment