Touchstone 4.0 Database Documentation
tNonCatAnalysisOption Table
Description
Stores analysis options used during a non-catastrophe Loss analysis.
Properties
Creation Date5/31/2016 9:45 AM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows0
Data Space Used0.00 KB
Index Space Used0.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key AnalysisSID

Unique system-generated sequential identifier for the analysis  record.

For a complete list of records, see tAnalysis Table 

Integer4   
 ProgramSID

Unique system-generated sequential identifier for the reinsurance program record.

For a complete list of records, see tProgram Table.

Integer4  
 LossCostType

Type of loss cost calculator used during the non-catastrophe loss analysis. This calculator type is selected by the user on the Detailed Loss Configuration screen.

For a complete list of codes, see dbo.tLossCostType Table.

VarChar10   
 PerilSetCode

Numeric code for the single peril or set of perils.

For a complete list of codes, see tPerilSet Table.

Integer4  
 LossDistributionTypeType of distribution to layer or loss cost reinsurance.VarChar10  
 CustomLossCostTemplateSID

Unique system-generated sequential identifier for the custom loss cost template record.

For a complete list of records, see tCustomLossCostTemplateRule Table.

Integer4  
 CPLossTrendFromDate

Commercial Property Loss Trend From Date - represents the midpoint of the experience and cannot be modified.

DBTimeStamp4  
 CPLossTrendToDateCommercial Property Loss Trend To Date - users can modify.DBTimeStamp4  
 CPLossTrendFactorThe amount by which the annual loss trend is greater than the annual exposure trend for commercial property.Double9  
 HOLossTrendFromDateHomeowner (Residential) Property Loss Trend From Date - represents the midpoint of the experience and cannot be modified.DBTimeStamp4  
 HOLossTrendToDateHomeowner Property Loss Trend To Date - users can modify.DBTimeStamp4  
 HOLossTrendFactorThe amount by which the annual loss trend is greater than the annual exposure trend for homeowner property.Double9  
 AOITrendFromDateAmount of Insurance (AOI) Trend From Date - represents the midpoint of the experience and cannot be modified.DBTimeStamp4  
 AOITrendToDateAmount of Insurance (AOI) Trend To Date - users can modify.DBTimeStamp4  
 AOITrendFactorThe amount by which the annual loss trend is greater than the annual exposure trend for property.Double9  
 AOIAdjustmentFactorAdjustment factor that applies to the Amount of Insurance (AOI) for all the exposure data values stored. Default is 1.Double9  
 LossScalingFactorApplies to all the location loss value stored.Double9  
 CPPercentCapPercentage used to Calculate Limited Average Severity for the Commercial property treaty.Single4  
 HOPercentCapPercentage used to Calculate Limited Average Severity for the Residential home owners property treaty.Single4  
 IsHOPolicyForm2and3Enabled

Indicates whether home owners policy form 2 and 3 is enabled.

  • 1 = Yes (enabled)
  • 0 = No (disabled)

For a complete list of codes, see FormCode in [AIRPSOLD].[dbo].[tISOformCode].  Note this database is available by license only.

Boolean1  
 IsHOPolicyForm5Enabled

Indicates whether home owners policy form 5 is enabled.

  • 1 = Yes (enabled)
  • 0 = No (disabled)

For a complete list of codes, see FormCode in [AIRPSOLD].[dbo].[tISOformCode].  Note this database is available by license only.

Boolean1  
 SaveByContract

Indicates whether the loss results are saved at the contract-level.

  • 1 = Yes (saved)
  • 0 = No (not saved)
Boolean1   
 SaveByLayer

Indicates whether the loss results are saved at the layer-level.

  • 1 = Yes (saved)
  • 0 = No (not saved)
Boolean1   
 SaveByLocation

Indicates whether the loss results are saved at the location-level.

  • 1 = Yes (saved)
  • 0 = No (not saved)
Boolean1   
 SaveGroundUp

Indicates whether Ground-up loss results are saved.

  • 1 = Yes (saved)
  • 0 = No (not saved)
Boolean1 
((0))
 
 SaveGross

Indicates whether Gross loss results are saved.

  • 1 = Yes (saved)
  • 0 = No (not saved)
Boolean1 
((0))
 
 SaveRetained

Indicates whether Retained loss results are saved.

  • 1 = Yes (saved)
  • 0 = No (not saved)
Boolean1 
((0))
 
 SaveNetOfPreCAT

Indicates whether Net-of-Pre loss results are saved.

  • 1 = Yes (saved)
  • 0 = No (not saved)
Boolean1 
((0))
 
 LossCostAdjustmentTemplateSID

Unique system-generated sequential identifier for the loss cost adjustment template record.

For a complete list of records, see tLossCostAdjustmentTemplateRule Table.

Integer4  
 DeductibleOptionCode

Code that represents the loss type to which the deductible is to be applied.

For a complete list of codes, see tDeductibleOption Table

VarChar10  
 PPCCode

Code that represents the Public Protection Class.  

For a complete list of codes, see tPublicProtectionClass Table.

VarChar10   
 IsSprinklersEnabled

Indicates whether sprinklers are enabled within the structure.

  • 1 = Yes (enabled)
  • 0 = No (disabled)
Boolean1   
 CoverageMappingCode

Stores the coverage mapping code.

  • BPC = Building and Property
  • CMB – Combined Building Property plus Time element
VarChar10  
 LossDistributionParametersPathStores the file path, which contains the combined exponential weights data.VarChar4000  
 IsCountrywideOverrideEnabled

Indicates whether a country-wide override is enabled. 

  • 1 = Yes (enabled)
  • 0 = No (disabled)
Boolean1  
 PerilGroupCode

Code that represents the ISO peril groups for commercial, non-catastrophe analyses.

For a complete list of codes, see dbo.tNonCatPerilGroup Table.

VarChar5  
 PreserveNonCATGroundUpLoss

Indicates whether the non-catastrophe Ground-Up loss should be preserved.

  • 1 = Yes (preserve)
  • 0 = No (discard)

This enables users to view results generated from previous version of Touchstone,  even when the models are updated.

Boolean1 
((0))
 
Check Constraints
NameDescriptionExpression
CKC_SAVEGROSS_TNONCATA 
([SaveGross]>=(0) AND [SaveGross]<=(1))
CKC_SAVEGROUNDUP_TNONCATA 
([SaveGroundUp]>=(0) AND [SaveGroundUp]<=(1))
CKC_SAVENETOFPRECAT_TNONCATA 
([SaveNetOfPreCAT]>=(0) AND [SaveNetOfPreCAT]<=(1))
CKC_SAVERETAINED_TNONCATA 
([SaveRetained]>=(0) AND [SaveRetained]<=(1))
Objects that tNonCatAnalysisOption depends on
 Database ObjectObject TypeDescriptionDep Level
tAnalysis tabletAnalysisTableStores information about each sub-section of the activity output. Each activity task creates and writes to this table as the task is performed.1
tDataServer tabletDataServerTableStores information about each data server used in the project, including its sequential identifier (SID), name, description, connection information, and default MDF and LDF paths.3
tDataSource tabletDataSourceTableStores information about the data source used for the Touchstone project. A data source is a database that is registered with the Touchstone application.2
tProject tabletProjectTableStores information regarding the project, such as project name and status code.1
See Also

Related Objects

AIRProject Database

 

 


AIR Client Confidential

© 2016. AIR Worldwide is a registered trademark. Touchstone is a registered trademark of AIR Worldwide.

Please contact AIR Worldwide with questions or comments. For database questions. For documentation comments.