| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | CLIENT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | ACTIVE | Table entry is active (A) or in suspense (S) | char | 1 | 0 | | | | Allow NULL? |
| 3 | CLAIM | Number of Claim | nvarchar | 17 | 0 | | | | Allow NULL? |
| 4 | PARTNER | Claim Participant | nvarchar | 10 | 0 | | | | Allow NULL? |
| 5 | ROLE | Participant Role Key | nvarchar | 4 | 0 | | | | Allow NULL? |
| 6 | CHANGETIME | Changed: Date + Time | decimal | 15 | 0 | | | | |
| 7 | CHANGEDBY | Changed By | nvarchar | 12 | 0 | | | | Allow NULL? |
| 8 | DELETED | Database Line Status (Original, Changed, Deleted) | char | 1 | 0 | | | | Allow NULL? |
| 9 | EMP_PAYROLL | Employer Payroll | nvarchar | 2 | 0 | | | | Allow NULL? |
| 10 | EMP_INDUSTRYCODE | Industry Code | nvarchar | 6 | 0 | | | | Allow NULL? |
| 11 | EMP_UINUMBER | Employer UI Number | nvarchar | 9 | 0 | | | | Allow NULL? |
| 12 | EMP_NATOFBUS | Nature of Business | nvarchar | 6 | 0 | | | | Allow NULL? |
| 13 | EMP_LOCNUM | Insured Location Number of Employer | nvarchar | 15 | 0 | | | | Allow NULL? |
| 14 | EMP_DATEREPTO | Date on Which Injury Reported to Employer | nvarchar | 8 | 0 | | | | Allow NULL? |
| 15 | EMP_LOSSCOND_ACT | Loss Conditions: Type of Transaction (NCCI) | nvarchar | 2 | 0 | | | | Allow NULL? |
| 16 | EMP_LOSS_TYPE | Loss Conditions: Type of Loss (NCCI) | nvarchar | 2 | 0 | | | | Allow NULL? |
| 17 | EMP_RECOVER_TYPE | Loss Conditions: Type of Recovery | nvarchar | 2 | 0 | | | | Allow NULL? |
| 18 | EMP_COVERAG_TYPE | Loss Condition: Type of Coverage | nvarchar | 2 | 0 | | | | Allow NULL? |
| 19 | EMP_SETTLE_TYPE | Loss Conditions: Settlement Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 20 | EMPE_EMP_STATUS | Employment Status | nvarchar | 2 | 0 | | | | Allow NULL? |
| 21 | EMPE_WAGEBASIS | Employee Wage Basis | nvarchar | 2 | 0 | | | | Allow NULL? |
| 22 | EMPE_WORKDAYS | Number of Days Regularly Worked per Week | char | 1 | 0 | | | | Allow NULL? |
| 23 | EMPE_NOOFDEP | Employee Number of Dependents | nvarchar | 2 | 0 | | | | Allow NULL? |
| 24 | EMPE_NOOFENTEXEM | Employee Number of Entitled Exemptions | nvarchar | 2 | 0 | | | | Allow NULL? |
| 25 | EMPE_NOOFWHEXEM | Employee Number of Withholding Exemptions | nvarchar | 2 | 0 | | | | Allow NULL? |
| 26 | EMPE_AWW | Pre-Injury Average Weekly Wage | decimal | 15 | 2 | | | | |
| 27 | EMPE_OTHR_PAY | Other Weekly Payments | decimal | 15 | 2 | | | | |
| 28 | EMPE_DISCFB | Discontinued Fringe Benefits | decimal | 15 | 2 | | | | |
| 29 | EMPE_LDW | Initial Date Last Day Worked | nvarchar | 8 | 0 | | | | Allow NULL? |
| 30 | EMPE_RTW | Initial Return to Work Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 31 | EMPE_MMI_DATE | Date of Maximum Medical Improvement | nvarchar | 8 | 0 | | | | Allow NULL? |
| 32 | EMPE_WORKTIME | Time Employee Began Work Before Accident | nvarchar | 6 | 0 | | | | Allow NULL? |
| 33 | CURRENCY | Currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 34 | EMPE_HIREDATE | Employee Date of Hire | nvarchar | 8 | 0 | | | | Allow NULL? |
| 35 | EMPE_OCC_CODE | Employee Occupation Code | nvarchar | 2 | 0 | | | | Allow NULL? |
| 36 | EMPE_MC_CODE | Manual Classification Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 37 | EMPE_OBJINJ | Object or Substance That Directly Injured the Employee | nvarchar | 6 | 0 | | | | Allow NULL? |
| 38 | EMPE_INITTRMNTCO | Initial Treatment Code | char | 1 | 0 | | | | Allow NULL? |
| 39 | EMPE_NOI | Nature of Injury | nvarchar | 2 | 0 | | | | Allow NULL? |
| 40 | EMPE_COI | Cause of Injury | nvarchar | 2 | 0 | | | | Allow NULL? |
| 41 | EMP_PREPAREDDATE | Date Prepared | nvarchar | 8 | 0 | | | | Allow NULL? |
| 42 | CLADMN_DATEREPTO | Date of Report of Injury to Claim Administrator | nvarchar | 8 | 0 | | | | Allow NULL? |
| 43 | XINITIALPROVIDER | WComp: Initial Medical Service Provider | char | 1 | 0 | | | | Allow NULL? |
| 44 | LAWY_STARTDATE | Date Attorney Started Working for Claimant | nvarchar | 8 | 0 | | | | Allow NULL? |
| 45 | LAWY_DISCLOSURE | Disclosure Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 46 | OSHA_CASE_NUM | Occupational Safety & Health Administration (OSHA) Case No. | nvarchar | 15 | 0 | | | | Allow NULL? |
| 47 | BODY_PART_CODE | Code for Injured Body Part | nvarchar | 2 | 0 | | | | Allow NULL? |
| 48 | EMPE_DEATHDATE | Date of Death of Employee | nvarchar | 8 | 0 | | | | Allow NULL? |
| 49 | ASSIGN_GUID | UUID of Entry to be Linked | nvarchar | 32 | 0 | | | | Allow NULL? |
| 50 | MCO_IDNUM | Managed Care Organization (MCO) ID Number | nvarchar | 9 | 0 | | | | Allow NULL? |
