Touchstone 4.0 Database Documentation
tLocFeature Table
Description

Contains detailed building information, including secondary risk characteristics.

Properties
Creation Date5/31/2016 9:46 AM
File GroupPRIMARY
Text File GroupPRIMARY
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   
 AdjacentBuildingHeightAverage height of buildings that are adjacent to the building.Integer4  
 AppurtenantStructureCode

Code for the appurtenant building, such as shed or detached garage.

For a complete list of codes, see tAppurtenantStructure Table.

UnsignedTinyInt1  
 BrickVeneerCode

Code that represents the percentage of external walls that consist of brick veneer.

For a complete list of codes, see tBrickVeneer Table.

UnsignedTinyInt1  
 BuildingConditionCode

Code that represents the condition of the building.

For a complete list of codes, see tBuildingCondition Table.

UnsignedTinyInt1  
 BuildingExteriorOpeningCode

Code that represents the percentage of exterior walls that are open (i.e. have windows or doors).

For a complete list of codes, see tBuildingExteriorOpening Table.

UnsignedTinyInt1  
 BuildingShapeCode

Code that represents the shape of the building.

For a complete list of codes, see tBuildingShape Table.

UnsignedTinyInt1  
 ChimneyCode

Code that indicates if the structure has a chimney and, if so, the height of the chimney.

For a complete list of codes, see tChimney Table.

UnsignedTinyInt1  
 ColdFormedTubeCode

Code that indicates the presence of cold-formed tubes in SRC structures.  

For a complete list of codes, see tColdFormedTube Table.

UnsignedTinyInt1  
 ColumnBasementCode

Code that represents the type of basement support columns for SRC and steel construction.

For a complete list of codes, see tColumnBasement Table.

UnsignedTinyInt1  
 CustomFloodStandardOfProtectionAmount of standard flood protection, values from 0-10,000.Double9  
 CustomFloodZoneCode

User-defined flood zones; used to filter locations for  detailed loss analysis.

For a complete list of codes, see tCustomFloodZone Table

UnsignedTinyInt1  
 EquipmentCode

Code that represents the bracing used the building. 

For a complete list of codes, see tEquipment Table.

UnsignedTinyInt1  
 ExternalDoorCode

Code that represents the type of exterior door used the building. 

For a complete list of codes, see tExternalDoor Table.

UnsignedTinyInt1  
 ExtraDataExtra location feature data.LongVarChar16  
 FloorAreaTotal area of floor in the structure.Integer4  
 FloorAreaUnitCode

Code for the unit of measure used to express the building's floor area.

For a complete list of codes, see tUnit Table.

VarChar10  
 FloorOfInterestIdentifies the floor where the insured risk resides when coverage does not include the entire building.SmallInt2  
 FloorsOccupiedNumber of floors in the building that are occupied.VarChar40  
 FoundationCode

Code that represents the construction type of the building's foundation.  

For a complete list of codes, see tFoundation Table.

UnsignedTinyInt1  
 FoundationConnectionCode

Code that represents the type of connection used between the building and its foundation, such as nails or epoxy.

For a complete list of codes, see tFoundationConnection Table.

UnsignedTinyInt1  
 GlassPercentCode

Code that represents the percentage of the walls that consist of glass (windows).

For a complete list of codes, see tGlassPercent Table.

UnsignedTinyInt1  
 GlassTypeCode

Code that represents the type of glass used in the building.

For a complete list of codes, see tGlassType Table.

UnsignedTinyInt1  
 InternalPartitionCode

Code that represents the type of materials used to construct the interior partition walls.

For a complete list of codes, see tInternalPartition Table.

UnsignedTinyInt1  
 ISValueCode

Code that represents the total seismic performance of the building, which accounts for all characteristics that affect the response of a building to an earthquake.

For a complete list of codes, see tISValue Table.

UnsignedTinyInt1  
 LargeMissileCode

Code that represents the potential for large missiles within a 100 foot radius of the building.

For a complete list of codes, see tLargeMissile Table.

UnsignedTinyInt1  
 LatticeCode

Code that represents the type of web used for H-shaped steel.

For a complete list of codes, see tLattice Table.

UnsignedTinyInt1  
 MultiStoryHallCode

Code that indicates if the building has a multi-story hall.

For a complete list of codes, see tMultiStoryHall Table.

UnsignedTinyInt1  
 OrnamentationCode

Code that represents the amount of decorative elements attached to the exterior of a building.

For a complete list of codes, see tOrnamentation Table.

UnsignedTinyInt1  
 PoundingCode

Code that represents the distance to the closest structure, which if not adequate, can cause the two structures to collide during earthquake shaking.

For a complete list of codes, see tPounding Table

UnsignedTinyInt1  
 ProjectCompletion

Code that represents the percentage of the project that is complete with start of the policy.  Valid values are 0-99%.

Single4  
 ProjectPhaseCode

Code that represents the current stage of the project's construction. This is used to identify the vulnerabilities during different phases of construction.

For a complete list of codes, see tProjectPhase Table

UnsignedTinyInt1  
 RedundancyCode

Indicates whether there are multiple lateral load resisting elements, such as frames or shear walls.

For a complete list of codes, see tRedundancy Table

UnsignedTinyInt1  
 RetrofitCode

Code that represents any retrofit measures that may have been added to the building to resist earthquake loads.

For a complete list of codes, see tRetrofit Table

UnsignedTinyInt1  
 RoofAnchorageCode

Code that represents the connections used to secure the roof support system to the walls

For a complete list of codes, see tRoofAnchorage Table

UnsignedTinyInt1  
 RoofAttachedStructureCode

Code that identifies items mounted on the roof, such as A/C units, skylights, or dormers.

For a complete list of codes, see tRoofAttachedStructure Table

UnsignedTinyInt1  
 RoofCoverAttachCode

Code that represents the connections used to secure the roof covering to the roof deck.

For a complete list of codes, see tRoofCoverAttach Table

UnsignedTinyInt1  
 RoofCoverCode

Code that represents the material used to cover the roof.

For a complete list of codes, see tRoofCover Table.

UnsignedTinyInt1  
 RoofDeckAttachCode

Code that represents the connections used to secure the roof deck to the underlying roof support system.

For a complete list of codes, see tRoofDeckAttach Table

UnsignedTinyInt1  
 RoofDeckCode

Code that represents the materials used to construct the roof deck.

For a complete list of codes, see tRoofDeck Table.

UnsignedTinyInt1  
 RoofGeometryCode

Code that represents the shape of the roof.

For a complete list of codes, see tRoofGeometry Table.

UnsignedTinyInt1  
 RoofPitchCode

Code that represents the slope of the roof.

For a complete list of codes, see tRoofPitch Table.

UnsignedTinyInt1  
 RoofYearBuiltYear the roof was last replaced.SmallInt2  
 SealOfApprovalCode

Code that represents the level of professional engineering attention given to the design of the building.

For a complete list of codes, see tSealOfApproval Table.

UnsignedTinyInt1  
 ShapeIrregularityCode

Code that represents any shape or structural irregularities in the building. 

For a complete list of codes, see tShapeIrregularity Table.

UnsignedTinyInt1  
 ShortColumnCode

Code that indicates if there are short columns in the building. 

For a complete list of codes, see tShortColumn Table.

UnsignedTinyInt1  
 SmallDebrisCode

Code that represents the potential for small debris within a 200 foot radius of the building.

For a complete list of codes, see tSmallDebris Table.

UnsignedTinyInt1  
 SoftStoryCode

Code that indicates if there is structural weakness at any floor.  First floor garages and taller first floors are likely to exhibit soft-story behavior. 

For a complete list of codes, see tSoftStory Table.

UnsignedTinyInt1  
 SpecialConstructionCode

Code that represents any earthquake-resistive systems that may have been installed on the building.

For a complete list of codes, see dbo.tSpecialConstruction Table

UnsignedTinyInt1  
 TallOneStoryCode

Code that represents the height of a one story building.

For a complete list of codes, see tTallOneStory Table

UnsignedTinyInt1  
 TankCode

Code that indicates if there are rooftop tanks on the adjoining higher buildings.

For a complete list of codes, see tTank Table

UnsignedTinyInt1  
 TerrainRoughnessCode

Code that represents the landscape of the area surrounding the building, such as city or wooded areas.

For a complete list of codes, see tTerrainRoughness Table

UnsignedTinyInt1  
 TorsionCode

Code that represents the layout of structural elements that can lead to torsional loads .

For a complete list of codes, see tTorsion Table

UnsignedTinyInt1  
 TransitionInSRCCode

Indicates whether the transition from SRC to RC in columns of SRC construction is smooth.

For a complete list of codes, see tTransitionInSRC Table

UnsignedTinyInt1  
 TreeExposureCode

Code that indicates if there are tree hazards around the building.

For a complete list of codes, see tTreeExposure Table

UnsignedTinyInt1  
 WallAttachedStructureCode

Code that represents a structure that is physically attached to the building, such as garage or balcony.

For a complete list of codes, see tWallAttachedStructure Table

UnsignedTinyInt1  
 WallCode

Code that represents the material used to construct the external walls.

For a complete list of codes, see tWall Table.

UnsignedTinyInt1  
 WallSidingCode

Code that represents the material used for weather protection of the external walls.

For a complete list of codes, see tWallSiding Table.

UnsignedTinyInt1  
 WaterHeaterCode

Code that indicates if the water heater in the building is braced.

For a complete list of codes, see tWaterHeater Table.

UnsignedTinyInt1  
 WeldingCode

Code that represents the quality of welding in the building.

For a complete list of codes, see tWelding Table.

UnsignedTinyInt1  
 WindowProtectionCode

Code that represents the wind protection systems used on the windows.

For a complete list of codes, see tWindowProtection Table.

UnsignedTinyInt1  
 BasementFinishTypeCode

Code that defines if the basement is finished or unfinished.

For a complete list of codes, see tBasementFinishType Table.

UnsignedTinyInt1  
 BasementLevelCountIndicates the number of basement levels in a structure.SmallInt2  
 BaseFloodElevationElevation of the base flood level. Double9  
 BaseFloodElevationUnitCode

Code for the unit of measure used to express the base flood elevation.

For a complete list of codes, see tUnit Table.

VarChar10  
 ContentVulnerabilityCode

Code that reflects the relative vulnerability of the contents exposed to flooding for the chosen occupancy.

For a complete list of codes, see tContentVulnerability Table.

UnsignedTinyInt1  
 CustomElevationUser-defined elevation; used to filter locations for detailed loss analysis.Double9  
 CustomElevationUnitCode

Code for the unit of measure used to express the elevation.

For a complete list of codes, see tUnit Table.

VarChar10  
 FIRMComplianceCode

Indicates whether the building is in compliance with the FEMA flood zone requirements in both design and construction. 

For a complete list of codes, see tFIRMCompliance Table.

UnsignedTinyInt1  
 FirstFloorHeightHeight of the building's first floor.Double9  
 FirstFloorHeightUnitCode

Code for the unit of measure used to express the height of the building's first floor.

For a complete list of codes, see tUnit Table.

VarChar10  
 RoofHailImpactResistanceCode

Code that represents the roof's level of resistance in regards to damage from hail impact.

For a complete list of codes, see tRoofHailImpactResistance Table.

UnsignedTinyInt1  
 ServiceEquipmentProtectionCode

Code that indicates if the service equipment is protected from flood. 

For a complete list of codes, see tServiceEquipmentProtection Table.

UnsignedTinyInt1  
 RowVersionUsed for version stamping.Binary8   
 PPCCode

Code that represents the location's Public Protection Classification (PPC), which designates the level of fire protection.

For a complete list of codes, see tPublicProtectionClass.

VarChar10  
 IsFireSprinklerAvailable

Indicates whether a fire sprinkler system is installed at the location.

  • 1 = Yes (installed)
  • 0 = No (not installed) 
Boolean1
((0))
 
 ISOOccupancyCode

Code that represents the ISO Occupancy Code for the location.

For a complete list of codes, see tConvertISOOccupancy Table

VarChar10  
 ISOConstructionCode

Code that represents the ISO Construction Code for the location.

For a complete list of codes, see tISOConstruction Table

VarChar10  
 IBHSFortifiedCode

Code that represents the location's level of certification per the Institute for Business and Home Safety, which defines a structure's ability to withstand load resistance. 

For a complete list of codes, see tIBHSFortified Table.

UnsignedTinyInt1  
Objects that tLocFeature 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.