Stores the values used to generate the results in a Comparative Loss analysis.
Touchstone 2022 Database Reference
tComparativeLossAnalysisOption Table
| Creation Date | 4/4/2022 3:02 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 | |
|---|---|---|---|---|---|---|---|
 | AnalysisSID | Unique system-generated sequential identifier for the analysis record. For a complete list of records, see tAnalysis Table. | int | 4 | |||
| PerilSetCode | Numeric code for the single peril or set of perils. For a complete list of codes, see dbo.tPerilSet Table. | int | 4 |  | |||
| EP1 | Value used to calculate the exceedance probably and summary. | float | 9 | ||||
| EP2 | Value used to calculate the exceedance probably and summary. | float | 9 | ||||
| EP3 | Value used to calculate the exceedance probably and summary. | float | 9 | ||||
| EP4 | Value used to calculate the exceedance probably and summary. | float | 9 | ||||
| EP5 | Value used to calculate the exceedance probably and summary. | float | 9 | ||||
| EP6 | Value used to calculate the exceedance probably and summary. | float | 9 | ||||
| EP7 | Value used to calculate the exceedance probably and summary. | float | 9 | | |||
| EP8 | Value used to calculate the exceedance probably and summary. | float | 9 | | |||
| EP9 | Value used to calculate the exceedance probably and summary. | float | 9 | | |||
| EP10 | Value used to calculate the exceedance probably and summary. | float | 9 | | |||
| EP11 | Value used to calculate the exceedance probably and summary. | float | 9 | | |||
| EP12 | Value used to calculate the exceedance probably and summary. | float | 9 | | |||
| EP13 | Value used to calculate the exceedance probably and summary. | float | 9 | | |||
| EP14 | Value used to calculate the exceedance probably and summary. | float | 9 | | |||
| EP15 | Value used to calculate the exceedance probably and summary. | float | 9 | | |||
| HasCoverage | Indicates whether the results include loss by coverage.
| bit | 1 | ((0)) | |||
| HasClaims | Indicates whether the results include claims loss.
| bit | 1 | ((0)) | |||
| HasTreatyLoss | Indicates whether the results include treaty loss.
| bit | 1 | ((0)) | |||
| HasInjury | Indicates whether the results include Workers' Compensation loss.
| bit | 1 | ((0)) | |||
| IsDeterministic | Indicates whether the results include deterministic terrorism loss.
| bit | 1 | ((0)) | |||
| SaveGroundUp | Indicates whether Ground-Up loss results were saved.
| bit | 1 | ((0)) | |||
| SaveRetained | Indicates whether Retained loss results were saved.
| bit | 1 | ((0)) | |||
| SavePreLayerGross | Indicates whether Pre-Layer Gross loss results were saved.
| bit | 1 | ((0)) | |||
| SaveGross | Indicates whether Gross loss results were saved.
| bit | 1 | ((0)) | |||
| SaveNetOfPreCAT | Indicates whether Net-of-Pre loss results are saved.
| bit | 1 | ((0)) | |||
| SavePostCATNet | Indicates whether Net-of-Post loss results were saved.
| bit | 1 | ((0)) | |||
| SaveByULOBContract | Indicates whether contract loss results by user Line of Business were saved.
| bit | 1 | ||||
| SaveByULOB | Indicates whether loss results by user Line of Business were saved.
| bit | 1 | ||||
| SaveByGeo | Indicates whether loss results by geographic resolution were saved.
| bit | 1 | ||||
| GeoLevelCode | Code that represents the geographic levels. For a complete list of codes see tGeoLevel Table. | varchar | 10 | | |||
| EventSetSID | Unique system-generated sequential identifier for the event set record. For a complete list of records, see dbo.tEventSet Table. | int | 4 |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tAnalysis | Table | Stores information about each analysis. | 1 |
| tDataServer | Table | Stores information about each data server associated with the project, including the sequential identifier (SID), name, description, connection information, and default MDF and LDF paths for the server. | 3 |
| tDataSource | Table | Stores information about the databases registered with the application, for example, the exposure and results databases. | 2 |
| tExposureSet | Table | Stores exposure set information from each exposure database on the server. | 3 |
| tProject | Table | Stores information about each project, for example, the project name and status code. | 2 |