Stores street-level address details for each location.
Touchstone 2022 Database Reference
tLocParsedAddress Table
| Creation Date | 4/11/2022 6:15 PM |
| File Group | PRIMARY |
| Text File Group | |
| 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 | |
|---|---|---|---|---|---|---|---|
 | LocationSID | Unique system-generated sequential identifier for the location record. For a complete list of records, see tLocation Table. | int | 4 | |||
| StreetNumberPrefix | Street number prefix. | varchar | 10 |  | |||
| StreetNumber | Street number in the location's address. | varchar | 10 | | |||
| StreetNumberSuffix | Street number suffix. | varchar | 10 | | |||
| StreetName | Street name in the location's address. | varchar | 40 | | |||
| StreetType | Street type, such as Rd or St. | varchar | 10 | | |||
| StreetTypeEx | Street type extension. | varchar | 10 | | |||
| PostDirection | Direct provided at the end of the street address,as in Main Street North. | varchar | 10 | | |||
| PreDirection | Direct provided at the beginning of the street address,as in North Main Street. | varchar | 10 | | |||
| BuildingUnitType | Type of unit, such as Apt or Suite, in the location's address. | varchar | 10 | | |||
| BuildingUnitValue | Value of the unit in the location's address used to identify the location in the building. | varchar | 10 | | |||
| BuildingFloorValue | Floor of the building in which the location resides. | varchar | 10 | | |||
| BuildingType | Type of building in which the location resides. | varchar | 10 | | |||
| BuildingName | Name of the building in which the location resides. | varchar | 40 | | |||
| DeliveryBoxType | Type of delivery receptacle at the location. | varchar | 10 | | |||
| DeliveryBoxValue | Value used to identify the location on the delivery receptacle. | varchar | 10 | | |||
| DeliveryRouteType | Type of delivery route for the location. | varchar | 10 | | |||
| DeliveryRouteValue | Value used to identify the location on the delivery route. | varchar | 10 | | |||
| RowVersion | Used for version stamping. | timestamp | 8 |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tContract | Table | Stores records for primary insurance policies. | 2 |
| tDataSource | Table | Stores information about the databases registered with the application, for example, the exposure and results databases. | 3 |
| tExposureSet | Table | Stores information about exposure sets. An exposure set is a collection of contracts, locations, and other related information. | 2 |
| tLocation | Table | Stores geographical attributes and primary risk characteristics for each location. The table serves as a reference point between Location and Contract entities.You can identify each location by the location sequential identifier (SID). | 1 |