6 Quality Checks

This chapter provides an overview of quality checks found in the QA Package, including:

For quality checks with complex logic or notable exceptions to the standard application of the check, please refer to Section 5.5 for more detailed explanation.

Please note that the sections on Level 1, 2, and 3 quality checks are complete and quite lengthy. A sortable version of the lookup files used to create these checks can also be downloaded as an Excel workbook from the QA Package git repository.

6.1 Basic Integrity Checks

The QA Program Package employs a series of basic program package integrity checks that execute before QA-specific processing begins and after each QA module completes its execution. These checks confirm that there are no system or user set-up errors present and aborts processing if an issue is detected.

Table 6.1 details basic integrity checks performed when QA Package processing initiates and before any QA-specific logic is executed. All checks must pass prior to entering the QA module sequence.

Table 6.1: QA Package Pre-Module Checks
Check	Description	Action
Pre-Module Check 1	This check confirms there are no system errors.	If an error is detected, the following message will be written to the log and the package will abort: `Pre-Module Check 1: System error detected. MASTER_FLOW macro is aborting. => Check main log at &sasprograms.00.0_scdm_data_qa_review_master_file.log`
Pre-Module Check 2	This check confirms the ETL parameter specified in the master program has been updated with a valid value.	If an error is detected, the following message will be written to the log and the package will abort: `Pre-Module Check 2: ETL error detected. MASTER_FLOW macro is aborting. => The ETL parameter cannot be blank or include any non-numeric value(s). Please contact SOC DMQA for next steps.`
Pre-Module Check 3	This check confirms existing output in the “msoc” directory will not be unintentionally overwritten during module processing.	If content is found but is not based on the user-specified ETL, processing will abort and the following message will be written to the log: `Pre-Module Check 3: Different ETL content detected in MSOC library. MASTER_FLOW macro is aborting.` If there is content in the directory that is based on the current ETL, the directory will be cleared before processing continues, and the following message will be written to the log: `ETL Versions match and the program will continue HOWEVER, unless otherwise specified in the master program, all existing SAS datasets in the local output directories (‘dplocal’,‘msoc’) will be deleted for data quality assurance purposes.`
Pre-Module Check 4	This check confirms there are no system errors.	If an error is detected, the following message will be written to the log and the package will abort: `Pre-Module Check 4: System error detected. MASTER_FLOW macro is aborting. => Check main log at &sasprograms.00.0_scdm_data_qa_master_&dt_today..log`
Pre-Module Check 5	This check confirms that each table specified in the control flow input corresponds to a user specified SCDM table parameter in the master program.	If an error is detected, the following message will be written to the log: `SCDM &table. parameter not specified in master program but defined by SOC inputfiles/control flow.csv file. If an error is detected, after checking all tables in in the control flow input, the following message will be written to the log and the package will abort: Pre-Module Check 5: MASTER_FLOW macro is aborting because an expected SCDM Table Name was not defined by your site for the ETL under review.`
Pre-Module Check 6	This check confirms that each user-specified table in the master programs corresponds to tables that will serve as input according to content in the control flow input file.	`SCDM &table. name is defined by DP, but not expected at the site. Only the SCDM tables defined by SOC in inputfiles/control_flow.csv file should be present in the directory and named in the master program.` After checking all tables in in the control flow input but not flagged for inclusion, an additional error message will be written to the log and processing will abort: `Pre-Module Check 6: MASTER_FLOW macro is aborting because an unexpected SCDM table name was defined by your site for the ETL under review.`
Pre-Module Check 7	This check confirms if the COD table is specified in the master program then the DTH table is also specified.	If an error the following message will be written to the log and the package will abort: `Defensive Pre-Check: CODTABLE specified without DEATHTABLE. RUN_QA_PACKAGE macro is aborting. The DEATHTABLE parameter cannot be blank if CODTABLE is specified. Please go back to the master program and populate DEATHTABLE.`

Table 6.2 details integrity checks performed after an individual module has completed.

Table 6.2: QA Package Post-Module Checks
Check	Description	Action
Check 1	This check confirms that there are no system errors generated during a module run.	If an error is detected, the following message will be written to the log and the package will abort: `Post Module Check 1: System error detected. Process will abort. ==> Check program log &msoc.&last_module.&dt_today..log for details.`
Check 2	This check evaluates the results of a module to detect data checking results that should cause processing to abort.	If an error is detected the final master signature file and log checking output will be generated: `&last_module. module has produced data check flags that require the QA package to abort. Process will abort after creating a master signature file and running the log checker.`
Check 2		After the generating the master signature file and log checking output, the following error message will also be written to the log: `Post-Module Check 2: The macro MASTER_FLOW has terminated early due to data check failures ==> The macro MASTER_FLOW will now abort …’; ==> Check msoc.&dpid._scdm_data_qa_logcheck.pdf for details.`
Check 3	This check evaluates whether generating the master signature file and log checking output resulted in a system error.	If an error is detected, the following message will be written to the log and the package will abort: `Post Module Check 3: The macro MASTER_FLOW has run the modules selected without any fatal problems detected. ==> HOWEVER, there was a fatal problem with either the master signature and/or log checker’; ==> program(s) that ran after the modules were run.’; ==> The macro MASTER_FLOW will now abort…’; ==> Check program log &sasprograms.00.0_scdm_data_qa_review_master_file.log for details.`

6.1.1 Partition Specific Integrity Checks

Table 6.3 specifies basic integrity checks specific to partitioned data, performed when QA Package processing initiates and before any QA-specific logic is executed. All checks must pass prior to entering the QA module sequence.

Table 6.3: QA Package Partitioning Pre-Module Checks
Check	Description	Action
Partitioning Pre-Module Check 1	This check confirms that the PatID-PartitionID crosswalk file exists.	If an error is detected, the following message will be written to the log and the package will abort: `ERROR: Crosswalk specified in ParTable parameter does not exist. Program is aborting. The crosswalk specified in ParTable needs to exist. Please check for its existence or change ParTable in the master program. Processing will abort.`
Partitioning Pre-Module Check 2	This check confirms the PatID-PartitionID crosswalk file format is valid.	If an error is detected, the following message will be written to the log and the package will abort: `ERROR: Crosswalk format invalid. Program is aborting.` If PatID is missing, the following additional error message will be written: `Crosswalk does not include PatID` If PatID is not numeric, the following additional error message will be written: `Crosswalk PatID is not numeric` If PartitionID is missing, the following additional error message will be written: `Crosswalk does not include PartitionID` If Partition is not numeric, the following additional error message will be written: `Crosswalk PartitionID is not numeric`
Pre-Module Check 3	This check confirms that all expected tables where partitioning applies exist.	If any given table is missing a dataset, the following message will be written to the log and the package will abort: `ERROR: Data sets expected based on header macro variables were not found. Please see dplocal.missing_scdm_tables for list of missing SCDM table parameters. Processing will abort.`
Pre-Module Check 4	This check confirms that the number of partitioned SCDM datasets matches the number of partitions specified in the master program.	If any given table is missing a dataset, the following message will be written to the log and the package will abort: `ERROR: Complete set of partitioned data not available per all SCDM tables. Please see dplocal.missing_partition_scdm for list of missing partitioned datasets. Processing will abort.`
Pre-Module Check 5	This check confirms that all tables which should be partitioned are, and those that should not be are not.	If an error is detected, the following message will be written to the log and the package will abort: `ERROR: SCDM tables not partitioned as expected. Please see DPLOCAL.ErrorPTabNm for name of tables. Processing will abort.`
Pre-Module Check 6	This check identifies duplicate entries in the PatID-PartitionID crosswalk file.	If an error is detected, the following message will be written to the log and the package will abort: `ERROR: duplicate records in dataset qadata.&ParTable. Please see dplocal.pdwalk_dups for list of PatID values with problematic entries. Processing will abort.`
Pre-Module Check 7	This check identifies inconsistencies in file format by and across all SCDM tables.	If an error is detected across partitions, the following message will be written to the log and the package will abort: `ERROR: variables inconsistently defined across partitions for SCDM Table &SCMTabPrefix. Please see DPLOCAL.F&SCMTabPrefix for further detail on variable attributes. Processing will abort.` If an error is detected across SCDM tables, the following message will be written to the log and the package will abort: `ERROR: Variables inconsistently defined across SCDM Database. Please see DPLOCAL.FallSCDM for further detail on SCDM table attributes. Processing will abort.`

6.2 Level 1 Quality Checks

6.2.1 Table of Contents

Enrollment Level 1 Quality Checks

Table 6.4: Enrollment Table Level 1 Quality Checks
FlagID	FlagType	AbortYN	Flag_Descr	Variable1
ENR_1_00_00-0_102	Fail	Y	ENR table is not sorted by the following variables: PatID, Enr_Start, Enr_End, MedCov, DrugCov, Chart
ENR_1_01_00-0_110	Fail	Y	PatID variable does not exist	PatID
ENR_1_02_00-0_110	Fail	Y	Enr_Start variable does not exist	Enr_Start
ENR_1_03_00-0_110	Fail	Y	Enr_End variable does not exist	Enr_End
ENR_1_04_00-0_110	Fail	Y	MedCov variable does not exist	MedCov
ENR_1_05_00-0_110	Fail	Y	DrugCov variable does not exist	DrugCov
ENR_1_06_00-0_110	Fail	Y	Chart variable does not exist	Chart
ENR_1_07_00-0_110	Fail	Y	PlanType variable does not exist	PlanType
ENR_1_08_00-0_110	Fail	Y	PayerType variable does not exist	PayerType
ENR_1_07_00-0_111	Note	N	PlanType variable is not populated	PlanType
ENR_1_08_00-0_111	Note	N	PayerType variable is not populated	PayerType
ENR_1_01_00-0_112	Fail	Y	PatID variable type does not conform to specifications	PatID
ENR_1_02_00-0_112	Fail	Y	Enr_Start variable type does not conform to specifications	Enr_Start
ENR_1_03_00-0_112	Fail	Y	Enr_End variable type does not conform to specifications	Enr_End
ENR_1_04_00-0_112	Fail	Y	MedCov variable type does not conform to specifications	MedCov
ENR_1_05_00-0_112	Fail	Y	DrugCov variable type does not conform to specifications	DrugCov
ENR_1_06_00-0_112	Fail	Y	Chart variable type does not conform to specifications	Chart
ENR_1_07_00-0_112	Fail	Y	PlanType variable type does not conform to specifications	PlanType
ENR_1_08_00-0_112	Fail	Y	PayerType variable type does not conform to specifications	PayerType
ENR_1_02_00-0_113	Fail	Y	Enr_Start variable length does not conform to specifications	Enr_Start
ENR_1_03_00-0_113	Fail	Y	Enr_End variable length does not conform to specifications	Enr_End
ENR_1_04_00-0_113	Fail	Y	MedCov variable length does not conform to specifications	MedCov
ENR_1_05_00-0_113	Fail	Y	DrugCov variable length does not conform to specifications	DrugCov
ENR_1_06_00-0_113	Fail	Y	Chart variable length does not conform to specifications	Chart
ENR_1_07_00-0_113	Fail	Y	PlanType variable length does not conform to specifications	PlanType
ENR_1_08_00-0_113	Fail	Y	PayerType variable length does not conform to specifications	PayerType
ENR_1_01_00-0_115	Fail	Y	PatID variable length is less than needed to contain maximum value	PatID
ENR_1_01_00-0_116	Fail	Y	PatID variable is formatted with an inadequate format	PatID
ENR_1_01_00-0_120	Fail	Y	PatID variable contains a null value	PatID
ENR_1_02_00-0_120	Fail	Y	Enr_Start variable contains a null value	Enr_Start
ENR_1_03_00-0_120	Fail	Y	Enr_End variable contains a null value	Enr_End
ENR_1_04_00-0_120	Fail	Y	MedCov variable contains a null value	MedCov
ENR_1_05_00-0_120	Fail	Y	DrugCov variable contains a null value	DrugCov
ENR_1_06_00-0_120	Fail	Y	Chart variable contains a null value	Chart
ENR_1_04_00-0_121	Fail	Y	MedCov variable contains an incorrect non-missing value	MedCov
ENR_1_05_00-0_121	Fail	Y	DrugCov variable contains an incorrect non-missing value	DrugCov
ENR_1_06_00-0_121	Fail	Y	Chart variable contains an incorrect non-missing value	Chart
ENR_1_07_00-0_121	Fail	Y	PlanType variable contains an incorrect non-missing value	PlanType
ENR_1_08_00-0_121	Fail	Y	PayerType variable contains an incorrect non-missing value	PayerType

FlagID	FlagType	AbortYN	Flag_Descr	Variable1
VIT_1_00_00-0_102	Fail	Y	VIT table is not sorted by the following variables: PatID, Measure_Date
VIT_1_01_00-0_110	Fail	Y	PatID variable does not exist	PatID
VIT_1_02_00-0_110	Fail	Y	EncounterID variable does not exist	EncounterID
VIT_1_03_00-0_110	Fail	Y	Measure_Date variable does not exist	Measure_Date
VIT_1_04_00-0_110	Fail	Y	Measure_Time variable does not exist	Measure_Time
VIT_1_05_00-0_110	Fail	Y	HT variable does not exist	HT
VIT_1_06_00-0_110	Fail	Y	WT variable does not exist	WT
VIT_1_07_00-0_110	Fail	Y	Diastolic variable does not exist	Diastolic
VIT_1_08_00-0_110	Fail	Y	Systolic variable does not exist	Systolic
VIT_1_09_00-0_110	Fail	Y	BP_Type variable does not exist	BP_Type
VIT_1_10_00-0_110	Fail	Y	Position variable does not exist	Position
VIT_1_11_00-0_110	Fail	Y	Tobacco variable does not exist	Tobacco
VIT_1_12_00-0_110	Fail	Y	Tobacco_Type variable does not exist	Tobacco_Type
VIT_1_01_00-0_112	Fail	Y	PatID variable type does not conform to specifications	PatID
VIT_1_02_00-0_112	Fail	Y	EncounterID variable type does not conform to specifications	EncounterID
VIT_1_03_00-0_112	Fail	Y	Measure_Date variable type does not conform to specifications	Measure_Date
VIT_1_04_00-0_112	Fail	Y	Measure_Time variable type does not conform to specifications	Measure_Time
VIT_1_05_00-0_112	Fail	Y	HT variable type does not conform to specifications	HT
VIT_1_06_00-0_112	Fail	Y	WT variable type does not conform to specifications	WT
VIT_1_07_00-0_112	Fail	Y	Diastolic variable type does not conform to specifications	Diastolic
VIT_1_08_00-0_112	Fail	Y	Systolic variable type does not conform to specifications	Systolic
VIT_1_09_00-0_112	Fail	Y	BP_Type variable type does not conform to specifications	BP_Type
VIT_1_10_00-0_112	Fail	Y	Position variable type does not conform to specifications	Position
VIT_1_11_00-0_112	Fail	Y	Tobacco variable type does not conform to specifications	Tobacco
VIT_1_12_00-0_112	Fail	Y	Tobacco_Type variable type does not conform to specifications	Tobacco_Type
VIT_1_03_00-0_113	Fail	Y	Measure_Date variable length does not conform to specifications	Measure_Date
VIT_1_04_00-0_113	Fail	Y	Measure_Time variable length does not conform to specifications	Measure_Time
VIT_1_05_00-0_113	Fail	Y	HT variable length does not conform to specifications	HT
VIT_1_06_00-0_113	Fail	Y	WT variable length does not conform to specifications	WT
VIT_1_07_00-0_113	Fail	Y	Diastolic variable length does not conform to specifications	Diastolic
VIT_1_08_00-0_113	Fail	Y	Systolic variable length does not conform to specifications	Systolic
VIT_1_09_00-0_113	Fail	Y	BP_Type variable length does not conform to specifications	BP_Type
VIT_1_10_00-0_113	Fail	Y	Position variable length does not conform to specifications	Position
VIT_1_11_00-0_113	Fail	Y	Tobacco variable length does not conform to specifications	Tobacco
VIT_1_12_00-0_113	Fail	Y	Tobacco_Type variable length does not conform to specifications	Tobacco_Type
VIT_1_01_00-0_115	Fail	Y	PatID variable length is less than needed to contain maximum value	PatID
VIT_1_02_00-0_115	Fail	Y	EncounterID variable length is less than needed to contain maximum value	EncounterID
VIT_1_01_00-0_116	Fail	Y	PatID variable is formatted with an inadequate format	PatID
VIT_1_02_00-0_116	Fail	Y	EncounterID variable is formatted with an inadequate format	EncounterID
VIT_1_01_00-0_120	Fail	Y	PatID variable contains a null value	PatID
VIT_1_03_00-0_120	Fail	Y	Measure_Date variable contains a null value	Measure_Date
VIT_1_05_00-0_121	Warn	N	HT variable contains an incorrect non-missing value	HT
VIT_1_06_00-0_121	Warn	N	WT variable contains an incorrect non-missing value	WT
VIT_1_07_00-0_121	Warn	N	Diastolic variable contains an incorrect non-missing value	Diastolic
VIT_1_08_00-0_121	Warn	N	Systolic variable contains an incorrect non-missing value	Systolic
VIT_1_09_00-0_121	Fail	Y	BP_Type variable contains an incorrect non-missing value	BP_Type
VIT_1_10_00-0_121	Fail	Y	Position variable contains an incorrect non-missing value	Position
VIT_1_11_00-0_121	Fail	Y	Tobacco variable contains an incorrect non-missing value	Tobacco
VIT_1_12_00-0_121	Fail	Y	Tobacco_Type variable contains an incorrect non-missing value	Tobacco_Type
VIT_1_05_00-0_124	Warn	N	HT contains an unexpected value of zero (0)	HT
VIT_1_06_00-0_124	Warn	N	WT contains an unexpected value of zero (0)	WT
VIT_1_07_00-0_124	Warn	N	Diastolic contains an unexpected value of zero (0)	Diastolic
VIT_1_08_00-0_124	Warn	N	Systolic contains an unexpected value of zero (0)	Systolic

FlagID	FlagType	AbortYN	Flag_Descr	Variable1
IRX_1_00_00-0_102	Fail	Y	IRX table is not sorted by the following variables: PatID, RxADate
IRX_1_01_00-0_110	Fail	Y	PatID variable does not exist	PatID
IRX_1_02_00-0_110	Fail	Y	EncounterID variable does not exist	EncounterID
IRX_1_03_00-0_110	Fail	Y	NDC variable does not exist	NDC
IRX_1_04_00-0_110	Fail	Y	RxID variable does not exist	RxID
IRX_1_05_00-0_110	Fail	Y	RxADate variable does not exist	RxADate
IRX_1_06_00-0_110	Fail	Y	RxATime variable does not exist	RxATime
IRX_1_07_00-0_110	Fail	Y	RxRoute variable does not exist	RxRoute
IRX_1_08_00-0_110	Fail	Y	RxDose variable does not exist	RxDose
IRX_1_09_00-0_110	Fail	Y	RxUOM variable does not exist	RxUOM
IRX_1_01_00-0_112	Fail	Y	PatID variable type does not conform to specifications	PatID
IRX_1_02_00-0_112	Fail	Y	EncounterID variable type does not conform to specifications	EncounterID
IRX_1_03_00-0_112	Fail	Y	NDC variable type does not conform to specifications	NDC
IRX_1_04_00-0_112	Fail	Y	RxID variable type does not conform to specifications	RxID
IRX_1_05_00-0_112	Fail	Y	RxADate variable type does not conform to specifications	RxADate
IRX_1_06_00-0_112	Fail	Y	RxATime variable type does not conform to specifications	RxATime
IRX_1_07_00-0_112	Fail	Y	RxRoute variable type does not conform to specifications	RxRoute
IRX_1_08_00-0_112	Fail	Y	RxDose variable type does not conform to specifications	RxDose
IRX_1_09_00-0_112	Fail	Y	RxUOM variable type does not conform to specifications	RxUOM
IRX_1_03_00-0_113	Fail	Y	NDC variable length does not conform to specifications	NDC
IRX_1_05_00-0_113	Fail	Y	RxADate variable length does not conform to specifications	RxADate
IRX_1_06_00-0_113	Fail	Y	RxATime variable length does not conform to specifications	RxATime
IRX_1_07_00-0_113	Fail	Y	RxRoute variable length does not conform to specifications	RxRoute
IRX_1_08_00-0_113	Fail	Y	RxDose variable length does not conform to specifications	RxDose
IRX_1_09_00-0_113	Fail	Y	RxUOM variable length does not conform to specifications	RxUOM
IRX_1_01_00-0_115	Fail	Y	PatID variable length is less than needed to contain maximum value	PatID
IRX_1_02_00-0_115	Fail	Y	EncounterID variable length is less than needed to contain maximum value	EncounterID
IRX_1_04_00-0_115	Fail	Y	RxID variable length is less than needed to contain maximum value	RxID
IRX_1_01_00-0_116	Fail	Y	PatID variable is formatted with an inadequate format	PatID
IRX_1_02_00-0_116	Fail	Y	EncounterID variable is formatted with an inadequate format	EncounterID
IRX_1_04_00-0_116	Fail	Y	RxID variable is formatted with an inadequate format	RxID
IRX_1_01_00-0_120	Fail	Y	PatID variable contains a null value	PatID
IRX_1_02_00-0_120	Fail	Y	EncounterID variable contains a null value	EncounterID
IRX_1_03_00-0_120	Fail	Y	NDC variable contains a null value	NDC
IRX_1_04_00-0_120	Fail	Y	RxID variable contains a null value	RxID
IRX_1_05_00-0_120	Fail	Y	RxADate variable contains a null value	RxADate
IRX_1_08_00-0_121	Fail	Y	RxDose variable contains an incorrect non-missing value	RxDose
IRX_1_03_00-0_122	Fail	Y	NDC value contains leading spaces	NDC
IRX_1_07_00-0_122	Fail	Y	RxRoute value contains leading spaces	RxRoute
IRX_1_09_00-0_122	Fail	Y	RxUOM value contains leading spaces	RxUOM

FlagID	FlagType	AbortYN	Flag_Descr	Variable1
TXN_1_00_00-0_102	Fail	Y	TXN table is not sorted by the following variables: PatID, TDate_Start
TXN_1_01_00-0_110	Fail	Y	PatID variable does not exist	PatID
TXN_1_02_00-0_110	Fail	Y	EncounterID variable does not exist	EncounterID
TXN_1_03_00-0_110	Fail	Y	TransID variable does not exist	TransID
TXN_1_04_00-0_110	Fail	Y	TransCode variable does not exist	TransCode
TXN_1_05_00-0_110	Fail	Y	TransCode_Type variable does not exist	TransCode_Type
TXN_1_06_00-0_110	Fail	Y	Orig_TransProd variable does not exist	Orig_TransProd
TXN_1_07_00-0_110	Fail	Y	BloodType variable does not exist	BloodType
TXN_1_08_00-0_110	Fail	Y	TDate_Start variable does not exist	TDate_Start
TXN_1_09_00-0_110	Fail	Y	TTime_Start variable does not exist	TTime_Start
TXN_1_10_00-0_110	Fail	Y	TDate_End variable does not exist	TDate_End
TXN_1_11_00-0_110	Fail	Y	TTime_End variable does not exist	TTime_End
TXN_1_12_00-0_110	Fail	Y	EncType variable does not exist	EncType
TXN_1_01_00-0_112	Fail	Y	PatID variable type does not conform to specifications	PatID
TXN_1_02_00-0_112	Fail	Y	EncounterID variable type does not conform to specifications	EncounterID
TXN_1_03_00-0_112	Fail	Y	TransID variable type does not conform to specifications	TransID
TXN_1_04_00-0_112	Fail	Y	TransCode variable type does not conform to specifications	TransCode
TXN_1_05_00-0_112	Fail	Y	TransCode_Type variable type does not conform to specifications	TransCode_Type
TXN_1_06_00-0_112	Fail	Y	Orig_TransProd variable type does not conform to specifications	Orig_TransProd
TXN_1_07_00-0_112	Fail	Y	BloodType variable type does not conform to specifications	BloodType
TXN_1_08_00-0_112	Fail	Y	TDate_Start variable type does not conform to specifications	TDate_Start
TXN_1_09_00-0_112	Fail	Y	TTime_Start variable type does not conform to specifications	TTime_Start
TXN_1_10_00-0_112	Fail	Y	TDate_End variable type does not conform to specifications	TDate_End
TXN_1_11_00-0_112	Fail	Y	TTime_End variable type does not conform to specifications	TTime_End
TXN_1_12_00-0_112	Fail	Y	EncType variable type does not conform to specifications	EncType
TXN_1_04_00-0_113	Fail	Y	TransCode variable length does not conform to specifications	TransCode
TXN_1_05_00-0_113	Fail	Y	TransCode_Type variable length does not conform to specifications	TransCode_Type
TXN_1_07_00-0_113	Fail	Y	BloodType variable length does not conform to specifications	BloodType
TXN_1_08_00-0_113	Fail	Y	TDate_Start variable length does not conform to specifications	TDate_Start
TXN_1_09_00-0_113	Fail	Y	TTime_Start variable length does not conform to specifications	TTime_Start
TXN_1_10_00-0_113	Fail	Y	TDate_End variable length does not conform to specifications	TDate_End
TXN_1_11_00-0_113	Fail	Y	TTime_End variable length does not conform to specifications	TTime_End
TXN_1_12_00-0_113	Fail	Y	EncType variable length does not conform to specifications	EncType
TXN_1_01_00-0_115	Fail	Y	PatID variable length is less than needed to contain maximum value	PatID
TXN_1_02_00-0_115	Fail	Y	EncounterID variable length is less than needed to contain maximum value	EncounterID
TXN_1_03_00-0_115	Fail	Y	TransID variable length is less than needed to contain maximum value	TransID
TXN_1_01_00-0_116	Fail	Y	PatID variable is formatted with an inadequate format	PatID
TXN_1_02_00-0_116	Fail	Y	EncounterID variable is formatted with an inadequate format	EncounterID
TXN_1_03_00-0_116	Fail	Y	TransID variable is formatted with an inadequate format	TransID
TXN_1_01_00-0_120	Fail	Y	PatID variable contains a null value	PatID
TXN_1_02_00-0_120	Fail	Y	EncounterID variable contains a null value	EncounterID
TXN_1_03_00-0_120	Fail	Y	TransID variable contains a null value	TransID
TXN_1_04_00-0_120	Fail	Y	TransCode variable contains a null value	TransCode
TXN_1_05_00-0_120	Fail	Y	TransCode_Type variable contains a null value	TransCode_Type
TXN_1_07_00-0_120	Fail	Y	BloodType variable contains a null value	BloodType
TXN_1_08_00-0_120	Fail	Y	TDate_Start variable contains a null value	TDate_Start
TXN_1_05_00-0_121	Fail	Y	TransCode_Type variable contains an incorrect non-missing value	TransCode_Type
TXN_1_07_00-0_121	Fail	Y	BloodType variable contains an incorrect non-missing value	BloodType
TXN_1_12_00-0_121	Fail	Y	EncType variable contains an incorrect non-missing value	EncType
TXN_1_04_00-0_122	Fail	Y	TransCode value contains leading spaces	TransCode

FlagID	FlagType	AbortYN	Flag_Descr	Variable1
PRE_1_00_00-0_102	Fail	Y	PRE table is not sorted by the following variables: PatID, OrderDate
PRE_1_01_00-0_110	Fail	Y	PatID variable does not exist	PatID
PRE_1_02_00-0_110	Fail	Y	EncounterID variable does not exist	EncounterID
PRE_1_03_00-0_110	Fail	Y	PrescribingID variable does not exist	PrescribingID
PRE_1_04_00-0_110	Fail	Y	ProviderID variable does not exist	ProviderID
PRE_1_05_00-0_110	Fail	Y	OrderDate variable does not exist	OrderDate
PRE_1_06_00-0_110	Fail	Y	Rx_CodeType variable does not exist	Rx_CodeType
PRE_1_07_00-0_110	Fail	Y	Rx variable does not exist	Rx
PRE_1_08_00-0_110	Fail	Y	RxSup variable does not exist	RxSup
PRE_1_09_00-0_110	Fail	Y	RxAmt variable does not exist	RxAmt
PRE_1_10_00-0_110	Fail	Y	RxSource variable does not exist	RxSource
PRE_1_11_00-0_110	Fail	Y	RxRoute variable does not exist	RxRoute
PRE_1_12_00-0_110	Fail	Y	RxDoseQuantity variable does not exist	RxDoseQuantity
PRE_1_13_00-0_110	Fail	Y	RxDoseUnit variable does not exist	RxDoseUnit
PRE_1_14_00-0_110	Fail	Y	RxDoseForm variable does not exist	RxDoseForm
PRE_1_15_00-0_110	Fail	Y	RxFreqQuantity variable does not exist	RxFreqQuantity
PRE_1_16_00-0_110	Fail	Y	RxFreqUnit variable does not exist	RxFreqUnit
PRE_1_17_00-0_110	Fail	Y	RxRefills variable does not exist	RxRefills
PRE_1_18_00-0_110	Fail	Y	RxPrnFlag variable does not exist	RxPrnFlag
PRE_1_19_00-0_110	Fail	Y	RxDAW variable does not exist	RxDAW
PRE_1_01_00-0_112	Fail	Y	PatID variable type does not conform to specifications	PatID
PRE_1_02_00-0_112	Fail	Y	EncounterID variable type does not conform to specifications	EncounterID
PRE_1_03_00-0_112	Fail	Y	PrescribingID variable type does not conform to specifications	PrescribingID
PRE_1_04_00-0_112	Fail	Y	ProviderID variable type does not conform to specifications	ProviderID
PRE_1_05_00-0_112	Fail	Y	OrderDate variable type does not conform to specifications	OrderDate
PRE_1_06_00-0_112	Fail	Y	Rx_CodeType variable type does not conform to specifications	Rx_CodeType
PRE_1_07_00-0_112	Fail	Y	Rx variable type does not conform to specifications	Rx
PRE_1_08_00-0_112	Fail	Y	RxSup variable type does not conform to specifications	RxSup
PRE_1_09_00-0_112	Fail	Y	RxAmt variable type does not conform to specifications	RxAmt
PRE_1_10_00-0_112	Fail	Y	RxSource variable type does not conform to specifications	RxSource
PRE_1_11_00-0_112	Fail	Y	RxRoute variable type does not conform to specifications	RxRoute
PRE_1_12_00-0_112	Fail	Y	RxDoseQuantity variable type does not conform to specifications	RxDoseQuantity
PRE_1_13_00-0_112	Fail	Y	RxDoseUnit variable type does not conform to specifications	RxDoseUnit
PRE_1_14_00-0_112	Fail	Y	RxDoseForm variable type does not conform to specifications	RxDoseForm
PRE_1_15_00-0_112	Fail	Y	RxFreqQuantity variable type does not conform to specifications	RxFreqQuantity
PRE_1_16_00-0_112	Fail	Y	RxFreqUnit variable type does not conform to specifications	RxFreqUnit
PRE_1_17_00-0_112	Fail	Y	RxRefills variable type does not conform to specifications	RxRefills
PRE_1_18_00-0_112	Fail	Y	RxPrnFlag variable type does not conform to specifications	RxPrnFlag
PRE_1_19_00-0_112	Fail	Y	RxDAW variable type does not conform to specifications	RxDAW
PRE_1_05_00-0_113	Fail	Y	OrderDate variable length does not conform to specifications	OrderDate
PRE_1_06_00-0_113	Fail	Y	Rx_CodeType variable length does not conform to specifications	Rx_CodeType
PRE_1_08_00-0_113	Fail	Y	RxSup variable length does not conform to specifications	RxSup
PRE_1_09_00-0_113	Fail	Y	RxAmt variable length does not conform to specifications	RxAmt
PRE_1_10_00-0_113	Fail	Y	RxSource variable length does not conform to specifications	RxSource
PRE_1_11_00-0_113	Fail	Y	RxRoute variable length does not conform to specifications	RxRoute
PRE_1_12_00-0_113	Fail	Y	RxDoseQuantity variable length does not conform to specifications	RxDoseQuantity
PRE_1_13_00-0_113	Fail	Y	RxDoseUnit variable length does not conform to specifications	RxDoseUnit
PRE_1_14_00-0_113	Fail	Y	RxDoseForm variable length does not conform to specifications	RxDoseForm
PRE_1_15_00-0_113	Fail	Y	RxFreqQuantity variable length does not conform to specifications	RxFreqQuantity
PRE_1_16_00-0_113	Fail	Y	RxFreqUnit variable length does not conform to specifications	RxFreqUnit
PRE_1_17_00-0_113	Fail	Y	RxRefills variable length does not conform to specifications	RxRefills
PRE_1_18_00-0_113	Fail	Y	RxPrnFlag variable length does not conform to specifications	RxPrnFlag
PRE_1_19_00-0_113	Fail	Y	RxDAW variable length does not conform to specifications	RxDAW
PRE_1_01_00-0_115	Fail	Y	PatID variable length is less than needed to contain maximum value	PatID
PRE_1_02_00-0_115	Fail	Y	EncounterID variable length is less than needed to contain maximum value	EncounterID
PRE_1_03_00-0_115	Fail	Y	PrescribingID variable length is less than needed to contain maximum value	PrescribingID
PRE_1_04_00-0_115	Fail	Y	ProviderID variable length is less than needed to contain maximum value	ProviderID
PRE_1_01_00-0_116	Fail	Y	PatID variable is formatted with an inadequate format	PatID
PRE_1_02_00-0_116	Fail	Y	EncounterID variable is formatted with an inadequate format	EncounterID
PRE_1_03_00-0_116	Fail	Y	PrescribingID variable is formatted with an inadequate format	PrescribingID
PRE_1_04_00-0_116	Fail	Y	ProviderID variable is formatted with an inadequate format	ProviderID
PRE_1_01_00-0_120	Fail	Y	PatID variable contains a null value	PatID
PRE_1_03_00-0_120	Fail	Y	PrescribingID variable contains a null value	PrescribingID
PRE_1_04_00-0_120	Fail	Y	ProviderID variable contains a null value	ProviderID
PRE_1_05_00-0_120	Fail	Y	OrderDate variable contains a null value	OrderDate
PRE_1_06_00-0_120	Fail	Y	Rx_CodeType variable contains a null value	Rx_CodeType
PRE_1_07_00-0_120	Fail	Y	Rx variable contains a null value	Rx
PRE_1_08_00-0_120	Warn	N	RxSup variable contains a null value	RxSup
PRE_1_09_00-0_120	Warn	N	RxAmt variable contains a null value	RxAmt
PRE_1_10_00-0_120	Fail	Y	RxSource variable contains a null value	RxSource
PRE_1_11_00-0_120	Fail	Y	RxRoute variable contains a null value	RxRoute
PRE_1_12_00-0_120	Warn	N	RxDoseQuantity variable contains a null value	RxDoseQuantity
PRE_1_13_00-0_120	Fail	Y	RxDoseUnit variable contains a null value	RxDoseUnit
PRE_1_15_00-0_120	Warn	N	RxFreqQuantity variable contains a null value	RxFreqQuantity
PRE_1_16_00-0_120	Fail	Y	RxFreqUnit variable contains a null value	RxFreqUnit
PRE_1_17_00-0_120	Warn	N	RxRefills variable contains a null value	RxRefills
PRE_1_18_00-0_120	Fail	Y	RxPrnFlag variable contains a null value	RxPrnFlag
PRE_1_19_00-0_120	Fail	Y	RxDAW variable contains a null value	RxDAW
PRE_1_04_00-0_121	Fail	Y	ProviderID variable contains an incorrect non-missing value	ProviderID
PRE_1_06_00-0_121	Fail	Y	Rx_CodeType variable contains an incorrect non-missing value	Rx_CodeType
PRE_1_08_00-0_121	Warn	N	RxSup variable contains an incorrect non-missing value	RxSup
PRE_1_09_00-0_121	Warn	N	RxAmt variable contains an incorrect non-missing value	RxAmt
PRE_1_10_00-0_121	Fail	Y	RxSource variable contains an incorrect non-missing value	RxSource
PRE_1_11_00-0_121	Fail	Y	RxRoute variable contains an incorrect non-missing value	RxRoute
PRE_1_12_00-0_121	Warn	N	RxDoseQuantity variable contains an incorrect non-missing value	RxDoseQuantity
PRE_1_13_00-0_121	Fail	Y	RxDoseUnit variable contains an incorrect non-missing value	RxDoseUnit
PRE_1_14_00-0_121	Fail	Y	RxDoseForm variable contains an incorrect non-missing value	RxDoseForm
PRE_1_15_00-0_121	Warn	N	RxFreqQuantity variable contains an incorrect non-missing value	RxFreqQuantity
PRE_1_16_00-0_121	Fail	Y	RxFreqUnit variable contains an incorrect non-missing value	RxFreqUnit
PRE_1_17_00-0_121	Warn	N	RxRefills variable contains an incorrect non-missing value	RxRefills
PRE_1_18_00-0_121	Fail	Y	RxPrnFlag variable contains an incorrect non-missing value	RxPrnFlag
PRE_1_19_00-0_121	Fail	Y	RxDAW variable contains an incorrect non-missing value	RxDAW
PRE_1_08_00-0_124	Warn	N	RxSup contains an unexpected value of zero (0)	RxSup
PRE_1_09_00-0_124	Warn	N	RxAmt contains an unexpected value of zero (0)	RxAmt

FlagID	FlagType	AbortYN	Flag_Descr	Variable1
FAC_1_00_00-0_102	Fail	Y	FAC table is not sorted by the following variables: FacilityID
FAC_1_01_00-0_110	Fail	Y	FacilityID variable does not exist	FacilityID
FAC_1_02_00-0_110	Fail	Y	Facility_Location variable does not exist	Facility_Location
FAC_1_01_00-0_112	Fail	Y	FacilityID variable type does not conform to specifications	FacilityID
FAC_1_02_00-0_112	Fail	Y	Facility_Location variable type does not conform to specifications	Facility_Location
FAC_1_01_00-0_115	Fail	Y	FacilityID variable length is less than needed to contain maximum value	FacilityID
FAC_1_01_00-0_116	Fail	Y	FacilityID variable is formatted with an inadequate format	FacilityID
FAC_1_01_00-0_120	Fail	Y	FacilityID variable contains a null value	FacilityID
FAC_1_01_00-0_121	Fail	Y	FacilityID variable contains an incorrect non-missing value	FacilityID

FlagID	FlagType	AbortYN	Flag_Descr	Variable1
PVD_1_00_00-0_102	Fail	Y	PVD table is not sorted by the following variables: ProviderID
PVD_1_01_00-0_110	Fail	Y	ProviderID variable does not exist	ProviderID
PVD_1_02_00-0_110	Fail	Y	Specialty variable does not exist	Specialty
PVD_1_03_00-0_110	Fail	Y	Specialty_CodeType variable does not exist	Specialty_CodeType
PVD_1_01_00-0_112	Fail	Y	ProviderID variable type does not conform to specifications	ProviderID
PVD_1_02_00-0_112	Fail	Y	Specialty variable type does not conform to specifications	Specialty
PVD_1_03_00-0_112	Fail	Y	Specialty_CodeType variable type does not conform to specifications	Specialty_CodeType
PVD_1_02_00-0_113	Fail	Y	Specialty variable length does not conform to specifications	Specialty
PVD_1_03_00-0_113	Fail	Y	Specialty_CodeType variable length does not conform to specifications	Specialty_CodeType
PVD_1_01_00-0_115	Fail	Y	ProviderID variable length is less than needed to contain maximum value	ProviderID
PVD_1_01_00-0_116	Fail	Y	ProviderID variable is formatted with an inadequate format	ProviderID
PVD_1_01_00-0_120	Fail	Y	ProviderID variable contains a null value	ProviderID
PVD_1_02_00-0_120	Fail	Y	Specialty variable contains a null value	Specialty
PVD_1_03_00-0_120	Fail	Y	Specialty_CodeType variable contains a null value	Specialty_CodeType
PVD_1_01_00-0_121	Fail	Y	ProviderID variable contains an incorrect non-missing value	ProviderID
PVD_1_02_00-0_121	Fail	Y	Specialty variable contains an incorrect non-missing value	Specialty
PVD_1_03_00-0_121	Fail	Y	Specialty_CodeType variable contains an incorrect non-missing value	Specialty_CodeType

FlagID	FlagType	AbortYN	Flag_Descr	Variable1
PRR_1_00_00-0_102	Fail	Y	PRR table is not sorted by the following variables: PatID, PRM_Code, Response_Dt, Response_Tm
PRR_1_01_00-0_110	Fail	Y	PatID variable does not exist	PatID
PRR_1_02_00-0_110	Fail	Y	EncounterID variable does not exist	EncounterID
PRR_1_03_00-0_110	Fail	Y	PRM_Code variable does not exist	PRM_Code
PRR_1_04_00-0_110	Fail	Y	SurveyID variable does not exist	SurveyID
PRR_1_05_00-0_110	Fail	Y	QuestionID variable does not exist	QuestionID
PRR_1_06_00-0_110	Fail	Y	QuestionVerID variable does not exist	QuestionVerID
PRR_1_07_00-0_110	Fail	Y	Response_Dt variable does not exist	Response_Dt
PRR_1_08_00-0_110	Fail	Y	Response_Tm variable does not exist	Response_Tm
PRR_1_09_00-0_110	Fail	Y	Response_Text variable does not exist	Response_Text
PRR_1_10_00-0_110	Fail	Y	Survey_Mode variable does not exist	Survey_Mode
PRR_1_01_00-0_112	Fail	Y	PatID variable type does not conform to specifications	PatID
PRR_1_02_00-0_112	Fail	Y	EncounterID variable type does not conform to specifications	EncounterID
PRR_1_03_00-0_112	Fail	Y	PRM_Code variable type does not conform to specifications	PRM_Code
PRR_1_04_00-0_112	Fail	Y	SurveyID variable type does not conform to specifications	SurveyID
PRR_1_05_00-0_112	Fail	Y	QuestionID variable type does not conform to specifications	QuestionID
PRR_1_06_00-0_112	Fail	Y	QuestionVerID variable type does not conform to specifications	QuestionVerID
PRR_1_07_00-0_112	Fail	Y	Response_Dt variable type does not conform to specifications	Response_Dt
PRR_1_08_00-0_112	Fail	Y	Response_Tm variable type does not conform to specifications	Response_Tm
PRR_1_09_00-0_112	Fail	Y	Response_Text variable type does not conform to specifications	Response_Text
PRR_1_10_00-0_112	Fail	Y	Survey_Mode variable type does not conform to specifications	Survey_Mode
PRR_1_03_00-0_113	Fail	Y	PRM_Code variable length does not conform to specifications	PRM_Code
PRR_1_05_00-0_113	Fail	Y	QuestionID variable length does not conform to specifications	QuestionID
PRR_1_07_00-0_113	Fail	Y	Response_Dt variable length does not conform to specifications	Response_Dt
PRR_1_08_00-0_113	Fail	Y	Response_Tm variable length does not conform to specifications	Response_Tm
PRR_1_10_00-0_113	Fail	Y	Survey_Mode variable length does not conform to specifications	Survey_Mode
PRR_1_01_00-0_115	Fail	Y	PatID variable length is less than needed to contain maximum value	PatID
PRR_1_02_00-0_115	Fail	Y	EncounterID variable length is less than needed to contain maximum value	EncounterID
PRR_1_04_00-0_115	Fail	Y	SurveyID variable length is less than needed to contain maximum value	SurveyID
PRR_1_06_00-0_115	Fail	Y	QuestionVerID variable length is less than needed to contain maximum value	QuestionVerID
PRR_1_01_00-0_116	Fail	Y	PatID variable is formatted with an inadequate format	PatID
PRR_1_02_00-0_116	Fail	Y	EncounterID variable is formatted with an inadequate format	EncounterID
PRR_1_04_00-0_116	Fail	Y	SurveyID variable is formatted with an inadequate format	SurveyID
PRR_1_06_00-0_116	Fail	Y	QuestionVerID variable is formatted with an inadequate format	QuestionVerID
PRR_1_01_00-0_120	Fail	Y	PatID variable contains a null value	PatID
PRR_1_03_00-0_120	Fail	Y	PRM_Code variable contains a null value	PRM_Code
PRR_1_04_00-0_120	Fail	Y	SurveyID variable contains a null value	SurveyID
PRR_1_05_00-0_120	Fail	Y	QuestionID variable contains a null value	QuestionID
PRR_1_06_00-0_120	Fail	Y	QuestionVerID variable contains a null value	QuestionVerID
PRR_1_07_00-0_120	Fail	Y	Response_Dt variable contains a null value	Response_Dt
PRR_1_08_00-0_120	Fail	Y	Response_Tm variable contains a null value	Response_Tm
PRR_1_09_00-0_120	Fail	Y	Response_Text variable contains a null value	Response_Text
PRR_1_10_00-0_120	Fail	Y	Survey_Mode variable contains a null value	Survey_Mode
PRR_1_03_00-0_121	Fail	Y	PRM_Code variable contains an incorrect non-missing value	PRM_Code
PRR_1_04_00-0_121	Fail	Y	SurveyID variable contains an incorrect non-missing value	SurveyID
PRR_1_05_00-0_121	Fail	Y	QuestionID variable contains an incorrect non-missing value	QuestionID
PRR_1_06_00-0_121	Fail	Y	QuestionVerID variable contains an incorrect non-missing value	QuestionVerID
PRR_1_10_00-0_121	Fail	Y	Survey_Mode variable contains an incorrect non-missing value	Survey_Mode

FlagID	FlagType	AbortYN	Flag_Descr	Variable1
PRS_1_00_00-0_102	Fail	Y	PRS table is not sorted by the following variables: PRM_Code, SurveyID, QuestionID, QuestionVerID
PRS_1_01_00-0_110	Fail	Y	PRM_Code variable does not exist	PRM_Code
PRS_1_02_00-0_110	Fail	Y	SurveyID variable does not exist	SurveyID
PRS_1_03_00-0_110	Fail	Y	QuestionID variable does not exist	QuestionID
PRS_1_04_00-0_110	Fail	Y	QuestionVerID variable does not exist	QuestionVerID
PRS_1_05_00-0_110	Fail	Y	Survey_Data_Source variable does not exist	Survey_Data_Source
PRS_1_06_00-0_110	Fail	Y	Survey_Name variable does not exist	Survey_Name
PRS_1_07_00-0_110	Fail	Y	Question_Dt variable does not exist	Question_Dt
PRS_1_08_00-0_110	Fail	Y	Question_Text variable does not exist	Question_Text
PRS_1_01_00-0_112	Fail	Y	PRM_Code variable type does not conform to specifications	PRM_Code
PRS_1_02_00-0_112	Fail	Y	SurveyID variable type does not conform to specifications	SurveyID
PRS_1_03_00-0_112	Fail	Y	QuestionID variable type does not conform to specifications	QuestionID
PRS_1_04_00-0_112	Fail	Y	QuestionVerID variable type does not conform to specifications	QuestionVerID
PRS_1_05_00-0_112	Fail	Y	Survey_Data_Source variable type does not conform to specifications	Survey_Data_Source
PRS_1_06_00-0_112	Fail	Y	Survey_Name variable type does not conform to specifications	Survey_Name
PRS_1_07_00-0_112	Fail	Y	Question_Dt variable type does not conform to specifications	Question_Dt
PRS_1_08_00-0_112	Fail	Y	Question_Text variable type does not conform to specifications	Question_Text
PRS_1_01_00-0_113	Fail	Y	PRM_Code variable length does not conform to specifications	PRM_Code
PRS_1_05_00-0_113	Fail	Y	Survey_Data_Source variable length does not conform to specifications	Survey_Data_Source
PRS_1_07_00-0_113	Fail	Y	Question_Dt variable length does not conform to specifications	Question_Dt
PRS_1_02_00-0_115	Fail	Y	SurveyID variable length is less than needed to contain maximum value	SurveyID
PRS_1_03_00-0_115	Fail	Y	QuestionID variable length is less than needed to contain maximum value	QuestionID
PRS_1_04_00-0_115	Fail	Y	QuestionVerID variable length is less than needed to contain maximum value	QuestionVerID
PRS_1_02_00-0_116	Fail	Y	SurveyID variable is formatted with an inadequate format	SurveyID
PRS_1_03_00-0_116	Fail	Y	QuestionID variable is formatted with an inadequate format	QuestionID
PRS_1_04_00-0_116	Fail	Y	QuestionVerID variable is formatted with an inadequate format	QuestionVerID
PRS_1_01_00-0_120	Fail	Y	PRM_Code variable contains a null value	PRM_Code
PRS_1_02_00-0_120	Fail	Y	SurveyID variable contains a null value	SurveyID
PRS_1_03_00-0_120	Fail	Y	QuestionID variable contains a null value	QuestionID
PRS_1_04_00-0_120	Fail	Y	QuestionVerID variable contains a null value	QuestionVerID
PRS_1_05_00-0_120	Fail	Y	Survey_Data_Source variable contains a null value	Survey_Data_Source
PRS_1_06_00-0_120	Fail	Y	Survey_Name variable contains a null value	Survey_Name
PRS_1_07_00-0_120	Fail	Y	Question_Dt variable contains a null value	Question_Dt
PRS_1_08_00-0_120	Fail	Y	Question_Text variable contains a null value	Question_Text
PRS_1_01_00-0_121	Fail	Y	PRM_Code variable contains an incorrect non-missing value	PRM_Code
PRS_1_02_00-0_121	Fail	Y	SurveyID variable contains an incorrect non-missing value	SurveyID
PRS_1_03_00-0_121	Fail	Y	QuestionID variable contains an incorrect non-missing value	QuestionID
PRS_1_04_00-0_121	Fail	Y	QuestionVerID variable contains an incorrect non-missing value	QuestionVerID
PRS_1_05_00-0_121	Fail	Y	Survey_Data_Source variable contains an incorrect non-missing value	Survey_Data_Source

FlagID	FlagType	AbortYN	Flag_Descr	Variable1
DEM_1_00_00-0_102	Fail	Y	DEM table is not sorted by the following variables: PatID
DEM_1_01_00-0_110	Fail	Y	PatID variable does not exist	PatID
DEM_1_02_00-0_110	Fail	Y	Birth_Date variable does not exist	Birth_Date
DEM_1_03_00-0_110	Fail	Y	Sex variable does not exist	Sex
DEM_1_04_00-0_110	Fail	Y	Hispanic variable does not exist	Hispanic
DEM_1_05_00-0_110	Fail	Y	Race variable does not exist	Race
DEM_1_06_00-0_110	Fail	Y	PostalCode variable does not exist	PostalCode
DEM_1_07_00-0_110	Fail	Y	PostalCode_Date variable does not exist	PostalCode_Date
DEM_1_08_00-0_110	Fail	Y	ImputedHispanic variable does not exist	ImputedHispanic
DEM_1_09_00-0_110	Fail	Y	ImputedRace variable does not exist	ImputedRace
DEM_1_08_00-0_111	Note	N	ImputedHispanic variable is not populated	ImputedHispanic
DEM_1_09_00-0_111	Note	N	ImputedRace variable is not populated	ImputedRace
DEM_1_01_00-0_112	Fail	Y	PatID variable type does not conform to specifications	PatID
DEM_1_02_00-0_112	Fail	Y	Birth_Date variable type does not conform to specifications	Birth_Date
DEM_1_03_00-0_112	Fail	Y	Sex variable type does not conform to specifications	Sex
DEM_1_04_00-0_112	Fail	Y	Hispanic variable type does not conform to specifications	Hispanic
DEM_1_05_00-0_112	Fail	Y	Race variable type does not conform to specifications	Race
DEM_1_06_00-0_112	Fail	Y	PostalCode variable type does not conform to specifications	PostalCode
DEM_1_07_00-0_112	Fail	Y	PostalCode_Date variable type does not conform to specifications	PostalCode_Date
DEM_1_08_00-0_112	Fail	Y	ImputedHispanic variable type does not conform to specifications	ImputedHispanic
DEM_1_09_00-0_112	Fail	Y	ImputedRace variable type does not conform to specifications	ImputedRace
DEM_1_02_00-0_113	Fail	Y	Birth_Date variable length does not conform to specifications	Birth_Date
DEM_1_03_00-0_113	Fail	Y	Sex variable length does not conform to specifications	Sex
DEM_1_04_00-0_113	Fail	Y	Hispanic variable length does not conform to specifications	Hispanic
DEM_1_05_00-0_113	Fail	Y	Race variable length does not conform to specifications	Race
DEM_1_07_00-0_113	Fail	Y	PostalCode_Date variable length does not conform to specifications	PostalCode_Date
DEM_1_08_00-0_113	Fail	Y	ImputedHispanic variable length does not conform to specifications	ImputedHispanic
DEM_1_09_00-0_113	Fail	Y	ImputedRace variable length does not conform to specifications	ImputedRace
DEM_1_01_00-0_115	Fail	Y	PatID variable length is less than needed to contain maximum value	PatID
DEM_1_01_00-0_116	Fail	Y	PatID variable is formatted with an inadequate format	PatID
DEM_1_01_00-0_120	Fail	Y	PatID variable contains a null value	PatID
DEM_1_03_00-0_120	Fail	Y	Sex variable contains a null value	Sex
DEM_1_04_00-0_120	Fail	Y	Hispanic variable contains a null value	Hispanic
DEM_1_05_00-0_120	Fail	Y	Race variable contains a null value	Race
DEM_1_03_00-0_121	Fail	Y	Sex variable contains an incorrect non-missing value	Sex
DEM_1_04_00-0_121	Fail	Y	Hispanic variable contains an incorrect non-missing value	Hispanic
DEM_1_05_00-0_121	Fail	Y	Race variable contains an incorrect non-missing value	Race
DEM_1_08_00-0_121	Fail	Y	ImputedHispanic variable contains an incorrect non-missing value	ImputedHispanic
DEM_1_09_00-0_121	Fail	Y	ImputedRace variable contains an incorrect non-missing value	ImputedRace

FlagID	FlagType	AbortYN	Flag_Descr	Variable1
DIS_1_00_00-0_102	Fail	Y	DIS table is not sorted by the following variables: PatID, RxDate
DIS_1_01_00-0_110	Fail	Y	PatID variable does not exist	PatID
DIS_1_02_00-0_110	Fail	Y	RxDate variable does not exist	RxDate
DIS_1_03_00-0_110	Fail	Y	Rx variable does not exist	Rx
DIS_1_04_00-0_110	Fail	Y	RxSup variable does not exist	RxSup
DIS_1_05_00-0_110	Fail	Y	RxAmt variable does not exist	RxAmt
DIS_1_06_00-0_110	Fail	Y	Rx_Codetype variable does not exist	Rx_Codetype
DIS_1_07_00-0_110	Fail	Y	ProviderID variable does not exist	ProviderID
DIS_1_01_00-0_112	Fail	Y	PatID variable type does not conform to specifications	PatID
DIS_1_02_00-0_112	Fail	Y	RxDate variable type does not conform to specifications	RxDate
DIS_1_03_00-0_112	Fail	Y	Rx variable type does not conform to specifications	Rx
DIS_1_04_00-0_112	Fail	Y	RxSup variable type does not conform to specifications	RxSup
DIS_1_05_00-0_112	Fail	Y	RxAmt variable type does not conform to specifications	RxAmt
DIS_1_06_00-0_112	Fail	Y	Rx_Codetype variable type does not conform to specifications	Rx_Codetype
DIS_1_07_00-0_112	Fail	Y	ProviderID variable type does not conform to specifications	ProviderID
DIS_1_02_00-0_113	Fail	Y	RxDate variable length does not conform to specifications	RxDate
DIS_1_04_00-0_113	Fail	Y	RxSup variable length does not conform to specifications	RxSup
DIS_1_05_00-0_113	Fail	Y	RxAmt variable length does not conform to specifications	RxAmt
DIS_1_06_00-0_113	Fail	Y	Rx_Codetype variable length does not conform to specifications	Rx_Codetype
DIS_1_01_00-0_115	Fail	Y	PatID variable length is less than needed to contain maximum value	PatID
DIS_1_07_00-0_115	Fail	Y	ProviderID variable length is less than needed to contain maximum value	ProviderID
DIS_1_01_00-0_116	Fail	Y	PatID variable is formatted with an inadequate format	PatID
DIS_1_07_00-0_116	Fail	Y	ProviderID variable is formatted with an inadequate format	ProviderID
DIS_1_01_00-0_120	Fail	Y	PatID variable contains a null value	PatID
DIS_1_02_00-0_120	Fail	Y	RxDate variable contains a null value	RxDate
DIS_1_03_00-0_120	Fail	Y	Rx variable contains a null value	Rx
DIS_1_06_00-0_120	Fail	Y	Rx_Codetype variable contains a null value	Rx_Codetype
DIS_1_07_00-0_120	Fail	Y	ProviderID variable contains a null value	ProviderID
DIS_1_04_00-0_121	Fail	Y	RxSup variable contains an incorrect non-missing value	RxSup
DIS_1_05_00-0_121	Fail	Y	RxAmt variable contains an incorrect non-missing value	RxAmt
DIS_1_06_00-0_121	Fail	Y	Rx_Codetype variable contains an incorrect non-missing value	Rx_Codetype
DIS_1_07_00-0_121	Fail	Y	ProviderID variable contains an incorrect non-missing value	ProviderID
DIS_1_04_00-0_124	Warn	N	RxSup contains an unexpected value of zero (0)	RxSup
DIS_1_05_00-0_124	Warn	N	RxAmt contains an unexpected value of zero (0)	RxAmt

Table 6.37: Laboratory Result Table Level 2 Quality Checks
FlagID	FlagType	AbortYN	Flag_Descr	Variable1	Variable2
LAB-ENR_2_01_00-0_201	Warn	N	PatID value present in LAB table, but not in the ENR table	PatID
LAB-FAC_2_33_00-0_201	Fail	Y	FacilityID value present in LAB table, but not in the FAC table	FacilityID	FacilityID
LAB-ENR_2_01_00-0_203	Fail	Y	PatID variable length is not consistent between tables	PatID
LAB-FAC_2_33_00-0_203	Fail	Y	FacilityID variable length is not consistent between tables	FacilityID	FacilityID
LAB_2_01_00-0_209	Warn	N	PatID variable length is greater than needed to contain maximum value across tables	PatID
LAB_2_33_00-0_209	Warn	N	FacilityID variable length is greater than needed to contain maximum value across tables	FacilityID
LAB_2_34_00-0_209	Warn	N	LabID variable length is greater than needed to contain maximum value across tables	LabID
LAB_2_00_00-0_211	Fail	Y	Duplicate record(s) present for unique key variable(s): LabID
LAB_2_07_99-U_220	Fail	Y	LOINC value is null where MS_Test_Name=UNMAPPED	LOINC	MS_Test_Name
LAB_2_03_01-N_222	Fail	N	Result_Type value is incorrect where MS_Test_Name=ALP	Result_Type	MS_Test_Name
LAB_2_03_02-N_222	Fail	N	Result_Type value is incorrect where MS_Test_Name=ALT	Result_Type	MS_Test_Name
LAB_2_03_03-N_222	Fail	N	Result_Type value is incorrect where MS_Test_Name=ANC	Result_Type	MS_Test_Name
LAB_2_03_04-N_222	Fail	N	Result_Type value is incorrect where MS_Test_Name=BILI_TOT	Result_Type	MS_Test_Name
LAB_2_03_05-N_222	Fail	N	Result_Type value is incorrect where MS_Test_Name=CK	Result_Type	MS_Test_Name
LAB_2_03_06-N_222	Fail	N	Result_Type value is incorrect where MS_Test_Name=CK_MB	Result_Type	MS_Test_Name
LAB_2_03_07-N_222	Fail	N	Result_Type value is incorrect where MS_Test_Name=CK_MBI	Result_Type	MS_Test_Name
LAB_2_03_08-N_222	Fail	N	Result_Type value is incorrect where MS_Test_Name=CREATININE	Result_Type	MS_Test_Name
LAB_2_03_11-N_222	Fail	N	Result_Type value is incorrect where MS_Test_Name=GLUCOSE	Result_Type	MS_Test_Name
LAB_2_03_12-N_222	Fail	N	Result_Type value is incorrect where MS_Test_Name=HGB	Result_Type	MS_Test_Name
LAB_2_03_13-N_222	Fail	N	Result_Type value is incorrect where MS_Test_Name=HGBA1C	Result_Type	MS_Test_Name
LAB_2_03_18-N_222	Fail	N	Result_Type value is incorrect where MS_Test_Name=INR	Result_Type	MS_Test_Name
LAB_2_03_19-N_222	Fail	N	Result_Type value is incorrect where MS_Test_Name=LIPASE	Result_Type	MS_Test_Name
LAB_2_03_22-N_222	Fail	N	Result_Type value is incorrect where MS_Test_Name=PLATELETS	Result_Type	MS_Test_Name
LAB_2_03_23-N_222	Fail	N	Result_Type value is incorrect where MS_Test_Name=TROP_I	Result_Type	MS_Test_Name
LAB_2_03_29-C_222	Fail	N	Result_Type value is incorrect where MS_Test_Name=SARS_COV_2	Result_Type	MS_Test_Name
LAB_2_03_99-U_222	Fail	Y	Result_Type value is incorrect where MS_Test_Name=UNMAPPED	Result_Type	MS_Test_Name
LAB_2_05_99-U_222	Fail	Y	Fast_Ind value is incorrect where MS_Test_Name=UNMAPPED	Fast_Ind	MS_Test_Name
LAB_2_06_99-U_222	Fail	Y	Specimen_Source value is incorrect where MS_Test_Name=UNMAPPED	Specimen_Source	MS_Test_Name
LAB_2_07_01-N_222	Warn	N	LOINC value is incorrect where MS_Test_Name=ALP	LOINC	MS_Test_Name
LAB_2_07_02-N_222	Warn	N	LOINC value is incorrect where MS_Test_Name=ALT	LOINC	MS_Test_Name
LAB_2_07_03-N_222	Warn	N	LOINC value is incorrect where MS_Test_Name=ANC	LOINC	MS_Test_Name
LAB_2_07_04-N_222	Warn	N	LOINC value is incorrect where MS_Test_Name=BILI_TOT	LOINC	MS_Test_Name
LAB_2_07_05-N_222	Warn	N	LOINC value is incorrect where MS_Test_Name=CK	LOINC	MS_Test_Name
LAB_2_07_06-N_222	Warn	N	LOINC value is incorrect where MS_Test_Name=CK_MB	LOINC	MS_Test_Name
LAB_2_07_07-N_222	Warn	N	LOINC value is incorrect where MS_Test_Name=CK_MBI	LOINC	MS_Test_Name
LAB_2_07_08-N_222	Warn	N	LOINC value is incorrect where MS_Test_Name=CREATININE	LOINC	MS_Test_Name
LAB_2_07_09-C_222	Warn	N	LOINC value is incorrect where MS_Test_Name=D_DIMER	LOINC	MS_Test_Name
LAB_2_07_09-N_222	Warn	N	LOINC value is incorrect where MS_Test_Name=D_DIMER	LOINC	MS_Test_Name
LAB_2_07_10-N_222	Warn	N	LOINC value is incorrect where MS_Test_Name=SODIUM	LOINC	MS_Test_Name
LAB_2_07_11-N_222	Warn	N	LOINC value is incorrect where MS_Test_Name=GLUCOSE	LOINC	MS_Test_Name

FlagID	FlagType	AbortYN	Flag_Descr	Variable1
ENC_1_00_00-0_102	Fail	Y	ENC table is not sorted by the following variables: PatID, ADate
ENC_1_01_00-0_110	Fail	Y	PatID variable does not exist	PatID
ENC_1_02_00-0_110	Fail	Y	EncounterID variable does not exist	EncounterID
ENC_1_03_00-0_110	Fail	Y	ADate variable does not exist	ADate
ENC_1_04_00-0_110	Fail	Y	DDate variable does not exist	DDate
ENC_1_06_00-0_110	Fail	Y	FacilityID variable does not exist	FacilityID
ENC_1_07_00-0_110	Fail	Y	EncType variable does not exist	EncType
ENC_1_09_00-0_110	Fail	Y	Discharge_Disposition variable does not exist	Discharge_Disposition
ENC_1_10_00-0_110	Fail	Y	Discharge_Status variable does not exist	Discharge_Status
ENC_1_11_00-0_110	Fail	Y	DRG variable does not exist	DRG
ENC_1_12_00-0_110	Fail	Y	DRG_Type variable does not exist	DRG_Type
ENC_1_13_00-0_110	Fail	Y	Admitting_Source variable does not exist	Admitting_Source
ENC_1_04_00-0_111	Fail	Y	DDate variable is not populated	DDate
ENC_1_09_00-0_111	Fail	Y	Discharge_Disposition variable is not populated	Discharge_Disposition
ENC_1_10_00-0_111	Fail	Y	Discharge_Status variable is not populated	Discharge_Status
ENC_1_13_00-0_111	Fail	Y	Admitting_Source variable is not populated	Admitting_Source
ENC_1_01_00-0_112	Fail	Y	PatID variable type does not conform to specifications	PatID
ENC_1_02_00-0_112	Fail	Y	EncounterID variable type does not conform to specifications	EncounterID
ENC_1_03_00-0_112	Fail	Y	ADate variable type does not conform to specifications	ADate
ENC_1_04_00-0_112	Fail	Y	DDate variable type does not conform to specifications	DDate
ENC_1_06_00-0_112	Fail	Y	FacilityID variable type does not conform to specifications	FacilityID
ENC_1_07_00-0_112	Fail	Y	EncType variable type does not conform to specifications	EncType
ENC_1_09_00-0_112	Fail	Y	Discharge_Disposition variable type does not conform to specifications	Discharge_Disposition
ENC_1_10_00-0_112	Fail	Y	Discharge_Status variable type does not conform to specifications	Discharge_Status
ENC_1_11_00-0_112	Fail	Y	DRG variable type does not conform to specifications	DRG
ENC_1_12_00-0_112	Fail	Y	DRG_Type variable type does not conform to specifications	DRG_Type
ENC_1_13_00-0_112	Fail	Y	Admitting_Source variable type does not conform to specifications	Admitting_Source
ENC_1_03_00-0_113	Fail	Y	ADate variable length does not conform to specifications	ADate
ENC_1_04_00-0_113	Fail	Y	DDate variable length does not conform to specifications	DDate
ENC_1_07_00-0_113	Fail	Y	EncType variable length does not conform to specifications	EncType
ENC_1_09_00-0_113	Fail	Y	Discharge_Disposition variable length does not conform to specifications	Discharge_Disposition
ENC_1_10_00-0_113	Fail	Y	Discharge_Status variable length does not conform to specifications	Discharge_Status
ENC_1_11_00-0_113	Fail	Y	DRG variable length does not conform to specifications	DRG
ENC_1_12_00-0_113	Fail	Y	DRG_Type variable length does not conform to specifications	DRG_Type
ENC_1_13_00-0_113	Fail	Y	Admitting_Source variable length does not conform to specifications	Admitting_Source
ENC_1_01_00-0_115	Fail	Y	PatID variable length is less than needed to contain maximum value	PatID
ENC_1_02_00-0_115	Fail	Y	EncounterID variable length is less than needed to contain maximum value	EncounterID
ENC_1_06_00-0_115	Fail	Y	FacilityID variable length is less than needed to contain maximum value	FacilityID
ENC_1_01_00-0_116	Fail	Y	PatID variable is formatted with an inadequate format	PatID
ENC_1_02_00-0_116	Fail	Y	EncounterID variable is formatted with an inadequate format	EncounterID
ENC_1_06_00-0_116	Fail	Y	FacilityID variable is formatted with an inadequate format	FacilityID
ENC_1_01_00-0_120	Fail	Y	PatID variable contains a null value	PatID
ENC_1_02_00-0_120	Fail	Y	EncounterID variable contains a null value	EncounterID
ENC_1_03_00-0_120	Fail	Y	ADate variable contains a null value	ADate
ENC_1_06_00-0_120	Fail	Y	FacilityID variable contains a null value	FacilityID
ENC_1_07_00-0_120	Fail	Y	EncType variable contains a null value	EncType
ENC_1_04_00-0_121	Fail	Y	DDate variable contains an incorrect non-missing value	DDate
ENC_1_06_00-0_121	Fail	Y	FacilityID variable contains an incorrect non-missing value	FacilityID
ENC_1_07_00-0_121	Fail	Y	EncType variable contains an incorrect non-missing value	EncType
ENC_1_09_00-0_121	Fail	Y	Discharge_Disposition variable contains an incorrect non-missing value	Discharge_Disposition
ENC_1_10_00-0_121	Fail	Y	Discharge_Status variable contains an incorrect non-missing value	Discharge_Status
ENC_1_12_00-0_121	Fail	Y	DRG_Type variable contains an incorrect non-missing value	DRG_Type
ENC_1_13_00-0_121	Fail	Y	Admitting_Source variable contains an incorrect non-missing value	Admitting_Source
ENC_1_11_00-0_122	Fail	Y	DRG value contains leading spaces	DRG

FlagID	FlagType	AbortYN	Flag_Descr	Variable1
DIA_1_00_00-0_102	Fail	Y	DIA table is not sorted by the following variables: PatID, ADate
DIA_1_01_00-0_110	Fail	Y	PatID variable does not exist	PatID
DIA_1_02_00-0_110	Fail	Y	EncounterID variable does not exist	EncounterID
DIA_1_03_00-0_110	Fail	Y	ADate variable does not exist	ADate
DIA_1_04_00-0_110	Fail	Y	ProviderID variable does not exist	ProviderID
DIA_1_05_00-0_110	Fail	Y	EncType variable does not exist	EncType
DIA_1_06_00-0_110	Fail	Y	Dx variable does not exist	Dx
DIA_1_07_00-0_110	Fail	Y	Dx_CodeType variable does not exist	Dx_CodeType
DIA_1_08_00-0_110	Fail	Y	OrigDx variable does not exist	OrigDx
DIA_1_09_00-0_110	Fail	Y	PDX variable does not exist	PDX
DIA_1_10_00-0_110	Fail	Y	Padmit variable does not exist	Padmit
DIA_1_09_00-0_111	Fail	Y	PDX variable is not populated	PDX
DIA_1_01_00-0_112	Fail	Y	PatID variable type does not conform to specifications	PatID
DIA_1_02_00-0_112	Fail	Y	EncounterID variable type does not conform to specifications	EncounterID
DIA_1_03_00-0_112	Fail	Y	ADate variable type does not conform to specifications	ADate
DIA_1_04_00-0_112	Fail	Y	ProviderID variable type does not conform to specifications	ProviderID
DIA_1_05_00-0_112	Fail	Y	EncType variable type does not conform to specifications	EncType
DIA_1_06_00-0_112	Fail	Y	Dx variable type does not conform to specifications	Dx
DIA_1_07_00-0_112	Fail	Y	Dx_CodeType variable type does not conform to specifications	Dx_CodeType
DIA_1_08_00-0_112	Fail	Y	OrigDx variable type does not conform to specifications	OrigDx
DIA_1_09_00-0_112	Fail	Y	PDX variable type does not conform to specifications	PDX
DIA_1_10_00-0_112	Fail	Y	Padmit variable type does not conform to specifications	Padmit
DIA_1_03_00-0_113	Fail	Y	ADate variable length does not conform to specifications	ADate
DIA_1_05_00-0_113	Fail	Y	EncType variable length does not conform to specifications	EncType
DIA_1_07_00-0_113	Fail	Y	Dx_CodeType variable length does not conform to specifications	Dx_CodeType
DIA_1_09_00-0_113	Fail	Y	PDX variable length does not conform to specifications	PDX
DIA_1_10_00-0_113	Fail	Y	Padmit variable length does not conform to specifications	Padmit
DIA_1_01_00-0_115	Fail	Y	PatID variable length is less than needed to contain maximum value	PatID
DIA_1_02_00-0_115	Fail	Y	EncounterID variable length is less than needed to contain maximum value	EncounterID
DIA_1_04_00-0_115	Fail	Y	ProviderID variable length is less than needed to contain maximum value	ProviderID
DIA_1_01_00-0_116	Fail	Y	PatID variable is formatted with an inadequate format	PatID
DIA_1_02_00-0_116	Fail	Y	EncounterID variable is formatted with an inadequate format	EncounterID
DIA_1_04_00-0_116	Fail	Y	ProviderID variable is formatted with an inadequate format	ProviderID
DIA_1_01_00-0_120	Fail	Y	PatID variable contains a null value	PatID
DIA_1_02_00-0_120	Fail	Y	EncounterID variable contains a null value	EncounterID
DIA_1_03_00-0_120	Fail	Y	ADate variable contains a null value	ADate
DIA_1_04_00-0_120	Fail	Y	ProviderID variable contains a null value	ProviderID
DIA_1_05_00-0_120	Fail	Y	EncType variable contains a null value	EncType
DIA_1_06_00-0_120	Fail	Y	Dx variable contains a null value	Dx
DIA_1_07_00-0_120	Fail	Y	Dx_CodeType variable contains a null value	Dx_CodeType
DIA_1_10_00-0_120	Fail	Y	Padmit variable contains a null value	Padmit
DIA_1_04_00-0_121	Fail	Y	ProviderID variable contains an incorrect non-missing value	ProviderID
DIA_1_05_00-0_121	Fail	Y	EncType variable contains an incorrect non-missing value	EncType
DIA_1_07_00-0_121	Fail	Y	Dx_CodeType variable contains an incorrect non-missing value	Dx_CodeType
DIA_1_09_00-0_121	Fail	Y	PDX variable contains an incorrect non-missing value	PDX
DIA_1_10_00-0_121	Fail	Y	Padmit variable contains an incorrect non-missing value	Padmit

FlagID	FlagType	AbortYN	Flag_Descr	Variable1
PRO_1_00_00-0_102	Fail	Y	PRO table is not sorted by the following variables: PatID, ADate
PRO_1_01_00-0_110	Fail	Y	PatID variable does not exist	PatID
PRO_1_02_00-0_110	Fail	Y	EncounterID variable does not exist	EncounterID
PRO_1_03_00-0_110	Fail	Y	ADate variable does not exist	ADate
PRO_1_04_00-0_110	Fail	Y	ProviderID variable does not exist	ProviderID
PRO_1_05_00-0_110	Fail	Y	EncType variable does not exist	EncType
PRO_1_06_00-0_110	Fail	Y	Px variable does not exist	Px
PRO_1_07_00-0_110	Fail	Y	Px_CodeType variable does not exist	Px_CodeType
PRO_1_08_00-0_110	Fail	Y	OrigPx variable does not exist	OrigPx
PRO_1_01_00-0_112	Fail	Y	PatID variable type does not conform to specifications	PatID
PRO_1_02_00-0_112	Fail	Y	EncounterID variable type does not conform to specifications	EncounterID
PRO_1_03_00-0_112	Fail	Y	ADate variable type does not conform to specifications	ADate
PRO_1_04_00-0_112	Fail	Y	ProviderID variable type does not conform to specifications	ProviderID
PRO_1_05_00-0_112	Fail	Y	EncType variable type does not conform to specifications	EncType
PRO_1_06_00-0_112	Fail	Y	Px variable type does not conform to specifications	Px
PRO_1_07_00-0_112	Fail	Y	Px_CodeType variable type does not conform to specifications	Px_CodeType
PRO_1_08_00-0_112	Fail	Y	OrigPx variable type does not conform to specifications	OrigPx
PRO_1_03_00-0_113	Fail	Y	ADate variable length does not conform to specifications	ADate
PRO_1_05_00-0_113	Fail	Y	EncType variable length does not conform to specifications	EncType
PRO_1_07_00-0_113	Fail	Y	Px_CodeType variable length does not conform to specifications	Px_CodeType
PRO_1_01_00-0_115	Fail	Y	PatID variable length is less than needed to contain maximum value	PatID
PRO_1_02_00-0_115	Fail	Y	EncounterID variable length is less than needed to contain maximum value	EncounterID
PRO_1_04_00-0_115	Fail	Y	ProviderID variable length is less than needed to contain maximum value	ProviderID
PRO_1_01_00-0_116	Fail	Y	PatID variable is formatted with an inadequate format	PatID
PRO_1_02_00-0_116	Fail	Y	EncounterID variable is formatted with an inadequate format	EncounterID
PRO_1_04_00-0_116	Fail	Y	ProviderID variable is formatted with an inadequate format	ProviderID
PRO_1_01_00-0_120	Fail	Y	PatID variable contains a null value	PatID
PRO_1_02_00-0_120	Fail	Y	EncounterID variable contains a null value	EncounterID
PRO_1_03_00-0_120	Fail	Y	ADate variable contains a null value	ADate
PRO_1_04_00-0_120	Fail	Y	ProviderID variable contains a null value	ProviderID
PRO_1_05_00-0_120	Fail	Y	EncType variable contains a null value	EncType
PRO_1_06_00-0_120	Fail	Y	Px variable contains a null value	Px
PRO_1_07_00-0_120	Fail	Y	Px_CodeType variable contains a null value	Px_CodeType
PRO_1_04_00-0_121	Fail	Y	ProviderID variable contains an incorrect non-missing value	ProviderID
PRO_1_05_00-0_121	Fail	Y	EncType variable contains an incorrect non-missing value	EncType
PRO_1_07_00-0_121	Fail	Y	Px_CodeType variable contains an incorrect non-missing value	Px_CodeType

FlagID	FlagType	AbortYN	Flag_Descr	Variable1
DTH_1_00_00-0_102	Fail	Y	DTH table is not sorted by the following variables: PatID
DTH_1_01_00-0_110	Fail	Y	PatID variable does not exist	PatID
DTH_1_02_00-0_110	Fail	Y	DeathDt variable does not exist	DeathDt
DTH_1_03_00-0_110	Fail	Y	Dtimpute variable does not exist	Dtimpute
DTH_1_04_00-0_110	Fail	Y	Source variable does not exist	Source
DTH_1_05_00-0_110	Fail	Y	Confidence variable does not exist	Confidence
DTH_1_01_00-0_112	Fail	Y	PatID variable type does not conform to specifications	PatID
DTH_1_02_00-0_112	Fail	Y	DeathDt variable type does not conform to specifications	DeathDt
DTH_1_03_00-0_112	Fail	Y	Dtimpute variable type does not conform to specifications	Dtimpute
DTH_1_04_00-0_112	Fail	Y	Source variable type does not conform to specifications	Source
DTH_1_05_00-0_112	Fail	Y	Confidence variable type does not conform to specifications	Confidence
DTH_1_02_00-0_113	Fail	Y	DeathDt variable length does not conform to specifications	DeathDt
DTH_1_03_00-0_113	Fail	Y	Dtimpute variable length does not conform to specifications	Dtimpute
DTH_1_04_00-0_113	Fail	Y	Source variable length does not conform to specifications	Source
DTH_1_05_00-0_113	Fail	Y	Confidence variable length does not conform to specifications	Confidence
DTH_1_01_00-0_115	Fail	Y	PatID variable length is less than needed to contain maximum value	PatID
DTH_1_01_00-0_116	Fail	Y	PatID variable is formatted with an inadequate format	PatID
DTH_1_01_00-0_120	Fail	Y	PatID variable contains a null value	PatID
DTH_1_02_00-0_120	Fail	Y	DeathDt variable contains a null value	DeathDt
DTH_1_03_00-0_120	Fail	Y	Dtimpute variable contains a null value	Dtimpute
DTH_1_04_00-0_120	Fail	Y	Source variable contains a null value	Source
DTH_1_05_00-0_120	Fail	Y	Confidence variable contains a null value	Confidence
DTH_1_03_00-0_121	Fail	Y	Dtimpute variable contains an incorrect non-missing value	Dtimpute
DTH_1_04_00-0_121	Fail	Y	Source variable contains an incorrect non-missing value	Source
DTH_1_05_00-0_121	Fail	Y	Confidence variable contains an incorrect non-missing value	Confidence

FlagID	FlagType	AbortYN	Flag_Descr	Variable1
COD_1_00_00-0_102	Fail	Y	COD table is not sorted by the following variables: PatID
COD_1_01_00-0_110	Fail	Y	PatID variable does not exist	PatID
COD_1_02_00-0_110	Fail	Y	COD variable does not exist	COD
COD_1_03_00-0_110	Fail	Y	CodeType variable does not exist	CodeType
COD_1_04_00-0_110	Fail	Y	Source variable does not exist	Source
COD_1_05_00-0_110	Fail	Y	Confidence variable does not exist	Confidence
COD_1_06_00-0_110	Fail	Y	CauseType variable does not exist	CauseType
COD_1_01_00-0_112	Fail	Y	PatID variable type does not conform to specifications	PatID
COD_1_02_00-0_112	Fail	Y	COD variable type does not conform to specifications	COD
COD_1_03_00-0_112	Fail	Y	CodeType variable type does not conform to specifications	CodeType
COD_1_04_00-0_112	Fail	Y	Source variable type does not conform to specifications	Source
COD_1_05_00-0_112	Fail	Y	Confidence variable type does not conform to specifications	Confidence
COD_1_06_00-0_112	Fail	Y	CauseType variable type does not conform to specifications	CauseType
COD_1_02_00-0_113	Fail	Y	COD variable length does not conform to specifications	COD
COD_1_03_00-0_113	Fail	Y	CodeType variable length does not conform to specifications	CodeType
COD_1_04_00-0_113	Fail	Y	Source variable length does not conform to specifications	Source
COD_1_05_00-0_113	Fail	Y	Confidence variable length does not conform to specifications	Confidence
COD_1_06_00-0_113	Fail	Y	CauseType variable length does not conform to specifications	CauseType
COD_1_01_00-0_115	Fail	Y	PatID variable length is less than needed to contain maximum value	PatID
COD_1_01_00-0_116	Fail	Y	PatID variable is formatted with an inadequate format	PatID
COD_1_01_00-0_120	Fail	Y	PatID variable contains a null value	PatID
COD_1_02_00-0_120	Fail	Y	COD variable contains a null value	COD
COD_1_03_00-0_120	Fail	Y	CodeType variable contains a null value	CodeType
COD_1_04_00-0_120	Fail	Y	Source variable contains a null value	Source
COD_1_05_00-0_120	Fail	Y	Confidence variable contains a null value	Confidence
COD_1_06_00-0_120	Fail	Y	CauseType variable contains a null value	CauseType
COD_1_03_00-0_121	Fail	Y	CodeType variable contains an incorrect non-missing value	CodeType
COD_1_04_00-0_121	Fail	Y	Source variable contains an incorrect non-missing value	Source
COD_1_05_00-0_121	Fail	Y	Confidence variable contains an incorrect non-missing value	Confidence
COD_1_06_00-0_121	Fail	Y	CauseType variable contains an incorrect non-missing value	CauseType
COD_1_02_00-0_122	Fail	Y	COD value contains leading spaces	COD

FlagID	FlagType	AbortYN	Flag_Descr	Variable1
LAB_1_00_00-0_102	Fail	Y	LAB table is not sorted by the following variables: PatID
LAB_1_01_00-0_110	Fail	Y	PatID variable does not exist	PatID
LAB_1_02_00-0_110	Fail	Y	MS_Test_Name variable does not exist	MS_Test_Name
LAB_1_03_00-0_110	Fail	Y	Result_Type variable does not exist	Result_Type
LAB_1_04_00-0_110	Fail	Y	MS_Test_Sub_Category variable does not exist	MS_Test_Sub_Category
LAB_1_05_00-0_110	Fail	Y	Fast_Ind variable does not exist	Fast_Ind
LAB_1_06_00-0_110	Fail	Y	Specimen_Source variable does not exist	Specimen_Source
LAB_1_07_00-0_110	Fail	Y	LOINC variable does not exist	LOINC
LAB_1_08_00-0_110	Fail	Y	Stat variable does not exist	Stat
LAB_1_09_00-0_110	Fail	Y	Pt_Loc variable does not exist	Pt_Loc
LAB_1_10_00-0_110	Fail	Y	Result_Loc variable does not exist	Result_Loc
LAB_1_11_00-0_110	Fail	Y	LOCAL_CD variable does not exist	LOCAL_CD
LAB_1_12_00-0_110	Fail	Y	BATTERY_CD variable does not exist	BATTERY_CD
LAB_1_13_00-0_110	Fail	Y	PX variable does not exist	PX
LAB_1_14_00-0_110	Fail	Y	PX_CodeType variable does not exist	PX_CodeType
LAB_1_15_00-0_110	Fail	Y	Order_dt variable does not exist	Order_dt
LAB_1_16_00-0_110	Fail	Y	Lab_dt variable does not exist	Lab_dt
LAB_1_17_00-0_110	Fail	Y	Lab_tm variable does not exist	Lab_tm
LAB_1_18_00-0_110	Fail	Y	Result_dt variable does not exist	Result_dt
LAB_1_19_00-0_110	Fail	Y	Result_tm variable does not exist	Result_tm
LAB_1_20_00-0_110	Fail	Y	Orig_Result variable does not exist	Orig_Result
LAB_1_21_00-0_110	Fail	Y	MS_Result_C variable does not exist	MS_Result_C
LAB_1_22_00-0_110	Fail	Y	MS_Result_N variable does not exist	MS_Result_N
LAB_1_23_00-0_110	Fail	Y	Modifier variable does not exist	Modifier
LAB_1_24_00-0_110	Fail	Y	Orig_Result_unit variable does not exist	Orig_Result_unit
LAB_1_25_00-0_110	Fail	Y	Std_Result_unit variable does not exist	Std_Result_unit
LAB_1_26_00-0_110	Fail	Y	MS_Result_unit variable does not exist	MS_Result_unit
LAB_1_27_00-0_110	Fail	Y	Norm_Range_low variable does not exist	Norm_Range_low
LAB_1_28_00-0_110	Fail	Y	Modifier_low variable does not exist	Modifier_low
LAB_1_29_00-0_110	Fail	Y	Norm_Range_high variable does not exist	Norm_Range_high
LAB_1_30_00-0_110	Fail	Y	Modifier_high variable does not exist	Modifier_high
LAB_1_31_00-0_110	Fail	Y	Abn_ind variable does not exist	Abn_ind
LAB_1_32_00-0_110	Fail	Y	Order_dept variable does not exist	Order_dept
LAB_1_33_00-0_110	Fail	Y	FacilityID variable does not exist	FacilityID
LAB_1_34_00-0_110	Fail	Y	LabID variable does not exist	LabID
LAB_1_01_00-0_112	Fail	Y	PatID variable type does not conform to specifications	PatID
LAB_1_02_00-0_112	Fail	Y	MS_Test_Name variable type does not conform to specifications	MS_Test_Name
LAB_1_03_00-0_112	Fail	Y	Result_Type variable type does not conform to specifications	Result_Type
LAB_1_04_00-0_112	Fail	Y	MS_Test_Sub_Category variable type does not conform to specifications	MS_Test_Sub_Category
LAB_1_05_00-0_112	Fail	Y	Fast_Ind variable type does not conform to specifications	Fast_Ind
LAB_1_06_00-0_112	Fail	Y	Specimen_Source variable type does not conform to specifications	Specimen_Source
LAB_1_07_00-0_112	Fail	Y	LOINC variable type does not conform to specifications	LOINC
LAB_1_08_00-0_112	Fail	Y	Stat variable type does not conform to specifications	Stat
LAB_1_09_00-0_112	Fail	Y	Pt_Loc variable type does not conform to specifications	Pt_Loc
LAB_1_10_00-0_112	Fail	Y	Result_Loc variable type does not conform to specifications	Result_Loc
LAB_1_11_00-0_112	Fail	Y	LOCAL_CD variable type does not conform to specifications	LOCAL_CD
LAB_1_12_00-0_112	Fail	Y	BATTERY_CD variable type does not conform to specifications	BATTERY_CD
LAB_1_13_00-0_112	Fail	Y	PX variable type does not conform to specifications	PX
LAB_1_14_00-0_112	Fail	Y	PX_CodeType variable type does not conform to specifications	PX_CodeType
LAB_1_15_00-0_112	Fail	Y	Order_dt variable type does not conform to specifications	Order_dt
LAB_1_16_00-0_112	Fail	Y	Lab_dt variable type does not conform to specifications	Lab_dt
LAB_1_17_00-0_112	Fail	Y	Lab_tm variable type does not conform to specifications	Lab_tm
LAB_1_18_00-0_112	Fail	Y	Result_dt variable type does not conform to specifications	Result_dt
LAB_1_19_00-0_112	Fail	Y	Result_tm variable type does not conform to specifications	Result_tm
LAB_1_20_00-0_112	Fail	Y	Orig_Result variable type does not conform to specifications	Orig_Result
LAB_1_21_00-0_112	Fail	Y	MS_Result_C variable type does not conform to specifications	MS_Result_C
LAB_1_22_00-0_112	Fail	Y	MS_Result_N variable type does not conform to specifications	MS_Result_N
LAB_1_23_00-0_112	Fail	Y	Modifier variable type does not conform to specifications	Modifier
LAB_1_24_00-0_112	Fail	Y	Orig_Result_unit variable type does not conform to specifications	Orig_Result_unit
LAB_1_25_00-0_112	Fail	Y	Std_Result_unit variable type does not conform to specifications	Std_Result_unit
LAB_1_26_00-0_112	Fail	Y	MS_Result_unit variable type does not conform to specifications	MS_Result_unit
LAB_1_27_00-0_112	Fail	Y	Norm_Range_low variable type does not conform to specifications	Norm_Range_low
LAB_1_28_00-0_112	Fail	Y	Modifier_low variable type does not conform to specifications	Modifier_low
LAB_1_29_00-0_112	Fail	Y	Norm_Range_high variable type does not conform to specifications	Norm_Range_high
LAB_1_30_00-0_112	Fail	Y	Modifier_high variable type does not conform to specifications	Modifier_high
LAB_1_31_00-0_112	Fail	Y	Abn_ind variable type does not conform to specifications	Abn_ind
LAB_1_32_00-0_112	Fail	Y	Order_dept variable type does not conform to specifications	Order_dept
LAB_1_33_00-0_112	Fail	Y	FacilityID variable type does not conform to specifications	FacilityID
LAB_1_34_00-0_112	Fail	Y	LabID variable type does not conform to specifications	LabID
LAB_1_02_00-0_113	Fail	Y	MS_Test_Name variable length does not conform to specifications	MS_Test_Name
LAB_1_03_00-0_113	Fail	Y	Result_Type variable length does not conform to specifications	Result_Type
LAB_1_04_00-0_113	Fail	Y	MS_Test_Sub_Category variable length does not conform to specifications	MS_Test_Sub_Category
LAB_1_05_00-0_113	Fail	Y	Fast_Ind variable length does not conform to specifications	Fast_Ind
LAB_1_06_00-0_113	Fail	Y	Specimen_Source variable length does not conform to specifications	Specimen_Source
LAB_1_07_00-0_113	Fail	Y	LOINC variable length does not conform to specifications	LOINC
LAB_1_08_00-0_113	Fail	Y	Stat variable length does not conform to specifications	Stat
LAB_1_09_00-0_113	Fail	Y	Pt_Loc variable length does not conform to specifications	Pt_Loc
LAB_1_10_00-0_113	Fail	Y	Result_Loc variable length does not conform to specifications	Result_Loc
LAB_1_14_00-0_113	Fail	Y	PX_CodeType variable length does not conform to specifications	PX_CodeType
LAB_1_15_00-0_113	Fail	Y	Order_dt variable length does not conform to specifications	Order_dt
LAB_1_16_00-0_113	Fail	Y	Lab_dt variable length does not conform to specifications	Lab_dt
LAB_1_17_00-0_113	Fail	Y	Lab_tm variable length does not conform to specifications	Lab_tm
LAB_1_18_00-0_113	Fail	Y	Result_dt variable length does not conform to specifications	Result_dt
LAB_1_19_00-0_113	Fail	Y	Result_tm variable length does not conform to specifications	Result_tm
LAB_1_20_00-0_113	Fail	Y	Orig_Result variable length does not conform to specifications	Orig_Result
LAB_1_21_00-0_113	Fail	Y	MS_Result_C variable length does not conform to specifications	MS_Result_C
LAB_1_22_00-0_113	Fail	Y	MS_Result_N variable length does not conform to specifications	MS_Result_N
LAB_1_23_00-0_113	Fail	Y	Modifier variable length does not conform to specifications	Modifier
LAB_1_24_00-0_113	Fail	Y	Orig_Result_unit variable length does not conform to specifications	Orig_Result_unit
LAB_1_25_00-0_113	Fail	Y	Std_Result_unit variable length does not conform to specifications	Std_Result_unit
LAB_1_26_00-0_113	Fail	Y	MS_Result_unit variable length does not conform to specifications	MS_Result_unit
LAB_1_27_00-0_113	Fail	Y	Norm_Range_low variable length does not conform to specifications	Norm_Range_low
LAB_1_28_00-0_113	Fail	Y	Modifier_low variable length does not conform to specifications	Modifier_low
LAB_1_29_00-0_113	Fail	Y	Norm_Range_high variable length does not conform to specifications	Norm_Range_high
LAB_1_30_00-0_113	Fail	Y	Modifier_high variable length does not conform to specifications	Modifier_high
LAB_1_31_00-0_113	Fail	Y	Abn_ind variable length does not conform to specifications	Abn_ind
LAB_1_01_00-0_115	Fail	Y	PatID variable length is less than needed to contain maximum value	PatID
LAB_1_33_00-0_115	Fail	Y	FacilityID variable length is less than needed to contain maximum value	FacilityID
LAB_1_34_00-0_115	Fail	Y	LabID variable length is less than needed to contain maximum value	LabID
LAB_1_01_00-0_116	Fail	Y	PatID variable is formatted with an inadequate format	PatID
LAB_1_33_00-0_116	Fail	Y	FacilityID variable is formatted with an inadequate format	FacilityID
LAB_1_34_00-0_116	Fail	Y	LabID variable is formatted with an inadequate format	LabID
LAB_1_01_00-0_120	Fail	Y	PatID variable contains a null value	PatID
LAB_1_02_00-0_120	Fail	Y	MS_Test_Name variable contains a null value	MS_Test_Name
LAB_1_03_00-0_120	Fail	Y	Result_Type variable contains a null value	Result_Type
LAB_1_05_00-0_120	Fail	Y	Fast_Ind variable contains a null value	Fast_Ind
LAB_1_06_00-0_120	Fail	Y	Specimen_Source variable contains a null value	Specimen_Source
LAB_1_08_00-0_120	Fail	Y	Stat variable contains a null value	Stat
LAB_1_09_00-0_120	Fail	Y	Pt_Loc variable contains a null value	Pt_Loc
LAB_1_20_00-0_120	Fail	Y	Orig_Result variable contains a null value	Orig_Result
LAB_1_23_00-0_120	Fail	Y	Modifier variable contains a null value	Modifier
LAB_1_31_00-0_120	Fail	Y	Abn_ind variable contains a null value	Abn_ind
LAB_1_34_00-0_120	Fail	Y	LabID variable contains a null value	LabID
LAB_1_02_00-0_121	Fail	Y	MS_Test_Name variable contains an incorrect non-missing value	MS_Test_Name
LAB_1_03_00-0_121	Fail	Y	Result_Type variable contains an incorrect non-missing value	Result_Type
LAB_1_04_00-0_121	Fail	Y	MS_Test_Sub_Category variable contains an incorrect non-missing value	MS_Test_Sub_Category
LAB_1_05_00-0_121	Fail	Y	Fast_Ind variable contains an incorrect non-missing value	Fast_Ind
LAB_1_06_00-0_121	Fail	Y	Specimen_Source variable contains an incorrect non-missing value	Specimen_Source
LAB_1_08_00-0_121	Fail	Y	Stat variable contains an incorrect non-missing value	Stat
LAB_1_09_00-0_121	Fail	Y	Pt_Loc variable contains an incorrect non-missing value	Pt_Loc
LAB_1_10_00-0_121	Fail	Y	Result_Loc variable contains an incorrect non-missing value	Result_Loc
LAB_1_14_00-0_121	Fail	Y	PX_CodeType variable contains an incorrect non-missing value	PX_CodeType
LAB_1_21_00-0_121	Warn	N	MS_Result_C variable contains an incorrect non-missing value	MS_Result_C
LAB_1_22_00-0_121	Warn	N	MS_Result_N variable contains an incorrect non-missing value	MS_Result_N
LAB_1_23_00-0_121	Fail	Y	Modifier variable contains an incorrect non-missing value	Modifier
LAB_1_26_00-0_121	Warn	N	MS_Result_unit variable contains an incorrect non-missing value	MS_Result_unit
LAB_1_27_00-0_121	Warn	N	Norm_Range_low variable contains an incorrect non-missing value	Norm_Range_low
LAB_1_28_00-0_121	Fail	Y	Modifier_low variable contains an incorrect non-missing value	Modifier_low
LAB_1_29_00-0_121	Warn	N	Norm_Range_high variable contains an incorrect non-missing value	Norm_Range_high
LAB_1_30_00-0_121	Fail	Y	Modifier_high variable contains an incorrect non-missing value	Modifier_high
LAB_1_31_00-0_121	Fail	Y	Abn_ind variable contains an incorrect non-missing value	Abn_ind
LAB_1_33_00-0_121	Fail	Y	FacilityID variable contains an incorrect non-missing value	FacilityID
LAB_1_07_00-0_122	Fail	Y	LOINC value contains leading spaces	LOINC
LAB_1_26_00-0_122	Fail	Y	MS_Result_unit value contains leading spaces	MS_Result_unit
LAB_1_27_00-0_122	Fail	Y	Norm_Range_low value contains leading spaces	Norm_Range_low
LAB_1_29_00-0_122	Fail	Y	Norm_Range_high value contains leading spaces	Norm_Range_high

FlagID	FlagType	AbortYN	Flag_Descr	Variable1	Variable2	Variable3
ENR-VIT_2_01_00-0_201	Note	N	PatID value present in ENR table, but not in the VIT table	PatID
ENR-IRX_2_01_00-0_201	Note	N	PatID value present in ENR table, but not in the IRX table	PatID
ENR-TXN_2_01_00-0_201	Note	N	PatID value present in ENR table, but not in the TXN table	PatID
ENR-PRE_2_01_00-0_201	Note	N	PatID value present in ENR table, but not in the PRE table	PatID
ENR-PRR_2_01_00-0_201	Note	N	PatID value present in ENR table, but not in the PRR table	PatID
ENR-DEM_2_01_00-0_201	Note	N	PatID value present in ENR table, but not in the DEM table	PatID
ENR-DIS_2_01_00-0_201	Note	N	PatID value present in ENR table, but not in the DIS table	PatID
ENR-ENC_2_01_00-0_201	Note	N	PatID value present in ENR table, but not in the ENC table	PatID
ENR-DIA_2_01_00-0_201	Note	N	PatID value present in ENR table, but not in the DIA table	PatID
ENR-PRO_2_01_00-0_201	Note	N	PatID value present in ENR table, but not in the PRO table	PatID
ENR-DTH_2_01_00-0_201	Note	N	PatID value present in ENR table, but not in the DTH table	PatID
ENR-COD_2_01_00-0_201	Note	N	PatID value present in ENR table, but not in the COD table	PatID
ENR-LAB_2_01_00-0_201	Note	N	PatID value present in ENR table, but not in the LAB table	PatID
ENR_2_01_00-0_209	Warn	N	PatID variable length is greater than needed to contain maximum value across tables	PatID
ENR_2_00_00-0_211	Fail	Y	Duplicate record(s) present for unique key variable(s): PatID, Enr_Start, Enr_End, MedCov, DrugCov, Chart, PlanType, PayerType
ENR_2_01_00-0_215	Fail	Y	Overlapping enrollment span(s) across records by PatID	PatID	Enr_Start	Enr_End
ENR_2_01_00-0_216	Warn	N	Consecutive, non-bridged enrollment span(s) across records by PatID	PatID	Enr_Start	Enr_End
ENR_2_02_00-0_226	Fail	Y	Enr_Start value occurs after Enr_End value	Enr_Start	Enr_End

FlagID	FlagType	AbortYN	Flag_Descr	Variable1	Variable2
VIT-ENR_2_01_00-0_201	Warn	N	PatID value present in VIT table, but not in the ENR table	PatID
VIT-ENC_2_02_00-0_201	Warn	N	EncounterID value present in VIT table, but not in the ENC table	EncounterID	EncounterID
VIT-ENR_2_01_00-0_203	Fail	Y	PatID variable length is not consistent between tables	PatID
VIT-ENC_2_02_00-0_203	Fail	Y	EncounterID variable length is not consistent between tables	EncounterID	EncounterID
VIT-DEM_2_03_00-0_206	Warn	N	Measure_Date value occurs before Birth_Date value	Measure_Date	Birth_Date
VIT_2_01_00-0_209	Warn	N	PatID variable length is greater than needed to contain maximum value across tables	PatID
VIT_2_02_00-0_209	Warn	N	EncounterID variable length is greater than needed to contain maximum value across tables	EncounterID

FlagID	FlagType	AbortYN	Flag_Descr	Variable1	Variable2
IRX-ENR_2_01_00-0_201	Warn	N	PatID value present in IRX table, but not in the ENR table	PatID
IRX-ENC_2_02_00-0_201	Warn	N	EncounterID value present in IRX table, but not in the ENC table	EncounterID	EncounterID
IRX-ENR_2_01_00-0_203	Fail	Y	PatID variable length is not consistent between tables	PatID
IRX-ENC_2_02_00-0_203	Fail	Y	EncounterID variable length is not consistent between tables	EncounterID	EncounterID
IRX-ENC_2_05_00-0_205	Warn	N	RxADate value occurs after DDate value	RxADate	DDate
IRX-DEM_2_05_00-0_206	Warn	N	RxADate value occurs before Birth_Date value	RxADate	Birth_Date
IRX-ENC_2_05_00-0_206	Warn	N	RxADate value occurs before ADate value	RxADate	ADate
IRX_2_01_00-0_209	Warn	N	PatID variable length is greater than needed to contain maximum value across tables	PatID
IRX_2_02_00-0_209	Warn	N	EncounterID variable length is greater than needed to contain maximum value across tables	EncounterID
IRX_2_04_00-0_209	Warn	N	RxID variable length is greater than needed to contain maximum value across tables	RxID
IRX_2_00_00-0_211	Fail	Y	Duplicate record(s) present for unique key variable(s): RxID

FlagID	FlagType	AbortYN	Flag_Descr	Variable1	Variable2
TXN-ENR_2_01_00-0_201	Warn	N	PatID value present in TXN table, but not in the ENR table	PatID
TXN-ENC_2_02_00-0_201	Warn	N	EncounterID value present in TXN table, but not in the ENC table	EncounterID	EncounterID
TXN-ENR_2_01_00-0_203	Fail	Y	PatID variable length is not consistent between tables	PatID
TXN-ENC_2_02_00-0_203	Fail	Y	EncounterID variable length is not consistent between tables	EncounterID	EncounterID
TXN-ENC_2_08_00-0_205	Warn	N	TDate_Start value occurs after DDate value	TDate_Start	DDate
TXN-ENC_2_10_00-0_205	Warn	N	TDate_End value occurs after DDate value	TDate_End	DDate
TXN-DEM_2_08_00-0_206	Warn	N	TDate_Start value occurs before Birth_Date value	TDate_Start	Birth_Date
TXN-ENC_2_08_00-0_206	Warn	N	TDate_Start value occurs before ADate value	TDate_Start	ADate
TXN-ENC_2_10_00-0_206	Warn	N	TDate_End value occurs before ADate value	TDate_End	ADate
TXN_2_01_00-0_209	Warn	N	PatID variable length is greater than needed to contain maximum value across tables	PatID
TXN_2_02_00-0_209	Warn	N	EncounterID variable length is greater than needed to contain maximum value across tables	EncounterID
TXN_2_03_00-0_209	Warn	N	TransID variable length is greater than needed to contain maximum value across tables	TransID
TXN_2_00_00-0_211	Fail	Y	Duplicate record(s) present for unique key variable(s): TransID

6 Quality Checks

6.1 Basic Integrity Checks

6.1.1 Partition Specific Integrity Checks

6.2 Level 1 Quality Checks

6.2.1 Table of Contents

Enrollment Level 1 Quality Checks

Vital Signs Level 1 Quality Checks

Inpatient Pharmacy Level 1 Quality Checks

Inpatient Infusion Level 1 Quality Checks

Prescribing Level 1 Quality Checks

Facility Level 1 Quality Checks

Provider Level 1 Quality Checks

Patient Reported Response Level 1 Quality Checks

Patient Reported Survey Level 1 Quality Checks

Demographic Level 1 Quality Checks

Dispensing Level 1 Quality Checks

Encounter Level 1 Quality Checks

Diagnosis Level 1 Quality Checks

Procedure Level 1 Quality Checks

Death Level 1 Quality Checks

Cause of Death Level 1 Quality Checks

Laboratory Result Level 1 Quality Checks

6.3 Level 2 Quality Checks

6.3.1 Table of Contents

Enrollment Level 2 Quality Checks

Vital Signs Level 2 Quality Checks

Inpatient Pharmacy Level 2 Quality Checks

Inpatient Infusion Level 2 Quality Checks

Prescribing Level 2 Quality Checks

Facility Level 2 Quality Checks

Provider Level 2 Quality Checks

Patient Reported Response Level 2 Quality Checks

Patient Reported Survey Level 2 Quality Checks

Demographic Level 2 Quality Checks

Dispensing Level 2 Quality Checks

Encounter Level 2 Quality Checks

Diagnosis Level 2 Quality Checks

Procedure Level 2 Quality Checks

Death Level 2 Quality Checks

Cause of Death Level 2 Quality Checks

Laboratory Result Level 2 Quality Checks

6.4 Level 3 Quality Checks

6.4.1 Table of Contents

Enrollment Level 3 Quality Checks

Inpatient Pharmacy Level 3 Quality Checks

Inpatient Infusion Level 3 Quality Checks

Prescribing Level 3 Quality Checks

Facility Level 3 Quality Checks

Provider Level 3 Quality Checks

Patient Reported Response Level 3 Quality Checks

Patient Reported Survey Level 3 Quality Checks

Demographic Level 3 Quality Checks

Dispensing Level 3 Quality Checks

Encounter Level 3 Quality Checks

Diagnosis Level 3 Quality Checks

Procedure Level 3 Quality Checks

Death Level 3 Quality Checks

Cause of Death Level 3 Quality Checks

FlagID	FlagType	AbortYN	Flag_Descr	Variable1	Variable2
PRE-ENR_2_01_00-0_201	Warn	N	PatID value present in PRE table, but not in the ENR table	PatID
PRE-ENC_2_02_00-0_201	Warn	N	EncounterID value present in PRE table, but not in the ENC table	EncounterID	EncounterID
PRE-PVD_2_04_00-0_201	Fail	Y	ProviderID value present in PRE table, but not in the PVD table	ProviderID	ProviderID
PRE-ENR_2_01_00-0_203	Fail	Y	PatID variable length is not consistent between tables	PatID
PRE-ENC_2_02_00-0_203	Fail	Y	EncounterID variable length is not consistent between tables	EncounterID	EncounterID
PRE-PVD_2_04_00-0_203	Fail	Y	ProviderID variable length is not consistent between tables	ProviderID	ProviderID
PRE-ENR_2_05_00-0_206	Warn	N	OrderDate value occurs before Enr_Start value	OrderDate	Enr_Start
PRE-DEM_2_05_00-0_206	Warn	N	OrderDate value occurs before Birth_Date value	OrderDate	Birth_Date
PRE_2_01_00-0_209	Warn	N	PatID variable length is greater than needed to contain maximum value across tables	PatID
PRE_2_02_00-0_209	Warn	N	EncounterID variable length is greater than needed to contain maximum value across tables	EncounterID
PRE_2_03_00-0_209	Warn	N	PrescribingID variable length is greater than needed to contain maximum value across tables	PrescribingID
PRE_2_04_00-0_209	Warn	N	ProviderID variable length is greater than needed to contain maximum value across tables	ProviderID
PRE_2_00_00-0_211	Fail	Y	Duplicate record(s) present for unique key variable(s): PrescribingID
PRE_2_07_00-0_223	Warn	N	Rx value is incorrect based on Rx_CodeType value	Rx	Rx_CodeType
PRE_2_07_00-0_228	Warn	N	Rx value length is incorrect based on Rx_CodeType	Rx	Rx_CodeType

FlagID	FlagType	AbortYN	Flag_Descr	Variable1	Variable2
FAC-ENC_2_01_00-0_201	Note	N	FacilityID value present in FAC table, but not in the ENC table	FacilityID
FAC-LAB_2_01_00-0_201	Note	N	FacilityID value present in FAC table, but not in the LAB table	FacilityID
FAC_2_01_00-0_209	Warn	N	FacilityID variable length is greater than needed to contain maximum value across tables	FacilityID
FAC_2_00_00-0_211	Fail	Y	Duplicate record(s) present for unique key variable(s): FacilityID
FAC_2_02_00-0_223	Warn	N	Facility_Location value is incorrect based on FacilityID value	Facility_Location	FacilityID

FlagID	FlagType	AbortYN	Flag_Descr	Variable1	Variable2
PVD-PRE_2_01_00-0_201	Note	N	ProviderID value present in PVD table, but not in the PRE table	ProviderID
PVD-DIS_2_01_00-0_201	Note	N	ProviderID value present in PVD table, but not in the DIS table	ProviderID
PVD-DIA_2_01_00-0_201	Note	N	ProviderID value present in PVD table, but not in the DIA table	ProviderID
PVD-PRO_2_01_00-0_201	Note	N	ProviderID value present in PVD table, but not in the PRO table	ProviderID
PVD_2_01_00-0_209	Warn	N	ProviderID variable length is greater than needed to contain maximum value across tables	ProviderID
PVD_2_00_00-0_211	Fail	Y	Duplicate record(s) present for unique key variable(s): ProviderID
PVD_2_03_00-0_228	Warn	N	Specialty_CodeType value length is incorrect based on Specialty	Specialty_CodeType	Specialty

FlagID	FlagType	AbortYN	Flag_Descr	Variable1	Variable2
PRR-ENR_2_01_00-0_201	Warn	N	PatID value present in PRR table, but not in the ENR table	PatID
PRR-ENC_2_02_00-0_201	Warn	N	EncounterID value present in PRR table, but not in the ENC table	EncounterID	EncounterID
PRR-PRS_2_03_00-0_201	Warn	N	PRM_Code value present in PRR table, but not in the PRS table	PRM_Code	PRM_Code
PRR-PRS_2_04_00-0_201	Warn	N	SurveyID value present in PRR table, but not in the PRS table	SurveyID	SurveyID
PRR-PRS_2_05_00-0_201	Warn	N	QuestionID value present in PRR table, but not in the PRS table	QuestionID	QuestionID
PRR-PRS_2_06_00-0_201	Warn	N	QuestionVerID value present in PRR table, but not in the PRS table	QuestionVerID	QuestionVerID
PRR-ENR_2_01_00-0_203	Fail	Y	PatID variable length is not consistent between tables	PatID
PRR-ENC_2_02_00-0_203	Fail	Y	EncounterID variable length is not consistent between tables	EncounterID	EncounterID
PRR-PRS_2_07_00-0_206	Warn	N	Response_Dt value occurs before Question_Dt value	Response_Dt	Question_Dt
PRR_2_01_00-0_209	Warn	N	PatID variable length is greater than needed to contain maximum value across tables	PatID
PRR_2_02_00-0_209	Warn	N	EncounterID variable length is greater than needed to contain maximum value across tables	EncounterID
PRR_2_04_00-0_209	Warn	N	SurveyID variable length is greater than needed to contain maximum value across tables	SurveyID
PRR_2_06_00-0_209	Warn	N	QuestionVerID variable length is greater than needed to contain maximum value across tables	QuestionVerID

FlagID	FlagType	AbortYN	Flag_Descr	Variable1	Variable2
PRS-PRR_2_01_00-0_201	Note	N	PRM_Code value present in PRS table, but not in the PRR table	PRM_Code	PRM_Code
PRS-PRR_2_02_00-0_201	Note	N	SurveyID value present in PRS table, but not in the PRR table	SurveyID	SurveyID
PRS-PRR_2_03_00-0_201	Note	N	QuestionID value present in PRS table, but not in the PRR table	QuestionID	QuestionID
PRS-PRR_2_04_00-0_201	Note	N	QuestionVerID value present in PRS table, but not in the PRR table	QuestionVerID	QuestionVerID
PRS-PRR_2_01_00-0_203	Fail	Y	PRM_Code variable length is not consistent between tables	PRM_Code	PRM_Code
PRS-PRR_2_02_00-0_203	Fail	Y	SurveyID variable length is not consistent between tables	SurveyID	SurveyID
PRS_2_02_00-0_209	Warn	N	SurveyID variable length is greater than needed to contain maximum value across tables	SurveyID
PRS_2_03_00-0_209	Warn	N	QuestionID variable length is greater than needed to contain maximum value across tables	QuestionID
PRS_2_04_00-0_209	Warn	N	QuestionVerID variable length is greater than needed to contain maximum value across tables	QuestionVerID
PRS_2_00_00-0_211	Fail	Y	Duplicate record(s) present for unique key variable(s): PRM_Code, SurveyID, QuestionID, QuestionVerID

FlagID	FlagType	AbortYN	Flag_Descr	Variable1	Variable2
DEM-ENR_2_01_00-0_201	Warn	N	PatID value present in DEM table, but not in the ENR table	PatID
DEM-ENR_2_01_00-0_203	Fail	Y	PatID variable length is not consistent between tables	PatID
DEM-ENR_2_02_00-0_205	Warn	N	Birth_Date value occurs after Enr_Start value	Birth_Date	Enr_Start
DEM-PRE_2_02_00-0_205	Warn	N	Birth_Date value occurs after OrderDate value	Birth_Date	OrderDate
DEM_2_01_00-0_209	Warn	N	PatID variable length is greater than needed to contain maximum value across tables	PatID
DEM_2_00_00-0_211	Fail	Y	Duplicate record(s) present for unique key variable(s): PatID
DEM_2_04_00-0_224	Note	N	Hispanic value does not match ImputedHispanic value	Hispanic	ImputedHispanic
DEM_2_05_00-0_224	Note	N	Race value does not match ImputedRace value	Race	ImputedRace
DEM_2_07_00-0_227	Warn	N	PostalCode_Date value occurs before Birth_Date value	PostalCode_Date	Birth_Date

FlagID	FlagType	AbortYN	Flag_Descr	Variable1	Variable2
DIS-ENR_2_01_00-0_201	Warn	N	PatID value present in DIS table, but not in the ENR table	PatID
DIS-PVD_2_07_00-0_201	Fail	Y	ProviderID value present in DIS table, but not in the PVD table	ProviderID	ProviderID
DIS-ENR_2_01_00-0_203	Fail	Y	PatID variable length is not consistent between tables	PatID
DIS-PVD_2_07_00-0_203	Fail	Y	ProviderID variable length is not consistent between tables	ProviderID	ProviderID
DIS-DEM_2_02_00-0_206	Warn	N	RxDate value occurs before Birth_Date value	RxDate	Birth_Date
DIS_2_01_00-0_209	Warn	N	PatID variable length is greater than needed to contain maximum value across tables	PatID
DIS_2_07_00-0_209	Warn	N	ProviderID variable length is greater than needed to contain maximum value across tables	ProviderID
DIS_2_00_00-0_211	Fail	Y	Duplicate record(s) present for unique key variable(s): PatID, RxDate, Rx, Rx_Codetype, ProviderID
DIS_2_03_00-0_223	Warn	N	Rx value is incorrect based on Rx_Codetype value	Rx	Rx_Codetype
DIS_2_03_00-0_228	Warn	N	Rx value length is incorrect based on Rx_Codetype	Rx	Rx_Codetype

FlagID	FlagType	AbortYN	Flag_Descr	Variable1	Variable2	Variable3	Variable4
ENC-ENR_2_01_00-0_201	Warn	N	PatID value present in ENC table, but not in the ENR table	PatID
ENC-VIT_2_02_00-0_201	Note	N	EncounterID value present in ENC table, but not in the VIT table	EncounterID
ENC-IRX_2_02_00-0_201	Note	N	EncounterID value present in ENC table, but not in the IRX table	EncounterID
ENC-TXN_2_02_00-0_201	Note	N	EncounterID value present in ENC table, but not in the TXN table	EncounterID
ENC-PRE_2_02_00-0_201	Note	N	EncounterID value present in ENC table, but not in the PRE table	EncounterID
ENC-PRR_2_02_00-0_201	Note	N	EncounterID value present in ENC table, but not in the PRR table	EncounterID
ENC-DIA_2_02_00-0_201	Note	N	EncounterID value present in ENC table, but not in the DIA table	EncounterID
ENC-PRO_2_02_00-0_201	Note	N	EncounterID value present in ENC table, but not in the PRO table	EncounterID
ENC-FAC_2_06_00-0_201	Fail	Y	FacilityID value present in ENC table, but not in the FAC table	FacilityID	FacilityID
ENC-ENR_2_01_00-0_203	Fail	Y	PatID variable length is not consistent between tables	PatID
ENC-FAC_2_06_00-0_203	Fail	Y	FacilityID variable length is not consistent between tables	FacilityID	FacilityID
ENC-DEM_2_03_00-0_206	Warn	N	ADate value occurs before Birth_Date value	ADate	Birth_Date
ENC_2_01_00-0_209	Warn	N	PatID variable length is greater than needed to contain maximum value across tables	PatID
ENC_2_02_00-0_209	Warn	N	EncounterID variable length is greater than needed to contain maximum value across tables	EncounterID
ENC_2_06_00-0_209	Warn	N	FacilityID variable length is greater than needed to contain maximum value across tables	FacilityID
ENC_2_00_00-0_211	Fail	Y	Duplicate record(s) present for unique key variable(s): EncounterID
ENC_2_04_00-0_223	Warn	N	DDate value is incorrect based on EncType value	DDate	EncType
ENC_2_09_00-0_223	Warn	N	Discharge_Disposition value is incorrect based on EncType value	Discharge_Disposition	EncType
ENC_2_10_00-0_223	Warn	N	Discharge_Status value is incorrect based on EncType value	Discharge_Status	EncType
ENC_2_13_00-0_223	Warn	N	Admitting_Source value is incorrect based on EncType value	Admitting_Source	EncType
ENC_2_03_00-0_226	Warn	N	ADate value occurs after DDate value	ADate	DDate
ENC_2_12_00-0_229	Warn	N	DRG_Type value is incorrect based on the date value of ADate	DRG_Type	ADate
ENC_2_07_00-0_244	Warn	N	Incorrect combination of values for EncType, DDate, Discharge_Disposition, and Discharge_Status	EncType	DDate	Discharge_Disposition	Discharge_Status
ENC_2_07_90-0_245	Warn	N	Met rate threshold for incorrect combination of EncType, DDate, Discharge_Disposition, Discharge_Status	EncType	DDate	Discharge_Disposition	Discharge_Status
ENC_2_07_91-0_245	Warn	N	Met rate threshold for incorrect combination of EncType, DDate, Discharge_Disposition, Discharge_Status	EncType	DDate	Discharge_Disposition	Discharge_Status
ENC_2_07_92-0_245	Warn	N	Met rate threshold for incorrect combination of EncType, DDate, Discharge_Disposition, Discharge_Status	EncType	DDate	Discharge_Disposition	Discharge_Status

FlagID	FlagType	AbortYN	Flag_Descr	Variable1	Variable2
DIA-ENR_2_01_00-0_201	Warn	N	PatID value present in DIA table, but not in the ENR table	PatID
DIA-ENC_2_02_00-0_201	Warn	N	EncounterID value present in DIA table, but not in the ENC table	EncounterID	EncounterID
DIA-PVD_2_04_00-0_201	Fail	Y	ProviderID value present in DIA table, but not in the PVD table	ProviderID	ProviderID
DIA-ENR_2_01_00-0_203	Fail	Y	PatID variable length is not consistent between tables	PatID
DIA-ENC_2_02_00-0_203	Fail	Y	EncounterID variable length is not consistent between tables	EncounterID	EncounterID
DIA-PVD_2_04_00-0_203	Fail	Y	ProviderID variable length is not consistent between tables	ProviderID	ProviderID
DIA_2_01_00-0_209	Warn	N	PatID variable length is greater than needed to contain maximum value across tables	PatID
DIA_2_02_00-0_209	Warn	N	EncounterID variable length is greater than needed to contain maximum value across tables	EncounterID
DIA_2_04_00-0_209	Warn	N	ProviderID variable length is greater than needed to contain maximum value across tables	ProviderID
DIA_2_00_00-0_211	Fail	Y	Duplicate record(s) present for unique key variable(s): EncounterID, ProviderID, Dx, Dx_CodeType
DIA_2_06_00-0_223	Warn	N	Dx value is incorrect based on Dx_CodeType value	Dx	Dx_CodeType
DIA_2_07_00-0_223	Warn	N	Dx_CodeType value is incorrect based on ADate value	Dx_CodeType	ADate
DIA-ENC_2_07_00-0_223	Warn	N	Dx_CodeType value is incorrect based on DDate value	Dx_CodeType	DDate
DIA_2_09_00-0_223	Warn	N	PDX value is incorrect based on EncType value	PDX	EncType
DIA_2_06_00-0_228	Warn	N	Dx value length is incorrect based on Dx_CodeType	Dx	Dx_CodeType

FlagID	FlagType	AbortYN	Flag_Descr	Variable1	Variable2
PRO-ENR_2_01_00-0_201	Warn	N	PatID value present in PRO table, but not in the ENR table	PatID
PRO-ENC_2_02_00-0_201	Warn	N	EncounterID value present in PRO table, but not in the ENC table	EncounterID	EncounterID
PRO-PVD_2_04_00-0_201	Fail	Y	ProviderID value present in PRO table, but not in the PVD table	ProviderID	ProviderID
PRO-ENR_2_01_00-0_203	Fail	Y	PatID variable length is not consistent between tables	PatID
PRO-ENC_2_02_00-0_203	Fail	Y	EncounterID variable length is not consistent between tables	EncounterID	EncounterID
PRO-PVD_2_04_00-0_203	Fail	Y	ProviderID variable length is not consistent between tables	ProviderID	ProviderID
PRO_2_01_00-0_209	Warn	N	PatID variable length is greater than needed to contain maximum value across tables	PatID
PRO_2_02_00-0_209	Warn	N	EncounterID variable length is greater than needed to contain maximum value across tables	EncounterID
PRO_2_04_00-0_209	Warn	N	ProviderID variable length is greater than needed to contain maximum value across tables	ProviderID
PRO_2_00_00-0_211	Fail	Y	Duplicate record(s) present for unique key variable(s): EncounterID, ProviderID, Px, Px_CodeType
PRO_2_06_00-0_223	Warn	N	Px value is incorrect based on Px_CodeType value	Px	Px_CodeType
PRO_2_07_00-0_223	Warn	N	Px_CodeType value is incorrect based on ADate value	Px_CodeType	ADate
PRO-ENC_2_07_00-0_223	Warn	N	Px_CodeType value is incorrect based on DDate value	Px_CodeType	DDate
PRO_2_06_00-0_228	Warn	N	Px value length is incorrect based on Px_CodeType	Px	Px_CodeType