20 Policy Assets Tables

Hazard Risk Level Dimension

Stores code details of the Hazard Risk Level.
Sample values: 1, 2, 3, and 4.

Hazard Risk Override Type Dimension

Stores code details of the Hazard Grade Override. This is a shorthand representation of the risk average degree assigned by a Rater or Underwriter to the standard Hazard Grade Code.
Sample values: degree1, degree2, and degree3.

Policy Asset Sub Type Dimension

Stores details of the asset subtype of a policy.
Sample values: AerationFan, AerBinHeaters, AerDuctwork, BalerSquare, and so on.

Policy Asset Valuation Type Dimension

Stores details of the code that identifies the method used to determine the policy asset value. This table uses the ValuationMethod code list.
Sample values: Appraisal, CompSale, and SaleRec.

Policy Covered Asset Dimension

Stores details of the assets covered in the policy.

Policy Asset Type Dimension

Stores details of the type of asset covered in the policy. The types of policy assets are Real Estate, Equipment, Automobiles, and so on. The type under the movable category includes automobiles, and so on. The type under the immovable category includes real estate, equipment, and so on.

Risk Qualifier Type Dimension

Stores details of the risk qualifier type that is either applicable or not for the insurance.
Sample values: APT, AR, BB, CNT, DP, ED, MT, and so on.

801

STG_HAZARD_RISK_LEVEL_MASTER

Stage Hazard Risk Level Master

DIM_HAZARD_RISK_LEVEL

Hazard Risk Level Dimension

802

STG_HAZ_RISK_OVRDE_TYPE_MASTER

Stage Hazard Risk Override Type Master

DIM_HAZ_RISK_OVRDE_TYPE

Hazard Risk Override Type Dimension

807

STG_POL_ASSET_SUB_TYPE_MASTER

Stage Policy Asset Sub Type Master

DIM_POL_ASSET_SUB_TYPE

Policy Asset Sub Type Dimension

808

STG_POL_ASSET_VAL_TYPE_MASTER

Stage Policy Asset Valuation Type Master

DIM_POL_ASSET_VAL_TYPE

Policy Asset Valuation Type Dimension

809

STG_POL_COV_ASSET_MASTER

Stage Policy Covered Asset Master

DIM_POL_COV_ASSET

Policy Covered Asset Dimension

810

STG_POLICY_ASSET_TYPE_MASTER

Stage Policy Asset Type Master

DIM_POLICY_ASSET_TYPE

Policy Asset Type Dimension

811

STG_RISK_QUALIFIER_TYPE_MASTER

Stage Risk Qualifier Type Master

DIM_RISK_QUALIFIER_TYPE

Risk Qualifier Type Dimension

T2T_FCT_POL_COV_ASSET_DTLS

Stores details of the assets covered in the policy.

T2T_FCT_POLICY_COV_ASSET_MAP

Stores the mapping identification information between the policy and the covered asset.

STG_POL_COV_ASSET_DTLS

Stage Policy Covered Asset Details

FCT_POL_COV_ASSET_DTLS

Fact Policy Covered Asset Details

T2T_FCT_POL_COV_ASSET_DTLS

STG_POLICY_COV_ASSET_MAP

Stage Policy Coverage Asset Map

FCT_POLICY_COV_ASSET_MAP

Fact Policy Coverage Asset Map

T2T_FCT_POLICY_COV_ASSET_MAP

Alarm Coverage Extent Dimension

This table stores information about the extent of the alarm coverage such as all floors, above-grade floors, all openings protected, complete safe vault, and so on. The sample values are AF, AG, AOP, CSV, FCP, FCW, PR1 System Premises Protection Grade 1, PSV, and so on.

Alarm Type Dimension

This table stores the type of alarm information such as 24-hour security, boarded, central station, the central station with keys, fenced, locked, limited mercantile with no guard response, fire, smoke, and so on. The sample values are 24H, BD, CE, CEK, FEN, LOC, LOK, CM, FIRE, HEAT, SMOKE, and so on.

Animal Family Dimension

This table stores information about animal families such as cats, dogs, cattle, horses, and so on.

Building Exposure Dimension

This table stores information about the exposure section of the building such as above, above roof, diagonal, East, front, and so on. The sample values are Ab, AbRoof, Bel, Diag, E, N, NE, and so on.

Animal Breed Dimension

This table stores information about the breed category that the animal belongs to among the cats, dogs, and so on.

Brush Fire Zone Dimension

This table stores the information about the brush fire zones as defined by the state or the insurer manuals.

Bullet Resistant Enclosure Dimension

This table stores information about the bullet-resistant enclosures such as bullet resisting enclosure and alarm system, bullet resisting enclosure, cage, and mantrap. The sample values are BA, BR, Cage, and Trap.

Chimney Lining Dimension

This table stores information about the chimney lining such as flue tile clay, stainless steel, and so on. The sample values are Flue, NONE, OT, and Stainless Steel.

Chimney Pipe Vent Style Dimension

This table stores information about the chimney pipe vent style such as a catalytic converter, circulating fan, heat extractor, heat reclaimer, and waste heat collector circulator. The sample values are CatConverter, CircFan, HeatExtr, HeatRecl, OT, and WHeatCollCirc.

Class Specific Rated Dimension

This table stores the class-specific rated information such as class rated, special rated, and specifically rated. The sample values are CLR, P, and S.

Clearance From Objects Dimension

This table stores information about the clearance from things such as heating units and pipes. The sample values are HU, Oth, and P.

Clearance To Objects Dimension

This table stores information about the clearance to objects such as ceiling, the outer edge of openings, floor, left wall, combustibles such as furniture, drapes, wood storage, and so on. The sample values are Ceil, Combust, Edge, Flr, Front, Left, Oth, Rear, Right, Side, and W.

Construction Type Dimension

This table stores the construction material type information such as aluminum, asbestos, asphalt, concrete block, block painted, brick, solid brownstone, cast iron, and so on. The sample values are Alu, ASB, Asp, BlkPnt, Brick, BrkCom, BrStone, CastIr, and so on.

Crime Index Dimension

This table stores the crime index information supplied by a crime indexing service documenting the relative potential risk for the address.

Door Lock Dimension

This table stores information about the protective device door locks such as double cylinder, deadbolt, spring, and so on. The sample values are DBLCL, DEADB, SPRNG, and so on.

Electrical Protection Dimension

This table stores the electrical protection device information such as lightning arrestor, lightning rod, and surge arrestor. The sample values are LArrest, LRod, and SurgeArrest.

Elevation Basis Dimension

This table stores information about the basis for determining elevation such as construction drawings, finished construction, and buildings under construction. The sample values are DRAW, FIN, and UND.

Elevation Datum Dimension

This table stores information about the basis for determining the elevation datum such as the North American Vertical Datum of 1988, National Geodetic Vertical Datum of 1929, and so on. The sample values are NAVD, NGVD, and OTH.

Enclosure Usage Dimension

This table stores the enclosure usage information such as access, parking, parking storage access, storage, and so on. The sample values are ACCES, OT, PARKG, PSA, and STRAG.

Enclosure Wall Dimension

This table stores information about the enclosure wall type such as breakaway, insect screening, lattice, masonry breakaway, solid perimeter wall, and so on. The sample values are BKAWY, INSCR, LATTC, MSNBY, SLDPW, and so on.

Equipment Storage Dimension

This table stores the details of the area where the equipment is stored such as the basement, below-elevated level, garage. The sample values are Base, Below, and Gar.

Fire Extinguisher System Dimension

This table stores information about the fire extinguisher system such as dry and wet mixed systems, dry, wet, and so on. The sample values are B, D, N, O, and W.

Fire Place Type Dimension

This table stores the fireplace type information such as embedded, gas hook up with logs, kiva, marble fireplace surround, masonry, and so on. The sample values are Emb, GH, Kiva, MarbSurrnd, Multiface, MY, ZC, and so on.

Flood Source Dimension

This table stores the flood source information such as lake, ocean, river, stream, and so on. The sample values are L, O, R, S, and Z.

Foundation Type Dimension

This table stores information about the mobile home foundation types such as continuous masonry, basement, crawl space, hillside foundation, pilings, parallel shear walls, walkout basement, and so on. The sample values are M, O, BS, Co, Cr, FinBas, HillFnd, Pilings, Walkout, and so on.

Fuel Type Dimension

This table stores the fuel type information such as alcohol, battery, butane, propane, coal, electric, ethanol, gas, kerosene, and so on. The sample values are A, BT, Bu, Pro, Co, Elec, Eth, G, K, and so on.

Heating Unit Type Dimension

This table stores the heating unit information such as acorn stove, barrel type, box stove, central heating, fireplace, fireplace with doors, forced air furnace, solid masonry, and so on. The sample values are Acorn, Barrel, Box, CEN, Fireplc, ForceAirFurn, Solid Masonry, and so on.

Home Owner Credit Rating Dimension

This table stores the credit rating information of the homeowners. The sample values are LIGHT, MANSE, NSMKR, OPTE, and OTHER.

Building Hydrant Type Dimension

This table stores information about the hydrant types in the dwelling vicinity. The sample values are N, NSTD, and STD.

Building Indoor Outdoor Location Type Dimension

This table stores the building indoor and outdoor type information such as combination indoor and outdoor, indoor, and outdoor. The sample values are CombiIndOut, Ind, and Out.

Item Type Dimension

This table stores information about the items in the dwelling place such as antenna, boat equipment, combination lock, electronic data processing equipment, fire receptacle, heating unit, motor, portable accessories, safe, watercraft, and so on. The sample values are Ant, BE, CombiLock, Crane, FireRecep, HU, W, and so on.

Mobile Home Anchoring System Dimension

This table stores the mobile home anchoring system information such as frame connectors, frame ties, ground anchors, and so on. The sample values are FConnectors, FTies, Ganchors, OT, OTT Ties, and Sand.

Mobile Home Installation Standard Dimension

This table stores information about the mobile home installation standards such as local floodplain management standards, manufacturer's specifications, and state and (or) local building standards. The sample values are LF, MS, and SS.

Mobile Home Tie Down Dimension

This table stores the mobile home tie down information such as chassis, over the top, and so on. The tie-down refers to the mobile home secured to the land or water bed underneath to prevent it from being swept away. The sample values are C, None, O, F, and Y.

Mobile Home Anchor Dimension

This table stores the mobile home tie-down anchor information such as concrete slab, drive anchors, hard rock, and so on. An anchor is an object to which the mobile home is secured to prevent it from being swept away. The sample values are CS, DA, HR, OT, and SC.

Mobile Home Tie Down Straps Dimension

This table stores the mobile home tie-down straps information such as 12 steel, 14 steel, Cables, Straps, and so on. The straps here are the rope cables used to connect the mobile home to the anchor. The sample values are C2, C4, CA, OT, S2, and so on.

Mine Subsidence Response Dimension

This table stores the mine subsidence response type information. The sample values are NNOOPT, No, NOTANS, UNKN, YEND, YNOOPT, and YSPP.

Building Miscellaneous Place Dimension

This table stores the location information of the oil storage tank, hydrant municipality, neighborhood description, and cooking facilities in a mobile home such as rural protected, commercial, fire district, indoors completely above ground on a masonry floor, middle, and so on. The sample values are B, CM, FD, IAM, MI, and so on.

Dwell Occupancy Vacancy Dimension

This table stores the dwelling occupancy and vacancy information such as Estate Settlement, Foreclosure, For Sale or Lease, Structure Damaged, Under Renovation, Unoccupied, and so on. The sample values are EstateSettlement, Foreclosure, ForSaleLease, StructureDamaged, UnderRenovation, Unoccupied, UnoccupiedDuringFirst30Days, and so on.

Building Owner Landlord And Tenant Territory Dimension

This table stores the owner, landlord, and tenant (OLT) territory information defined by the user. The OLT is a liability insurance coverage form designed for those businesses where liability loss exposure (other than automobile and workers compensation) derives principally from the business premises.

Building Plumbing Type Dimension

This table stores the building plumbing material type information such as cast iron, copper, and PVC. The sample values are CI, COP, and P.

Roof Plumbing And Housekeeping Maintenance Condition Dimension

This table stores the housekeeping, plumbing, and roof condition type information such as average, below average, excellent, and good. The sample values are AV, BAVE, E, and GD.

Heat Unit Placement Dimension

This table stores the heating unit placement information such as the attached garage, basement, detached garage, exterior, main living area, main floor, workshop, and so on. The sample values are AttGar, Base, DetacGar, Ext, Main, MainFlr, Oth, and Work.

Pool Construction Dimension

This table stores information about the material type used in the pool construction such as fiberglass, reinforced concrete, and vinyl liner. The sample values are F, RCC, and VL.

Protection Class Dimension

This table stores information about the protection classes defined by the state or insurer manuals.

Protective Device Dimension

This table stores information about protective devices in the building such as (or designed for protection from) both local and central, battery, burglar, central station with keys, central, fire, humidity, police connection, standpipes, and temperature. The sample values are BLC, BT, BU, CEK, CN, FIRE, HM, PC, STANDPIPES, and TM.

Building Roof Attachment Dimension

This table stores information about the building roof attachment type such as adhesive epoxy, mortar, nail, screw, staple, structurally connected, double wraps, gravity friction, and so on. The sample values are ADHESIVE, MORTAR, NAIL, SCREW, STAPLE, UN, STRUCTURE, WRAPD, and Gravity.

Roof Geometry Shape Dimension

This table stores information about the roof geometry shape, which can be defined by the user.

Rural Fire Protection District Dimension

This table stores the rural fire protection district information such as first-rate water supply and second-rate water supply.

Seen By Dimension

This table stores information about the property seen by roles such as caretaker, manager, owner, realtor, security, and so on. The sample values are CARE, MGR, OT, OWN, REAL, and SEC.

Shoreline Distance Dimension

This table stores the nearest shoreline distance information from the site location such as less than 200 feet, 200 feet to 500 feet, 500 feet to 1000 feet, greater than 1000 feet. The sample values are A, B, C, and D.

Storage Tank Content Dimension

This table stores information about the storage tank contents such as ammonia, anhydrous ammonia, dairy milk, diesel, pesticide, water, and so on. The sample values are Ammonia, AnhyAmmonia, Dairy, Diesel, Pesticide Pesticide, Water, and so on.

Stored Equipment Dimension

This table stores information about the stored equipment such as air conditioner, cistern, elevator equipment, food freezer, fuel tank, and so on. The sample values are AC, CT, EE, FF, FT, and so on.

Stove Type Dimension

This table stores information about the heating unit stove type like circulating, radiant, and so on. The sample values are C, OT, and R.

Structure Condition Dimension

This table stores the structure condition information such as broken, excellent, fair, contains gaps, good, new, poor, and so on. The sample values are Broken, Excellent, Fair, Gaps, Good, and so on.

Building Structure Type Dimension

This table stores the building structure type information such as agricultural building, airplane hangar, barn or outbuilding, dairy barn, machine shed, main house building, pool house, and so on. The sample values are AgricBuilding, AirplaneHanger, BarnOutbuilding, MachineShed, Main, and so on.

Building Surveillance Dimension

This table stores the building surveillance type information such as Closed-Circuit TV, Security Patrol, and Video. The sample values are CCTV, SecPatrol, and Video.

Insurer Territory Code Dimension

This table stores the Insurer territory information, which can be defined by the user. These codes are different from location codes.

Thimble Pass Layer Dimension

This table stores information about the things the thimble passes through such as the ceiling and wall. The sample values are Ceil and W.

Asset Usage Dimension

This table stores the asset usage type information such as add on, commercial, occasional, personal, and so on. The sample values are AO, Comm, Occ, Prim, and so on.

Watch Person Factor Dimension

This table stores the watch person factor information such as central station signals every 2 hours, central station signals every 3 hours, central station hourly registration, and so on. The sample values are C2, C3, CH, and so on.

Water Quantity Dimension

This table stores the water supply quantity information such as 1000 to 3000 gallons, over 3000 gallons, and less than 1000 gallons. The sample values are 1000To3000, Over3000, and Under1000.

Water Source Dimension

This table stores the water source information such as hydrant, lake, swimming pool, tanker, and so on. The sample values are H, L, OT, P, PL, S, T, and W.

Waterbody Proximity Dimension

This table stores the water body proximity information such as the outside, seaward side of an ocean water barrier, inland, seacoast, tidal water, and unprotected island. The sample values are BCH, C, I, S, TidalWater, and U.

Wind Class Dimension

This table stores the wind class information such as Semi Wind Resistive, Wind Resistive, and so on. The sample values are OT, SWR, and WR.

Building Wiring Type Dimension

This table stores information about the wiring material type used in building such as copper, cloth, knob, and tube. Certain types of wiring are more prone to fire and shock. Therefore, the wiring type is an underwriting consideration. In rare circumstances, such as in the case of old homes, the wiring type changes.

Working Utilities Dimension

This table stores the working utility information such as electricity, gas, water, and so on. The sample values are Electric, Gas, OT, and Water.

Flood Zone Dimension

The table stores information about the flood zone, where the property is located. The source of this code list is the Flood Insurance Rate Map. The benefits of the National Flood Insurance Program are limited to the communities that participate in the program.

Flood Community Rate Class Dimension

This table stores the flood community rate class information used to determine the rates. The source of this code list is the Federal Emergency Management Agency (FEMA) or any other supporting federal agency. The benefits of the National Flood Insurance Program are limited to the communities that participate in the program.

Flood Community Information Source Dimension

This table stores the flood community information source details such as community official, flood map, mortgagee, and so on. The benefits of the National Flood Insurance Program are limited to communities that participate in the program. The sample values are COMMO, FLMAP, MORTG, and OT.

Flood Community Program Dimension

This table stores the information that identifies the community program type such as emergency and regular. The benefits of the National Flood Insurance Program are limited to the communities that participate in the program. The sample values are E and R.

Flood Rating Dimension

This table stores details regarding whether the flood community information is used for the policy rating, or whether the data represents more current National Flood Insurance Program (NFIP) information in a grandfathering situation that is not used for the policy rating.
"Current" means the information in the aggregate is not used for the policy rating. In a grandfathering situation, this is the current NFIP data.
"Rating" means the information in the aggregate is used for the policy rating. This may be the grandfathered data.

Material Type Dimension

This table stores the information about the construction material type used in the chimney, roof, roof deck and the protective material type used in the heating unit, and pipes such as stone, cement, brick-lined with fireproof tiles, concrete, wood planks, reinforced concrete slab, asbestos, Fiberglass, Copper, and so on. The sample values are Stone, Cement, BrickLineWTiles, CBL, Concrete, Fct2WallChimIns, Masonry Brick, and so on.

877

STG_ALARM_COV_EXTENT_MASTER

Stage Alarm Coverage Extent Master

DIM_ALARM_COV_EXTENT

Alarm Coverage Extent Dimension

878

STG_ALARM_TYPE_MASTER

Stage Alarm Type Master

DIM_ALARM_TYPE

Alarm Type Dimension

879

STG_ANIMAL_FAMILY_MASTER

Stage Animal Family Master

DIM_ANIMAL_FAMILY

Animal Family Dimension

881

STG_BLDG_EXPOSURE_MASTER

Stage Building Exposure Master

DIM_BLDG_EXPOSURE

Building Exposure Dimension

882

STG_BREED_MASTER

Stage Animal Breed Master

DIM_BREED

Animal Breed Dimension

883

STG_BRUSH_FIRE_ZONE_MASTER

Stage Brush Fire Zone Master

DIM_BRUSH_FIRE_ZONE

Brush Fire Zone Dimension

884

STG_BULLET_RESIST_ENCL_MASTER

Stage Bullet Resistant Enclosure Master

DIM_BULLET_RESIST_ENCL

Bullet Resistant Enclosure Dimension

885

STG_CHIMNEY_LINING_MASTER

Stage Chimney Lining Master

DIM_CHIMNEY_LINING

Chimney Lining Dimension

886

STG_CHIMNEY_PPVN_STYLE_MASTER

Stage Chimney Pipe Vent Style Master

DIM_CHIMNEY_PPVN_STYLE

Chimney Pipe Vent Style Dimension

887

STG_CLASS_SPECIFIC_RTD_MASTER

Stage Class Specific Rated Master

DIM_CLASS_SPECIFIC_RTD

Class Specific Rated Dimension

888

STG_CLEARANCE_FROM_OBJ_MASTER

Stage Clearance From Objects Master

DIM_CLEARANCE_FROM_OBJ

Clearance From Objects Dimension

889

STG_CLEARANCE_TO_OBJ_MASTER

Stage Clearance To Objects Master

DIM_CLEARANCE_TO_OBJ

Clearance To Objects Dimension

890

STG_CONSTRUCTION_TYPE_MASTER

Stage Construction Type Master

DIM_CONSTRUCTION_TYPE

Construction Type Dimension

875

STG_CRIME_INDEX_MASTER

Stage Crime Index Master

DIM_CRIME_INDEX

Crime Index Dimension

892

STG_DOOR_LOCK_MASTER

Stage Door Lock Master

DIM_DOOR_LOCK

Door Lock Dimension

893

STG_ELECTRICAL_PROT_MASTER

Stage Electrical Protection Master

DIM_ELECTRICAL_PROT

Electrical Protection Dimension

894

STG_ELEVATION_BASIS_MASTER

Stage Elevation Basis Master

DIM_ELEVATION_BASIS

Elevation Basis Dimension

895

STG_ELEVATION_DATUM_MASTER

Stage Elevation Datum Master

DIM_ELEVATION_DATUM

Elevation Datum Dimension

896

STG_ENCLOSURE_USAGE_MASTER

Stage Enclosure Usage Master

DIM_ENCLOSURE_USAGE

Enclosure Usage Dimension

897

STG_ENCLOSURE_WALL_MASTER

Stage Enclosure Wall Master

DIM_ENCLOSURE_WALL

Enclosure Wall Dimension

898

STG_EQUIPMENT_STORAGE_MASTER

Stage Equipment Storage Master

DIM_EQUIPMENT_STORAGE

Equipment Storage Dimension

899

STG_FIRE_EXTNG_SYSTEM_MASTER

Stage Fire Extinguisher System Master

DIM_FIRE_EXTNG_SYSTEM

Fire Extinguisher System Dimension

900

STG_FIREPLACE_TYPE_MASTER

Stage Fire Place Type Master

DIM_FIREPLACE_TYPE

Fire Place Type Dimension

891

STG_FLOOD_SOURCE_MASTER

Stage Flood Source Master

DIM_FLOOD_SOURCE

Flood Source Dimension

901

STG_FOUNDATION_TYPE_MASTER

Stage Foundation Type Master

DIM_FOUNDATION_TYPE

Foundation Type Dimension

876

STG_FUEL_TYPE_MASTER

Stage Fuel Type Master

DIM_FUEL_TYPE

Fuel Type Dimension

902

STG_HEATING_UNIT_TYPE_MASTER

Stage Heating Unit Type Master

DIM_HEATING_UNIT_TYPE

Heating Unit Type Dimension

903

STG_HOMOWNR_CRED_RATING_MASTER

Stage Home Owner Credit Rating Master

DIM_HOMOWNR_CRED_RATING

Home Owner Credit Rating Dimension

904

STG_BLDG_HYDRANT_TYPE_MASTER

Stage Building Hydrant Type Master

DIM_BLDG_HYDRANT_TYPE

Building Hydrant Type Dimension

905

STG_BLDG_INOUTDOOR_TYPE_MASTER

Stage Building Indoor Outdoor Location Type Master

DIM_BLDG_INOUTDOOR_TYPE

Building Indoor Outdoor Location Type Dimension

907

STG_ITEM_TYPE_MASTER

Stage Item Type Master

DIM_ITEM_TYPE

Item Type Dimension

909

STG_MH_ANCHORING_SYSTEM_MASTER

Stage Mobile Home Anchoring System Master

DIM_MH_ANCHORING_SYSTEM

Mobile Home Anchoring System Dimension

910

STG_MH_INSTALLATION_STD_MASTER

Stage Mobile Home Installation Standard Master

DIM_MH_INSTALLATION_STD

Mobile Home Installation Standard Dimension

911

STG_MH_TIE_DOWN_ANCHOR_MASTER

Stage Mobile Home Tie Down Anchor Master

DIM_MH_TIE_DOWN

Mobile Home Tie Down Dimension

912

STG_MH_TIE_DOWN_MASTER

Stage Mobile Home Tie Master

DIM_MH_TIE_DOWN_ANCHOR

Mobile Home Anchor Dimension

913

STG_MH_TIE_DOWN_STRAPS_MASTER

Stage Mobile Home Tie Down Straps Master

DIM_MH_TIE_DOWN_STRAPS

Mobile Home Tie Down Straps Dimension

914

STG_MINE_SUBSIDE_RESP_MASTER

Stage Mine Subsidence Response Master

DIM_MINE_SUBSIDE_RESP

Mine Subsidence Response Dimension

915

STG_BLDG_MISC_PLACE_MASTER

Stage Building Miscellaneous Place Master

DIM_BLDG_MISC_PLACE

Building Miscellaneous Place Dimension

916

STG_DWELL_OCCUP_VACANCY_MASTER

Stage Dwell Occupancy Vacancy Master

DIM_DWELL_OCCUP_VACANCY

Dwell Occupancy Vacancy Dimension

917

STG_BLDG_OLT_TERRITORY_MASTER

Stage Building Owner Landlord Territory Master

DIM_BLDG_OLT_TERRITORY

Building Owner Landlord And Tenant Territory Dimension

919

STG_BLDG_PLUMBING_TYPE_MASTER

Stage Building Plumbing Type Master

DIM_BLDG_PLUMBING_TYPE

Building Plumbing Type Dimension

908

STG_MAINTENANCE_COND_MASTER

Stage Maintenance Condition Master

DIM_MAINTENANCE_COND

Roof Plumbing And Housekeeping Maintenance Condition Dimension

918

STG_HEAT_UNIT_PLACEMENT_MASTER

Stage Heat Unit Placement Master

DIM_HEAT_UNIT_PLACEMENT

Heat Unit Placement Dimension

920

STG_POOL_CONSTRUCT_TYPE_MASTER

Stage Pool Construction Master

DIM_POOL_CONSTRUCT_TYPE

Pool Construction Dimension

921

STG_PROTECTION_CLASS_MASTER

Stage Protection Class Master

DIM_PROTECTION_CLASS

Protection Class Dimension

922

STG_PROTECTIVE_DEVICE_MASTER

Stage Protection Device Master

DIM_PROTECTIVE_DEVICE

Protective Device Dimension

923

STG_BLDG_ROOF_ATTCHMNT_MASTER

Stage Building Roof Attachment Master

DIM_BLDG_ROOF_ATTCHMNT

Building Roof Attachment Dimension

924

STG_ROOF_GEOMETRY_SHAPE_MASTER

Stage Roof Geometry Shape Master

DIM_ROOF_GEOMETRY_SHAPE

Roof Geometry Shape Dimension

925

STG_RURL_FIRE_PROT_DIST_MASTER

Stage Rural Fire Protection District Master

DIM_RURL_FIRE_PROT_DIST

Rural Fire Protection District Dimension

926

STG_SEEN_BY_ROLE_MASTER

Stage Seen By Master

DIM_SEEN_BY_ROLE

Seen By Dimension

927

STG_SHORELINE_DIST_MASTER

Stage Shoreline Distance

DIM_SHORELINE_DIST

Shoreline Distance Dimension

928

STG_STORE_TANK_CONTENT_MASTER

Stage Storage Tank Content Master

DIM_STORE_TANK_CONTENT

Storage Tank Content Dimension

929

STG_STORED_EQUIPMENT_MASTER

Stage Stored Equipment Master

DIM_STORED_EQUIPMENT

Stored Equipment Dimension

930

STG_STOVE_TYPE_MASTER

Stage Stove Type Master

DIM_STOVE_TYPE

Stove Type Dimension

931

STG_STRUCTURE_CONDITION_MASTER

Stage Structure Condition Master

DIM_STRUCTURE_CONDITION

Structure Condition Dimension

932

STG_BLDG_STRUCTURE_TYPE_MASTER

Stage Building Structure Type Master

DIM_BLDG_STRUCTURE_TYPE

Building Structure Type Dimension

933

STG_BLDG_SURVEILLANCE_MASTER

Stage Building Surveillance Master

DIM_BLDG_SURVEILLANCE

Building Surveillance Dimension

906

STG_INSURER_TERRITRY_CD_MASTER

Stage Insurer Territory Code Master

DIM_INSURER_TERRITRY_CD

Insurer Territory Code Dimension

934

STG_THIMBLE_PASS_LAYER_MASTER

Stage Thimble Pass Layer Master

DIM_THIMBLE_PASS_LAYER

Thimble Pass Layer Dimension

880

STG_ASSET_USAGE_MASTER

Stage Asset Usage Master

DIM_ASSET_USAGE

Asset Usage Dimension

935

STG_WATCH_PERSON_FACTOR_MASTER

Stage Watch Persons Factor Master

DIM_WATCH_PERSON_FACTOR

Watch Person Factor Dimension

936

STG_WATER_QUANTITY_MASTER

Stage Water Quantity Master

DIM_WATER_QUANTITY

Water Quantity Dimension

937

STG_WATER_SOURCE_MASTER

Stage Water Source Master

DIM_WATER_SOURCE

Water Source Dimension

938

STG_WATERBODY_PROXIMITY_MASTER

Stage Waterbody Proximity Master

DIM_WATERBODY_PROXIMITY

Waterbody Proximity Dimension

939

STG_WIND_CLASS_MASTER

Stage Wind Class Master

DIM_WIND_CLASS

Wind Class Dimension

940

STG_BLDG_WIRING_TYPE_MASTER

Stage Building Wiring Type Master

DIM_BLDG_WIRING_TYPE

Building Wiring Type Dimension

941

STG_WORKING_UTILITIES_MASTER

Stage Working Utilities Master

DIM_WORKING_UTILITIES

Working Utilities Dimension

870

STG_FLOOD_ZONE_MASTER

Stage Flood Zone Master

DIM_FLOOD_ZONE

Flood Zone Dimension

871

STG_FL_COMM_RATE_CLASS_MASTER

Stage Flood Community Rate Class Master

DIM_FL_COMM_RATE_CLASS

Flood Community Rate Class Dimension

874

STG_FL_COMM_INFO_SOURCE_MASTER

Stage Flood Community Info Source Master

DIM_FL_COMM_INFO_SOURCE

Flood Community Information Source Dimension

872

STG_FLOOD_COMM_PROGRAM_MASTER

Stage Flood Community Program Master

DIM_FLOOD_COMM_PROGRAM

Flood Community Program Dimension

873

STG_FLOOD_RATING_MASTER

Stage Flood Rating Master

DIM_FLOOD_RATING

Flood Rating Dimension

942

STG_MATERIAL_TYPE_MASTER

Stage Material Type Master

DIM_MATERIAL_TYPE

Material Type Dimension

T2T_FCT_POL_COV_ASSET_EXP_DTLS

This T2T stores information about the policy coverage asset exposures.

T2T_FCT_POL_COV_ASSET_BUS_DTLS

This T2T stores information about the policy coverage asset business.

T2T_FCT_LOC_FLOOD_CRIME_DTLS

The T2T stores the flood zone details where the property is located. The source of this code list is the Flood Insurance Rate Map. The benefits of the National Flood Insurance Program are limited to the communities that participate in the program.

STG_POL_COV_ASSET_EXP_DTLS

Stage Policy Coverage Asset Exposure Details

FCT_POL_COV_ASSET_EXP_DTLS

Fact Policy Coverage Asset Exposure Details

T2T_FCT_POL_COV_ASSET_EXP_DTLS

STG_POL_COV_ASSET_BUS_DTLS

Stage Policy Coverage Asset Business Details

FCT_POL_COV_ASSET_BUS_DTLS

Fact Policy Coverage Asset Business Details

T2T_FCT_POL_COV_ASSET_BUS_DTLS

STG_LOC_FLOOD_CRIME_DTLS

Stage Location Flood Crime Details

FCT_LOC_FLOOD_CRIME_DTLS

Fact Location Flood Crime Details

T2T_FCT_LOC_FLOOD_CRIME_DTLS

Air Conditioner Type Dimension

This table stores the air conditioner type information such as evaporative cooling, electric baseboard, forced air using heating ducts that are single zone, and so on. The sample values are EvapDuct, EvapNoDuct, FAHDSZ, and so on.

Construction Class Dimension

This table stores the construction class information such as custom luxury, designer, economy, economy standard, minimum, average standard builders’ grade, and so on. The sample values are CUSLUX, CUSTM, ECONO, and so on.

Interior Builtins Dimension

This table stores the built-in interior information such as air exchanger, air humidifier, appliance center, bathroom heater, dishwasher, and so on. The sample values are AirExch, AirHum, ApplCtr, Dishwash, and so on.

Dwell Style Dimension

This table stores the dwelling style information such as one and three-quarter stories, two and three-quarter stories, basic, basement flat, colonial, and so on. The sample values are 13Q, 23Q, BASIC, BF, Colonial, and so on.

Dwell Construction Style Dimension

This table stores the dwell construction style information such as pre-1930, pre-1940, and standard. The sample values are Pre1930, Pre1940, and Standard.

Dwell Evaluation Method Dimension

This table stores information about the dwell evaluation method codes such as standard, unit method, professional appraisal, full market value excluding land, and so on. The sample values are Standard, 1, 2, 3, F, and so on.

Dwell General Shape Dimension

This table stores the dwell general shape information such as L-shaped, rectangle box, T-shaped, very irregular, and so on. The sample values are Lshape, Rect, Slrreg, Tshape, and so on.

Building Storey Type Dimension

This table stores information about the number of stories in the building. The sample values are 1, 1H, 2, BILEVEL, and so on.

Building Detached Structure Dimension

This table stores information about the detached structure type such as awning, barbecue, boat dock, boathouse, boat shelter, cabana, deck, video door answering, and so on. The sample values are Awning, BBQ, BoatDock, CompactorVanityCus, and so on.

Garage Type Dimension

This table stores the garage type information such as built-in, basement, carport, masonry garage with living space above, and so on. The sample values are BI, BS, CP, MasonryLs, and so on.

Interior Primary Component Dimension

This table stores information about the interior component finish type such as ceiling construction, ceiling finish, floor finish, wall construction, and wall covering. The sample values are CeilingConstruction, CeilingFinish, FloorFinish, WallConstruction, and WallCovering.

Interior Primary Material Dimension

This table stores information about the material types used in the interior finishing such as ash plank, acoustical tile, concrete block, glass block, nylon carpet, wool carpet, ceramic tile, and so on. The sample values are AshPlnk, Atile, B, BlkGlass, CrvStud, and so on.

Porch Breezeway Dimension

This table stores the porch type information such as covered stoop, enclosed, screened porch, and so on. The sample values are CovStoop, E, Screen, and so on.

Substructure Type Dimension

This table stores the substructure type information such as the basement, basement below ground from all sides, crawl space, and slab. The sample values are BS, BSBG, CRSP, and S.

Inspection Report Source Dimension

This table stores information about the source of the inspection report (in the form of codes) such as agency inspection, authorized inspection company, certified appraisal, and so on. The sample values are 0, 1, 2, and so on.

Specialty Room Dimension

This table stores information about the specialty rooms in a building such as a ballroom, billiards, computer room, drawing room, grand salon parlor, and so on. The sample values are Ballrm, Billiards, Computer, Drawing, GrParlor, LgFoyer, and so on.

Building System Dimension

This table stores information about the building system such as the computer room, den, family room, and so on. The sample values are Computer, Den, Family, and so on.

Primary Siding Material Dimension

This table stores information about the primary type of siding material used such as aluminum siding, beveled wood clapboards, asbestos, board, wood siding, and so on. The siding or the wall cladding is a protective material attached to the exterior side of a wall of a house or any building. These techniques of joinery are designed to prevent water from entering the walls. The sample values are A, BevWd, BrdBat, Board, LogCed, Wshakes, and so on.

Insurer Construction Class Dimension

This table stores information about the general quality of building construction. These codes may be defined by the insurer.

Detached Structure Earthquake Suitability Dimension

This table stores information about building the ground earthquake suitability for a detached structure such as firm natural, hazardous, and intermediate hazardous. The sample values are FN, HZ, and I.

Window Bars Dimension

This table stores information about the type of window bars the building is equipped such as the type for those devices that do not provide a releasable latch for emergency exit, for those devices that provide a releasable latch allowing emergency exit, and so on. The sample values are NonRelease, Release, and so on.

Earthquake Building Class Dimension

This table stores information that identifies the degree of rigidity and flexibility to withstand the seismic waves based on the building material, floor roof material, area, and the number of stories as it relates to the earthquake, and the earthquake sprinkler leakage coverage of the building.

Earthquake Retrofit Dimension

This table stores information about the retrofitting completed on the structure related to earthquakes such as structure anchored to the foundation and cripple walls braced, structure anchored to the foundation, all retrofit conditions met, and so on. The sample values are AB, AF, AL, and so on.

Earthquake Contents Grade Dimension

This table stores the industry or company-specific information that identifies the susceptibility grade for contents in the building.

Electrical Insulation Dimension

This table stores information about the electrical insulation type for the building such as cellulose, exposed fiberboard, and so on. The sample values are Cellulose, FiberglassFoam, and so on.

Windstorm Mitigation Dimension

This table stores information about the windstorm mitigation evidence or documentation of the building such as IBHS FORTIFIED for Existing Homes - Bronze-Level 1, IBHS FORTIFIED for Existing Homes - Bronze-Level 2, IBHS FORTIFIED for Existing Homes - Gold-Level 1, and Total Hip Roof. The sample values are IBHSBronzeLevel1, IBHSBronzeLevel2, IBHSGoldLevel1, TotalHipRoof, and so on.

Building Inspection Type Dimension

This table stores the building inspection type information such as appraisal, chimney, emissions, exterior paint, heating unit, replacement cost calculator or an equivalent worksheet, and so on. The sample values are Appraisal, Chimney, Emissions, ExteriorPaint, HeatingUnit, and so on.

Flood Waiting Period Dimension

This table stores information about the flood waiting period such as Lender Required No Waiting, map revision zone change from non-SPHA to SPHA - One Day, standard 30-day waiting period, Transfer - No Waiting, and so on. The sample values are LN0, LR0, MR1, S30, and TR0.

Policy Coverage Sub Asset Dimension

This table stores information about the policy coverage sub-assets such as the specialty rooms and finished attic areas.

943

STG_AC_TYPE_MASTER

Stage Air Conditioner Type Master

DIM_AC_TYPE

Air Conditioner Type Dimension

944

STG_CONSTRUCTION_CLASS_MASTER

Stage Construction Class Master

DIM_CONSTRUCTION_CLASS

Construction Class Dimension

945

STG_INTERIOR_BUILTINS_MASTER

Stage Interior Builtins Master

DIM_INTERIOR_BUILTINS

Interior Builtins Dimension

946

STG_DWELL_STYLE_MASTER

Stage Dwell Style Master

DIM_DWELL_STYLE

Dwell Style Dimension

947

STG_DWELL_CONSTR_STYLE_MASTER

Stage Dwell Construction Style Master

DIM_DWELL_CONSTR_STYLE

Dwell Construction Style Dimension

948

STG_DWELL_EVAL_METHOD_MASTER

Stage Dwell Evaluation Method Master

DIM_DWELL_EVAL_METHOD

Dwell Evaluation Method Dimension

949

STG_DWELL_GENERAL_SHAPE_MASTER

Stage Dwell General Shape Master

DIM_DWELL_GENERAL_SHAPE

Dwell General Shape Dimension

950

STG_BLDG_STOREY_TYPE_MASTER

Stage Building Storey Type Master

DIM_BLDG_STOREY_TYPE

Building Storey Type Dimension

951

STG_BLDG_DET_STRUC_TYPE_MASTER

Stage Building Detached Structure Type Master

DIM_BLDG_DET_STRUC_TYPE

Building Detached Structure Dimension

952

STG_GARAGE_TYPE_MASTER

Stage Garage Type Master

DIM_GARAGE_TYPE

Garage Type Dimension

953

STG_INT_PRIMARY_COMPNNT_MASTER

Stage Interior Primary Component Master

DIM_INT_PRIMARY_COMPNNT

Interior Primary Component Dimension

954

STG_INT_PRIMARY_MTRL_MASTER

Stage Interior Primary Material Master

DIM_INT_PRIMARY_MTRL

Interior Primary Material Dimension

955

STG_PORCH_BREEZEWAY_MASTER

Stage Porch Breezeway Master

DIM_PORCH_BREEZEWAY

Porch Breezeway Dimension

956

STG_SUBSTRUCTURE_TYPE_MASTER

Stage Substructure Type Master

DIM_SUBSTRUCTURE_TYPE

Substructure Type Dimension

957

STG_INSP_REPORT_SRC_MASTER

Stage Inspection Report Source Master

DIM_INSP_REPORT_SRC

Inspection Report Source Dimension

958

STG_SPECIALTY_ROOM_MASTER

Stage Specialty Room

DIM_SPECIALTY_ROOM

Specialty Room Dimension

959

STG_BLDG_SYSTEM_MASTER

Stage Building System Master

DIM_BLDG_SYSTEM

Building System Dimension

960

STG_PRIM_SIDING_MTRL_MASTER

Stage Primary Siding Material Master

DIM_PRIM_SIDING_MTRL

Primary Siding Material Dimension

961

STG_INS_CONST_CLASS_MASTER

Stage Insurer Construction Class Master

DIM_INS_CONST_CLASS

Insurer Construction Class Dimension

962

STG_DS_QUAKE_SUITABILTY_MASTER

Stage Detached Structure Earthquake Suitability Master

DIM_DS_QUAKE_SUITABILTY

Detached Structure Earthquake Suitability Dimension

963

STG_WINDOW_BARS_MASTER

Stage Window Bars Master

DIM_WINDOW_BARS

Window Bars Dimension

964

STG_QUAKE_BLDG_CLASS_MASTER

Stage Earthquake Building Class Master

DIM_QUAKE_BLDG_CLASS

Earthquake Building Class Dimension

965

STG_QUAKE_RETROFIT_MASTER

Stage Earthquake Retrofit Master

DIM_QUAKE_RETROFIT

Earthquake Retrofit Dimension

966

STG_QUAKE_CONT_GRADE_MASTER

Stage Earthquake Contents Grade Master

DIM_QUAKE_CONT_GRADE

Earthquake Contents Grade Dimension

967

STG_ELTRC_INSULATE_TYPE_MASTER

Stage Electrical Insulation Master

DIM_ELTRC_INSULATE_TYPE

Electrical Insulation Dimension

968

STG_WINDSTORM_MITIGTN_MASTER

Stage Windstorm Mitigation Master

DIM_WINDSTORM_MITIGTN

Windstorm Mitigation Dimension

969

STG_BLD_INSPECTION_TYPE_MASTER

Stage Building Inspection Type Master

DIM_BLD_INSPECTION_TYPE

Building Inspection Type Dimension

970

STG_FL_WAITING_PERIOD_MASTER

Stage Flood Waiting Period Master

DIM_FL_WAITING_PERIOD

Flood Waiting Period Dimension

971

STG_POL_COV_SUB_ASSET_MASTER

Stage Policy Coverage Sub Asset Master

DIM_POL_COV_SUB_ASSET

Policy Coverage Sub Asset Dimension

T2T_FCT_POL_COV_ASSET_INSP_DTLS

This T2T stores inspection details for the policy coverage asset.

T2T_FCT_POL_COV_SUB_ASST_INSP_DTLS

This T2T stores information about the inspection of the sub-assets. Examples of sub-assets are specialty rooms, attics, and so on.

STG_POL_COV_ASSET_INSP_DTLS

Stage Policy Coverage Asset Inspection Details

FCT_POL_COV_ASSET_INSP_DTLS

Fact Policy Coverage Asset Inspection Details

T2T_FCT_POL_COV_ASSET_INSP_DTLS

STG_POL_COV_SUB_ASST_INSP_DTLS

Stage Policy Coverage Sub Asset Inspection Details

FCT_POL_COV_SUB_ASST_INSP_DTLS

Fact Policy Coverage Sub Asset Inspection Details

T2T_FCT_POL_COV_SUB_ASST_INSP_DTLS

 Data Category

Marine

Cargo

Dwelling Insurance

Worker's Compensation

Liquor Liability Insurance

Commercial Property Insurance

Automobile Insurance

Claim

Underwriting (Driving Violations)

Underwriting
(Lifestyle Activity)

Vehicle Data in Motion

Y

Y

Y

Vehicle Data at Rest

Y

Y

Y*

Y

Y

Y

Y

Vehicle Driving History

Y

Y

Transportation

Y

Y

Y

Y

Policy Covered Assets

Y

Y

Y

Y

Vehicle Class Sub Type Dimension

This table stores the vehicle class subtype details.

The sample values are SUV, Hatchbacks, Supercars, and Superbikes.

Vehicle Class Type Dimension

This table stores the vehicle class type details.

The sample values are Cars, Motorbikes, Lorry, and Aircraft.

Vehicle Filter Status Dimension

This table stores the vehicle filter status code information.

The sample values are FARE, FARS, FFRWH, FPRE, FPRS, and FRN.

Vehicle Horizontal Coordinate Reference Dimension

This table stores the code list that identifies the horizontal coordinate reference system.

The sample values are NAD27, NAD83, and WGS84.

Performance Threshold Type Dimension

This table stores the performance threshold type details.

The sample values are SD, RWA, LSSP, and HSTO.

835

STG_VEH_CLASS_STYPE_MASTER

Stage Vehicle Class Sub Type Master

DIM_VEH_CLASS_STYPE

Vehicle Class Sub Type Dimension

836

STG_VEH_CLASS_TYPE_MASTER

Stage Vehicle Class Type Master

DIM_VEH_CLASS_TYPE

Vehicle Class Type Dimension

838

STG_VEH_FILTER_STATUS_MASTER

Stage Vehicle Filter Status Master

DIM_VEH_FILTER_STATUS

Vehicle Filter Status Dimension

839

STG_VEH_HC_REF_MASTER

Stage Vehicle Horizontal Coordinate Reference Master

DIM_VEH_HC_REF

Vehicle Horizontal Coordinate Reference Dimension

841

STG_PERF_THRESHOLD_TYPE_MASTER

Stage Performance Threshold Type Master

DIM_PERF_THRESHOLD_TYPE

Performance Threshold Type Dimension

T2T_FCT_VEHICLE_DETAILS

This T2T stores the vehicle details.

STG_VEHICLE_DETAILS

Stage Vehicle Details

FCT_VEHICLE_DETAILS

Fact Vehicle Details

T2T_FCT_VEHICLE_DETAILS

Shipment Mode Dimension

This table stores the shipment details of the cargo such as the shipment mode indicator and the shipment mode. The shipment mode can be by air, common carrier, rail, and so on.

The sample values are A, CommCar, Oth, Own, and R.

Transportation Dimension

This table stores information about the transportation instances in the Cargo Insurance and commercial Inland Marine Insurance.

988

STG_SHIPMENT_MODE_MASTER

Stage Shipment Mode Master

DIM_SHIPMENT_MODE

Shipment Mode Dimension

989

STG_TRANSPORTATION_MASTER

Stage Transportation Master

DIM_TRANSPORTATION

Transportation Dimension

T2T_FCT_POL_COV_ASSET_SHIPMENT_DTL

This T2T stores the shipment details of the policy coverage assets.

STG_POL_COV_ASSET_SHIPMENT_DTL

Stage Policy Coverage Asset Shipment Detail

FCT_POL_COV_ASSET_SHIPMENT_DTL

Fact Policy Coverage Asset Shipment Detail

T2T_FCT_POL_COV_ASSET_SHIPMENT_DTL

Insurance Storage Dimension

This table stores the mapping information about the Insurance covered asset storage.

990

STG_INS_STORAGE_MASTER

Stage Insurance Storage Master

DIM_INS_STORAGE

Insurance Storage Dimension

T2T_FCT_POL_COV_ASSET_STORAGE_DTLS

This T2T stores the policy coverage asset storage details for Cargo and Marine Insurance.

T2T_FCT_POL_COV_ASSET_STORAGE_MAP

This T2T stores the mapping details of the policy coverage asset storage.

STG_POL_COV_ASSET_STORAGE_DTLS

Stage Policy Coverage Asset Storage Details

FCT_POL_COV_ASSET_STORAGE_DTLS

Fact Policy Coverage Asset Storage Details

T2T_FCT_POL_COV_ASSET_STORAGE_DTLS

STG_POL_COV_ASSET_STORAGE_MAP

Stage Policy Coverage Asset Storage Map

FCT_POL_COV_ASSET_STORAGE_MAP

Fact Policy Coverage Asset Storage Map

T2T_FCT_POL_COV_ASSET_STORAGE_MAP