| Creation Date | 4/11/2022 6:15 PM |
| File Group | PRIMARY |
| Text File Group | PRIMARY |
| System Object |  |
| Published for Replication | |
| Rows | 0 |
| Data Space Used | 0.00 KB |
| Index Space Used | 0.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | ExposureDataSourceSID | Stores attributes associated with each location included in the analysis. These attributes are displayed on the user interface along with data from tRRRR_EC_ByLocation Table. For a complete list of records, see tDataSource Table. | int | 4 | |||
| | LocationSID | Unique system-generated sequential identifier for the location record. For a complete list of records, see tLocation Table. | int | 4 | |||
| ContractSID | Unique system-generated sequential identifier for the contract record. For a complete list of records, see tContract Table. | int | 4 |  | |||
| GeographySID | Unique system-generated sequential identifier for the geographic record. For a complete list of records, see tGeography Table. | int | 4 | | |||
| ExposureSetName | Name of the exposure set. | varchar | 255 | | |||
| LocationID | Name of the exposure set. | varchar | 100 | ||||
| CurrencyCode | ISO 3-character code for the currency. For a complete list of codes, see tCurrency Table. | char | 3 | | |||
| AIRConstructionCode | AIR-defined construction code. For a complete list of codes, see tAIRConstruction Table. | smallint | 2 | | |||
| AIROccupancyCode | AIR-defined construction code. For a complete list of codes, see tAIRConstruction Table. | smallint | 2 | | |||
| City | City in which the location resides. | varchar | 255 | | |||
| Address | Street address for the location. | varchar | 255 | | |||
| Latitude | Latitude coordinate for the location. Values will be positive for locations north of the equator and negative south of the equator. | numeric | 9 (9,6) | | |||
| Longitude | Longitude coordinate for the location. 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. | numeric | 9 (9,6) | | |||
| GeoMatchLevelCode | Code that represents the level at which geocode match occurred. For a complete list of codes, see tGeoMatchLevel Table. | varchar | 10 | | |||
| Stories | Code that represents the level at which geocode match occurred. For a complete list of codes, see tGeoMatchLevel Table. | tinyint | 1 | | |||
| YearBuilt | Year the structure was built. | smallint | 2 | | |||
| LocationGeo | geography | 0 | | ||||
| ReplacementValueA | float | 9 | | ||||
| ReplacementValueB | float | 9 | | ||||
| ReplacementValueC | float | 9 | | ||||
| ReplacementValueD | float | 9 | | ||||
| TotalReplacementValue | Accumulated replacement values of all Coverages (A, B, C, and D) for the location. | float | 9 | | |||
| RiskCount | Number of risks for the specified location record. | int | 4 | | |||
| PerilSetCode | int | 4 | | ||||
| Territory | varchar | 60 | | ||||
| UserDefined1 | User-defined field 1. | varchar | 60 | | |||
| UserDefined2 | User-defined field 2. | varchar | 60 | | |||
| UserDefined3 | User-defined field 3. | varchar | 60 | | |||
| UserDefined4 | User-defined field 4. | varchar | 60 | | |||
| UserDefined5 | User-defined field 5. | varchar | 60 | | |||
| UserGeoMatchLevel | User-specified geocode match level. | varchar | 60 | | |||
| Employees | Employee count, by location, within the analyzed area. | float | 9 | | |||
| DayShiftEmployees | Day-shift employee count, by location, within the analyzed area. | float | 9 | | |||
| EveningShiftEmployees | Evening-shift employee count, by location, within the analyzed area. | float | 9 | | |||
| NightShiftEmployees | Night-shift employee count, by location, within the analyzed area. | float | 9 | | |||
| GeocoderCode | varchar | 10 | | ||||
| GeocoderAccountId | nvarchar | 50 | |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tRRRR_EC_ByLocation | Table | Stores the results of the Geospatial analysis at the latitude/longitude location level. | 1 |