Stores information about the source of flood plain options in detailed loss analyses.
Applicable only for US Model in Touchstone.
The Precipitation Flood and Inland Flood perils apply to precipitation events that cause inland flooding due to river overflow, as well as to overflow caused by inadequate drainage systems. Based on the region, user can select the flood plain options before running an analysis.
| Creation Date | 4/4/2022 3:02 AM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 4 |
| Data Space Used | 8.00 KB |
| Index Space Used | 8.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | AnalysisSID | Unique system-generated sequential identifier associated with the detailed loss analysis record. | int | 4 | |||
| | OnPlain | Indicates whether the OnPlain option in Inland Flood peril is enabled for each detailed loss analysis record.
| bit | 1 | |||
| | OffPlain | Indicates whether the OffPlain option in Inland Flood peril is enabled for each detailed loss analysis record.
| bit | 1 | |||
| RowVersion | Used for version stamping. | timestamp | 8 | ||||
| | PerilSetCode | Code that represents the peril code associated with the detailed loss analysis record. | int | 4 | ((2048)) |
| 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 |