The Workers Compensation report is based on the Workers Compensation topic. This template allows users to report on details such as WCB account numbers and employee information (for example, name and pay group).
Fields
| Field Name | Group by | Sort Order | Totals |
|---|---|---|---|
| Year | A to Z | ||
| WCB Code | A to Z | ||
| Employee Display Name | Ascending | ||
| WCB Account Number | |||
| Employee State Code | |||
| Legal Entity Name | |||
| Pay Group Name | |||
| Department Name | |||
| Employee Badge | |||
| Employee Display Name | |||
| Job Name | |||
| Employee Rate | |||
| Employer Rate | |||
| Employer Total Committed Premium | |||
| Employee Total Committed Premium | |||
| Total WCB Assessable Value | |||
| Total Limited WCB Assessable Value | |||
| Total Excess Value |
|
Custom Fields
Total Excess Value
The Total Excess Value custom field displays the workers' compensation total excess value. It uses the following expression:
ISNULL(PRPayRunWorkersCompView.TotalWcbAssessableWages, 0) - ISNULL(PRPayRunWorkersCompView.LimitedWCBAssessableWages, 0)
Filters
The template includes the following filters: