Stores a list of supported area weight types.
Touchstone 2022 Database Reference
TblAreaWeightType Table
| Creation Date | 7/16/2007 5:34 PM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 4 |
| Data Space Used | 8.00 KB |
| Index Space Used | 8.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | intWeightTypeId | Identifier for the weight type.
| int | 4 | |||
| strWeightType | Name of the weight type. Corresponds to the identifier in intWeightTypeId. | varchar | 30 | ||||
| strBriefWeightType | Brief name for the weight type. Corresponds to the identifier in intWeightTypeId. | char | 3 |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | TblAreaDistribution_xref | Table | Stores reference data that the application uses to retrieve the highest weighted areas and to assign values to areas that do not have a sufficiently high weight. | 1 |
| TblSourceDefaultTarget_Xref | Table | Stores information that the application uses in the airsp_EA_PagingPrepare stored procedure to retrieve the highest weighted regions and to assign values to regions that do not have a high enough weight. | 1 |
| TblSourceDefaultTargetWc_Xref | Table | Stores information that the application uses in the airsp_EA_PagingPrepare stored procedure to retrieve the highest weighted regions for Workers' Compensation and to assign values to regions that do not have a high enough weight. | 1 |
| TblSourceTargetMap_ANZ | Table | Stores the grid identifier and weight type that corresponds to each source code. The table also stores 'look-up' area codes that the application uses for disaggregated locations in Australia and New Zealand and the weight for each location. | 1 |
| TblSourceTargetMap_BRA | Table | Stores the grid identifier and weight type that corresponds to each source code. The table also stores 'look-up' area codes that the application uses for disaggregated locations in Brazil and the weight for each location. | 1 |
| TblSourceTargetMap_CAM | Table | Stores the grid identifier and weight type that corresponds to each source code. The table also stores 'look-up' area codes that the application uses for disaggregated locations in Central America and the weight for each location. | 1 |
| TblSourceTargetMap_CAN | Table | Stores the grid identifier and weight type that corresponds to each source code. The table also stores 'look-up' area codes that the application uses for disaggregated locations in Canada and the weight for each location. | 1 |
| TblSourceTargetMap_CAR | Table | Stores grid identifier and weight type that corresponds to each source code.The table also stores 'look-up' area codes that the application uses for disaggregated locations in Central African Republic (CAR) and the weight for each location. | 1 |
| TblSourceTargetMap_CHI | Table | Stores the grid identifier and weight type that corresponds to each source code. The table also stores 'look-up' area codes that the application uses for disaggregated locations in China and the weight for each location. | 1 |
| TblSourceTargetMap_EUR | Table | Stores the grid identifier and weight type that corresponds to each source code. The table also stores 'look-up' area codes that the application uses for disaggregated locations in Europe and the weight for each location. | 1 |
| TblSourceTargetMap_IND | Table | Stores the grid identifier and weight type that corresponds to each source code. The table also stores 'look-up' area codes that the application uses for disaggregated locations in India and the weight for each location. | 1 |
| TblSourceTargetMap_JAP | Table | Stores the grid identifier and weight type that corresponds to each source code. The table also stores 'look-up' area codes that the application uses for disaggregated locations in Japan and the weight for each location. | 1 |
| TblSourceTargetMap_MEU | Table | Stores the grid identifier and weight type that corresponds to each source code. The table also stores 'look-up' area codes that the application uses for disaggregated mid-European locations and the weight for each location. | 1 |
| TblSourceTargetMap_MEX | Table | Stores the grid identifier and weight type that corresponds to each source code. The table also stores 'look-up' area codes that the application uses for disaggregated locations in Mexico and the weight for each location. | 1 |
| TblSourceTargetMap_SAM | Table | Stores the grid identifier and weight type that corresponds to each source code. The table also stores 'look-up' area codes that the application uses for disaggregated locations in South America and the weight for each location. | 1 |
| TblSourceTargetMap_SEA | Table | Stores the grid identifier and weight type that corresponds to each source code. The table also stores 'look-up' area codes that the application uses for disaggregated locations in Southeast Asia and the weight for each location. | 1 |
| TblSourceTargetMap_SEU | Table | Stores the grid identifier and weight type that corresponds to each source code. The table also stores 'look-up' area codes that the application uses for disaggregated southern-European locations and the weight for each location. | 1 |
| TblSourceTargetMap_US | Table | Stores the grid identifier and weight type that corresponds to each source code. The table also stores 'look-up' area codes that the application uses for disaggregated locations in the United States and the weight for each location. | 1 |
| TblSourceTargetMapWC_JAP | Table | Stores the grid identifier and weight type that corresponds to each source code. The table is used for workers' compensation and also stores 'look-up' area codes that the application uses for disaggregated locations in Japan and the weight for each location. | 1 |