Touchstone 4.0 Database Documentation
tLocParsedAddress Table
Description
Contains street-level address details for each location.
Properties
Creation Date5/31/2016 9:46 AM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows0
Data Space Used0.00 KB
Index Space Used0.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key LocationSID

Unique system-generated sequential identifier for the location record.

For a complete list of records, see tLocation Table.

Integer4   
 StreetNumberPrefixStreet number prefix.VarChar10  
 StreetNumberStreet number in the  location's address.VarChar10  
 StreetNumberSuffixStreet number suffix.VarChar10  
 StreetNameStreet name in the  location's address.VarChar40  
 StreetTypeStreet type, such as Rd or St.VarChar10  
 StreetTypeExStreet type extension.VarChar10  
 PostDirection

Direct provided at the end of the street address,as in Main Street North.

VarChar10  
 PreDirection

Direct provided at the beginning of the street address,as in North Main Street.

VarChar10  
 BuildingUnitTypeType of unit, such as Apt or Suite,  in the location's address.VarChar10  
 BuildingUnitValueValue of the unit in the location's address used to identify the location in the building.VarChar10  
 BuildingFloorValueFloor of the building in which the location resides.VarChar10  
 BuildingTypeType of building in which the location resides.VarChar10  
 BuildingNameName of the building in which the location resides.VarChar40  
 DeliveryBoxTypeType of delivery receptacle at the location.VarChar10  
 DeliveryBoxValueValue used to identify the location on the delivery receptacle.VarChar10  
 DeliveryRouteTypeType of delivery route for the location.VarChar10  
 DeliveryRouteValueValue used to identify the location on the delivery route.VarChar10  
 RowVersionUsed for version stamping.Binary8   
Objects that tLocParsedAddress depends on
 Database ObjectObject TypeDescriptionDep Level
tContract tabletContractTable

Contains records for primary insurance policies.

2
tExposureSet tabletExposureSetTableContains exposure set information. An exposure set is a collection of contracts, locations, and other related information.3
tLocation tabletLocationTable

Contains geographical attributes and primary risk characteristics for each location. It serves as a reference point between Location and Contract entities.  All locations entities are tied together by the same Location SID.

1
See Also

Related Objects

AIRExposure Database

 

 


AIR Client Confidential

© 2016. AIR Worldwide is a registered trademark. Touchstone is a registered trademark of AIR Worldwide.

Please contact AIR Worldwide with questions or comments. For database questions. For documentation comments.