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.
Touchstone 2022 Database Reference
tDQIndustryFilterLOB Table
| Creation Date | 4/4/2022 3:02 AM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 0 |
| Data Space Used | 0.00 KB |
| Index Space Used | 0.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 | |||
| | OutputTypeCode | Code that represents the type of output generated during the analysis. For a complete list of codes, see tOutputType Table. | varchar | 10 | |||
| | LOBSID | Unique system-generated sequential identifier for the Line of Business record. | bigint | 8 | |||
| LOBName | Name of the Line of Business. | varchar | 255 |  |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tAnalysis | Table | Stores information about each analysis. | 3 |
| tDataQualityAnalysisOption | Table | Stores information regarding the augmentation of data during a Data Quality analysis. | 2 |
| tDataQualityAnalysisOutputOption | Table | Stores the output options for a Data Quality 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. | 5 |
| tDataSource | Table | Stores information about the databases registered with the application, for example, the exposure and results databases. | 4 |
| tExposureSet | Table | Stores exposure set information from each exposure database on the server. | 5 |
| tProject | Table | Stores information about each project, for example, the project name and status code. | 4 |