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/4/2022 3:02 AM |
| 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 | |
|---|---|---|---|---|---|---|---|
 | AnalysisSID | Unique system-generated sequential identifier for the analysis. For a complete list of records, see tAnalysis Table. | int | 4 | |||
| GlobalZoneSetSIDList | Unique system-generated sequential identifier for the zone set associated with the analysis. 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.
| bit | 1 | ((0)) |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tAnalysis | Table | Stores information about each analysis. | 2 |
| 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. | 4 |
| tDataSource | Table | Stores information about the databases registered with the application, for example, the exposure and results databases. | 3 |
| tExposureSet | Table | Stores exposure set information from each exposure database on the server. | 4 |
| tLossAnalysisOption | Table | Stores information about the general options specified for each loss analysis. | 1 |
| tProject | Table | Stores information about each project, for example, the project name and status code. | 3 |