Stores information about contracts that experienced Loss in the analysis. This dimension table is generated when losses are saved by contract or by location.
Touchstone 2022 Database Reference
tRRRR_LOSS_DimContract Table
| Creation Date | 4/11/2022 6:15 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 | |||
| | ContractSID | Unique system-generated sequential identifier for the contract record. For a complete list of records, see tContract Table. | int | 4 | |||
| ContractTypeCode | Code that represents the contract type. For a compete list of codes, see tContractType Table. | varchar | 10 | ||||
| ExposureSetName | Name of the exposure set. | varchar | 255 |  | |||
| ContractID | Unique user-provided identifier for the contract. | varchar | 100 | ||||
| PerilSetCode | Numeric code for the single peril or set of perils. For a complete list of codes, see tPerilSet Table. | int | 4 | ||||
| UserLineOfBusiness | User's Line of Business. | varchar | 60 | | |||
| PolicyForm | User-defined policy. | varchar | 60 | | |||
| InsuredName | Client's name | varchar | 60 | | |||
| UserDefined1 | User-defined field 1. | varchar | 60 | | |||
| UserDefined2 | User-defined field 2. | varchar | 60 | | |||
| UserDefined3 | User-defined field 3. | varchar | 60 | | |||
| UserDefined4 | User-defined field 4. | varchar | 60 | | |||
| UserDefined5 | User-defined field 5. | varchar | 60 | | |||
| ExpiringContractID | Unique user-defined identifier for the expiring contract. | varchar | 100 | |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tRRRR_LOSS_ByContract | Table | Stores event losses for one detailed loss analysis by contract. Touchstone creates one table for each analysis that includes Contract as an output option. | 1 |
| tRRRR_LOSS_ByContractGeo | Table | Stores event losses for one detailed loss analysis by each combination of contract and geography. Touchstone creates one table for each analysis that includes Contract and Geography as output options. | 1 |
| tRRRR_LOSS_ByContractGeoLayer | Table | Stores event losses for one detailed loss analysis by each combination of contract, layer, and geography. Touchstone creates one table for each analysis that includes Contract, Geography, and Layer as output options. | 1 |
| tRRRR_LOSS_ByContractSummary | Table | Stores summary losses for one detailed loss analysis by contract. Touchstone creates one table for each analysis that includes Contract Summary as an output option. | 1 |
| tRRRR_LOSS_ByContractZone | Table | Stores event losses for one detailed loss analysis by each combination of contract and zone. Touchstone creates one table for each analysis that includes Contract and Zone as output options. | 1 |
| tRRRR_LOSS_ByContractZoneLayer | Table | Stores event losses for one detailed loss analysis by each combination of contract, zone, and layer. Touchstone creates one table for each contract analysis that includes Contract, Zone, and Layer as output options. | 1 |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
| tRRRR_LOSS_DimExposureDataSource | Table | Stores information about databases that contain exposures that have been analyzed. This dimension table is created for every Loss analysis. | 1 |