Stores information about exposure sets.
An exposure set is a collection of contracts, locations, and other related information.
CEDE 9.0 Database Reference
tExposureSet Table
Stores information about exposure sets.
An exposure set is a collection of contracts, locations, and other related information.
| Creation Date | 4/12/2021 11:26 AM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 1 |
| Data Space Used | 8.00 KB |
| Index Space Used | 24.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | ExposureSetSID | Unique system-generated sequential identifier for the exposure set record. | int | 4 | |||
| ExposureSetName | Unique user-defined name for the exposure set. | varchar | 300 |  | |||
| StatusCode | System-provided status code for the record in the table. For a complete list of codes, see tStatus Table. | varchar | 10 | ('A') | |||
| EnteredDate | Date and time when the exposure set was created. | datetime | 4 | (getutcdate()) | |||
| EditedDate | Date and time when the exposure set was modified. | datetime | 4 | (getutcdate()) | |||
| Description | User-provided description, notes, and comments. | varchar | 4000 | | |||
| RowVersion | Used for version stamping. | timestamp | 8 | ||||
| CompanySID | Reserved for future use. | int | 4 | |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tContract | Table | Stores records for primary insurance policies. | 1 |
| tLayer | Table | Stores primary contract layer information. | 2 |
| tLayerCondition | Table | Stores layer conditions, such as sublimit and policy restrictions.
Sublimits are generally applied to layers based on filter criteria, such as a list of locations or perils.
| 2 |
| tLocation | Table | Stores geographical attributes and primary risk characteristics for each location. The table serves as a reference point between Location and Contract entities.You can identify each location by the location sequential identifier (SID). | 1 |
| tLocFeature | Table | Stores detailed building information for each location. The information includes secondary risk characteristics, such as the building shape and glass type. | 2 |
| tLocOffshore | Table | Stores risk characteristics for each offshore location. | 2 |
| tLocTerm | Table | Stores information about location terms. | 2 |
| tLocWC | Table | Stores information about the workers' compensation details for the location. | 2 |
| tReinsAppliesToExp | Table | Stores information about facultative certificates and surplus share treaties that are applied to exposures such as locations, contracts, and layers. | 1 |
| tStepFunction | Table | Stores general information about step functions, including the contract associated with each step function. | 2 |
| tStepFunctionDetail | Table | Stores detailed information about step functions. | 3 |