Stores information about the perils and Lines of Business analyzed during the Loss analysis.
The table also identifies the percentage of the loss from storm surge or precipitation flood, when applicable.
| 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 tPerilSet Table. | int | 4 | |||
| | UserLineOfBusiness | User's Line of Business. | varchar | 255 | |||
| Percentage | Percentage of the loss that is from storm surge or precipitation flood perils. | real | 4 | ||||
| RowVersion | Used for version stamping. | timestamp | 8 |
| 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 |