The AIRReference database is a central repository for reference information.
In general, each table in the database includes columns for code values, the names of the codes, and descriptions of the codes.
Table | Description |
---|---|
tAIRConstruction | Stores information about AIR construction class codes. |
tAIROccupancy | Stores information about AIR occupancy class codes. |
tAppurtenantStructure | Stores codes that represent types of appurtenant structures. The codes are used in the tLocFeature Table. |
tAuditStatus | System reference table used internally by the loss and geospatial analysis engines to determine the status of a location in the location table. |
tBasementFinishType | Stores codes that indicate whether a basement is finished. The codes are used in the tLocFeature Table. |
tBrickVeneer | Stores codes that indicate the percentage of a building that is constructed of brick veneer. The codes are used in the tLocFeature Table. |
tBuildingCondition | Stores codes that indicate the condition of a building. The codes are used in the tLocFeature Table. |
tBuildingExteriorOpening | Stores codes that indicate the percentage of a building's exterior walls that comprise openings. Openings include windows and doors. The codes are used in the tLocFeature Table. |
tBuildingShape | Stores codes that indicate the shape of a building. The codes are used in the tLocFeature Table. |
tChimney | Stores codes used to identify whether a building has a chimney, and if so, the chimney height. The codes are used in the tLocFeature Table. |
tColdFormedTube | Stores codes that indicate the presence of cold-formed tubes in a building. The codes are used in the tLocFeature Table. |
tColumnBasement | Stores codes that indicate the type of connection between the columns and basement in a building with stell-reinforced concrete (SRC) or steel construction. The codes are used in the tLocFeature Table. |
tCompanySize | Stores codes that indicate the size of a company associated with an offshore location. The codes are used in the tLocFeature Table. |
tContentVulnerability | Stores codes that indicate the relative vulnerability of contents in a building. The codes are used in the tLocFeature Table. |
tContractType | Stores the supported contract types. |
tCountry | Stores the supported country codes and indicates whether each country is modeled and an offshore location. |
tCurrency | Stores AIR currency codes. |
tCustomFloodSOPType | Stores codes that represent types of custom standards of protection for flood. A custom standard of protection is a user-specified level of flood protection that overrides the AIR-defined level of protection during analyses. Flood protection includes levees, dikes, and flood walls. The codes are used in the tLocFeature Table. |
tCustomFloodZone | Stores codes that represent user-specified flood zones. The codes are used in the tLocFeature Table. |
tDataSourceType | Stores codes that represent types of data sources. |
tDBVersion | Defines the version of the database. |
tDeductibleType | Stores codes that represent types of location, layer, and sublimit deductibles. |
tEnhancedGeoMatchLevel | Stores the supported geocode match levels. |
tEquipment | Stores codes that indicate the quality of the bracing of a building. The codes are used in the tLocFeature Table. |
tExternalDoor | Stores codes that represent types of exterior doors. The codes are used in the tLocFeature Table. |
tFIRMCompliance | Stores codes that indicate whether a building is in compliance with the FEMA flood zone requirements in design and construction. The codes are used in the tLocFeature Table.
|
tFoundation | Stores codes that represent types of building foundations. The codes are used in the tLocFeature Table. |
tFoundationConnection | Stores codes that represent types of connections between a structure and foundation. The codes are used in the tLocFeature Table. |
tGeocoder | Stores the geocode resources available in Touchstone. Some resources are available only by license. |
tGeoLevel | Stores codes that represent geographic levels. |
tGeoMatchLevel | Stores codes that represent the levels at which a geocode match can occur. |
tGlassPercent | Stores codes that represent the percentage of the walls in a building that consist of glass. The codes are used in the tLocFeature Table. |
tGlassType | Stores codes that represent types of glass used in a building. The codes are used in the tLocFeature Table. |
tIBHSFortified | Stores codes that represent the level of certification per the Institute for Business and Home Safety, which defines a structure's ability to withstand load resistance. The codes are used in the tLocFeature Table. |
tInternalPartition | Stores codes that represent types of interior walls. The codes are used in the tLocFeature Table. |
tISValue | Stores codes that represent measurements of the total seismic performance of a building. The measurements account for all characteristics that affect the response of a building to an earthquake. The codes are used in the tLocFeature Table. |
tLargeMissile | Stores codes that indicate the presence of large missiles within 100 feet of a structure. The codes are used in the tLocFeature Table. |
tLattice | Stores codes that represent types of lattices. The codes are used in the tLocFeature Table. |
tLayerConditionType | Stores codes that indicate whether a layer is associated with a sublimit or a sub-sublimit. |
tLimitType | Stores codes that represent types of location limits. |
tManned | Stores codes that indicate whether an offshore platform is manned or unmanned. The codes apply only to offshore locations. |
tMultiStoryHall | Stores codes that indicate the presence of multi-story halls in a building. The codes are used in the tLocFeature Table. |
tOccLimitType | Stores the limit types that you can apply to layers and sublimits. |
tOrnamentation | Stores codes that indicate the amount of decorative elements attached to the exterior of a building. The codes are used in the tLocFeature Table. |
tPeril | Stores codes that represent the perils supported by the application. |
tPerilSet | Stores codes that represent the perils sets supported by the application. |
tPounding | Stores codes that indicate the distance between two structures. If the distance is not sufficiently long, the two structures may collide during earthquake shaking. The codes are used in the tLocFeature Table. |
tPreferredExposureType | Stores the preferred exposure types. |
tProjectPhase | Stores codes that represent project phases, which indicate stages of construction. The codes are used in the tLocFeature Table. |
tPublicProtectionClass | Stores Public Protection Classification (PPC) codes. ISO analyzes community data (for example, fire department, water supply, or emergency communications system data) and assigns a Public Protection Classification (PPC). PPCs range from 1 to 10. Class 1 generally represents superior fire protection, and Class 10 indicates that the area's fire suppression program does not meet ISO's minimum criteria. The codes are used in the tLocFeature Table. |
tRedundancy | Stores codes that indicate the presence of multiple lateral load resisting elements in a building. The codes are used in the tLocFeature Table. |
tReinsTargetType | Stores codes that represent types of targets associated with the reinsurance contract. |
tReinsuranceType | Stores codes that represent the types of reinsurance treaties supported in the application. |
tRetrofit | Stores codes that represent types of retrofitting. The codes are used in the tLocFeature Table. |
tRoofAnchorage | Stores codes that represent types of anchors used to secure a roof support system to the walls of a building. The codes are used in the tLocFeature Table. |
tRoofAttachedStructure | Stores codes that represent types of mechanical and other equipment that is attached to the roof of a building. The codes are used in the tLocFeature Table. |
tRoofCover | Stores codes that represent types of materials used for covering the roof of a building. The codes are used in the tLocFeature Table. |
tRoofCoverAttach | Stores codes that represent types of connections used to secure the roof covering to the roof deck. The codes are used in the tLocFeature Table. |
tRoofDeck | Stores codes that represent materials used to construct the roof deck of a building. The codes are used in the tLocFeature Table. |
tRoofDeckAttach | Stores codes that represent types of connections used to secure the roof deck of a building to the underlying roof support system. The codes are used in the tLocFeature Table. |
tRoofGeometry | Stores codes that represent roof shapes The codes are used in the tLocFeature Table. |
tRoofHailImpactResistance | Stores codes that represent a roof's level of resistance to damage from hail impact. The codes are used in the tLocFeature Table. |
tRoofPitch | Stores codes that represent roof pitch angles, which determine the slope of the roof. The codes are used in the tLocFeature Table. |
tSealOfApproval | Stores codes that represent types of professional engineering attention given to the design of a structure. The codes are used in the tLocFeature Table. |
tServiceEquipmentProtection | Stores codes that indicate regarding whether the service equipment at a location is protected from flood. The codes are used in the tLocFeature Table. |
tShapeIrregularity | Stores codes that represent types of structural irregularity for a building. The codes are used in the tLocFeature Table. |
tShortColumn | Stores codes that indicate the presence of a short column in a building. The codes are used in the tLocFeature Table. |
tSmallDebris | Stores codes that indicate the presence of small debris within 200 meters of a structure. The codes are used in the tLocFeature Table. |
tSoftStory | Stores codes that indicate the presence of any structural weaknesses. The codes are used in the tLocFeature Table. |
tSpecialConstruction | Stores codes that represent types of earthquake-resistant system types. The codes are used in the tLocFeature Table. |
tStatus | Stores codes that represent the status of objects in the applicable tables. |
tStepTriggerType | Stores the supported trigger types for step functions. |
tSubmitStatus | Stores the supported contract submission status options. |
tTallOneStory | Stores codes that represent the height of a one story building. The codes are used in the tLocFeature Table. |
tTank | Stores codes that indicate the presence of storage tanks in a building. The codes are used in the tLocFeature Table. |
tTerrainRoughness | Stores codes that represent the condition (or categorization) of the terrain surrounding a building. The codes are used in the tLocFeature Table. |
tTorsion | Stores codes that represent the layout of the structural elements in a building that may lead to torsional loads. The codes are used in the tLocFeature Table. |
tTransitionInSRC | Stores codes that indicate whether the transition from steel-reinforced concrete (SRC) to reinforced concrete (RC) in the columns of a building with SRC construction is smooth. The codes are used in the tLocFeature Table. |
tTransverseFrameType | Stores codes that represent types of transverse framing used to brace offshore platform legs. |
tTreeExposure | Stores codes that indicate the presence of trees. The codes are used to identify the tree hazard around a structure. The codes are used in the tLocFeature Table. |
tTriggerType | Stores the supported trigger types, which are used to determine how reinsurance contracts are applied. |
tUnit | Stores the supported units of measure. |
tWall | Stores codes that represent types of materials used for the external walls of a building. The codes are used in the tLocFeature Table. |
tWallAttachedStructure | Stores codes that represent types of structures that may be attached to a primary building. The codes are used in the tLocFeature Table. |
tWallSiding | Stores codes that represent types of siding used for weather protection on the external walls of a building. The codes are used in the tLocFeature Table. |
tWaterHeater | Stores codes that indicate the presence of bracing for the water heater in a building. The codes are used in the tLocFeature Table. |
tWelding | Stores codes that indicate whether welding occurs within a building. The codes are used in the tLocFeature Table. |
tWindowProtection | Stores codes that represent types of protection systems used for the windows of a building. The codes are used in the tLocFeature Table. |