Stores information regarding the augmentation of data during a Data Quality analysis.
Touchstone 2022 Database Reference
tDataQualityAnalysisOption Table
| Creation Date | 4/4/2022 3:02 AM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 2 |
| Data Space Used | 8.00 KB |
| Index Space Used | 8.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | AnalysisSID | Unique system-generated sequential identifier for the analysis record. For a complete list of records, see tAnalysis Table. | int | 4 | |||
| AUGMode | Augmentation mode option for a Data Quality analysis.
| int | 4 |  | |||
| AUGDestinationTarget | Name of the newly created exposure view for non-destructive augmentation mode. | varchar | 255 | | |||
| 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. | int | 4 | | |||
| AUGType | Augmentation format. | int | 4 | | |||
| IsAUGTrueExposureEnabled | Indicates whether the exposure is to be enhanced using AIR Property Data.
| bit | 1 | | |||
| IsAUGUserSpecifiedEnabled | Indicates whether the augmentation is to utilize user-specified values.
| bit | 1 | | |||
| IsAUGDetailConsistencyEnabled | Indicates whether the augmentation consistency report is to be generated.
| bit | 1 | | |||
| IsDQACompletenessEnabled | Indicates whether completeness rules are enabled for use during the Data Quality – Validation analysis.
| bit | 1 | | |||
| IsDQAReasonabilityEnabled | Indicates whether reasonability rules are enabled for use during the Data Quality – Validation analysis.
| bit | 1 | | |||
| IsDQAScoringEnabled | Indicates whether scoring is enabled for use during the Data Quality analysis.
| bit | 1 | | |||
| IsLocationPerilEnabled | Indicates whether the location peril is enabled for use in the Data Quality analysis scoring report.
| bit | 1 | | |||
| ExpFilterRiskIndexOperation | Risk index filter operator used for scoring. For example, ‘>’ or ‘<’. | varchar | 50 | | |||
| ExpFilterRiskIndexValue | Risk index filter value used along with ExpFilterRiskIndexOperation. | float | 9 | | |||
| ExpFilterTRVValue | Total replacement value filter value used along with ExpFilterTRVOperation. | float | 9 | | |||
| ExpFilterTRVOperation | Total replacement value filter operator. For example, ‘>’ or ‘<’. | varchar | 50 | | |||
| PreAugmentationId | System-generated identifier of the exposure data set before augmentation. | bigint | 8 | | |||
| PostAugmentationId | System-generated identifier of the exposure data set after augmentation. | bigint | 8 | | |||
| ExpFilterDataQualityScoreOperation | Score filter operator used during a Data Quality analysis. For example, ‘>’ or ‘<’. | varchar | 50 | | |||
| ExpFilterDataQualityScoreValue | Score filter value used along with ExpFilterDataQualityScoreOperation during a Data Quality analysis. | float | 9 | | |||
| Version | Version of the exposure data used in the analysis. | varchar | 20 | | |||
| IsFilterEnabled | Indicates whether the filter is enabled for use during the Data Quality - Augmentation analysis.
| int | 4 | | |||
| DetailedLog | Indicates whether a full or default log should be generated for the report.
| bit | 1 | | |||
| DQSettingTypeSID | Unique system-generated sequential identifier for the Data Quality analysis settings record. For a complete list of records, see tDQAnalysisSetting Table | int | 4 | | |||
| DQSettingvalue | XML expression for the settings used during a Data Quality analysis. Used internally by Touchstone. | varchar | 8000 | | |||
| AUGExcludedLocationsFileName | Name of the file that identifies the locations to be excluded from augmentation. | varchar | 4000 | | |||
| AUGExposureSetSuffix | Reserved for future use. | varchar | 50 | | |||
| ScoringPerilOptionCode | Alpha-numeric codes that are used within the database. These codes flag the peril data against which the scoring report needs to be generated. | varchar | 5 | | |||
| PerilSetCode | Numeric code for the single peril or set of perils. For a complete list of codes, see tPerilSet Table. | int | 4 | |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tDataQualityAnalysisOutputOption | Table | Stores the output options for a Data Quality analysis. | 1 |
| tDQAnalysisRule | Table | Stores data relating to the rules used in a Data Quality analysis. | 3 |
| tDQAnalysisRuleSet | Table | Stores information regarding the rule sets used during a Data Quality analysis. | 2 |
| tDQAnalysisRuleSetRuleSubTypeSelected | Table | Stores information regarding the rule sub type used during the Data Quality analysis. | 3 |
| tDQAnalysisSetting | Table | Stores information regarding the analysis settings used during a Data Quality analysis. | 2 |
| tDQIndustryFilterLOB | Table | Stores the type of output of the Data Quality analysis and the Line of Business of the insured properties to include in the output results. | 2 |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
| tAnalysis | Table | Stores information about each analysis. | 1 |
| tDataServer | Table | Stores information about each data server associated with the project, including the sequential identifier (SID), name, description, connection information, and default MDF and LDF paths for the server. | 3 |
| tDataSource | Table | Stores information about the databases registered with the application, for example, the exposure and results databases. | 2 |
| tExposureSet | Table | Stores exposure set information from each exposure database on the server. | 3 |
| tProject | Table | Stores information about each project, for example, the project name and status code. | 2 |