Stores the worker's compensation information that is associated with a specific location.
Touchstone 2022 Database Reference
tDefaultLocWC Table
Stores the worker's compensation information that is associated with a specific location.
| Creation Date | 4/4/2022 3:02 AM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 784 |
| Data Space Used | 64.00 KB |
| Index Space Used | 176.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | DefaultLocWCSID | Unique system-generated sequential identifier for the location's workers' compensation record. | int | 4 | |||
| GeographySID | Unique system-generated sequential identifier for the geographic record. For a complete list of records, see tGeography Table. | int | 4 | ||||
| BusinessUnitSID | Unique system-generated sequential identifier for the business unit record. | int | 4 | ||||
| CurrencyCode | ISO 3-character code for the currency. For a complete list of codes, see tCurrency Table. | char | 3 | ||||
| AIROccupancyWeightTypeCode | Code that represents the occupancy weight type. For a complete list of codes, see tAIROccupancyWeightType Table. | smallint | 2 | ||||
| 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 | | |||
| 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 | |