Touchstone 4.0 Database Documentation
TblAreaWeightType Table
Description
Defines the area weight type. Used by airsp_DistributeCrestaLocations.
Properties
Creation Date7/16/2007 5:34 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows4
Data Space Used8.00 KB
Index Space Used8.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key intWeightTypeId

Identifier for the weight type.

  • 1 = Residential (RES)
  • 2 = Commercial (COM)
  • 3 = Industrial (IND)
  • 4 = Car/Ear (CAR)
Integer4   
 strWeightType

Name of the weight type.

Corresponds to the identifier in intWeightTypeId.

VarChar30   
 strBriefWeightType

Brief name for the weight type.

Corresponds to the identifier in intWeightTypeId.

Char3   
Objects that depend on TblAreaWeightType
 Database ObjectObject TypeDescriptionDep Level
TblAreaDistribution_xref tableTblAreaDistribution_xrefTable

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

1
TblSourceDefaultTarget_Xref tableTblSourceDefaultTarget_XrefTableSystem reference table used by airsp_EA_PagingPrepare to retrieve the highest weighted regions. This value is used to assign values to regions that do not have a high enough weight.1
TblSourceDefaultTargetWc_Xref tableTblSourceDefaultTargetWc_XrefTable

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.

1
TblSourceTargetMap_ANZ tableTblSourceTargetMap_ANZTableMaps source codes to gridID and weightType. Also stores 'look-up' Area codes that are needed for disaggregated locations in Australia and New Zealand, as well as the weight for each of those locations.1
TblSourceTargetMap_BRA tableTblSourceTargetMap_BRATable

Maps source codes to gridID and weightType. Also stores 'look-up' Area codes that are needed for disaggregated locations in Brazil, as well as the weight for each of those locations.

1
TblSourceTargetMap_CAM tableTblSourceTargetMap_CAMTable

Maps source codes to gridID and weightType. Also stores 'look-up' Area codes that are needed for disaggregated locations in Central America, as well as the weight for each of those locations.

1
TblSourceTargetMap_CAN tableTblSourceTargetMap_CANTableMaps source codes to gridID and weightType. Also stores 'look-up' Area codes that are needed for disaggregated locations in Canada, as well as the weight for each of those locations.1
TblSourceTargetMap_CHI tableTblSourceTargetMap_CHITableMaps source codes to gridID and weightType. Also stores 'look-up' Area codes that are needed for disaggregated locations in China, as well as the weight for each of those locations.1
TblSourceTargetMap_EUR tableTblSourceTargetMap_EURTableMaps source codes to gridID and weightType. Also stores 'look-up' Area codes that are needed for disaggregated locations in Europe, as well as the weight for each of those locations.1
TblSourceTargetMap_IND tableTblSourceTargetMap_INDTableMaps source codes to gridID and weightType. Also stores 'look-up' Area codes that are needed for disaggregated locations in India, as well as the weight for each of those locations.1
TblSourceTargetMap_JAP tableTblSourceTargetMap_JAPTableMaps source codes to gridID and weightType. Also stores 'look-up' Area codes that are needed for disaggregated locations in Japan, as well as the weight for each of those locations.1
TblSourceTargetMap_MEU tableTblSourceTargetMap_MEUTableMaps source codes to gridID and weightType. Also stores 'look-up' Area codes that are needed for disaggregated mid-European locations, as well as the weight for each of those locations.1
TblSourceTargetMap_MEX tableTblSourceTargetMap_MEXTableMaps source codes to gridID and weightType. Also stores 'look-up' Area codes that are needed for disaggregated locations in Mexico, as well as the weight for each of those locations.1
TblSourceTargetMap_SAM tableTblSourceTargetMap_SAMTableMaps source codes to gridID and weightType. Also stores 'look-up' Area codes that are needed for disaggregated locations in South America, as well as the weight for each of those locations.1
TblSourceTargetMap_SEA tableTblSourceTargetMap_SEATableMaps source codes to gridID and weightType. Also stores 'look-up' Area codes that are needed for disaggregated locations in Southeast Asia, as well as the weight for each of those locations.1
TblSourceTargetMap_SEU tableTblSourceTargetMap_SEUTableMaps source codes to gridID and weightType. Also stores 'look-up' Area codes that are needed for disaggregated southern-European locations, as well as the weight for each of those locations.1
TblSourceTargetMap_US tableTblSourceTargetMap_USTableMaps source codes to gridID and weightType. Also stores 'look-up' Area codes that are needed for disaggregated locations in the United States, as well as the weight for each of those locations.1
TblSourceTargetMapWC_JAP tableTblSourceTargetMapWC_JAPTableUsed for Workers' Compensation. Maps source codes to gridID and weightType. Also stores 'look-up' Area codes that are needed for disaggregated locations in Japan, as well as the weight for each of those locations. 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.