Stores attributes associated with each contract. These attributes are displayed on the user interface together with data from table tRRRR_EC_ByContract Table.
Touchstone 2022 Database Reference
tRRRR_EC_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 | |||
| ExposureSetName | Code that represents the type of contract. For a complete list of codes, see tContractType Table. | 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 | | |||
| Branch | varchar | 60 | | ||||
| ContractTypeCode | Code that represents the type of contract. For a complete list of codes, see tContractType Table. | varchar | 10 | | |||
| InsuredName | Client's name. | varchar | 60 | | |||
| PolicyForm | User-specified policy form. | varchar | 60 | | |||
| ProducerName | varchar | 60 | | ||||
| SubmitStatusCode | varchar | 10 | | ||||
| Underwriter | varchar | 60 | | ||||
| UserLineOfBusiness | User's Line of Business. | 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 | | |||
| InceptionDate | date | 8 | | ||||
| ExpirationDate | date | 8 | |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tRRRR_EC_ByContract | Table | Unique system-generated sequential identifier for the zones, rings, or polygons in which exposure concentration is accumulated for a specified peril in a Geospatial analysis.Stores the results of the Geospatial analysis at the contract level. | 1 |