Touchstone 2022 Database Reference
tAIROccupancyRegionXref Table
AIRReference Database : tAIROccupancyRegionXref Table
Description

System reference table that stores the geography and line of business associated with each AIR occupancy class code.

Properties
Creation Date1/18/2013 2:22 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows0
Data Space Used0.00 KB
Index Space Used0.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key AIROccupancyCode

Code that represents the AIR occupancy class.

For a complete list of codes, see tAIROccupancy Table.

smallint2   
Primary Key GeoRegionSID

Unique system-generated sequential identifier for the geography record.

For a complete list of records, see tGeoRegion Table.

int4   
 AIRLineOfBusinessCode

Code that represents the Line of Business.

For a complete list of codes, see tAIRLineOfBusiness Table.

varchar10   
Objects that tAIROccupancyRegionXref depends on
 Database ObjectObject TypeDescriptionDep Level
tAIRLineOfBusiness tabletAIRLineOfBusinessTableDefines the AIR Line of Business types.1
tAIROccupancy tabletAIROccupancyTableStores information about AIR occupancy class codes.1
See Also

Related Objects

AIRReference Database

 

 

Verisk Analytics Client Confidential

© 2022. AIR Worldwide is now Extreme Event Solutions. AIR Worldwide is a registered trademark. Touchstone is a registered trademark of AIR Worldwide.

Please contact Verisk Analytics with questions or comments.