This article lists the public EPM queries and descriptions for this topic. Please review available public queries below before making a new query.
EPM public query names and descriptions for Workers Compensation
- Paycheck History - Core-CT (DOCX) - This query provides paycheck history for the employee and the "To" and "From" date the user prompts on.
- MSA Pay Hist for Avg Salary (DOCX) - This query retrieves historical MSA payroll data to determine the employee's average salary for the previous 52 weeks. The user must enter the EmplID and a date range.
- Disability Claims (DOCX) - This is a query where you prompt off of DeptID for all Disability WC Claims, Open or Closed where Disability Date (Entitlement) is not null.
- Open 5/142 WC Claims (DOCX) - This query pulls worker's compensation information for open claims that have an Injury Treatment = Lost Time and a Workers Comp Claim Rate. Query prompts for a Dept ID (LIKE) (query is used by DAS).
- Claim Status Open Query (DOCX) - This query will list all WC Claims that are Open where Closed Date is null. This query prompts for DeptID.
- Recurrent Claim Activity (DOCX) - This query is used to track recurring or reopened workers’ compensation claims to identify repeated injury cases and related cost trends..
More resources