Stores information about the workers' compensation details for the location.
Stores information about the workers' compensation details for the location.
Creation Date | 4/11/2022 6:15 PM |
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. | 3 |
![]() | 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 |