Stores information about each layer defined for an analysis. tRRRR_EC_ByLayer Table refers to the data in this parent table.
Touchstone 2022 Database Reference
tRRRR_EC_DimLayer Table
| Creation Date | 4/11/2022 5:46 PM |
| 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 | |
|---|---|---|---|---|---|---|---|
 | ExposureDataSourceSID | Unique system-generated sequential identifier for the exposure data source record. For a complete list of records, see tDataSource Table. | int | 4 | |||
| | LayerSID | Unique system-generated sequential identifier for the layer record. For a complete list of records, see tLayer Table. | int | 4 | |||
| ContractSID | int | 4 | |||||
| ExposureSetName | Name of the exposure set. | varchar | 255 |  | |||
| ContractID | Unique user-provided identifier for the contract. | varchar | 100 | | |||
| InsuredName | Client's name. | varchar | 60 | | |||
| LayerID | Unique user-provided identifier for the layer. | varchar | 60 | | |||
| PerilSetCode | int | 4 | |||||
| OccLimitTypeCode | varchar | 10 | |||||
| OccTotalLimit | float | 9 | |||||
| OccParticipation | float | 9 | |||||
| OccTotalParticipation | float | 9 | | ||||
| DeductibleTypeCode | varchar | 10 | |||||
| Deductible1 | float | 9 | | ||||
| Deductible2 | float | 9 | | ||||
| Premium | float | 9 | | ||||
| AttachmentPoint | float | 9 | | ||||
| ContractTypeCode | varchar | 10 | |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tRRRR_EC_ByLayer | Table | Stores the results of the Geospatial analysis at the layer-level. | 1 |