tRRRR_DQ_AUG_ResultValues Table

Description

Defines actual values referenced by the augmentation rules. Stores both user and industry value for easy comparison and augmentation. Referenced by the tRRRR_DQ_AUG_ResultDetail Table to provide multiple values per location. Each location affected by the augmentation should have an ISOBIN record within this table to keep track of the augmentation data source.

Properties

Creation Date	4/11/2022 6:15 PM
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

Columns

Column Name	Description	Datatype	Length
ResultDetailSID	Unique system-generated sequential identifier for the detailed results record. For a complete list of records, see tAnalysisResult Table.	int	4
DQValueClassCode	Code that represents the Data Quality class. For a complete list of names, see tDQValueClass Table.	int	4
RuleSID	Unique system-generated sequential identifier for the data quality rule record. For a complete list of records, see tDQAnalysisRule Table.	int	4
DQValueClass	Name of the Data Quality class.	varchar	255
ValueUser	Augmentation value provided by the user.	varchar	255
ValueUserDescription	Text description of the user's value. When the value is a code, this field contains the description for the code.	varchar	200
ValueIndustry	Augmentation value.	varchar	200
ValueIndustryDescription	Description of the industry value. When the industry value is a code, the code's description is used.	varchar	200
IndDataSource	Source for the augmented data, such as Property Exposure or User Specified.	varchar	200
IsAccepted	Indicates whether the augmented value was accepted or rejected by the user. 1 = Yes (accepted) 0 = No (rejected)	bit	1
TargetSID	Unique system-generated sequential identifier for the target record. This identification is used when the record cannot be identified via the ResultDetailSID. For a complete list of records, see tAnalysisTarget Table.	int	4
OriginalValueIndustry	Original value before augmentation.	varchar	200
IsConsistent	Indicates whether the augmented value is consistent. 1 = Yes (consistent) 0 = No (inconsistent)	bit	1

Objects that tRRRR_DQ_AUG_ResultValues depends on

	Database Object	Object Type	Description	Dep Level
	tRRRR_DQ_AUG_ResultDetail	Table	Report detail results for the Data Quality - Augmentation reports.	1

Related Objects

AIRExposureSummary Database