Touchstone 4.0 Database Documentation
tLayerConditionLocationXref Table
Description

System reference table used to map the location to the layer condition.

Properties
Creation Date5/31/2016 9:46 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 LayerConditionSID

Unique system-generated sequential identifier for the layer term record.

For a complete list of records, see tLayerCondition Table.

Integer4   
Primary Key LocationSID

Unique system-generated sequential identifier for the location record.

For a complete list of records, see tLocation Table.

Integer4   
 RowVersionUsed for version stamping.Binary8   
Objects that tLayerConditionLocationXref depends on
 Database ObjectObject TypeDescriptionDep Level
tContract tabletContractTable

Contains records for primary insurance policies.

2
tLayer tabletLayerTable

Contains primary contract layer information.

2
tLayerCondition tabletLayerConditionTable

Contains layer conditions, such as sublimit and policy restrictions.  Note that sublimit belongs to a layer and is usually associated with a filter criteria, such as specific group of locations or perils.

1
tLocation tabletLocationTable

Contains geographical attributes and primary risk characteristics for each location. It serves as a reference point between Location and Contract entities.  All locations entities are tied together by the same Location SID.

1
See Also

Related Objects

AIRExposure 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.