COBRA Activity Report | PowerSchool ERP

Use this option to generate a report on payment activity records that are created to provide an audit trail of changes made in the Payment History page.

The Payment Activity report includes employees, dependents, benefits, new/old payment values, original/change dates, and login IDs of operators who made the entries. Social Security numbers may display in a masked (XXX-XX-9999) format or not at all depending on your security resources and the Human Resources Profile.

Menu Path: Benefits > Reports > Benefits Reports > Cobra Activity Report

Generating the COBRA Activity report

Select Benefits > Reports > Benefits Reports > Cobra Activity Report.
Complete the page's fields.
Click OK.
In the Print window, specify how to generate the report, and then click OK. The report's default file name is activity.rpt.

Fields

Field	Description
Employee Number	Employee ID numbers. You can enter an individual ID or use query symbols to identify multiple employees. To select multiple employees, separate IDs with the pipe symbol; for example, 112233\|123456\|135791. To select a range of ID numbers, use a colon between the lowest and highest numbers, for example, 100000:120000. To access all employees, leave the field blank.
Benefit	Codes identifying benefits, as defined in the Benefit Codes table. To select multiple codes, separate the codes with the pipe symbol, for example, 1270\|2630\|4590. To select codes that share the same first characters, use the asterisk symbol. For example, 35* selects all codes that begin with 35. To access all benefits, leave this field blank.
Dependent SSN	Social Security numbers of employees' dependents. Be sure to include the dashes. If a benefit is not for a dependent, then the system uses the Social Security number of the employee. This field is only available for users with the proper security. To enter multiple numbers, insert the pipe symbol between each, for example, 159-92-4505\|204-56-7882\|186-92-4022 To access records regardless of Social Security number, leave the field blank.
Date Paid	Dates of payments. To specify payments made before or after a given date, use the less than (<) or greater than (>) query symbol. For example, <05012011 accesses all payments made before May 1, 2011.
Action	Code indicating the type of action recorded in the COBRA History table as a result of using the Payment History Maintenance option. Select: A - Added payment C - Changed payment D - Deleted payment To enter multiple codes, insert the pipe symbol between each, for example, A\|C. To include all records regardless of their codes, leave the field blank.
Original Value	Amounts of the payments when either originally posted or last changed. Added (new) records always show 0.00 in this field.
New Value	Amounts currently stored in payment records as the result of a change. Deleted records always show 0.00 in this field.
Operator	Login IDs of employees who made the additions, changes, or deletions. Use the pipe symbol to enter more than one ID.
Change Date	Dates the additions, changes, or deletions were made. Use the greater than (>) or less than (<) symbol, as shown in the example for the Date Paid field.
Note	In date fields, you can use the less than (<), greater than (>), and equal (=) symbols to search for records. <=03012018 accesses all records on or before 03/01/2018. >=03012018 accesses all records on or after 03/01/2018. <03012018 accesses all records before 03/01/2018. >03012018 accesses all records after 03/01/2018. =03012018 accesses all records on 03/01/2018. You can also use these symbols in amount fields. For example, >150 accesses all records where the amount was greater than $150.