Stores information about the zone sets used to generate each set of detailed loss analysis results.
If you save results by zone during an analysis, Touchstone creates one or more rows for the analysis that indicate the zone sets you specified, whether you saved summary exceedance probability (EP) results by each combination of zone and peril, and whether you saved annual EP values by zone.
| Creation Date | 4/11/2022 6:15 PM |
| File Group | PRIMARY |
| Text File Group | PRIMARY |
| 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 | |
|---|---|---|---|---|---|---|---|
 | ResultSID | Unique system-generated sequential identifier for the results record. For a complete list of records, see tAnalysisResult Table. | int | 4 | |||
| GlobalZoneSetSIDList | Unique system-generated identifier for the zone set. For a complete list of records, see tGlobalZoneSet Table. | varchar | 16 | ||||
| SaveSummaryByPerilByZone | Indicates whether summary exceedance probability (EP) losses were saved by each combination of peril and zone.
| bit | 1 | ((0)) | |||
| RetainEPByZone | Indicates whether annual EP losses were saved by zone. If you do not save EP results by zone, Touchstone deletes the tRRRR_LOSS_AnnualEPSummary_ByZone Table and tRRRR_LOSS_AnnualEPSummary_ByPerilByZone Table.
| bit | 1 | ((0)) | |||
| RowVersion | Used for version stamping. | timestamp | 8 |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tLossAnalysisOption | Table | Stores the loss analysis options used to generate results during a loss analysis. Touchstone creates one row for each analysis. | 1 |