Stores detailed building information for each location.
The information includes secondary risk characteristics, such as the building shape and glass type.
Stores detailed building information for each location.
The information includes secondary risk characteristics, such as the building shape and glass type.
Creation Date | 4/12/2021 11:26 AM |
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 | |
---|---|---|---|---|---|---|---|
LocationSID | Unique system-generated sequential identifier for the location record. For a complete list of records, see tLocation Table. | int | 4 | ||||
AdjacentBuildingHeight | Average height of buildings that are adjacent to the building. | int | 4 | ||||
AppurtenantStructureCode | Code that represents the type of any appurtenant building, such as a shed or detached garage. For a complete list of codes, see tAppurtenantStructure Table. | tinyint | 1 | ||||
BrickVeneerCode | Code that represents the percentage of external walls that consist of brick veneer. For a complete list of codes, see tBrickVeneer Table. | tinyint | 1 | ||||
BuildingConditionCode | Code that represents the condition of the building. For a complete list of codes, see tBuildingCondition Table. | tinyint | 1 | ||||
BuildingExteriorOpeningCode | Code that represents the percentage of exterior walls that are open. Openings include windows and doors. For a complete list of codes, see tBuildingExteriorOpening Table. | tinyint | 1 | ||||
BuildingShapeCode | Code that represents the shape of the building. For a complete list of codes, see tBuildingShape Table. | tinyint | 1 | ||||
ChimneyCode | Code that indicates whetherthe structure has a chimney and, if so, the height of the chimney. For a complete list of codes, see tChimney Table. | tinyint | 1 | ||||
ColdFormedTubeCode | Code that indicates the presence of cold-formed tubes in SRC structures. For a complete list of codes, see tColdFormedTube Table. | tinyint | 1 | ||||
ColumnBasementCode | Code that represents the type of basement support columns for SRC and steel construction. For a complete list of codes, see tColumnBasement Table. | tinyint | 1 | ||||
CustomFloodStandardOfProtection | User-specified level of flood protection. A user-specified level of protection overrides the AIR-defined level of protection. Flood protection comes in various forms, including levees, dikes, and flood walls. The CustomFloodSOPType column indicates how the user specified the level. | float | 9 | ||||
CustomFloodZoneCode | User-defined flood zones; used to filter locations for detailed loss analysis. For a complete list of codes, see tCustomFloodZone Table | tinyint | 1 | ||||
EquipmentCode | Code that represents the bracing used the building. For a complete list of codes, see tEquipment Table. | tinyint | 1 | ||||
ExternalDoorCode | Code that represents the type of exterior door used the building. For a complete list of codes, see tExternalDoor Table. | tinyint | 1 | ||||
ExtraData | Extra location feature data. | varchar | 16 | ||||
FloorArea | Total area of floor in the structure. | int | 4 | ||||
FloorAreaUnitCode | Code for the unit of measure used to express the building's floor area. For a complete list of codes, see tUnit Table. | varchar | 10 | ||||
FloorOfInterest | Identifies the floor where the insured risk resides when coverage does not include the entire building. | smallint | 2 | ||||
FloorsOccupied | Number of floors in the building that are occupied. | varchar | 40 | ||||
FoundationCode | Code that represents the construction type of the building's foundation. For a complete list of codes, see tFoundation Table. | tinyint | 1 | ||||
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. | tinyint | 1 | ||||
GlassPercentCode | Code that represents the percentage of the walls that consist of glass (windows). For a complete list of codes, see tGlassPercent Table. | tinyint | 1 | ||||
GlassTypeCode | Code that represents the type of glass used in the building. For a complete list of codes, see tGlassType Table. | tinyint | 1 | ||||
InternalPartitionCode | Code that represents the type of materials used to construct the interior partition walls. For a complete list of codes, see tInternalPartition Table. | tinyint | 1 | ||||
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. | tinyint | 1 | ||||
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. | tinyint | 1 | ||||
LatticeCode | Code that represents the type of web used for H-shaped steel. For a complete list of codes, see tLattice Table. | tinyint | 1 | ||||
MultiStoryHallCode | Code that indicates if the building has a multi-story hall. For a complete list of codes, see tMultiStoryHall Table. | tinyint | 1 | ||||
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. | tinyint | 1 | ||||
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. | tinyint | 1 | ||||
ProjectCompletion | Code that represents the percentage of the project that is complete with start of the policy. Valid values are 0-99%. | real | 4 | ||||
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. | tinyint | 1 | ||||
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. | tinyint | 1 | ||||
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. | tinyint | 1 | ||||
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. | tinyint | 1 | ||||
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. | tinyint | 1 | ||||
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. | tinyint | 1 | ||||
RoofCoverCode | Code that represents the material used to cover the roof. For a complete list of codes, see tRoofCover Table. | tinyint | 1 | ||||
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. | tinyint | 1 | ||||
RoofDeckCode | Code that represents the materials used to construct the roof deck. For a complete list of codes, see tRoofDeck Table. | tinyint | 1 | ||||
RoofGeometryCode | Code that represents the shape of the roof. For a complete list of codes, see tRoofGeometry Table. | tinyint | 1 | ||||
RoofPitchCode | Code that represents the slope of the roof. For a complete list of codes, see tRoofPitch Table. | tinyint | 1 | ||||
RoofYearBuilt | Year the roof was last replaced. | smallint | 2 | ||||
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. | tinyint | 1 | ||||
ShapeIrregularityCode | Code that represents any shape or structural irregularities in the building. For a complete list of codes, see tShapeIrregularity Table. | tinyint | 1 | ||||
ShortColumnCode | Code that indicates if there are short columns in the building. For a complete list of codes, see tShortColumn Table. | tinyint | 1 | ||||
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. | tinyint | 1 | ||||
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. | tinyint | 1 | ||||
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. | tinyint | 1 | ||||
TallOneStoryCode | Code that represents the height of a one story building. For a complete list of codes, see tTallOneStory Table. | tinyint | 1 | ||||
TankCode | Code that indicates if there are rooftop tanks on the adjoining higher buildings. For a complete list of codes, see tTank Table. | tinyint | 1 | ||||
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. | tinyint | 1 | ||||
TorsionCode | Code that represents the layout of structural elements that can lead to torsional loads . For a complete list of codes, see tTorsion Table. | tinyint | 1 | ||||
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. | tinyint | 1 | ||||
TreeExposureCode | Code that indicates if there are tree hazards around the building. For a complete list of codes, see tTreeExposure Table. | tinyint | 1 | ||||
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. | tinyint | 1 | ||||
WallCode | Code that represents the material used to construct the external walls. For a complete list of codes, see tWall Table. | tinyint | 1 | ||||
WallSidingCode | Code that represents the material used for weather protection of the external walls. For a complete list of codes, see tWallSiding Table. | tinyint | 1 | ||||
WaterHeaterCode | Code that indicates if the water heater in the building is braced. For a complete list of codes, see tWaterHeater Table. | tinyint | 1 | ||||
WeldingCode | Code that represents the quality of welding in the building. For a complete list of codes, see tWelding Table. | tinyint | 1 | ||||
WindowProtectionCode | Code that represents the wind protection systems used on the windows. For a complete list of codes, see tWindowProtection Table. | tinyint | 1 | ||||
BasementFinishTypeCode | Code that defines if the basement is finished or unfinished. For a complete list of codes, see tBasementFinishType Table. | tinyint | 1 | ||||
BasementLevelCount | Indicates the number of basement levels in a structure. | smallint | 2 | ||||
BaseFloodElevation | Elevation of the base flood level. | float | 9 | ||||
BaseFloodElevationUnitCode | Code for the unit of measure used to express the base flood elevation. For a complete list of codes, see tUnit Table. | varchar | 10 | ||||
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. | tinyint | 1 | ||||
CustomElevation | User-defined elevation; used to filter locations for detailed loss analysis. | float | 9 | ||||
CustomElevationUnitCode | Code for the unit of measure used to express the elevation. For a complete list of codes, see tUnit Table. | varchar | 10 | ||||
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. | tinyint | 1 | ||||
FirstFloorHeight | Height of the building's first floor. | float | 9 | ||||
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. | varchar | 10 | ||||
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. | tinyint | 1 | ||||
ServiceEquipmentProtectionCode | Code that indicates if the service equipment is protected from flood. For a complete list of codes, see tServiceEquipmentProtection Table. | tinyint | 1 | ||||
RowVersion | Used for version stamping. | timestamp | 8 | ||||
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. | varchar | 10 | ||||
IsFireSprinklerAvailable | Indicates whether a fire sprinkler system is installed at the location.
| bit | 1 | ((0)) | |||
ISOOccupancyCode | Code that represents the ISO Occupancy Code for the location. For a complete list of codes, see tConvertISOOccupancy Table. | varchar | 10 | ||||
ISOConstructionCode | Code that represents the ISO Construction Code for the location. For a complete list of codes, see tISOConstruction Table. | varchar | 10 | ||||
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. | tinyint | 1 | ||||
DefensibleSpace | Area in feet between the structure and an oncoming wildfire, where the landscaping has been managed to alter or cut off the paths through which wildfires approach the structure and to increase the probability of a structure surviving. The value may be between 0 and 10,000. The application maps negative values to -999, which is the default/unknown value. | smallint | 2 | ||||
FirewiseCommunityParticipation | Indicates whether the location is in a recognized Firewise USA® site.
| tinyint | 1 | ||||
CustomFloodSOPType | Code that represents the type of CustomFloodStandardOfProtection, if the user specified a level of protection. For a complete list of codes, see tCustomFloodSOPType Table. | varchar | 3 | ('H') | |||
WetFloodProofingCode | Indicates whether the location has protection against wet flooding.
| tinyint | 1 | ((0)) | |||
ContentDamageabilityCode | Code that indicates damage information for each content. For a complete list of codes, see tContentDamageability Table. | tinyint | 1 | ||||
CargoPackingCode | Code that indicates the marine cargo packing details. For a complete list of codes, see tCargoPacking Table. | tinyint | 1 | ||||
CargoProtectionCode | Code that indicates information about the protection of cargo package. For a complete list of codes, see tCargoProtection Table. | tinyint | 1 | ||||
SpecieStorageCode | Code that indicates types of storage used in special construction structures For a complete list of codes, see tSpecieStorage Table. | tinyint | 1 | ||||
SprinklerTypeCode | Code that indicates sprinkler identifier for each sprinkler type. For a complete list of codes, see tSprinklerType Table. | tinyint | 1 | ||||
SalvagePotentialCode | Code that indicates the damage level to determine the total loss for policy conditions. For a complete list of codes, see tSalvagePotential Table. | tinyint | 1 |
Database Object | Object Type | Description | Dep Level | |
---|---|---|---|---|
tContract | Table | Stores records for primary insurance policies. | 2 | |
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 |