Touchstone 4.0 Database Documentation
tLayerCondition Table
Description

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.

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 LayerConditionSIDUnique system-generated sequential identifier for the layer term record.Integer4   
 LayerSID

Unique system-generated sequential identifier for the layer record.

For a complete list of records, see tLayer Table.

Integer4   
 ContractSID

Unique system-generated sequential identifier for the contract record.

For a complete list of records, see tContract Table.

Integer4   
 LayerConditionTypeCode

Code for the layer condition type.

For a complete list of codes, see tLayerConditionType Table.

VarChar10   
 PerilSetCode

Numeric code for the single peril or set of perils.

For a complete list of codes, see tPerilSet Table.

Integer4   
 AppliesToTagUser-defined condition key.VarChar255  
 OccLimitTypeCode

Code for the occurrence limit type, options include:

For a complete list of codes, see tOccLimitType Table.

VarChar10   
 OccLimit1Limit 1 amount.Double9  
 OccLimit2Limit 2 amount.Double9  
 OccLimit3Limit 1 amount.Double9  
 OccLimit4Limit 2 amount.Double9  
 DeductibleTypeCode

Code for the layer deductible type, options.

For a complete list of codes, see tDeductibleType Table.

VarChar10   
 Deductible1Deductible 1 amount.Double9  
 Deductible2Deductible 2 amount.Double9  
 Attachment1Attachment point 1 amount.Double9  
 Attachment2Attachment point 2 amount.Double9  
 Attachment3Attachment point 3 amount.Double9  
 Attachment4Attachment point 4 amount.Double9  
 InuringSequenceNumberLayer sequence order.SmallInt2  
 ParentLayerConditionSIDUnique system-generated sequential identifier for the layer condition for the parent record.Integer4  
 RowVersionUsed for version stamping.Binary8   
Objects that depend on tLayerCondition
 Database ObjectObject TypeDescriptionDep Level
tLayerConditionLocationXref tabletLayerConditionLocationXrefTable

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

1
Objects that tLayerCondition depends on
 Database ObjectObject TypeDescriptionDep Level
tContract tabletContractTable

Contains records for primary insurance policies.

2
tExposureSet tabletExposureSetTableContains exposure set information. An exposure set is a collection of contracts, locations, and other related information.3
tLayer tabletLayerTable

Contains primary contract layer information.

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