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 |
|---|---|
| tActivityType | Stores codes that represent types of activities. |
| tActivityTypeActivityStageXref | System reference table used by the Activity Monitor to determine the current stage of the activity. |
| tAggregateDeductibleType | Stores codes that represent types of aggregate deductibles. |
| tAggregateLimitType | Stores codes that represent types of aggregate limits. |
| tAIRConstOccRegionConstXref | System reference table that stores the AIR construction class codes supported for each geographic region. |
| tAIRConstOccRegionCountryXref | System reference table that stores the countries supported for each region. |
| 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. |
| tCargoPacking | Stores information about the cargo packing details. |
| tCargoProtection | Stores information about the protection of cargo package. |
| tCascadeDeleteOption | Stores codes that represent the type of data to delete during a delete operation. |
| tCatalogModelXref | System reference table that stores the mappings between model codes and catalog model codes. |
| tCatalogTagType | Stores possible subtypes of event catalogs. For example, a catalog tag type code can indicate that an event catalog is time dependent. |
| tCatalogType | Stores the possible catalogs that can be used during a Loss analysis. |
| tCatalogTypeFlagType | Reserved for future use. |
| 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. |
| tCompanyType | Stores codes that represent types of AM Best Imports in Touchstone Re. |
| tContentDamageability | Stores the relative damageability of the contents exposed to flooding for the chosen occupancy. |
| 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. |
| tConvertCL2CatalogType | Stores information about the catalog types used in CLASIC/2. Touchstone uses the information to convert CLASIC/2 catalog types to Touchstone catalog types. |
| tConvertCL2Country | Stores information about the country names used in CLASIC/2. Touchstone uses the information to convert CLASIC/2 country names to Touchstone country names. |
| tCountry | Stores the supported country codes and indicates whether each country is modeled and an offshore location. |
| tCountryCurrencyXref | System reference table used to map currencies to countries when exporting company loss files (CLFs) and UNICEDE/2 files for CATRADER. |
| tCountryILOBs | Stores the industry lines of business (LOBs) supported for each country and peril set combination. |
| tCountryIndustryLOBXref | System reference table used to map the Industry Line of Business to a county. |
| tCountryPerilXref | System reference table used to determine the perils that are associated with a country. |
| tCoverage | Stores the possible coverage types. |
| tCurrency | Stores AIR currency codes. |
| tCurrencyMapping | Stores mappings between previously and currently supported 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. |
| tEPCurveType | Stores the possible types of EP curve that can be generated in Touchstone. |
| tEPTargetType | Stores the possible exposure targets that the application can display EP curves for. |
| 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. |
| tFinancialPerspective | Stores the possible financial perspectives. |
| 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. The premium geocodes obtained by licensing this feature are restricted for use only within Touchstone and cannot be used outside of Touchstone. These are identified by the GeocoderCode = 'Syncsort' column in Touchstone AIRExposure, AIRReference and AIRResults databases. For the Export feature, these premium geocodes are either encrypted or removed during export to comply with these contractual restrictions. Direct extracts of premium geocodes from the Touchstone databases are also contractually prohibited. |
| 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. |
| tHazardAttribute | Stores the possible the attributes of a hazard. |
| tHazardAttributeType | Stores information regarding the possible hazard attribute types. |
| 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. |
| tIndustryLineOfBusiness | Stores the possible the industry Line of Business types. |
| tInjuryType | Stores codes that represent types of injuries. |
| tIntensityAttribute | Stores information about the intensity attributes that may be used during a hazard analysis. |
| 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. |
| tMainPerilSubPerilXref | System reference table that stores information about the sub-perils that are associated with a primary peril set. For example, the following sub-perils are associated with MainPerilSetCode "4" (earthquake):
|
| tManned | Stores codes that indicate whether an offshore platform is manned or unmanned. The codes apply only to offshore locations. |
| tMinMaxDeductibleType | Stores codes that represent minimum maximum deductible types for location terms. |
| tMinMaxLogic | Stores codes for Stores codes for minimum maximum policy logic types used in layer and sublimit terms. |
| tModelCountryXref | System reference table used to determine the countries that are covered by the model. |
| tMultiStoryHall | Stores codes that indicate the presence of multi-story halls in a building. The codes are used in the tLocFeature Table. |
| tObjectType | A generic table to hold objects like templates and widgets which are added through the object management screen in administration console. |
| 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. |
| tOutputTable | Stores the database tables where the output is stored. |
| tOutputTypPerspectiveXref_NGM | System reference table that stores the financial perspective codes that correspond to each output table type. |
| 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. |
| tReinsuranceUNICEDELOB | Stores the mappings between UNICEDE/2 lines of business (LOBs) and LOBs supported in Touchstone Re. Touchstone uses the mappings when a user exports UNICEDE/2 data and associates the data to a company in Touchstone Re. For more information, see the Touchstone online help. |
| tReinsuranceUNICEDEUpgradeMapping | Stores mappings between lines of business in previous versions of the UNICEDE/2 specification and the corresponding lines of business in the current version of the specification. |
| tRetrofit | Stores codes that represent types of retrofitting. The codes are used in the tLocFeature Table. |
| tRiskMeasure | Stores the possible replacement value types available for use in the Geospatial analysis. |
| 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. |
| tSalvagePotential | Stores potential damage level associated with each salvage potential code. This table contains information to evaluate the potential loss and the corresponding damage level to determine the total loss for policy conditions. |
| 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. |
| tSEQUELImpactAirGOMArea | Stores information about the support codes for Gulf of Mexico (GOM) with area code and their corresponding AIR specific sequential identifier. |
| tSEQUELImpactMMSData | Stores information about the SEQUELImpact Offshore structure including the type and number of structures. For internal use only. |
| tSEQUELImpactSubPerilGroupingXRef | Stores codes, descriptions, and groupings of the peril codes generated in Touchstone. |
| 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. |
| tSpecieStorage | Stores code that represent types of storage used in special construction structures. |
| tSprinklerType | This table contains the sprinkler identifier for each sprinkler type. |
| 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. |
| tTimeOfShift | Stores codes that represent types of shift definitions. |
| 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. |
| tUpgradeLog | Stores information about upgrade scripts. |
| tValidationError | Stores import validation error codes, validation rules, and error messages. When a validation error occurs, the error is written to the import log file using the following format: ERROR CODE | Contract ID: XXX Location ID XXX | Summary Message. |
| tVulnerabilitySetFileType | Stores codes that represent the type of vulnerability set files in Touchstone. |
| 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. |
| tWetFloodProofing | Stores codes that represent types of protection systems for wet flood in a location. 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. |