Touchstone 4.0 Database Documentation

tDefaultLossAnalysisOption Table

AIRUserSetting Database : tDefaultLossAnalysisOption Table |

Description

Stores the default Loss analysis options.

Properties

Creation Date | 5/31/2016 9:46 AM |

File Group | PRIMARY |

Text File Group | |

System Object | |

Published for Replication | |

Rows | 2 |

Data Space Used | 8.00 KB |

Index Space Used | 56.00 KB |

Columns

Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
---|---|---|---|---|---|---|---|

DefaultLossAnalysisOptionSID | Unique system-generated sequential identifier for the default loss analysis options record. | Integer | 4 | ||||

BusinessUnitSID | Unique system-generated sequential identifier for the business unit record. | Integer | 4 | ||||

EP1 | Value for the first point on the exceedance probability curve. | Double | 9 | ||||

EP2 | Value for the second point on the exceedance probability curve. | Double | 9 | ||||

EP3 | Value for the third point on the exceedance probability curve. | Double | 9 | ||||

EP4 | Value for the fourth point on the exceedance probability curve. | Double | 9 | ||||

EP5 | Value for the fifth point on the exceedance probability curve. | Double | 9 | ||||

EP6 | Value for the sixth point on the exceedance probability curve. | Double | 9 | ||||

EP7 | Value for the seventh point on the exceedance probability curve. | Double | 9 | ||||

EP8 | Value for the eighth point on the exceedance probability curve. | Double | 9 | ||||

EP9 | Value for the ninth point on the exceedance probability curve. | Double | 9 | ||||

EP10 | Value for the tenth point on the exceedance probability curve. | Double | 9 | ||||

DisplayEPReturnPeriod | Indicates whether the results are to be displayed by return period. - 1 = Yes
- 0 = No
| Boolean | 1 | `((1))` | |||

OilPrice | Default oil price, used for the offshore drilling industry. | Double | 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 | Default gas price, used for the offshore drilling industry. | Double | 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%. | Single | 4 | ||||

UncPercentile2 | Boundaries used to create the uncertainty curve, , represents the lower range of the confidence level. The default is 95.00%. | Single | 4 | ||||

UncIntraPolicyCorrelationFactor | Default percentage of correlation between locations within a contract. | Single | 4 | ||||

UncInterPolicyCorrelationFactor | Default percentage of correlation between contracts in a portfolio. | Single | 4 | ||||

MoveMarineCraftGeocodesToCoast | Indicates whether the marine craft geocodes are moved to the coastline during a loss analysis. - 1 = Yes (moved)
- 0 = No (not moved)
| Boolean | 1 | ||||

EP11 | Value for the eleventh point on the exceedance probability curve. | Double | 9 | ||||

EP12 | Value for the twelfth point on the exceedance probability curve. | Double | 9 | ||||

EP13 | Value for the thirteenth point on the exceedance probability curve. | Double | 9 | ||||

EP14 | Value for the fourteenth point on the exceedance probability curve. | Double | 9 | ||||

EP15 | Value for the fifteenth point on the exceedance probability curve. | Double | 9 |

Objects that depend on tDefaultLossAnalysisOption

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 |

See Also