Touchstone 4.0 Database Documentation
TblSourceDefaultTargetWc_Xref Table
Description

System reference table used by airsp_EA_PagingPrepare to retrieve the highest weighted regions for Workers' Compensation. This value is used to assign values to regions that do not have a high enough weight.

Properties
Creation Date3/6/2013 8:43 AM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows231591
Data Space Used15,576.00 KB
Index Space Used88.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key guidExternalSourceGUID of the low-level zone.Binary16   
Primary Key intWeightTypeId

Identifier for the weight type. 

For a complete list of weight types, see TblAreaWeightType Table.

Integer4   
Primary Key intGridIdDefaultHighest weighted level for this zone and weight type.BigInt8   
 MinEmployeeMinimum number of employees.Integer4   
Objects that TblSourceDefaultTargetWc_Xref depends on
 Database ObjectObject TypeDescriptionDep Level
TblAreaExternal tableTblAreaExternalTableStored valid area information.1
TblAreaWeightType tableTblAreaWeightTypeTableDefines the area weight type. Used by airsp_DistributeCrestaLocations.1
See Also

Related Objects

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