Touchstone 2022 Database Reference
tAdminBoundary Table
AIRUserSetting Database : tAdminBoundary Table
Description

Stores information about the administrative boundaries available in Touchstone.

Detailed information about the administrative boundaries is available in tAdminBoundaryDetail Table

Properties
Creation Date4/4/2022 3:02 AM
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 Unique system-generated sequential identifier for the custom administrative boundary record.int4   
 Name of the administrative boundary.varchar255   
Objects that depend on tAdminBoundary
 Database ObjectObject TypeDescriptionDep Level
tAdminBoundaryDetail tabletAdminBoundaryDetailTable

Stores information about the geographic records that are associated with specific administrative boundaries.

Information regarding the AIR-provided administrative boundaries is available in tAdminBoundary Table.

1
tLossModTemplateRule tabletLossModTemplateRuleTable

Used for a Loss analysis, this table stores information about the custom, user-defined rules (filter) that identify the Ground-Up losses to which the Loss analysis engine applies the specified loss modification factor.

1
tLossModTemplateRuleConstructionCode tabletLossModTemplateRuleConstructionCodeTable

Used for a Loss analysis, this table stores information about the construction class filter in the rule definition.

These custom, user-defined rules identify the Ground-Up losses to which the Loss analysis engine applies the specified loss modification factor. The engine applies the factor to losses from the events that satisfy the rules.

2
tLossModTemplateRuleOccupancyCode tabletLossModTemplateRuleOccupancyCodeTable

Used for a Loss analysis, this table stores information about the occupancy class filter in the rule definition.

These custom, user-defined rules identify the Ground-Up losses to which the Loss analysis engine applies the specified loss modification factor. The engine applies the factor to losses from the events that satisfy the rules.

2
tLossModTemplateRuleSetEventParameterXref tabletLossModTemplateRuleSetEventParameterXrefTableSystem reference table used  to identify to look-up template rules and event rule set associations.2
See Also

Related Objects

AIRUserSetting Database