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.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related searches
- schools open or closed today
- open vs closed questions worksheet
- open vs closed questions exercise
- open and closed question games
- open and closed questions worksheets
- open and closed question activity
- nyc schools open or closed today
- open and closed questions ppt
- open and closed questions pdf
- difference between open and closed mri
- open versus closed questions
- open and closed questions examples