Each attribute specifies a data type. The following types are used:
text
number
percentage
currency
boolean
date
year
choices
object
† If an attribute’s data type has a dagger (†) next to it, the attribute will actually contain a mapping containing one or more of the following attributes
(if null, they are simply not included):
Copy
Ask AI
{ "value": Cleaned-up data value. "confidence": 0.0 (lowest confidence) to 1.0 (highest confidence), indicating a reliability score for the element. "original": Cell value as originally read, before any scrubbing operations. "source": Provenance of the data. "units": Currency of value, if known. "comment": Human-readable information about the derivation of the value.}
item_key (text)
Uniqely identify each item globally.
extra (object)
Mapping containing labels/values of any additional unidentified but parsed data.
custom_attrs (object†)
Client Custom Attributes: Any custom client-specific attributes.
building_counter (number)
Incrementing counter to uniquely identify each item within the output.
sheet_name (text)
Excel Worksheet Name: Name of the original source worksheet.
sheet_row_number (number)
Excel Worksheet Row: Original source Excel row number.
parsing_sheet_name (text)
Actively Parsing Excel Worksheet Name: Name of the worksheet being parsed (from the scrubber/intermediate format, as opposed to the original source). Same as sheet_name unless explicitly mapped from a Ping-generated scrubber sheet.
parsing_sheet_row_number (number)
Actively Parsing Excel Worksheet Row: Source Excel row number being parsed. Same as sheet_name unless explicitly mapped from a Ping-generated scrubber sheet.
reliability (object)
An estimate of the quality of scrubbing/mapping of several key categories.
reliability_reason (object)
external_data (object)
External Data: Key/object pairs of third-party enrichment as fetched from Ping Data.
zones (object)
Calculated zones for each peril.
integration_results (object)
Integration Results: Results of any 3rd party data integrations: ABOUT_TO_REQUEST=“A”, NOT_REQUESTED=“N”, LOCALLY_CACHED = “C”, REQUESTED=“R”, LOCALLY_CACHED_FAILURE=“G”, FAILED=“F”, SKIPPED=“S”
integration_messages (object)
Integration Messages: Error messages provided by any 3rd party data integrations.
appurtenant_structure_of (text†)
ping_viewer_url (text)
ping_pli_url (text)
orig (object)
Original Excel cell data for any relevant source cells.
individual_values (object)
Individual Values: If more than one value has been set for an attribute, each individually is included here (as well as aggregated into the regular attribute).
const__desc (text†)
Construction: Original SOV construction information. Available integrations: HH construction_type, LB construction_type, TF construction_type.
const__desc_ping (choices†)
Ping Construction Description
Attributes that provide descriptive information about the property or its geolocation.
location_group (number†)
Identify campuses or other sets of buildings that should be treated as ‘together’. This is used to help guide occupancy mapping of ambiguous sub-buildings.
location_group_item (number†)
Individual buildings within a location_group. Numbered (or renumbered) sequentially within a location_group.
location_code (text†)
Location Code
location_number (number†)
Location Number
building_number (number†)
Building Number
naics_code (text†)
NAICS Code: NAICS business type code
sic_code (text†)
SIC Code: SIC business type code
bldg_name (text†)
Building Name
insured__business_name (text†)
Insured Business Name
insured__name (text†)
Insured’s Name
insured__street (text†)
Insured Street
insured__city (text†)
Insured City
insured__state (text†)
Insured State
insured__zip (text†)
Insured Zip
insured__county (text†)
Insured County
ownership_status (text†)
Ownership Status: Information about whether the property is owned, leased, etc.
limits__orig_limits (dict_currency†)
Individual/Original SOV Limits: Mapping containing each limit as found in the original SOV. See subclass_mapping for translating these to limit categories.
limits__building_limit (currency†)
Building Limit: Part of limits__building_limit. Components limits__builders_risk_hard_costs + limits__building_limit + limits__tenant_improvement_and_betterments_limit.
limits__building_value (currency†)
Building Value
limits__building_value_type (text†)
Building Valuation Type: System for creating/calculating the building value. Common values include RC (Replacement Cost) and AC (Actual Cost).
limits__bpp_limit (currency†)
Business Personal Property (BPP) Limit: Part of limits__total_limit. Components limits__contents_limit + limits__edp_limit + limits__equipment_limit + limits__fine_art_limit + limits__furniture_and_fixtures_limit + limits__inventory_limit + limits__property_of_others_limit + limits__vehicle_limit.
limits__bpp_value (currency†)
Business Personal Property (BPP) Value
limits__contents_limit (currency†)
Contents Limit: Part of limits__bpp_limit.
limits__vehicle_limit (currency†)
Vehicle Limit: Part of limits__bpp_limit.
limits__edp_limit (currency†)
Electronic Data Processing Limit (EDP): Part of limits__bpp_limit.
limits__equipment_limit (currency†)
Equipment Limit: Part of limits__bpp_limit.
limits__fine_art_limit (currency†)
Fine Art Limit: Part of limits__bpp_limit.
limits__furniture_and_fixtures_limit (currency†)
Furniture and Fixtures Limit: Part of limits__bpp_limit.
limits__inventory_limit (currency†)
Inventory Limit: Part of limits__bpp_limit.
limits__property_of_others_limit (currency†)
Personal Property of Others Limit: Part of limits__bpp_limit.
limits__tenant_improvement_and_betterments_limit (currency†)
Tenant Improvements and Betterments Limit: Part of limits__building_limit.
limits__builders_risk_hard_costs (currency†)
Builder’s Risk Hard Costs: Part of limits__building_limit.
limits__builders_risk_soft_costs (currency†)
Builder’s Risk Soft Costs: Part of limits__bi_limit.
limits__signs_limit (currency†)
Signs Limit: Part of limits__signs_limit. Components limits__billboards_limit + limits__signs_limit.
limits__billboards_limit (currency†)
Billboards Limit: Part of limits__signs_limit.
limits__bpp_excl_inventory_and_equipment (currency†)
BPP Excl Inventory and Equipment Limit: BPP excluding inventory and equipment.
limits__signs_and_other_limit (currency†)
Signs and Other Limits
limits__other_limit (currency†)
Other Limit: Part of limits__other_limit. Components limits__other_limit.
limits__total_rp_and_bpp (currency†)
Total Real Property & BPP: Sum of building and BPP limits. Part of limits__total_limit.
limits__total_limit (currency†)
Total Limit: TIV, or, the sum of all limits. Should equal building_limit+bpp_limit+bi_limit+signs_limit+other_limit. Components limits__bpp_limit + limits__total_rp_and_bpp.
limits__total_value (currency†)
The sum of all values (potentially different than the insured limit). Should equal building_value+bpp_value+bi_limit+signs_limit+other_limit.
limits__building_deductible (currency†)
Building Deductible
limits__bpp_deductible (currency†)
Business Personal Property (BPP) Deductible
limits__bi_limit (currency†)
Business Interruption Limit: Part of limits__bi_limit. Components limits__aicow_limit + limits__bi_extra_expense_limit + limits__bi_limit + limits__builders_risk_soft_costs + limits__gross_profit_limit + limits__payroll_limit + limits__rent_limit.
limits__bi_period (number†)
Business Interruption Period
limits__bi_waiting_period (number†)
Business Interruption Waiting Period
limits__bi_extra_expense_limit (currency†)
Extra Expense Limit: Part of limits__bi_limit.
limits__payroll_limit (currency†)
Payroll Limit: Part of limits__bi_limit.
limits__rent_limit (currency†)
Rent Limit: Part of limits__bi_limit.
limits__gross_profit_limit (currency†)
Gross Profit Limit: Part of limits__bi_limit.
limits__aicow_limit (currency†)
Additional Increased Cost Of Working: Part of limits__bi_limit.
limits__insurance_to_value (currency†)
$ per Sq Ft
currency (text†)
Currency: If there is a currency unit column, this will contain it. However, typically you should use the units property.
limits__homeowners_cvg_a_limit (currency†)
Homeowners Coverage A
limits__homeowners_cvg_b_limit (currency†)
Homeowners Coverage B
limits__homeowners_cvg_c_limit (currency†)
Homeowners Coverage C
limits__homeowners_cvg_d_limit (currency†)
Homeowners Coverage D
premium (currency†)
Premium: Collection of all premiums so they don’t end up counted as limits.
const__wall_type (text†)
Wall Type: Description of materials used for external walls. Available integrations: LB wall_type, TF wall_type.
const__wall_siding (text†)
Wall Siding: Description of cladding materials used for weather, wind, and rain protection of the external walls. Available integrations: LB wall_siding, TF wall_siding.
const__eifs (boolean†)
EIFS
const__frame_to_foundation_connection (text†)
Frame to Foundation Connection
const__foundation_type (text†)
Building Foundation Type
const__base_flood_elevation (number†)
Base Flood Elevation
const__wind_pool_eligible (boolean†)
Wind Pool Eligible: Input from AMRISC only.
const__tall_one_story (text†)
const__torsion (text†)
Torsion
const__soft_story (text†)
Soft Story
const__special_construction (text†)
Special Construction
const__retrofit (text†)
Retrofit Measures: Description of any seismic retrofit measures. A properly retrofitted structure can resist earthquakes even though the original structural form had weaknesses.
const__short_column (text†)
Short Column
const__ornamentation (text†)
Ornamentation
const__water_heater (text†)
Water Heater
const__redundancy (text†)
Redundancy: Whether there are multiple lateral load-resisting elements (frames or shear walls) in the building at this location. Redundancy provides additional reinforcement against earthquake damage.
const__pounding (text†)
Pounding: Distance from the building at this location to the closest structure, which, if not adequate, can cause the two structures to collide during earthquake shaking.
const__flashing_coping_quality (text†)
Flashing and Coping Quality
const__mfd_subcategory (text†)
MFD Subcategory
air__adjacent_building_height (number†)
AIR Adjacent Building Height
air__appurtenant_structures (choices†)
AIR Appurtenant Structures
0: Unknown/default
1: Detached garage
2: Pool enclosures
3: Shed
4: Masonry boundary wall
5: Other fence
6: No appurtenant structures
7: No pool enclosures
air__attached_structures (choices†)
AIR Attached Structures
0: Unknown/default
1: Carports/Canopies/Porches
2: Single Door Garages
3: Double Door Garages
4: Reinforced Single Door Garages
5: Reinforced Double Door Garages
6: Screened Porches/Glass Patio Doors
7: Balcony
8: No attached wall structures
air__basement_level_count (number†)
AIR Basement Level Count
air__basement_finish_type (choices†)
AIR Basement Finish Type
0: Unknown/default
1: Unfinished basement
2: Finished basement
air__base_flood_elevation (number†)
AIR Base Flood Elevation
air__base_flood_elevation_unit (text†)
AIR Base Flood Elevation Unit
air__brick_veneer (choices†)
AIR Brick Veneer
0: Unknown/default
1: More than 90%
2: 20 - 50%
3: 0 - 20%
air__building_condition (choices†)
AIR Building Condition
0: Unknown/default
1: Average
2: Good
3: Poor
air__building_exterior_opening (choices†)
AIR Building Exterior Opening
0: Unknown/default
1: Less than 50% of wall open
2: More than 50% of wall open
air__building_shape (choices†)
AIR Building Shape
0: Unknown/default
1: Square
2: Rectangle
3: Circular
4: L-shaped
5: T-shaped
6: U-shaped
7: H-shaped
8: Complex
air__chimney (choices†)
AIR Chimney
0: Unknown/default
1: No
2: Yes, height <= 2 ft.
3: Yes, height <= 5 ft.
4: Yes, height > 5 ft.
air__cold_formed_tube (choices†)
AIR Cold Formed Tube
0: Unknown/default
1: No
2: Yes
air__column_basement_type (choices†)
AIR Column Basement Type
0: Unknown/default
1: Mixed
2: Non-Embedded
3: Embedded
air__content_vulnerability (choices†)
AIR Content Vulnerability
0: Unknown/default
1: Low
2: Moderate
3: High
4: Very High
air__custom_elevation_unit (text†)
AIR Custom Elevation Unit
air__custom_elevation (number†)
AIR Custom Elevation
air__equipment_bracing (choices†)
AIR Equipment Bracing
0: Unknown/default
1: Well-Braced
2: Average Bracing
3: Unbraced
air__exterior_doors (choices†)
AIR Exterior Doors
0: Unknown/default
1: Single width Doors
2: Double width Doors
3: Reinforced single width doors
4: Reinforced double width doors
5: Sliding doors
6: Reinforced sliding doors
air__firm_compliance (choices†)
AIR FIRM Compliance
0: Unknown/default
1: No
2: Yes
air__first_floor_height (number†)
AIR First Floor Height
air__first_floor_height_unit (text†)
AIR First Floor Height Unit
air__foundation_connection (choices†)
AIR Foundation Connection
0: Unknown (Default)
1: Hurricane Ties
2: Nails / Screws
3: Anchor Bolts
4: Gravity / Friction
5: Adhesive Epoxy
6: Structurally connected
air__foundation_type (choices†)
AIR Foundation Type
0: Unknown/default
1: Masonry basement
2: Concrete basement
3: Masonry wall
4: Crawl space cripple wall
5: Crawl space masonry
6: Post & pier
7: Footing
8: Mat / slab
9: Pile
10: No basement
11: Engineering foundation
12: Crawlspace - raised (wood)
air__glass_percentage (choices†)
AIR Glass Percentage
0: Unknown/default
1: Less than 5%
2: Between 5% and 20%
3: Between 20% and 60%
4: Greater than 60%
air__glass_type (choices†)
AIR Glass Type
0: Unknown/default
1: Annealed
2: Tempered
3: Heat strengthened
4: Laminated
5: Insulating glass units
air__ibhs_certified (choices†)
AIR IBHS Certified
0: Unknown/default
1: Fortified Home (IBHS) Bronze Option 1
2: Fortified Home (IBHS) Bronze Option 2
3: Fortified Home (IBHS) Silver Option 1
4: Fortified Home (IBHS) Silver Option 2
5: Fortified Home (IBHS) Gold Option 1
6: Fortified Home (IBHS) Gold Option 2
7: Fortified for Safer Living (IBHS)
air__internal_partition (choices†)
AIR Internal Partition
0: Unknown/default
1: Wood
2: Gypsum boards
3: Plastered masonry
4: Brick
5: Other
air__is_value_type (choices†)
AIR IS Value Type
0: Unknown/default
1: Less than 0.3
2: 0.3 - 0.45
3: 0.45 - 0.55
4: 0.55 - 0.65
5: 0.65 - 0.75
6: 0.75 - 0.85
7: 0.85 - 1.0
8: 1.0 - 1.25
9: Greater than 1.2
air__large_missile (choices†)
AIR Large Missile
0: Unknown/default
1: No
2: Yes
air__lattice_type (choices†)
AIR Lattice Type
0: Unknown/default
1: Full Web
2: Grid
3: Lattice
air__multi_story_hall_type (choices†)
AIR Multi Story Hall Type
0: Unknown/default
1: No
2: Yes
air__ornamentation (choices†)
AIR Ornamentation
0: Unknown/default
1: None
2: Average
3: Extensive
air__pounding (choices†)
AIR Pounding: Distance from the building at this location to the closest structure, which, if not adequate, can cause the two structures to collide during earthquake shaking.
0: Unknown/default
1: 0-0.25 m
2: 0.25-0.5 m
3: 0.5-1.0 m
4: 1.0-2.0 m
5: >2.0 m
air__project_completion (percentage†)
AIR Project Completion
air__project_phase_code (choices†)
AIR Project Phase Code
0: No Builder’s Risk
1: Phase 1
2: Phase 2
3: Phase 3
4: Phase 4
5: Average Project Loss
6: Worst Loss
air__redundancy (choices†)
AIR Redundancy
0: Unknown/default
1: No
2: Yes
air__retrofit (choices†)
AIR Retrofit: A properly retrofitted structure can resist earthquakes even though the original structural form had weaknesses.
0: Unknown/default
1: Bracing of cripple walls
2: Bracing of parapets
3: Bracing of soft-story
4: Foundation anchorage (bolting)
5: Glass/window strengthening
6: Tilt Up
7: General
air__seal_of_approval (choices†)
AIR Seal Of Approval
0: Unknown/default
1: Fully Engineered Structure
2: Partially Engineered Structure
3: Minimally Engineered Structure
air__service_equipment_protection (choices†)
AIR Service Equipment Protection
0: Unknown/default
1: Unprotected
2: Low Protection for flood
3: Medium Protection for flood
4: High Protection for flood
air__short_column (choices†)
AIR Short Column
0: Unknown/default
1: No
2: Yes
air__small_debris (choices†)
AIR Small Debris
0: Unknown/default
1: No
2: Yes
air__soft_story (choices†)
AIR Soft Story
0: Unknown/default
1: No
2: Yes
air__special_construction (choices†)
AIR Special Construction
0: Unknown/default
1: Base isolation
2: Visco-elastic dampers
3: Other energy dissipaters
air__sprinkler_type (choices†)
AIR Sprinkler Type
Unknown
Wet
Dry
air__structural_irregularity (choices†)
AIR Structural Irregularity
0: Unknown/default
1: Vertical Offset
2: Non-uniform Floor Area
3: Discontinuous Shear Wall
4: Heavy floor
air__tall_one_story (choices†)
AIR Tall One Story
0: Unknown/default
1: <= 20 ft
2: > 20 ft
3: > 40 ft
air__tank (choices†)
AIR Tank: Indicate whether there are rooftop tanks on adjacent higher buildings, for EQ.
0: Unknown/default
1: No
2: Yes
air__terrain_roughness (choices†)
AIR Terrain Roughness
0: Unknown/default
1: Large city centers
2: Urban and suburban areas, wooded areas
3: Open terrain with scattered obstruct
4: Flat, unobstructed areas
air__torsion (choices†)
AIR Torsion
0: Unknown/default
1: Symmetric
2: Asymmetric
3: Corner building
air__transition_in_source_type (choices†)
AIR Transition In Src Type
0: Unknown/default
1: Smooth
2: Non-Smooth
air__tree_exposure (choices†)
AIR Tree Exposure
0: Unknown/default
1: No
2: Yes
air__wall_siding (choices†)
AIR Wall Siding: Available integrations: LB wall_siding, TF wall_siding.
0: Unknown/default
1: Veneer brick/masonry
2: Wood shingles
3: Clapboards
4: Aluminum/vinyl siding
5: Stone panels
6: Exterior insulation finishing system
7: Stucco
air__wall_type (choices†)
AIR Wall Type: Available integrations: LB wall_type, TF wall_type.
0: Unknown/default
1: Brick/unreinforced masonry
2: Reinforced masonry
3: Plywood
4: Wood planks
5: Particle board/OSB
6: Metal panels
7: Pre-cast concrete elements
8: Cast-in-place concrete
9: Gypsum board
air__water_heater (choices†)
AIR Water Heater
0: Unknown/default
1: Braced
2: Unbraced
air__wet_floodproofing (choices†)
AIR Wet Floodproofing
0: Unknown/default
1: Unprotected
2: Low Protection, wet floodproofed by one foot
3: Medium Protection, wet floodproofed by three feet
4: High Protection, wet floodproofed by over three feet
air__welding (choices†)
AIR Welding Detail
0: Unknown/default
1: On-Site
2: In-House
air__window_protection (choices†)
AIR Window Protection
0: Unknown/default
1: No protection
2: Non-engineered shutters
3: Engineered shutters
amrisc__basement (choices†)
AMRISC Basement: Input from AMRISC only. Available integrations: HH has_basement, Q basement.
100-Unknown
101-No basement
102-Basement WITH Flood Protection
103-Basement WITHOUT Flood Protection
104-Basement with unknown flood protection
amrisc__frame_to_foundation_connection (choices†)
AMRISC Building Frame to Foundation Connection: Input from AMRISC only.
100-Unknown
101-Bolted
102-Unbolted
amrisc__building_foundation (choices†)
AMRISC Building Foundation: Input from AMRISC only.
1-Engineered
2-Non-Engineered
amrisc__building_maintenance (choices†)
AMRISC Building Maintenance: Input from AMRISC only.
1-Maint Enforced
2-No Maintenance
amrisc__construction_quality (choices†)
AMRISC Construction Quality: Input from AMRISC only.
100-Unknown
101-Certified Design & Construction
102-Obvious Signs of Deterioration or Distress
103-Certificate of Occupancy
amrisc__property_type (choices†)
AMRISC Property Type: Input from AMRISC only.
Building
Eqpt
Pool/Spa
Outdoor Prop
Other Structures
amrisc__wind_pool_eligible (boolean†)
AMRISC Wind Pool Eligible: Input from AMRISC only.
amrisc__wall_siding (choices†)
AMRISC Wall Cladding: Input from AMRISC only. Available integrations: LB wall_siding, TF wall_siding.
100-Unknown
101-Brick Veneer
102-Metal Sheathing
103-Wood
104-EIFS
105-Unreinforced Masonry
106-Reinforced Masonry
107-Precast Concrete
108-Cast-in-Place Concrete
109-Impact Rated Glass
110-Non-Impact Glass WITH gravel roof or gravel on adjacent Bldg<1000 ft.
111-Non-Impact Glass WITHOUT gravel roof or gravel on adjacent Bldg<1000 ft.
112-Aluminum/Vinyl Siding
113-Cementitous Hardboard Siding
114-Stucco
amrisc__acic_location (text†)
AMRISC ACIC Location: Input from AMRISC only.
amrisc__acic_bcegs (text†)
AMRISC ACIC BCEGS: Input from AMRISC only.
amrisc__acic_terrain (text†)
AMRISC ACIC Terrain: Input from AMRISC only.
amrisc__acic_group_two_construction (text†)
AMRISC ACIC Group 2 Construction: Input from AMRISC only.
amrisc__acic_occupancy (text†)
AMRISC ACIC Occupancy: Input from AMRISC only.
amrisc__acic_building_valuation (choices†)
AMRISC ACIC Building Valuation: Input from AMRISC only.
RCV
ACV
amrisc__acic_sprinklers_iso_approved (boolean†)
AMRISC ACIC Sprinklers ISO Approved?: Input from AMRISC only.
amrisc__em_cladding_type (choices†)
AMRISC EM Cladding Type: Input from AMRISC only.
100-Unknown
101-Glass
102-Precast
103-Unreinforced Masonry
amrisc__em_cripple_walls (choices†)
AMRISC EM Cripple Walls: Input from AMRISC only.
100-Unknown
101-No Cripple walls
102-Braced Cripple walls
103-Unbraced Cripple walls
amrisc__em_equipment_bracing (choices†)
AMRISC EM Equipment Bracing: Input from AMRISC only.
100-Unknown
101-Generally Well Braced
102-Somewhat Braced
103-Generally Unbraced
amrisc__em_frame_bolted (choices†)
AMRISC EM Frame Bolted: Input from AMRISC only.
100-Unknown
101-Bolted
102-Unbolted
amrisc__em_pounding (choices†)
AMRISC EM Pounding: Input from AMRISC only.
100-Unknown
101-No
102-Yes
amrisc__em_purlin_anchoring (choices†)
AMRISC EM Purlin Anchoring: Input from AMRISC only.
100-Unknown
101-Purlins Properly Anchored (tilt-up)
102-Purlins Not Properly Anchored (tilt-up)
amrisc__em_soft_story (choices†)
AMRISC EM Soft Story: Input from AMRISC only.
100-Unknown
101-No
102-Yes
amrisc__em_unreinforced_masonry_retrofit (choices†)
AMRISC EM Unreinforced Masonry Retrofit: Input from AMRISC only.
100-Unknown
101-No
102-Yes
amrisc__em_year_upgrade (year†)
AMRISC EM Year Upgrade: Input from AMRISC only.
icm__appurtenant_structures (choices†)
ICM Appurtenant Structures: Input from ICM only.
Unknown (Default)
Detached Garages
Pool Enclosures
Shed
Masonry Boundary Wall
Other Fence
No Appurtenant Structures
No Pool Enclosures
icm__basement_finish_type (choices†)
ICM Basement Finish Type: Input from ICM only.
Unknown (Default)
Unfinished Basement
Finished Basement
icm__basement_level_count (choices†)
ICM Basement Level Count: Input from ICM only.
Unknown (Default)
No Basement
One Basement Level
Two Basement Levels
Three or More Basement Levels
icm__brick_veneer (choices†)
ICM Brick Veneer: Input from ICM only.
Unknown (Default)
More than 90%
20 - 50%
0 - 20%
icm__building_exterior_opening (choices†)
ICM Building Exterior Opening: Input from ICM only.
Unknown (Default)
Less than 50%
More than 50%
icm__chimney (choices†)
ICM Chimney: Input from ICM only.
Unknown (Default)
No
Yes - Height Less Than 2 ft.
Yes - Height 2-5 ft.
Yes - Height More Than 5 ft.
icm__building_condition (choices†)
ICM Building Condition: Input from ICM only.
Unknown (Default)
Average
Good
Poor
icm__content_vulnerability (choices†)
ICM Content Vulnerability: Input from ICM only.
Unknown (Default)
Low
Moderate
High
Very High
icm__deductible_type (choices†)
ICM Deductible Type: Input from ICM only.
No Location Deductible
Deductible By Coverage
Combined - Excluding Time
Combined - Including Time
icm__equipment_bracing (choices†)
ICM Equipment Bracing: Input from ICM only.
Unknown (Default)
Well-braced
Average-braced
Unbraced
icm__exterior_doors (choices†)
ICM Exterior Doors: Input from ICM only.
Unknown (Default)
Single Width Doors
Double Width Doors
Reinforced Single Width Doors
Reinforced Double Width Doors
Sliding Doors
Reinforced Sliding Doors
icm__firewise_community_participation (choices†)
ICM Firewise Community Participation: Input from ICM only.
Unknown (Default)
No
Yes
icm__fire_sprinklers (choices†)
ICM Fire Sprinklers: Input from ICM only.
Unknown (Default)
No
Yes - Wet Pipe System
Yes - Dry Pipe System
icm__firm_compliance (choices†)
ICM Firm Compliance: Input from ICM only.
Unknown (Default)
No
Yes
icm__frame_to_foundation_connection (choices†)
ICM Foundation Connection: Input from ICM only.
Unknown (Default)
Hurricane Ties
Nails / Screws
Anchor Bolts
Gravity / Friction
Adhesive Epoxy
Structurally connected
icm__foundation_type (choices†)
ICM Foundation Type: Input from ICM only.
Unknown (Default)
Masonry Basement
Concrete Basement
Masonry Wall
Crawlspace Cripple Wall
Crawlspace Masonry
Post & Pier
Footing
Mat / Slab
Pile
No Basement
Engineered Foundation
Crawlspace - Raised
icm__glass_percentage (choices†)
ICM Glass Percentage: Input from ICM only.
Unknown (Default)
Less than 5%
5 - 20%
20 - 60%
Greater than 60%
icm__glass_type (choices†)
ICM Glass Type: Input from ICM only.
Unknown (Default)
Annealed
Tempered
Heat Strengthened
Laminated
Insulating Glass Units
icm__ibhs_fortified (choices†)
ICM IBHS Fortified: Input from ICM only.
Unknown (Default)
Fortified Home (IBHS) Bronze Option 1
Fortified Home (IBHS) Bronze Option 2
Fortified Home (IBHS) Silver Option 1
Fortified Home (IBHS) Silver Option 2
Fortified Home (IBHS) Gold Option 1
Fortified Home (IBHS) Gold Option 2
Fortified for Safer Living (IBHS)
icm__internal_partition (choices†)
ICM Internal Partition: Input from ICM only.
Unknown (Default)
Wood
Gypsum Boards
Plastered Masonry
Brick
Other
icm__large_missile (choices†)
ICM Large Missile: Input from ICM only.
Unknown (Default)
No
Yes
icm__ornamentation (choices†)
ICM Ornamentation: Input from ICM only.
Unknown (Default)
None
Average
Extensive
icm__pounding (choices†)
ICM Pounding: Input from ICM only.
Unknown (Default)
0.00 - 0.25 m
0.25 - 0.50 m
0.50 - 1.00 m
1.00 - 2.00 m
Greater than 2.00 m
icm__redundancy (choices†)
ICM Redundancy: Input from ICM only.
Unknown (Default)
No
Yes
icm__retrofit (choices†)
ICM Retrofit: Input from ICM only.
Unknown (Default)
Bracing of Cripple Walls
Bracing of Parapets
Bracing of Soft-Story
Foundation Anchorage
Glass / Window Strengthening
Tilt-Up
General
icm__seal_of_approval (choices†)
ICM Seal of Approval: Input from ICM only.
Unknown (Default)
Fully Engineered Structure
Partially Engineered Structure
Minimally Engineered Structure
icm__service_equipment_protection (choices†)
ICM Service Equipment Protection: Input from ICM only.
Unknown (Default)
Protected for Flood
Unprotected for Flood
icm__building_shape (choices†)
ICM Building Shape: Input from ICM only.
Unknown (Default)
Square
Rectangle
Circular
L-Shaped
T-Shaped
U-Shaped
H-Shaped
Complex
icm__short_column (choices†)
ICM Short Column: Input from ICM only.
Unknown (Default)
No
Yes
icm__small_debris (choices†)
ICM Small Debris: Input from ICM only.
Unknown (Default)
No
Yes
icm__soft_story (choices†)
ICM Soft Story: Input from ICM only.
Unknown (Default)
No
Yes
icm__special_construction (choices†)
ICM Special Construction: Input from ICM only.
Unknown (Default)
Base Isolation
Visco-elastic Dampers
Other Energy Dissipaters
icm__structural_irregularity (choices†)
ICM Structural Irregularity: Input from ICM only.
Unknown (Default)
Vertical Offset
Non-Uniform Floor Area
Discontinuous Shear Wall
Heavy Floor
icm__tall_one_story (choices†)
ICM Tall One Story: Input from ICM only.
Unknown (Default)
0-20 ft.
20-40 ft.
40 ft. or more
icm__tank (choices†)
ICM Tank: Input from ICM only.
Unknown (Default)
No
Yes
icm__terrain_roughness (choices†)
ICM Terrain Roughness: Input from ICM only.
Unknown (Default)
Large City Centers
Urban and Suburban Areas
Open Terrain with Scattered Obstruct
Flat, Unobstructed Areas
icm__torsion (choices†)
ICM Torsion: Input from ICM only.
Unknown (Default)
Symmetric
Asymmetric
Corner Building
icm__tree_exposure (choices†)
ICM Tree Exposure: Input from ICM only.
Unknown (Default)
No Trees
Low Tree Risk
High Tree Risk
icm__wall_attached_structure (choices†)
ICM Wall Attached Structure: Input from ICM only.
Unknown (Default)
Carports / Canopies / Porches
Single Door Garages
Double Door Garages
Reinforced Single Door Garages
Reinforced Double Door Garages
Screened Porches / Glass Patio Doors
Balcony
No Wall Attached Structures
icm__wall_siding (choices†)
ICM Wall Siding: Input from ICM only. Available integrations: LB wall_siding, TF wall_siding.
Unknown (Default)
Veneer Brick/Masonry
Wood Shingles
Clapboards
Aluminum / Vinyl Siding
Stone Panels
Exterior Insulation Finishing System (EIFS)
Stucco
icm__wall_type (choices†)
ICM Wall Type: Input from ICM only. Available integrations: LB wall_type, TF wall_type.
Unknown (Default)
Brick / Unreinforced Masonry
Reinforced Masonry
Plywood
Wood Planks
Particle Board / OSB
Metal Panels
Pre-cast Concrete Elements
Cast-in-place Concrete
Gypsum Board
icm__water_heater (choices†)
ICM Water Heater: Input from ICM only.
Unknown (Default)
Braced
Unbraced
icm__wet_flood_proofing (choices†)
ICM Wet Flood Proofing: Input from ICM only.
Unknown (Default)
Unprotected
Low Protection, wet floodproofed by 1 ft.
Medium Protection, wet floodproofed by 3 ft.
High Protection, wet floodproofed by over 3 ft.
icm__wind_tier (text†)
ICM Wind Tier: Input from ICM only.
icm__window_protection (choices†)
ICM Window Protection: Input from ICM only.
Unknown (Default)
No Protection
Non-Engineered Shutters
Engineered Shutters
rms__areaunit (choices†)
RMS Area Unit
2: sqft
4: sqm
rms__eq_sl_coverage (choices†)
RMS Earthquake Sprinkler Leakage Coverage Flag: This is the EQSL coverage flag. If the flag is set to No (default) no EQSL coverage is provided to the location and no EQSL loss will be calculated at the particular location.
0: No
1: Yes
rms__eq_shape_configuration (choices†)
RMS EQ Shape Configuration: Configurations can be regular (square, rectangular, circular) or irregular (L-shape, T-shape, triangular). Irregular buildings tend to twist in addition to shaking laterally. Damage often occurs at the corners between different wings of a building.
rms__eq_cladding_type (choices†)
RMS EQ Cladding Type
0: Unknown
1: Glass
2: Precast Concrete
3: Unreinforced Masonry
rms__eq_bldg_exterior (choices†)
RMS EQ Building Exterior: For shear wall buildings, the 50% rule refers to the area of a building’s exterior wall surface that consists of window and door openings. Buildings with more than 50% of the wall open are evaluated as having less seismic resistance.
0: Unknown
1: Less than 50% Wall Open
2: More than 50% Wall Open
rms__eq_short_column (choices†)
RMS EQ Short Column
0: Unknown
1: No
2: Yes
rms__eq_urm_chimney (choices†)
RMS EQ URM Chimney
0: Unknown
1: No
2: Yes
rms__eq_urm_partition (choices†)
RMS EQ URM Partition: Secondary modifier that indicates whether unreinforced masonry (brick or hollow clay tile) walls/partitions are present. Unreinforced masonry walls and partitions can have a significant impact on a building’s damageability. Their collapse can contribute significantly to the overall structural damage. In seismic zone 4 in California, they are not allowed in post-1934 construction.
rms__eq_anchoring (choices†)
RMS EQ Anchoring: In older tilt-up structures, connections between the tilt-up walls and the roof framing system were designed inadequately for earthquake resistance. The failure of these connections can be prevented by the addition of special anchors.
0: Unknown
1: Properly Anchored
2: Not Properly Anchored
rms__eq_urm_retrofit (choices†)
RMS EQ URM Retrofit: Several jurisdictions in California U.S.G.S. seismic zone 4 have instituted mandatory seismic retrofit programs for unreinforced masonry buildings.
rms__eq_base_isolation (choices†)
RMS EQ Base Isolation
0: Unknown
1: No
2: Yes
rms__eq_content_grade (choices†)
RMS EQ Content Grade: This field is a rating of the fragility of the contents and is relevant for earthquake due to the nature of the hazard (e.g., potential for building collapse). It is based on the ISO Contents Rate Grade.
0: Unknown damageable
1: Highly damageable (e.g., glassware, fine art)
2: Moderately damageable (e.g., computers)
3: Damageable (e.g, general office furniture)
4: Slightly damageable (e.g., rugs, tires)
rms__eq__equipment_support_maintenance (choices†)
0: Unknown
1: No Signs of Fatigue / Good Maintenance
2: Few Signs of Fatigue / Avg. Maintenance
3: Obvious Fatigue / Poor Maintenance
rms__eq_redundancy (choices†)
RMS EQ Redundancy: Redundancy refers to having multiple lateral load resisting elements (frames or shear walls) in a building. Redundancy is a desirable feature because of one structural system fails during an earthquake, another system is present to resist the lateral earthquake forces, thus avoiding catastrophic collapse.
0: Unknown
1: Some redundancy
2: Little or no redundancy
rms__eq_tank (choices†)
RMS EQ Tank: Rooftop tanks on adjoining, higher buildings are a falling hazard during an earthquake.
0: Unknown
1: No
2: Yes
rms__eq_torsion (choices†)
RMS EQ Torsion: The geometry of the lateral load resisting system. Asymmetry can aggravate damage by inducing twisting, torsion, and differential motion in the building. Some of the most common occurrences of asymmetry are in frame buildings with a stiff elevator core that is placed asymmetrically.
0: Unknown
1: No
2: Yes
rms__flood_protection (choices†)
RMS Flood Protection: Damage due to flood can be reduced if flood protection or proofing measures are implemented.
0: Unknown
1: FloodProt1
2: FloodProt2
3: FloodProt3
4: FloodProt4
5: FloodProt5
6: FloodProt6
7: FloodProt7
rms__flood_missile (choices†)
RMS Flood Missile: Buildings may receive damage from exposure to flood- carried missiles such as uprooted trees, branches, and sand.
0: Unknown
1: No potential flood-driven missiles
2: Flood-carried missiles, unknown size (the location is close to a wooded area or a beach where potential flood-driven missiles are present)
3: Flood-carried missiles, small size (for Europe flood only)
4: Flood-carried missiles, large size (for Europe flood only)
5: Flood-carried pollution (oil, etc.) (for Europe flood only)
rms__ws_design_code (choices†)
RMS WS Design Code: The design/building code that is adopted is a good indication of the quality of design and whether the structure has been designed to withstand wind loads.
1: Highly damageable (e.g., unprotected contents made of materials that are highly susceptible to wind and/or water damage (such as paper-based products), or extended power outages (such as contents that require refrigeration)
2: Moderately damageable (e.g., computers)
3: Damageable (e.g., general office furniture)
4: Slightly damageable (e.g., highly protected contents, such as jewelry and fine art, or contents composed of water tolerant material such as stone or rubber
rms__ws_flashing_coping_quality (choices†)
RMS WS Flashing and Coping Quality
2: Small airborne missiles, e.g., gravel, foliage (structure is within 100 ft. of missiles)
3: Protective foliage
4: Gravel ballast present
5: Potential severe missile exposure (trees within striking distance of structure)
6: Isolated large trees
rms__ws_floor_type (choices†)
RMS WS Floor Type: For flood analyses, RiskLink uses these modifiers for Germany flood locations only. For flood peril in other countries, these fields are used for informational purposes only.
0: Unknown
1: Wood
2: Masonry/RC floor
rms__ws_resistance_doors (choices†)
RMS WS Resistance Doors: Doors with poor wind resistance can expose interior building components and contents to more wind and water hazards than openings with good wind resistance.
0: Unknown
1: Designed for wind pressure and impact resistance
2: Designed for wind pressure only
3: Not designed for wind protection (e.g. flexible doors, thin doors, doors poorly attached to frame)
4: No Door (TO Only)
rms__ws_roof_framing_type (choices†)
RMS WS Roof Framing Type: The type of framing material for the roof affects the ability of the roof to stay attached to a building under high wind conditions.
0: Unknown
1: Poured/Cast-in-place concrete
2: Precast concrete
3: Heavy steel frames
4: Light gauge steel purlin
5: Wood purlin
rms__ws_content_vulnerability (choices†)
RMS WS Content Vulnerability: These levels are functions of the quantity of contents that are susceptible to wind-damage.
0: Unknown
1: Low (the structure contains few contents damageable by wind, e.g., sturdy, heavy, or bolted components)
2: Average (the structure contains a typical amount of contents damageable by wind, e.g., residential units)
3: High (the structure contains an inordinate amount of contents susceptible to be spoiled by high winds, e.g., retail china/crystal shops)
4: Very high (the structure contents will almost always be damaged by wind)
rms__ws_content_vulnerability_flood (choices†)
RMS WS Content Vulnerability Due to Water: These levels are functions of the quantity of contents that are susceptible to water damage.
0: Unknown
1: Low (the structure contains few contents damageable by water)
2: Average (the structure contains a typical amount of contents damageable by water, e.g., residential units)
3: High (the structure contains an inordinate amount of contents susceptible to be spoiled by water, e.g., perishable foodstuffs in restaurants, grocery stores)
4: Very high (the structure contents will almost always be damaged by water)
