Touchstone 4.0 Database Documentation
tLayer Table
Description

Contains primary contract layer information.

Properties
Creation Date5/31/2016 9:46 AM
File GroupPRIMARY
Text File GroupPRIMARY
System Object
Published for Replication
Rows0
Data Space Used0.00 KB
Index Space Used0.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key LayerSIDUnique system-generated sequential identifier for the layer record.Integer4   
 ContractSID

Unique system-generated sequential identifier for the contract record.

For a complete list of records, see tContract Table.

Integer4   
 LayerIDUnique user-defined identifier for the layer.VarChar100   
 PerilSetCode

Numeric code for the single peril or set of perils.

For a complete list of codes, see tPerilSet Table.

Integer4   
 OccLimitTypeCode

Code for the occurrence limit type.

For a complete list of codes, see tOccLimitType Table.

VarChar10   
 OccTotalLimit

Occurrence limit amount, used for facultative reinsurance treaties and primary insurance contracts.

This column contains the user interface value provided in the 100% Layer Amount field on the Contracts tab.

Double9   
 OccParticipation

Occurrence participation, used for facultative reinsurance treaties and primary insurance contracts.

This column contains the user interface value provided in the Participating Layer Amount field on the Contracts tab.

Note: In the database this value is stored as a percentage of the total limit; on the user interface it is presented using the same format as was imported.

Double9   
 OccTotalParticipation

100% participation amount, used for facultative reinsurance treaties and primary insurance contracts.

This column contains the user interface value provided in the Assumed Amount field on the Contracts tab.

Note: Any values that are less than or equal to 1 will be interpreted as percentages (e.g., 0.12 as 12%).

Double9  
 AttachmentPointValue of the attachment point.Double9  
 DeductibleTypeCode

Code for the layer deductible type, options.

For a complete list of codes, see tDeductibleType Table.

VarChar10   
 Deductible1Deductible 1 amount. Any value less than or equal to 1 will be changed to 0.Double9  
 Deductible2Deductible 2 amount. For example, the maximum deductible for deductible min/max. Any value less than or equal to 1 will be changed to 0.Double9  
 PremiumPremium amount. Any value less than or equal to 1 will be interpreted as percentages (e.g., 0.12 as 12%).Double9  
 ExhaustionSequencePriority assignments for coverages, listed in the order in which losses by coverage should be applied against the limit.Xml16  
 EnteredDateDate and time when the contract was created.DBTimeStamp4 
(getutcdate())
 
 EditedDateDate and time when the contract was modified.DBTimeStamp4 
(getutcdate())
 
 RowVersionUsed for version stamping.Binary8   
Objects that depend on tLayer
 Database ObjectObject TypeDescriptionDep Level
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
tLayerConditionLocationXref tabletLayerConditionLocationXrefTable

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

1
Objects that tLayer 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
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.