CEDE 8.0 Database Reference
AIRReference Database
Description

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.

Tables
TableDescription
tActivityTypeStores codes that represent types of activities.
tActivityTypeActivityStageXrefSystem 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.

tAIRConstructionStores information about AIR construction class codes.
tAIROccupancyStores 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.

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.

tCatalogTypeFlagTypeReserved 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.

tCompanyTypeStores codes that represent types of AM Best Imports in Touchstone Re.
tContentVulnerability

Stores codes that indicate the relative vulnerability of contents in a building.

The codes are used in the tLocFeature Table.

tContractTypeStores 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.

tCountryStores the supported country codes and indicates whether each country is modeled and an offshore location.
tCountryCurrencyXrefSystem reference table used to map currencies to countries when exporting company loss files (CLFs) and UNICEDE/2 files for CATRADER.
tCountryILOBsStores the industry lines of business (LOBs) supported for each country and peril set combination.
tCountryIndustryLOBXrefSystem reference table used to map the Industry Line of Business to a county.
tCountryPerilXrefSystem reference table used to determine the perils that are associated with a country.
tCoverageStores the possible coverage types.
tCurrency

Stores AIR currency codes.

tCurrencyMappingStores 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.

tDBVersionDefines 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.

tInjuryTypeStores codes that represent types of injuries.
tIntensityAttributeStores 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.

tLayerConditionTypeStores codes that indicate whether a layer is associated with a sublimit or a sub-sublimit.
tLimitTypeStores 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):

  • 4 (earthquake)
  • 8 (fire following)
  • 12 (earthquake shake, fire following)
  • 128 (sprinkler leakage)
  • 8192 (tsunami)
  • 8196 (earthquake shake, tsunami)
  • 8200 (fire following, tsunami)
  • 8204 (earthquake shake, fire following, tsunami)
  • 139404 (earthquake shake, fire following, tsunami, sprinkler leakage, and landslide)
tManned

Stores codes that indicate whether an offshore platform is manned or unmanned.

The codes apply only to offshore locations.

tMinMaxDeductibleTypeStores codes that represent minimum maximum deductible types for location terms.
tMinMaxLogicStores codes for Stores codes for minimum maximum policy logic types used in layer and sublimit terms.
tModelCountryXrefSystem 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.

tObjectTypeA 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.

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.

tPreferredExposureTypeStores 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.

tReinsuranceTypeStores codes that represent the types of reinsurance treaties supported in the application.
tReinsuranceUNICEDEAreatagCountryXref 
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.

tReinsuranceUNICEDEUpgradeMappingStores 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.

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.

tSEQUELImpactSubPerilGroupingXRefStores 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.

tStatus

Stores codes that represent the status of objects in the applicable tables.

tStepTriggerTypeStores the supported trigger types for step functions.
tSubmitStatusStores 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.

tTimeOfShiftStores 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.

tUnitStores the supported units of measure.
tUpgradeLogStores 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.

tVulnerabilitySetFileTypeStores 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.