Stores default loss analysis options, such as the EP points to include in the analysis results.
Touchstone 2022 Database Reference
tDefaultLossAnalysisOption Table
Stores default loss analysis options, such as the EP points to include in the analysis results.
| Creation Date | 4/4/2022 3:02 AM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 3 |
| Data Space Used | 8.00 KB |
| Index Space Used | 56.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | DefaultLossAnalysisOptionSID | Unique system-generated sequential identifier for the default loss analysis options record. | int | 4 | |||
| BusinessUnitSID | Unique system-generated sequential identifier for the business unit associated with the default loss analysis options. | int | 4 | ||||
| EP1 | Default value for the first point on the exceedance probability curve. | float | 9 |  | |||
| EP2 | Default value for the second point on the exceedance probability curve. | float | 9 | | |||
| EP3 | Default value for the third point on the exceedance probability curve. | float | 9 | | |||
| EP4 | Default value for the fourth point on the exceedance probability curve. | float | 9 | | |||
| EP5 | Default value for the fifth point on the exceedance probability curve. | float | 9 | | |||
| EP6 | Default value for the sixth point on the exceedance probability curve. | float | 9 | | |||
| EP7 | Default value for the seventh point on the exceedance probability curve. | float | 9 | | |||
| EP8 | Default value for the eighth point on the exceedance probability curve. | float | 9 | | |||
| EP9 | Default value for the ninth point on the exceedance probability curve. | float | 9 | | |||
| EP10 | Default value for the tenth point on the exceedance probability curve. | float | 9 | | |||
| DisplayEPReturnPeriod | Indicates whether the application displays results by return period.
| bit | 1 | ((1)) | |||
| OilPrice | Default oil price that the application uses for the offshore drilling industry. | float | 9 | ||||
| OilPriceUnitCode | Code for the unit of measure used to express the oil price. For a complete list of codes, see tUnit Table. | varchar | 10 | ||||
| GasPrice | Default gas price that the application uses for the offshore drilling industry. | 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 | ||||
| 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 | ||||
| MoveMarineCraftGeocodesToCoast | Indicates whether the application changes marine craft geocodes are to coastline geocodes during a loss analysis.
| bit | 1 | ||||
| EP11 | Default value for the eleventh point on the exceedance probability curve. | float | 9 | | |||
| EP12 | Default value for the twelfth point on the exceedance probability curve. | float | 9 | | |||
| EP13 | Default value for the thirteenth point on the exceedance probability curve. | float | 9 | | |||
| EP14 | Default value for the fourteenth point on the exceedance probability curve. | float | 9 | | |||
| EP15 | Default value for the fifteenth point on the exceedance probability curve. | float | 9 | | |||
| IsInvestmentAmount | Not used by Touchstone. | bit | 1 | | ((0)) | ||
| IsExpectedLoss | Not used by Touchstone. | bit | 1 | | ((0)) | ||
| IsExhaustionProbability | Not used by Touchstone. | bit | 1 | | ((0)) | ||
| IsAttachmentProbability | Not used by Touchstone. | bit | 1 | | ((0)) | ||
| MinMaxLogicCode | Code that represents the MinMaxLogicCode. | varchar | 3 | |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tForestryLandPrice | Table | Stores information about the per-hectare unit price for forestry land in Finland, Norway, and Sweden. | 1 |