Understanding the CEDE Format, Touchstone 4.0
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.int4   
 LayerSID

Unique system-generated sequential identifier for the layer record.

For a complete list of records, see tLayer Table.

int4   
 ContractSID

Unique system-generated sequential identifier for the contract record.

For a complete list of records, see tContract Table.

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

int4   
 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.float9  
 OccLimit2Limit 2 amount.float9  
 OccLimit3Limit 1 amount.float9  
 OccLimit4Limit 2 amount.float9  
 DeductibleTypeCode

Code for the layer deductible type, options.

For a complete list of codes, see tDeductibleType Table.

varchar10   
 Deductible1Deductible 1 amount.float9  
 Deductible2Deductible 2 amount.float9  
 Attachment1Attachment point 1 amount.float9  
 Attachment2Attachment point 2 amount.float9  
 Attachment3Attachment point 3 amount.float9  
 Attachment4Attachment point 4 amount.float9  
 InuringSequenceNumberLayer sequence order.smallint2  
 ParentLayerConditionSIDUnique system-generated sequential identifier for the layer condition for the parent record.int4  
 RowVersionUsed for version stamping.timestamp8   
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

 

 


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