Touchstone 4.0 Database Documentation
tDataQualityAnalysisOption Table
Description
Stores information regarding the augmentation of data during a Data Quality analysis.
Properties
Creation Date5/31/2016 9:45 AM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows2
Data Space Used8.00 KB
Index Space Used8.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   
 AUGMode

Augmentation mode option for a Data Quality analysis. 

  • Preview
  • Destructive
  • Non-destructive
Integer4  
 AUGDestinationTarget

Name of the newly created exposure view for non-destructive augmentation mode. 

VarChar255  
 AUGDestinationTargetSID

Unique system-generated sequential identifier for the newly created exposure view  record.  This is applicable for non-destructive augmentation mode.

For a complete list of records, see tExposureView Table.

Integer4  
 AUGTypeAugmentation format.Integer4  
 IsAUGTrueExposureEnabled

Indicates whether the exposure is to be enhanced using AIR Property Data.

  • 1 = Yes (enhance)
  • 0 = No (do not enhance)
Boolean1  
 IsAUGUserSpecifiedEnabled

Indicates whether the augmentation is to utilize user-specified values.

  • 1 = Yes (use)
  • 0 = No (do not use)
Boolean1  
 IsAUGDetailConsistencyEnabled

Indicates whether the augmentation consistency report is to be generated.

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

Indicates whether completeness rules are enabled for use during the Data Quality – Validation analysis.

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

Indicates whether reasonability rules are enabled for use during the Data Quality – Validation analysis.

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

Indicates whether scoring is enabled for use during the Data Quality analysis.

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

Indicates whether the location peril is enabled for use in the Data Quality analysis scoring report.

  • 1 = Yes (enabled)
  • 0 = No (disabled)
Boolean1  
 ExpFilterRiskIndexOperationRisk index filter operator used for scoring. For example, ‘>’ or ‘<’.VarChar50  
 ExpFilterRiskIndexValueRisk index filter value used along with ExpFilterRiskIndexOperation.Double9  
 ExpFilterTRVValueTotal replacement value filter value used along with ExpFilterTRVOperation.Double9  
 ExpFilterTRVOperationTotal replacement value filter operator. For example, ‘>’ or ‘<’.VarChar50  
 PreAugmentationIdSystem-generated identifier of the exposure data set before augmentation.BigInt8  
 PostAugmentationIdSystem-generated identifier of the exposure data set after augmentation.BigInt8  
 ExpFilterDataQualityScoreOperationScore filter operator used during a Data Quality analysis. For example, ‘>’ or ‘<’.VarChar50  
 ExpFilterDataQualityScoreValueScore filter value used along with ExpFilterDataQualityScoreOperation during a Data Quality analysis.Double9  
 VersionVersion of the exposure data used in the analysis.VarChar20  
 IsFilterEnabled

Indicates whether the filter is enabled for use during the Data Quality - Augmentation analysis.   

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

Indicates whether a full or default log should be generated for the report.

  • 1 = Yes (full log)
  • 0 = No (default log)
Boolean1  
 DQSettingTypeSID

Unique system-generated sequential identifier for the Data Quality analysis settings record.

For a complete list of records, see tDQAnalysisSetting Table

Integer4  
 DQSettingvalueXML expression for the settings used during a Data Quality analysis. Used internally by Touchstone.VarChar8000  
 AUGExcludedLocationsFileNameName of the file that identifies the locations to be excluded from augmentation.VarChar4000  
 AUGExposureSetSuffixReserved for future use.VarChar50  
 ScoringPerilOptionCodeAlpha-numeric codes that are used within the database. These codes flag the peril data against which the scoring report needs to be generated. VarChar5  
 PerilSetCode

Numeric code for the single peril or set of perils.

For a complete list of codes, see tPerilSet Table.

Integer4  
Objects that depend on tDataQualityAnalysisOption
 Database ObjectObject TypeDescriptionDep Level
tDataQualityAnalysisOutputOption tabletDataQualityAnalysisOutputOptionTableStores the output options for a Data Quality analysis.3
tDQAnalysisRule tabletDQAnalysisRuleTableStores data relating to the rules used in a Data Quality analysis.5
tDQAnalysisRuleSet tabletDQAnalysisRuleSetTableStores information regarding the rule sets used during a Data Quality analysis.4
tDQAnalysisRuleSetRuleSubTypeSelected tabletDQAnalysisRuleSetRuleSubTypeSelectedTableStores information regarding the rule sub type used during the Data Quality analysis.5
tDQAnalysisSetting tabletDQAnalysisSettingTableStores information regarding the analysis settings used during a Data Quality analysis.4
tDQIndustryFilterLOB tabletDQIndustryFilterLOBTableStores the type of output of the Data Quality analysis and the Line of Business of the insured properties to include in the output results.4
Objects that tDataQualityAnalysisOption 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.