Touchstone 4.0 Database Documentation
tAIROccupancyRegionXref Table
Description

System reference table that is used to group occupancy and region information.

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.

Integer4   
 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 AIR occupancy class information.1
See Also

Related Objects

AIRReference Database

 

 


AIR Client Confidential

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