Stores information about the workers' compensation details for the location.
CEDE 9.0 Database Reference
tLocWC Table
Stores information about the workers' compensation details for the location.
| Creation Date | 4/12/2021 11:26 AM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 0 |
| Data Space Used | 0.00 KB |
| Index Space Used | 0.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | LocationSID | Unique system-generated sequential identifier for the location record. For a complete list of records, see tLocation Table. | int | 4 | |||
| Employees | Number of covered employees. | float | 9 |  | |||
| PercentDayShift | Percentage of covered employees who are at the location during normal working hours (9 a.m.–4:59 p.m.). | real | 4 | | |||
| PercentEveningShift | Percentage of covered employees who are at the location during evening hours or typical commute times (7 a.m. – 8:59 a.m., 5 p.m. – 6:59 p.m.). | real | 4 | | |||
| PercentNightShift | Percentage of covered employees who are at the location during the night shift (7 p.m. – 6:59 a.m.). | real | 4 | | |||
| AnnualPayroll | Total annual payroll for all covered employees. | float | 9 | | |||
| AverageAnnualPay | Average wage for all covered employees. | float | 9 | | |||
| MinorInjuryExpectedValue | Expected value of medical or indemnity payment per Minor(Outpatient for Japan) injuries claim. | float | 9 | | |||
| ModerateInjuryExpectedValue | Expected value of medical or indemnity payment per Moderate(Hospitalization and Surgery for Japan) injuries claim. | float | 9 | | |||
| MajorInjuryExpectedValue | Expected value of medical or indemnity payment per Major(Disability for Japan) injuries claim. | float | 9 | | |||
| FatalInjuryExpectedValue | Expected value of medical or indemnity payment per Fatal (Death for Japan) injuries claim. | float | 9 | | |||
| RowVersion | Used for version stamping. | timestamp | 8 |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tContract | Table | Stores records for primary insurance policies. | 2 |
| tExposureSet | Table | Stores information about exposure sets. An exposure set is a collection of contracts, locations, and other related information. | 2 |
| tLocation | Table | Stores geographical attributes and primary risk characteristics for each location. The table serves as a reference point between Location and Contract entities.You can identify each location by the location sequential identifier (SID). | 1 |