Open or Closed Disability WC Claims .us



CT_CORE_WC_DISABILITY_CLAIMS

Purpose of Query

Open or Closed Disability WC Claims - Query returns all Disability WC Claims, Open or Closed where Disability Date (Entitlement Date) is not null. This query is executed for a specified Open Date range.

Folder

WC

Tables

CTW_HLTH_SF_VW - Health/Safety View

Prompts

DeptID llike (%) – (Wildcard enabled)

Open Date between – (Between condition)

Sample Results

Please note, due to page size limitations, sample results may be incomplete.

[pic]

Criteria

DISABILITY_DT - WC Entitlement Date is not null

Note: Runtime prompts are included as criteria.

Fields

|Col |Record.Fieldname |Format |Ord |XLAT |Agg |Heading Text |

|1 |A.EMPLID - EmplID |Char11 |  |  |  |Employee ID |

|2 |A.INCIDENT_NBR - Incident Number |Char8 |  |  |  |Incident # |

|3 |A.CLAIM_NBR - Claim Number |Char8 |  |  |  |Claim Nbr |

|4 |A.NAME - Name |Char50 |1 |  |  |Name |

|5 |A.INCIDENT_DT - Incident Date |Date |  |  |  |Incdnt Dt |

|6 |A.DEPTID - Department |Char10 |  |  |  |DeptID |

|7 |A.OPEN_DT - Date Opened |Date |  |  |  |Open Date |

|8 |A.CLOSE_DT - Date Closed |Date |  |  |  |Close Date |

|9 |A.CT_ORIGINAL_CLM - Original Claim Number |Char14 |  |  |  |Orig Claim Nbr |

|10 |A.CT_WRK_CMP_CLM_RTE - Claim Rate |Char1 |  |N |  |Wrk Cmp Clm Rte |

|11 |A.CT_TOTAL_WAGES - Total Wages |Num13.6 |  |  |  |Total Wages |

|12 |A.CT_TOTAL_WEEKS - Total Weeks |Num2.0 |  |  |  |Total Weeks |

|13 |A.CT_52_WK_SAL_AVG - 52 Week Salary Average |Num13.6 |  |  |  |52 Wk Sal Avg |

|14 |A.CT_WRK_CMP_FIL_STA - Filing Status |Char1 | | | | |

|15 |A.CT_WRK_CMP_WTHOLD - Number of Withholdings |Num3.0 |  |  |  |# Wthldngs |

|16 |A.CT_PS_WKCMP_WK_RT - PS Calculated TPA WC Weekly Rt |Num13.6 |  |  |  |PS Calc Wk Rt |

|17 |A.CT_PS_WKCMP_DL_RT - PS Calculated TPA WC Daily Rt |Num13.6 |  |  |  |PSCalc TPA Day |

|18 |A.CT_FIRST_CHK_DAYS - First Check Days |Num3.0 |  |  |  |1st Chk Days |

|19 |A.CT_LAST_PERIOD_DAY - Last Period Days |Num3.0 |  |  |  |Last Per Days |

|20 |A.DISABILITY_DT - WC Entitlement Date |Date |  |  |  |Entitlement Dt (Disability)|

|21 |A.INJURY_TREATMENT - Injury Treatment |Char1 |  |N |  |Treatment |

|22 |A.LAST_FULL_WORK_DAY - Last Work Date Before Injury |Date |  |  |  |Last Day |

|23 |A.RETURN_DT - Return Date |Date |  |  |  |Return Dt |

|24 |A.RECURRENCE - Is this a recurrence |Char1 |  |  |  |Recurrnce |

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download