| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | HLCASE | Number - Case/File | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 2 | HLCSTS | Status - Case | String | UDC (08 CS) | 2 | 0 | Allow NULL? |
| 3 | HLOSH | Yes or No - OSHA | Character | UDC (05 YN) | 1 | 0 | Allow NULL? |
| 4 | HLAN8 | Address Number | Numeric | UDC | 8 | 0 | Allow NULL? |
| 5 | HLJBCD | Job Type (Craft) Code | String | UDC (06 G) | 6 | 0 | Allow NULL? |
| 6 | HLJBST | Job Step | String | UDC (06 GS) | 4 | 0 | Allow NULL? |
| 7 | HLWCMP | Worker's Comp. Insurance Code | String | UDC (00 W) | 4 | 0 | Allow NULL? |
| 8 | HLWET | Sub Class - Workers Comp | Character | UDC (07 WH) | 1 | 0 | Allow NULL? |
| 9 | HLHMCO | Company - Home | String | Generic Edit | 5 | 0 | Allow NULL? |
| 10 | HLHMCU | Business Unit - Home | String | Generic Edit | 12 | 0 | Allow NULL? |
| 11 | HLANPA | Supervisor | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 12 | HLXAN8 | Address Number - Foreman | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 13 | HLDIJ | Date - of Injury | Date | Generic Edit | 6 | 0 | |
| 14 | HLTMAC | Time of Accident | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 15 | HLWKD | Day of Week | Character | UDC (08 WD) | 1 | 0 | Allow NULL? |
| 16 | HLDRP | Date - Injury Reported | Date | Generic Edit | 6 | 0 | |
| 17 | HLDCLO | Date - Case Closed | Date | Generic Edit | 6 | 0 | |
| 18 | HLDSIJ | Description - Injury or Illness | String | Generic Edit | 40 | 0 | Allow NULL? |
| 19 | HLIR | Injury/Illness Related (IN/IL) | String | UDC (08H IR) | 2 | 0 | Allow NULL? |
| 20 | HLRSWA | Restricted Work Activity Y/N | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 21 | HLDYSA | Days Away from Work Y/N | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 22 | HLNDWA | Number - Days Restricted | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 23 | HLNDAW | Number - Days Away from Work | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 24 | HLDDEC | Date - Deceased | Date | Generic Edit | 6 | 0 | |
| 25 | HLDRT | Date - Returned to Work | Date | Generic Edit | 6 | 0 | |
| 26 | HLESTB | Number - Establishment of Business Activ | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 27 | HLCSFX | Suffix - Case Entry Number | Numeric | Generic Edit | 3 | 0 | Allow NULL? |
| 28 | HLHH01 | Safety Group | String | UDC (08 H1) | 3 | 0 | Allow NULL? |
| 29 | HLHH02 | Occurrence Location | String | UDC (08 H2) | 3 | 0 | Allow NULL? |
| 30 | HLHH03 | Occurrence Type | String | UDC (08 H3) | 3 | 0 | Allow NULL? |
| 31 | HLHH04 | Part of Body | String | UDC (08 H4) | 3 | 0 | Allow NULL? |
| 32 | HLHH05 | Occupational Illness/Injury | String | UDC (08 H5) | 3 | 0 | Allow NULL? |
| 33 | HLHH06 | Health & Safety Category Codes 06 | String | UDC (08 H6) | 3 | 0 | Allow NULL? |
| 34 | HLHH07 | Health & Safety Category Codes 07 | String | UDC (08 H7) | 3 | 0 | Allow NULL? |
| 35 | HLHH08 | Health & Safety Category Codes 08 | String | UDC (08 H8) | 3 | 0 | Allow NULL? |
| 36 | HLHH09 | Health & Safety Category Codes 09 | String | UDC (08 H9) | 3 | 0 | Allow NULL? |
| 37 | HLHH10 | Health & Safety Category Codes 10 | String | UDC (08 H0) | 3 | 0 | Allow NULL? |
| 38 | HLHH11 | Health & Safety Category Codes 11 | String | UDC (08 HA) | 3 | 0 | Allow NULL? |
| 39 | HLHH12 | Health & Safety Category Codes 12 | String | UDC (08 HB) | 3 | 0 | Allow NULL? |
| 40 | HLHH13 | Health & Safety Category Codes 13 | String | UDC (08 HC) | 3 | 0 | Allow NULL? |
| 41 | HLHH14 | Health & Safety Category Codes 14 | String | UDC (08 HD) | 3 | 0 | Allow NULL? |
| 42 | HLHH15 | Health & Safety Category Codes 15 | String | UDC (08 HE) | 3 | 0 | Allow NULL? |
| 43 | HLCTR | Country | String | UDC (00 CN) | 3 | 0 | Allow NULL? |
| 44 | HLONPRM | Incident Occured on Employer's Premises | Character | UDC (00 ZO) | 1 | 0 | Allow NULL? |
| 45 | HLUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 46 | HLPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 47 | HLUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 48 | HLJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |