Touchstone Re 2022 Database Reference
tDefaultEnterpriseOption Table
AIRUserSetting Database : tDefaultEnterpriseOption Table
Description

Stores administrator-specified default values for each business unit. For example, an administrator can specify that the demand surge option is enabled by default for all analyses in a given business unit.

The application uses the values to pre-fill fields. However, users can optionally override the default values.

The application stores additional defaults in tDefaultUserOption Table.

Properties
Creation Date4/4/2022 3:02 AM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows3
Data Space Used8.00 KB
Index Space Used8.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key Unique system-generated sequential identifier for the set of defaults. int4   
 Unique system-generated sequential identifier for the business unit associated with the set of defaults.int4   
 Default value for the London Interbank Offered Rate (LIBOR).float9   
 

Indicates whether the option to use the latest Industry Exposure Database during analyses will be enabled by default.

  • 1 = Yes (enabled)
  • 0 = No (not enabled)
bit1 
((0))
 
 Default reinsurance type code for new reinsurance programs.varchar10  
 Default inception date for treaties.date8  
 Default expiration date for treaties.date8  
 

System-generated status code for the record in the table.

For a complete list of codes, see tStatus Table.

varchar10  
 

ISO 3-character code for the default currency.

For a complete list of codes, see tCurrency Table.

char3  
 

Numeric code for the default single peril or set of perils used during analyses.

For a complete list of codes, see tPerilSet Table.

int4  
 

Indicates whether the demand surge option is enabled by default during analyses.

  • 1 = Yes (enabled)
  • 0 = No (not enabled)
bit1 
((0))
 
 

Indicates whether the loss market share option is enabled by default during analyses.

  • 1 = Yes (enabled)
  • 0 = No (not enabled)
bit1 
((0))
 
 

Indicates whether the reinsurance program covers agricultural losses.

The default coverage is 100%. However, user can override the default value.

float9 
((100.00))
 
 

Indicates whether the reinsurance program covers workers' compensation losses.

The default coverage is 100%. However, user can override the default value.

float9 
((100.00))
 
 

Indicates whether the reinsurance program covers offshore physical damage (PD) losses.

The default coverage is 100%. However, user can override the default value.

float9 
((0))
 
 

Indicates whether the reinsurance program covers offshore removal of debris (ROD) losses.

The default coverage is 100%. However, user can override the default value.

float9 
((0))
 
 

Indicates whether the reinsurance program covers operator's extra expenses (OEE) losses.

The default coverage is 100%. However, user can override the default value.

float9 
((0))
 
 

Indicates whether the reinsurance program covers offshore business interruption (BI) losses.

The default coverage is 100%. However, user can override the default value.

float9 
((0))
 
 

Indicates whether the reinsurance program covers forestry losses.

The default coverage is 100%. However, user can override the default value.

float9 
((100.00))
 
 

Indicates whether the reinsurance program covers residential losses.

The default coverage is 100%. However, user can override the default value.

float9 
((100.00))
 
 

Indicates whether the reinsurance program covers commercial losses.

The default coverage is 100%. However, user can override the default value.

float9 
((100.00))
 
 

Indicates whether the reinsurance program covers auto losses.

The default coverage is 100%. However, user can override the default value.

float9 
((100.00))
 
 Default market trend factor.float9  
 Default loss modification factor. float9  
 Code that represents the default in force date for portfolios.varchar10  
 

Indicates whether the reinsurance program covers multiple-peril crop insurance losses in China for the Corn line of business.

The default coverage is 100%. However, user can override the default value.

float9 
((1))
 
 

Indicates whether the reinsurance program covers multiple-peril crop insurance losses in China for the Cotton line of business.

The default coverage is 100%. However, user can override the default value.

float9 
((1))
 
 

Indicates whether the reinsurance program covers multiple-peril crop insurance losses in China for the Rapeseed line of business.

The default coverage is 100%. However, user can override the default value.

float9 
((1))
 
 

Indicates whether the reinsurance program covers multiple-peril crop insurance losses in China for the Rice line of business.

The default coverage is 100%. However, user can override the default value.

float9 
((1))
 
 

Indicates whether the reinsurance program covers multiple-peril crop insurance losses in China for the Soybean line of business.

The default coverage is 100%. However, user can override the default value.

float9 
((1))
 
 

Indicates whether the reinsurance program covers multiple-peril crop insurance losses in China for the Wheat line of business.

The default coverage is 100%. However, user can override the default value.

float9 
((1))
 
 

Indicates whether the reinsurance program covers multiple-peril crop insurance losses in China for the Crop Combined line of business.

The default coverage is 100%. However, user can override the default value.

float9 
((1))
 
 

Indicates whether the reinsurance program covers multiple-peril crop insurance losses in China for the Forestry line of business.

The default coverage is 100%. However, user can override the default value. 

float9 
((1))
 
 

Indicates whether the user selected the CustomLOB option for the business unit.

  • Yes = 1 (CustomLOBOn)
  • No = 0 (CustomLOB not selected)
bit1 
((0))
 
 The default coverage is 100%. However, user can override the default value.float9 
((1))
 
 Unique system-generated sequential identifier for the business unit.int4 
((1))
 
 Number of reinstatements.int4 
((1))
 
 Indicates the reinsurance premium amount associated with the business unit.float9 
((100.00))
 
 Indicates the amount.float9 
((-1.00))
 
 Indicates the time limit.float9 
((100.00))
 
 

Indicates whether the reinsurance program covers loss in barley crop.

The default coverage is 100%. However, user can override the default value.

float9 
((1))
 
 

Indicates whether the reinsurance program covers insurance loss in peanut crop.

The default coverage is 100%. However, user can override the default value.

float9 
((1))
 
 

Indicates whether the reinsurance program covers insurance loss in potato crop.

The default coverage is 100%. However, user can override the default value.

float9 
((1))
 
 

Indicates whether the reinsurance program covers insurance loss in sugar crop.

The default coverage is 100%. However, user can override the default value.

float9 
((1))
 
 

Indicates whether the reinsurance program covers insurance loss in rubber.

The default coverage is 100%. However, user can override the default value.

float9 
((1))
 
 

Indicates whether the reinsurance program covers inusrance loss in cattle. 

The default coverage is 100%. However, user can override the default value.

float9 
((1))
 
 

Indicates whether the reinsurance program covers for other cattle.

The default coverage is 100%. However, user can override the default value.

float9 
((1))
 
 

Indicates whether the reinsurance program covers insurance loss for breeding sow.

The default coverage is 100%. However, user can override the default value.

float9 
((1))
 
 

Indicates whether the reinsurance program covers insurance loss for pig.

The default coverage is 100%. However, user can override the default value.

float9 
((1))
 
 

Indicates whether the reinsurance program covers insurance loss for poultry.

The default coverage is 100%. However, user can override the default value.

float9 
((1))
 
 

Indicates whether the reinsurance program covers insurance loss for sheep.

The default coverage is 100%. However, user can override the default value.

float9 
((1))
 
 

Indicates whether the reinsurance program covers insurance loss for livestock.

The default coverage is 100%. However, user can override the default value.

float9 
((1))
 
  date8  
Check Constraints
NameDescriptionExpression
 
([ExpirationDate]>=[InceptionDate])
Objects that depend on tDefaultEnterpriseOption
 Database ObjectObject TypeDescriptionDep Level
tDefaultTerrorismOption tabletDefaultTerrorismOptionTableStores the administrator-defined default terrorism option for loss analyses.1
See Also

Related Objects

AIRUserSetting Database