Stores information about the general options specified for each loss analysis.
Touchstone 2022 Database Reference
tLossAnalysisOption Table
Stores information about the general options specified for each loss analysis.
| Creation Date | 4/4/2022 3:02 AM |
| File Group | PRIMARY |
| Text File Group | PRIMARY |
| System Object |  |
| Published for Replication | |
| Rows | 8 |
| Data Space Used | 8.00 KB |
| Index Space Used | 168.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 | ||||
| EventSetSID | Unique system-generated sequential identifier for the event set record. For a complete list of records, see tEventSet Table. | int | 4 | ||||
| EventFilter | XML expression for the filter applied on an event during a Loss analysis. Used internally by Touchstone. | xml | 0 |  | |||
| ProgramSID | Unique system-generated sequential identifier for the reinsurance program record. For a complete list of records, see tProgram Table. | int | 4 | | |||
| FacultativeOptionCode | Code that represents how the facultative option is applied. For a complete list of codes, see tFacultativeOption Table. | varchar | 10 | | |||
| CATFinancialPerspectiveCode | Code that represents the financial perspectives. For a complete list of codes, see tFinancialPerspective Table. | varchar | 10 | | |||
| OutputTypeCode | Code that represents the type of output generated during the analysis. For a complete list of codes, see tOutputType Table. | varchar | 10 | ||||
| OutputDetailedAALCode | Code that represents the type of AAL summary that was output for the analysis. For a complete list of codes, see tOutputDetailedAAL Table. | varchar | 10 | | |||
| GeoLevelCode | Code that represents the geographic level. For a complete list of codes, see tGeoLevel Table. | varchar | 10 | | |||
| OutputGroupByCode | Code that represents the group in which the output is organized. For a complete list of codes, see tOutputGroupBy Table. | varchar | 10 | | |||
| AveragePropertyOptionCode | Indicates whether the average properties option was enabled. When ‘On’, the data is analyzed at a coarser geographic resolution. For a complete list of codes, see tAveragePropertyOption Table. | varchar | 10 | | |||
| ApplyDisaggregation | Indicates whether disaggregation is used on aggregate location data.
| bit | 1 | ((0)) | |||
| ApplyDeductibleBeforeLimit | Indicates whether location terms are applied in residential contracts.
| bit | 1 | ((0)) | |||
| RemapConstructionOccupancy | Indicates whether invalid construction/occupancy combination are ignored or mapped to the default combinations
| bit | 1 | ((1)) | |||
| EnableCorrelation | Indicates whether correlation is enabled.
| bit | 1 | ((0)) | |||
| DemandSurgeOptionCode | Code that represents how demand surge was applied. For a complete list of codes, see tDemandSurgeOption Table. | varchar | 10 | ||||
| MoveMarineCraftGeocodesToCoast | Indicates whether the marine craft geocodes are moved to the coastline during a loss analysis.
| bit | 1 | ((1)) | |||
| SaveGroundUp | Indicates whether Ground-Up loss results are saved.
| bit | 1 | ((0)) | |||
| SaveRetained | Indicates whether Retained loss results are saved.
| bit | 1 | ((0)) | |||
| SavePreLayerGross | Indicates whether Pre-Layer Gross loss results are saved.
| bit | 1 | ((0)) | |||
| SaveGross | Indicates whether Gross loss results are saved.
| bit | 1 | ((0)) | |||
| SaveNetOfPreCAT | Indicates whether Net-of-Pre loss results are saved.
| bit | 1 | ((0)) | |||
| SavePostCATNet | Indicates whether Net-of-Post loss results are saved.
| bit | 1 | ((0)) | |||
| SaveCoverage | Indicates whether coverage data for a given financial perspective is saved. For example, when Ground-Up is selected and coverage option is chosen, the resultant table would include Ground-Up loss for Coverage A, Coverage B , Coverage C, and Coverage D.
| bit | 1 | ((0)) | |||
| SaveInjury | Reserved for future use. | bit | 1 | ((0)) | |||
| SaveClaims | Indicates whether claims count is saved.
| bit | 1 | ((0)) | |||
| SaveMAOL | Indicates whether Maximum Any One Life terms are saved.
| bit | 1 | ((0)) | |||
| MAOLMinor | Medical Minor (Limit 1) term applied during the analysis when SaveMAOL is saved. | float | 9 | | |||
| MAOLModerate | Medical Moderate (Limit 2) term applied during the analysis when SaveMAOL is saved. | float | 9 | | |||
| MAOLMajor | Medical Major (Limit 3) term applied during the analysis when SaveMAOL is saved. | float | 9 | | |||
| MAOLFatal | Medical Fatal (Limit 4) term applied during the analysis when SaveMAOL is saved. | float | 9 | | |||
| EP1 | Value for the first point on the exceedance probability curve. | float | 9 | ||||
| EP2 | Value for the second point on the exceedance probability curve. | float | 9 | ||||
| EP3 | Value for the third point on the exceedance probability curve. | float | 9 | ||||
| EP4 | Value for the fourth point on the exceedance probability curve. | float | 9 | ||||
| EP5 | Value for the fifth point on the exceedance probability curve. | float | 9 | ||||
| EP6 | Value for the sixth point on the exceedance probability curve. | float | 9 | ||||
| EP7 | Value for the seventh point on the exceedance probability curve. | float | 9 | | |||
| EP8 | Value for the eighth point on the exceedance probability curve. | float | 9 | | |||
| EP9 | Value for the ninth point on the exceedance probability curve. | float | 9 | | |||
| EP10 | Value for the tenth point on the exceedance probability curve. | float | 9 | | |||
| UncPercentile1 | Boundaries used to create the uncertainty curve, represents the upper range of the confidence level. The default is 5.00%. | real | 4 | ||||
| UncPercentile2 | Boundaries used to create the uncertainty curve, , represents the lower range of the confidence level. The default is 95.00%. | real | 4 | ||||
| UncIntraPolicyCorrelationFactor | Default percentage of correlation between locations within a contract. | real | 4 | ||||
| UncInterPolicyCorrelationFactor | Default percentage of correlation between contracts in a portfolio. | real | 4 | ||||
| OilPrice | Default oil price, as extracted from tDefaultLossAnalysisOption Table. | float | 9 | ||||
| OilPriceUnitCode | Code for the unit of measure used to express the price of the oil. For a complete list of codes, see tUnit Table. | varchar | 10 | ||||
| GasPrice | Gas price used during the analysis for the AIR Hurricane Model for Offshore Assets. | float | 9 | ||||
| GasPriceUnitCode | Code for the unit of measure used to express the price of the gas. For a complete list of codes, see tUnit Table. | varchar | 10 | ||||
| EP11 | Value for the eleventh point on the exceedance probability curve. | float | 9 | | |||
| EP12 | Value for the twelfth point on the exceedance probability curve. | float | 9 | | |||
| EP13 | Value for the thirteenth point on the exceedance probability curve. | float | 9 | | |||
| EP14 | Value for the fourteenth point on the exceedance probability curve. | float | 9 | | |||
| EP15 | Value for the fifteenth point on the exceedance probability curve. | float | 9 | | |||
| LossModOption | XML string that defines the loss modification option. Used internally by Touchstone. | xml | 0 | | |||
| LossModTemplateSID | Unique system-generated sequential identifier for the loss modification template. For a complete list of records, see tLossModTemplate Table. | int | 4 | | |||
| LossModTemplateHash | Reserved for future use. | decimal | 9 (38,0) | | |||
| RowVersion | Used for version stamping. | timestamp | 8 | ||||
| BaseAnalysisSID | Unique system-generated sequential identifier for the analysis record. For a complete list of records, see tAnalysis Table. | int | 4 | | |||
| ComponentCode | Code that represents the component/model used during the analysis. | varchar | 10 | | |||
| SaveSummaryByPeril | Indicates whether a summary of losses by peril were saved.
| bit | 1 | ((0)) | |||
| SaveSummaryByModel | Indicates whether a summary of losses by model were saved.
| bit | 1 | ((0)) | |||
| SaveZone | Indicates whether losses were saved by zone.
| bit | 1 | ((0)) | |||
| IsPreviousVersionModel | Indicates whether the event set included in the analysis corresponds to the current or previous version of the AIR models.
| bit | 1 | ((0)) | |||
| IsSelectedVulnerabilitySet | Indicates whether the vulnerability set is selected for the loss analysis.
| bit | 1 | ((0)) | |||
| MinMaxLogicCode | Code that represents the MinMaxLogicCode. | varchar | 3 | | |||
| SaveSubPeril | Indicates whether losses were saved by sub peril.
| bit | 1 | ((0)) | |||
| SaveTreaty | Indicates whether losses were saved by treaty.
| bit | 1 | ((0)) | |||
| SaveFacultative | Indicates whether losses were saved by facultative program.
| bit | 1 | ((0)) | |||
| IsSelectedCustomFrequencySet | Indicates whether custom frquency set is selected for the loss analysis.
| bit | 1 | ((0)) | |||
| IsApplyAIRAnalysis | Indicates whether the AIR Analysis is selected for the loss analysis.
| bit | 1 | |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tLossAnalysisAdditionalOption | Table | Stores information about the additional options for each loss analysis. | 1 |
| tLossAnalysisCustomFrequencySetXref | Table | Stores the loss analysis information associated with the custom frequency set. | 1 |
| tLossAnalysisDemandSurgeOption | Table | Stores information about the demand surge curves applied during detailed loss analyses. If an analysis does not include demand surge, the table does not include a row for the analysis. | 1 |
| tLossAnalysisEarthquakeOption | Table | Stores information about the earthquake options applied during detailed loss analyses. If the earthquake peril is not included in a given analysis, the table does not include a row for the analysis. | 1 |
| tLossAnalysisFloodOption | Table | Stores information about the custom flood zones included in detailed loss analyses. | 1 |
| tLossAnalysisFloodPlainOption | Table | 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. | 1 |
| tLossAnalysisPerilSetULOBOption | Table | 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. | 1 |
| tLossAnalysisSTStormOption | Table | Stores information about the severe storm options using during a Loss analysis. | 1 |
| tLossAnalysisTerrorismOption | Table | Stores information about the terrorism options used during a Loss analysis. | 1 |
| tLossAnalysisVulnerabilitySetXref | Table | Stores the additional options for vulnerability set files associated with loss analyses. | 1 |
| tLossAnalysisZoneOption | Table | 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. | 1 |
| 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 |