Stores information regarding advanced options used during a Marginal Impact analysis.
Touchstone 2022 Database Reference
tImpactAnalysisAdditionalOption Table
| 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 record. For a complete list of records, see tAnalysis Table. | int | 4 | |||
| ExcludedContracts | List of the expiring contracts excluded from the analysis. | varchar | 16 |  | |||
| AvgWindow | Number of points on the EP (exceedance probability) curve that Touchstone should average to replace an outlying EP point for the analysis. For example, if AvgWindow is 3, Touchstone replaces the value of any outlying EP points with the average of the values of the six EP points surrounding the outlying EP point. | smallint | 2 |
| 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 |