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

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.

tContractTypeStores the supported contract types.
tCountryStores 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.

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.

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.

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

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

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.

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

 

 


© 2019. 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.