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.
| Creation Date | 1/22/2015 7:11 AM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 655800 |
| Data Space Used | 66,024.00 KB |
| Index Space Used | 320.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | guidExternalSource | GUID of the external source. | dbo.GUID | 16 | |||
| | intGridID | Grid identifier. | bigint | 8 | |||
| intLevel1 | Country code for the location. For a complete list of codes, see tCountry Table. | smallint | 2 | ||||
| strLevel2 | Area or CRESTA code for the location. For a complete list of codes, see tGeography Table. | varchar | 16 | ||||
| strLevel3 | Subarea code for the location. For a complete list of codes, see tGeography Table. | varchar | 16 |  | |||
| strLevel4 | Postal code for the location. For a complete list of codes, see tGeography Table. | varchar | 16 | | |||
| fltGeoLat | Latitude coordinate for the grid. Values will be positive for locations north of the equator and negative south of the equator. | real | 4 | ||||
| fltGeoLong | Longitude coordinate for the grid. Values will be negative for locations west of the prime meridian up to the international date line. They will be positive for locations east of the prime meridian. | real | 4 | ||||
| | intWeightTypeId | Identifier for the weight type. For a complete list of weight types, see TblAreaWeightType Table. | int | 4 | |||
| fltDaytimePercent | Percentage of workers that work the daytime shift. | decimal | 9 (10,9) | ||||
| fltEveningDayRatio | Ratio that represents the number of workers that work the evening shift compared to the day shift. | decimal | 9 (10,9) | ||||
| fltNightDayRatio | Ratio that represents the number of workers that work the night shift compared to the day shift. | decimal | 9 (10,9) | ||||
| GridGeographySID | Unique system-generated sequential identifier for the geography grid record. Used internally by Touchstone. | int | 4 |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | TblAreaExternal | Table | Stores valid area information. | 1 |
| TblAreaWeightType | Table | Stores a list of supported area weight types. | 1 |