System reference table used to map the location to the layer condition.
CEDE 2024 (12.0) Database Reference
tLayerConditionLocationXref Table
System reference table used to map the location to the layer condition.
| Creation Date | 6/5/2024 11:42 AM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 0 |
| Data Space Used | 0.00 KB |
| Index Space Used | 0.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | LayerConditionSID | Unique system-generated sequential identifier for the layer term record. For a complete list of records, see tLayerCondition Table. | int | 4 | |||
| | LocationSID | Unique system-generated sequential identifier for the location record. For a complete list of records, see tLocation Table. | int | 4 | |||
| RowVersion | Used for version stamping. | timestamp | 8 |
| 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 |