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

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

For a complete list of codes, see tStatus Table.

 EnteredDateDate and time when the exposure set was created.datetime4 
 EditedDateDate and time when the exposure set was modified.datetime4 
 DescriptionUser-provided description, notes, and comments.varchar4000  
 RowVersionUsed for version stamping.timestamp8   
Objects that depend on tExposureSet
 Database ObjectObject TypeDescriptionDep Level
tContract tabletContractTable

Contains records for primary insurance policies.

tEngineLocPhysicalProperty tabletEngineLocPhysicalPropertyTableStore information about the location's physical properties that were calculated by the engine.1
tLayer tabletLayerTable

Contains primary contract layer information.

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.

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.

tLocFeature tabletLocFeatureTable

Contains detailed building information, including secondary risk characteristics.

tLocOffshore tabletLocOffshoreTable

Contains risk characteristics for each offshore location.

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

Contains information about location terms.

tLocWC tabletLocWCTable

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

tReinsAppliesToExp tabletReinsAppliesToExpTable

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

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



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