Stores information about exposure sets.
An exposure set is a collection of contracts, locations, and other related information.
Stores information about exposure sets.
An exposure set is a collection of contracts, locations, and other related information.
Creation Date | 4/11/2022 6:15 PM |
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. | 2 |
![]() | 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.
| 1 |
![]() | 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. | 1 |
![]() | tLocOffshore | Table | Stores risk characteristics for each offshore location. | 1 |
![]() | tLocTerm | Table | Stores information about location terms. | 1 |
![]() | tLocWC | Table | Stores information about the workers' compensation details for the location. | 1 |
![]() | 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. | 1 |
![]() | tStepFunctionDetail | Table | Stores detailed information about step functions. | 1 |