Touchstone 4.0 Database Documentation
tExposureConcentrationAnalysisOption Table
Description
Stores the options used during a Geospatial 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   
 AccumulatorTypeCode

Code that represents the accumulator type for the analysis.

For a complete list of codes, see  tAccumulatorType Table.

VarChar10   
 ProgramSID

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

For a complete list of records, see tProgram Table.

Integer4  
 FacultativeOptionCode

Code that represents how the facultative option is applied.

For a complete list of codes, see tFacultativeOption Table.

VarChar10  
 CATFinancialPerspectiveCode

Code that represents the financial perspectives.

For a complete list of codes, see tFinancialPerspective Table

VarChar10  
 ApplyDisaggregation

Indicates whether aggregate locations are disaggregated.

  • 1 = Yes (disaggregate)
  • 0 = No (no disaggregation)
Boolean1 
((0))
 
 ApplyDeductibleBeforeLimitIndicates whether the location terms are applied in residential contracts.
  • 1 = Yes (saved)
  • 0 = No (not saved)
Boolean1 
((0))
 
 SaveReplacementValueIndicates whether the replacement values are saved.
  • 1 = Yes (saved)
  • 0 = No (not saved)
Boolean1 
((1))
 
 SavePremiumIndicates whether the premium is saved.
  • 1 = Yes (saved)
  • 0 = No (not saved)
Boolean1 
((0))
 
 SaveRiskCountIndicates whether the risk count is saved.
  • 1 = Yes (saved)
  • 0 = No (not saved)
Boolean1 
((1))
 
 SaveLocationCountIndicates whether the location count is saved.
  • 1 = Yes (saved)
  • 0 = No (not saved)
Boolean1 
((0))
 
 SavePrimaryCharacteristicsIndicates whether the primary characteristics are saved.
  • 1 = Yes (saved)
  • 0 = No (not saved)
Boolean1 
((1))
 
 SaveSecondaryCharacteristicsIndicates whether the secondary characteristics are saved.
  • 1 = Yes (saved)
  • 0 = No (not saved)
Boolean1 
((0))
 
 SaveLocationTermIndicates whether the location terms are saved.
  • 1 = Yes (saved)
  • 0 = No (not saved)
Boolean1 
((0))
 
 SaveContractPrimaryAttributesIndicates whether the contract's primary attributes are saved.
  • 1 = Yes (saved)
  • 0 = No (not saved)
Boolean1 
((0))
 
 SaveLayerTermIndicates whether the layer terms are saved.
  • 1 = Yes (saved)
  • 0 = No (not saved)
Boolean1 
((0))
 
 SaveGroundUpIndicates whether the Ground-Up results loss are saved.
  • 1 = Yes (saved)
  • 0 = No (not saved)
Boolean1 
((0))
 
 SaveGrossIndicates whether the Gross loss results are saved.
  • 1 = Yes (saved)
  • 0 = No (not saved)
Boolean1 
((0))
 
 SaveNetOfPreCATIndicates whether the Net-of-Pre loss results are saved.
  • 1 = Yes (saved)
  • 0 = No (not saved)
Boolean1 
((0))
 
 SavePostCATNetIndicates whether the Net-of-Post loss results are saved.
  • 1 = Yes (saved)
  • 0 = No (not saved)
Boolean1 
((0))
 
 SaveCoverage

Indicates whether coverage data for a given financial perspective is saved. For example, when Ground-Up is selected and coverage option is chosen, the resultant table would include Ground-Up loss for Coverage A, Coverage B , Coverage C, and Coverage D.

  • 1 = Yes (saved)
  • 0 = No (not saved)
Boolean1 
((0))
 
 SaveEmployeeCountIndicates whether the employee count is saved.
  • 1 = Yes (saved)
  • 0 = No (not saved)
Boolean1 
((0))
 
 SaveTotalAnnualPayrollIndicates whether the total annual payroll is saved.
  • 1 = Yes (saved)
  • 0 = No (not saved)
Boolean1 
((0))
 
 SaveCostOfLivesIndicates whether the cost of lives amount is saved.
  • 1 = Yes (saved)
  • 0 = No (not saved)
Boolean1 
((0))
 
 SaveLossCost

Indicates whether the loss costs are saved.

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

Indicates whether the loss is saved at a contract level.

  • 1 = Yes (saved)
  • 0 = No (not saved)
Boolean1 
((1))
 
 SaveByLocationIndicates whether the loss is saved at a location level.
  • 1 = Yes (saved)
  • 0 = No (not saved)
Boolean1 
((1))
 
 SaveByLayer

Indicates whether the loss is saved at a layer level.

  • 1 = Yes (saved)
  • 0 = No (not saved)
Boolean1 
((1))
 
 EnableDynamicResultBrowsingIndicates whether the ability to browse results is enabled.
  • 1 = Yes (enabled)
  • 0 = No (disabled)
Boolean1 
((1))
 
 IsWorkersCompSelected

Indicates whether the worker's compensation option was selected.

  • 1 = Yes (selected)
  • 0 = No (not selected)
Boolean1 
((0))
 
Objects that depend on tExposureConcentrationAnalysisOption
 Database ObjectObject TypeDescriptionDep Level
tECAAreaZoneOption tabletECAAreaZoneOptionTableStores the zone set identifiers used during a Geospatial analysis.3
tECACustomSaveOption tabletECACustomSaveOptionTableStores user-defined accumulators that are used in a Geospatial analysis. Reserved for future use.3
tECARingDefinition tabletECARingDefinitionTableStores information regarded the rings used during a Geospatial analysis.4
tECARingGeoMatchLevelOption tabletECARingGeoMatchLevelOptionTableStores information about the geocode match level achieved during the Geospatial \analysis.4
tECARingLandmarkOption tabletECARingLandmarkOptionTableStores information about the landmarks used during a Geospatial analysis.4
tECARingLocationList tabletECARingLocationListTableStores information about the locations included in the Geospatial analysis.4
tECARingOption tabletECARingOptionTableStores information about the ring options selected for the Geospatial analysis.3
tECASpatialDataSetBucketDefinition tabletECASpatialDataSetBucketDefinitionTableStores information that defines the buckets used in a Geospatial analysis. A bucket is a range of attribute values that is analyzed as a single entity with a single damage ratio; For example, a bucket of wind speed could be 60 – 70 miles per hour.4
tECASpatialDataSetBucketDetail tabletECASpatialDataSetBucketDetailTableStores information regarding the data set bucket used during the Geospatial analysis. A bucket is a range that is analyzed as a single entity with a single damage ratio; For example, a bucket of wind speed could be 60 – 70 miles per hour.5
tECASpatialDataSetOption tabletECASpatialDataSetOptionTableStores information regarding the spatial data set options used during the Geospatial analysis.3
tECASpatialEventOption tabletECASpatialEventOptionTableStores information regarding the events for each model to include during the Geospatial analysis.3
tECASpatialLossOption tabletECASpatialLossOptionTableStores information regarding the loss analysis options used during the Geospatial analysis.3
Objects that tExposureConcentrationAnalysisOption 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.