Understanding the CEDE Format, Touchstone 4.0
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.

int4   
 EmployeesNumber of covered employees.float9  
 PercentDayShiftPercentage of covered employees who are at the location during normal working hours (9 a.m.–4:59 p.m.).real4  
 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.).real4  
 PercentNightShiftPercentage of covered employees who are at the location during the night shift (7 p.m. – 6:59 a.m.).real4  
 AnnualPayrollTotal annual payroll for all covered employees.float9  
 AverageAnnualPayAverage wage for all covered employees.float9  
 MinorInjuryExpectedValueExpected value of medical or indemnity payment per Minor(Outpatient for Japan) injuries claim.float9  
 ModerateInjuryExpectedValueExpected value of medical or indemnity payment per Moderate(Hospitalization and Surgery for Japan) injuries claim.float9  
 MajorInjuryExpectedValueExpected value of medical or indemnity payment per Major(Disability for Japan) injuries claim.float9  
 FatalInjuryExpectedValueExpected value of medical or indemnity payment per Fatal (Death for Japan) injuries claim.float9  
 RowVersionUsed for version stamping.timestamp8   
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

 

 


© 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.