Touchstone 4.0 Database Documentation
tExposureSet Table
Description
Contains exposure set information. An exposure set is a collection of contracts, locations, and other related information.
Properties
Creation Date5/31/2016 9:46 AM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows1
Data Space Used8.00 KB
Index Space Used40.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key ExposureSetSIDUnique system-generated sequential identifier for the exposure set record.Integer4   
 ExposureSetNameUnique user-defined name for the exposure set.VarChar255  
 StatusCode

System-provided status code for the record in the table.

For a complete list of codes, see tStatus Table.

VarChar10 
('A')
 
 EnteredDateDate and time when the exposure set was created.DBTimeStamp4 
(getutcdate())
 
 EditedDateDate and time when the exposure set was modified.DBTimeStamp4 
(getutcdate())
 
 DescriptionUser-provided description, notes, and comments.VarChar4000  
 RowVersionUsed for version stamping.Binary8   
Objects that depend on tExposureSet
 Database ObjectObject TypeDescriptionDep Level
tContract tabletContractTable

Contains records for primary insurance policies.

2
tEngineLocPhysicalProperty tabletEngineLocPhysicalPropertyTableStore information about the location's physical properties that were calculated by the engine.1
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
tLocFeature tabletLocFeatureTable

Contains detailed building information, including secondary risk characteristics.

1
tLocOffshore tabletLocOffshoreTable

Contains risk characteristics for each offshore location.

1
tLocParsedAddress tabletLocParsedAddressTableContains street-level address details for each location.1
tLocTerm tabletLocTermTable

Contains information about location terms.

1
tLocWC tabletLocWCTable

Contains information about the workers' compensation details for the location.

1
tReinsAppliesToExp tabletReinsAppliesToExpTable

Contains information about Facultative certificates and Surplus Share treaties that are applied to exposures such as location, contract, and layer.

1
tStepFunction tabletStepFunctionTableContains general information for each step function SID, including the contract in which the step function is used.1
tStepFunctionDetail tabletStepFunctionDetailTableContains detailed information for each step function 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.