Touchstone 4.0 Database Documentation
tLocWC Table
Description

Contains information about the workers' compensation details for the location.

Properties
Creation Date5/31/2016 9:46 AM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows0
Data Space Used0.00 KB
Index Space Used0.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key LocationSID

Unique system-generated sequential identifier for the location record.

For a complete list of records, see tLocation Table.

Integer4   
 EmployeesNumber of covered employees.Double9  
 PercentDayShiftPercentage of covered employees who are at the location during normal working hours (9 a.m.–4:59 p.m.).Single4  
 PercentEveningShiftPercentage 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.).Single4  
 PercentNightShiftPercentage of covered employees who are at the location during the night shift (7 p.m. – 6:59 a.m.).Single4  
 AnnualPayrollTotal annual payroll for all covered employees.Double9  
 AverageAnnualPayAverage wage for all covered employees.Double9  
 MinorInjuryExpectedValueExpected value of medical or indemnity payment per Minor(Outpatient for Japan) injuries claim.Double9  
 ModerateInjuryExpectedValueExpected value of medical or indemnity payment per Moderate(Hospitalization and Surgery for Japan) injuries claim.Double9  
 MajorInjuryExpectedValueExpected value of medical or indemnity payment per Major(Disability for Japan) injuries claim.Double9  
 FatalInjuryExpectedValueExpected value of medical or indemnity payment per Fatal (Death for Japan) injuries claim.Double9  
 RowVersionUsed for version stamping.Binary8   
Objects that tLocWC depends on
 Database ObjectObject TypeDescriptionDep Level
tContract tabletContractTable

Contains records for primary insurance policies.

2
tExposureSet tabletExposureSetTableContains exposure set information. An exposure set is a collection of contracts, locations, and other related information.3
tLocation tabletLocationTable

Contains geographical attributes and primary risk characteristics for each location. It serves as a reference point between Location and Contract entities.  All locations entities are tied together by the same Location SID.

1
See Also

Related Objects

AIRExposure Database

 

 


AIR Client Confidential

© 2016. AIR Worldwide is a registered trademark. Touchstone is a registered trademark of AIR Worldwide.

Please contact AIR Worldwide with questions or comments. For database questions. For documentation comments.