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.
| Creation Date | 3/6/2013 8:43 AM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 231591 |
| Data Space Used | 9,408.00 KB |
| Index Space Used | 64.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | guidExternalSource | GUID of the low-level zone. | dbo.GUID | 16 | |||
| | intWeightTypeId | Identifier for the weight type. For a complete list of weight types, see TblAreaWeightType Table. | int | 4 | |||
| | intGridIdDefault | Highest weighted level for this zone and weight type. | bigint | 8 | |||
| MinEmployee | Minimum number of employees. | 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 |