Stores some of the options used during aggregate loss analyses. Touchstone Re stores additional options in tAggregateLossAnalysisOption Table.
Touchstone Re 2022 Database Reference
tLossAnalysisOption Table
| Creation Date | 4/11/2022 6:17 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 tReinsuranceEventSet 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 tReinsuranceProgram Table. | int | 4 | | |||
| ProgramID | Identifier for the reinsurance program, if one was applied in this analysis. | varchar | 100 | | |||
| ProgramDescription | User-specified 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. | 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. | varchar | 10 | ||||
| OutputDetailedAALCode | Code that represents the type of AAL summary that was output for the analysis. | 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. | varchar | 10 | | |||
| AveragePropertyOptionCode | Code that indicates whether the average properties option was enabled. | 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 | Indicates whether demand surge was enabled.
| 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 | Boundary used to create the uncertainty curve. | real | 4 | ||||
| UncPercentile2 | Boundary 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 Touchstone loss modification template. | 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 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 losses were saved by zone.
| bit | 1 | ((0)) | |||
| IsPreviousVersionModel | Not used by Touchstone Re. | 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 | bit | 1 | ((0)) | ||||
| SaveTreaty | bit | 1 | ((0)) | ||||
| SaveFacultative | bit | 1 | ((0)) | ||||
| IsSelectedCustomFrequencySet | bit | 1 | ((0)) | ||||
| IsApplyAIRAnalysis | bit | 1 | |