Touchstone 4.0 Database Documentation
tDefaultLocWC Table
Description

Stores the worker's compensation information that is associated with a specific location. 

Properties
Creation Date5/31/2016 9:46 AM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows784
Data Space Used64.00 KB
Index Space Used184.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key DefaultLocWCSIDUnique system-generated sequential identifier for the location's workers' compensation record.Integer4   
 GeographySID

Unique system-generated sequential identifier for the geographic record.

For a complete list of records, see tGeography Table.

Integer4   
 BusinessUnitSID

Unique system-generated sequential identifier for the business unit record.

Integer4   
 CurrencyCode

ISO 3-character code for the currency.

For a complete list of codes, see tCurrency Table.

Char3   
 AIROccupancyWeightTypeCode

Code that represents the occupancy weight type.

For a complete list of codes, see tAIROccupancyWeightType Table.

SmallInt2   
 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  
 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  
See Also

Related Objects

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