Stores the general options used to generate each set of detailed loss analysis results.
Touchstone 2022 Database Reference
tLossAnalysisOption Table
Stores the general options used to generate each set of detailed loss analysis results.
| Creation Date | 4/11/2022 5:46 PM |
| 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 | |
|---|---|---|---|---|---|---|---|
 | ResultSID | Unique system-generated sequential identifier for the results record. For a complete list of records, see tAnalysisResult 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 | ||||
| EventSet | Name of the set of events simulated by the AIR model. | varchar | 255 | ||||
| EventFilter | XML string that defines the filters to be used in selecting events to be analyzed. | xml | 0 |  | |||
| ProgramSID | Unique system-generated sequential identifier for the program record. For a complete list of records, see tProgram Table. | int | 4 | | |||
| ProgramID | Identifier for the reinsurance program, if one was applied in this analysis. | varchar | 100 | | |||
| ProgramDescription | User-provided description of the analyzed reinsurance program, if one is to be applied in this analysis | varchar | 4000 | | |||
| 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 perspective loss on which CatExcess of loss treaties are applied. 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 | Code that 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 was used on aggregate location data.
| bit | 1 | ((0)) | |||
| ApplyDeductibleBeforeLimit | Indicates whether location terms were applied in residential contracts.
| bit | 1 | ((0)) | |||
| RemapConstructionOccupancy | Indicates whether invalid construction/occupancy combination were ignored or mapped to the default combinations.
| bit | 1 | ((1)) | |||
| EnableCorrelation | Indicates whether correlation was 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 marine craft geocodes were moved to the coast.
| bit | 1 | ((1)) | |||
| SaveGroundUp | Indicates whether Ground-Up loss results were saved.
| bit | 1 | ((0)) | |||
| SaveRetained | Indicates whether Retained loss results were saved.
| bit | 1 | ((0)) | |||
| SavePreLayerGross | Indicates whether Pre-Layer Gross loss results were saved.
| bit | 1 | ((0)) | |||
| SaveGross | Indicates whether Gross loss results were 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 were saved.
| bit | 1 | ((0)) | |||
| SaveCoverage | Indicates whether coverage data for a given financial perspective was 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 were saved.
| bit | 1 | ((0)) | |||
| EP1 | Value used to calculate the exceedance probably and summary. | float | 9 | ||||
| EP2 | Value used to calculate the exceedance probably and summary. | float | 9 | ||||
| EP3 | Value used to calculate the exceedance probably and summary. | float | 9 | ||||
| EP4 | Value used to calculate the exceedance probably and summary. | float | 9 | ||||
| EP5 | Value used to calculate the exceedance probably and summary. | float | 9 | ||||
| EP6 | Value used to calculate the exceedance probably and summary. | float | 9 | ||||
| EP7 | Value used to calculate the exceedance probably and summary. | float | 9 | | |||
| EP8 | Value used to calculate the exceedance probably and summary. | float | 9 | | |||
| EP9 | Value used to calculate the exceedance probably and summary. | float | 9 | | |||
| EP10 | Value used to calculate the exceedance probably and summary. | float | 9 | | |||
| UncPercentile1 | Boundaries used to create the uncertainty curve. | real | 4 | ||||
| UncPercentile2 | Boundaries used to create the uncertainty curve. | real | 4 | ||||
| UncIntraPolicyCorrelationFactor | Factor used for intra-policy correlation. | real | 4 | ||||
| UncInterPolicyCorrelationFactor | Factor used for inter-policy correlation. | real | 4 | ||||
| OilPrice | Oil price used in an analysis ran using the AIR U.S. Hurricane Model for Offshore Assets. | float | 9 | ||||
| OilPriceUnitCode | Code for the unit of measure used to express the price of oil. For a complete list of codes, see tUnit Table. | varchar | 10 | ||||
| GasPrice | Gas price used in an analysis ran using the AIR U.S. Hurricane Model for Offshore Assets. | float | 9 | ||||
| GasPriceUnitCode | Code for the unit of measure used to express the price of gas. For a complete list of codes, see tUnit Table. | varchar | 10 | ||||
| SaveMAOL | Indicates whether Maximum Any One Life terms were 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 | | |||
| BaseAnalysisSID | Unique system-generated sequential identifier for the base loss analysis record used by the Loss Modification analysis. For a compete list of records, see tAnalysis Table. | int | 4 | | |||
| EP11 | Value used to calculate the exceedance probably and summary. | float | 9 | | |||
| EP12 | Value used to calculate the exceedance probably and summary. | float | 9 | | |||
| EP13 | Value used to calculate the exceedance probably and summary. | float | 9 | | |||
| EP14 | Value used to calculate the exceedance probably and summary. | float | 9 | | |||
| EP15 | Value used to calculate the exceedance probably and summary. | 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 | ||||
| StatusCode | System-provided status code for the record in the table. For a complete list of codes, see dbo.tStatus Table. | varchar | 10 | ('AX') | |||
| EventSetStandardName | Name of the event set used in the analysis. | varchar | 1000 | ('EventSTD') | |||
| EventSetProductVersion | Product version associated with the event set. This enables users to view results generated from previous version of Touchstone, even when the models are updated. Note that for old model results, event description are not accessible because catalog files no longer exist in the Touchstone system. | varchar | 10 | ('3.0.X') | |||
| AnalysisProductVersion | Version of the product used to perform the analysis. This enables users to view results generated from previous version of Touchstone, even when the models are updated. | varchar | 10 | ('3.0.X') | |||
| 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 a summary of losses by geographic zone was saved.
| 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 user has selected vulnerability set at the time of a detailed loss analysis.
| bit | 1 | ((0)) | |||
| MinMaxLogicCode | Indicates the minimum maximum cores for a loss analysis. | varchar | 3 | | |||
| SaveSubPeril | Save loss analysis results by sub peril. | bit | 1 | ((0)) | |||
| SaveTreaty | Save loss analysis results by treaty. | bit | 1 | ((0)) | |||
| SaveFacultative | Save loss analysis results by facultative. | bit | 1 | ((0)) | |||
| IsSelectedCustomFrequencySet | Indicates whether the user has selected custom event frequency set at the time of a detailed loss analysis.
| bit | 1 | ((0)) | |||
| IsApplyAIRAnalysis | Indicates whether you want to run the AIR model for a detailed loss analysis. By default, Touchstone includes AIR model for the detailed 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 information about the unique sequential identifier of the result associated with the custom event frequency set 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 |
| 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 |