Stores the loss analysis options used to generate company loss file (CLF) sets that users exported from Touchstone to Touchstone Re.
Touchstone Re 2022 Database Reference
tCLEXPORT_LossAnalysisOption Table
| Creation Date | 4/4/2022 3:03 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 associated with the CLF. | int | 4 | ||||
| CurrencyCode | ISO 3-character code for the currency associated with the CLF. For a complete list of codes, see tCurrency Table. | char | 3 | ||||
| ResultDataSourceName | Name of the database that stores the analysis results associated with the CLF. | varchar | 255 |  | |||
| ResultSID | Unique system-generated sequential identifier for the analysis results associated with the CLF. | int | 4 | ||||
| PerilSetCode | Numeric code for the peril or set of perils associated with the CLF. For a complete list of codes, see tPerilSet Table | int | 4 | ||||
| EventSetSID | Unique system-generated sequential identifier for the Touchstone event set associated with the CLF. | int | 4 | ||||
| EventSet | Name of the event set. | varchar | 255 | ||||
| EventFilter | XML string that defines the filters applied to the event set. | xml | 0 | | |||
| ProgramSID | Unique system-generated sequential identifier for the Touchstone reinsurance program associated with the CLF. For a complete list of records, see tProgram Table in the Touchstone AIRReinsurance database. | int | 4 | | |||
| ProgramID | Identifier for the reinsurance program. | varchar | 100 | | |||
| ProgramDescription | User-specified description of the reinsurance program. | varchar | 4000 | | |||
| FacultativeOptionCode | Code that represents how facultative reinsurance was applied during the analysis. For a complete list of codes, see tFacultativeOption Table. | varchar | 10 | | |||
| CATFinancialPerspectiveCode | Code that represents the financial perspective that Touchstone applied any catastrophe excess of loss treaties to. 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 generated during the analysis. For a complete list of codes, see tOutputDetailedAAL Table. | varchar | 10 | | |||
| GeoLevelCode | Code that represents the geographic level of the losses. For a complete list of codes, see tGeoLevel Table. | varchar | 10 | | |||
| OutputGroupByCode | Code that represents the category that the losses are grouped by. For a complete list of codes, see tOutputGroupBy Table. | varchar | 10 | | |||
| AveragePropertyOptionCode | Code that indicated whether the average properties option was enabled during the analysis. For a complete list of codes, see tAveragePropertyOption Table. | varchar | 10 | | |||
| ApplyDisaggregation | Indicates whether the disaggregation option was enabled during the analysis.
| bit | 1 | ||||
| ApplyDeductibleBeforeLimit | Indicated whether Touchstone applied deductibles before limits for residential contracts. Touchstone always applies deductibles before limits for commercial contracts.
| bit | 1 | ||||
| RemapConstructionOccupancy | Indicates whether invalid construction and occupancy class code combinations were remapped to default combinations during the analysis.
| bit | 1 | ||||
| EnableCorrelation | Indicates whether correlation was enabled during the analysis.
| bit | 1 | ||||
| DemandSurgeOptionCode | Code that indicates how demand surge was applied. For a complete list of codes, see tDemandSurgeOption Table. | varchar | 10 | ||||
| MoveMarineCraftGeocodesToCoast | Indicates whether geocodes for marine craft were changed to coastline geocodes during the analysis.
| bit | 1 | ||||
| SaveGroundUp | Indicates whether ground-up losses were saved during the analysis.
| bit | 1 | ||||
| SaveRetained | Indicates whether retained losses were saved during the analysis.
| bit | 1 | ||||
| SavePreLayerGross | Indicates whether pre-layer gross losses were saved during the analysis.
| bit | 1 | ||||
| SaveGross | Indicates whether gross losses were saved during the analysis.
| bit | 1 | ||||
| SaveNetOfPreCAT | Indicates whether net of pre-catastrophe losses were saved during the analysis.
| bit | 1 | ||||
| SavePostCATNet | Indicates whether post-catastrophe net losses were saved during the analysis.
| bit | 1 | ||||
| SaveCoverage | Indicates whether losses were saved by coverage for each financial perspective.
| bit | 1 | ||||
| SaveInjury | Reserved for future use. | bit | 1 | ||||
| SaveClaims | Indicates whether claims counts were saved.
| bit | 1 | ||||
| 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 | Boundary used to create the uncertainty curve. The value represents the upper range of the confidence level. The default is 5.00%. | real | 4 | ||||
| UncPercentile2 | Boundary used to create the uncertainty curve. The value represents the lower range of the confidence level. The default is 5.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 from tDefaultLossAnalysisOption Table. | float | 9 | ||||
| OilPriceUnitCode | Code for the unit of measure associated with the oil price. 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 associated with the gas price. For a complete list of codes, see tUnit Table. | varchar | 10 | ||||
| SaveMAOL | Indicates whether Maximum Any One Life terms were saved.
| bit | 1 | ||||
| MAOLMinor | Medical Minor (Limit 1) term applied during the analysis. | float | 9 | | |||
| MAOLModerate | Medical Moderate (Limit 1) term applied during the analysis. | float | 9 | | |||
| MAOLMajor | Medical Major (Limit 1) term applied during the analysis. | float | 9 | | |||
| MAOLFatal | Medical Fatal (Limit 1) term applied during the analysis. | float | 9 | | |||
| BaseAnalysisSID | Unique system-generated identifier for the base analysis. For a complete list of records, see tAnalysis Table. | int | 4 | | |||
| 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 applied during the analysis. | 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-generated code that represents the status of the record. For a complete list of codes, see tStatus Table. | varchar | 10 | ||||
| EventSetStandardName | Name of the event set used during the analysis. | varchar | 1000 | ||||
| EventSetProductVersion | Product version associated with the event set. | varchar | 10 | ||||
| AnalysisProductVersion | Product version used to perform the analysis. | varchar | 10 | ||||
| ComponentCode | Code that represents the component (or model) used during the analysis. | varchar | 10 | | |||
| SaveSummaryByPeril | Indicates whether a summary of losses by peril was saved.
| bit | 1 | ||||
| SaveSummaryByModel | Indicates whether a summary of losses by model was saved.
| bit | 1 | ||||
| SaveZone | Indicates whether losses were saved by zone.
| bit | 1 | ||||
| IsPreviousVersionModel | Indicates whether the event set included in the analysis corresponds to the current or previous version of the AIR models.
| bit | 1 | ((0)) |