5 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 4.6 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.

5.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 5.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 5.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.`

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

Table 5.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.`

5.2 Level 1 Quality Checks

5.2.1 Table of Contents

Enrollment Level 1 Quality Checks

Table 5.3: 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_01_00-0_112	Fail	Y	PatID variable type does not conform to specifications	PatID
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_110	Fail	Y	Enr_Start variable does not exist	Enr_Start
ENR_1_02_00-0_112	Fail	Y	Enr_Start variable type does not conform to specifications	Enr_Start
ENR_1_02_00-0_113	Fail	Y	Enr_Start variable length does not conform to specifications	Enr_Start
ENR_1_02_00-0_120	Fail	Y	Enr_Start variable contains a null value	Enr_Start
ENR_1_03_00-0_110	Fail	Y	Enr_End variable does not exist	Enr_End
ENR_1_03_00-0_112	Fail	Y	Enr_End variable type does not conform to specifications	Enr_End
ENR_1_03_00-0_113	Fail	Y	Enr_End variable length does not conform to specifications	Enr_End
ENR_1_03_00-0_120	Fail	Y	Enr_End variable contains a null value	Enr_End
ENR_1_04_00-0_110	Fail	Y	MedCov variable does not exist	MedCov
ENR_1_04_00-0_112	Fail	Y	MedCov variable type does not conform to specifications	MedCov
ENR_1_04_00-0_113	Fail	Y	MedCov variable length does not conform to specifications	MedCov
ENR_1_04_00-0_120	Fail	Y	MedCov variable contains a null value	MedCov
ENR_1_04_00-0_121	Fail	Y	MedCov variable contains an invalid non-missing value	MedCov
ENR_1_05_00-0_110	Fail	Y	DrugCov variable does not exist	DrugCov
ENR_1_05_00-0_112	Fail	Y	DrugCov variable type does not conform to specifications	DrugCov
ENR_1_05_00-0_113	Fail	Y	DrugCov variable length does not conform to specifications	DrugCov
ENR_1_05_00-0_120	Fail	Y	DrugCov variable contains a null value	DrugCov
ENR_1_05_00-0_121	Fail	Y	DrugCov variable contains an invalid non-missing value	DrugCov
ENR_1_06_00-0_110	Fail	Y	Chart variable does not exist	Chart
ENR_1_06_00-0_112	Fail	Y	Chart variable type does not conform to specifications	Chart
ENR_1_06_00-0_113	Fail	Y	Chart variable length does not conform to specifications	Chart
ENR_1_06_00-0_120	Fail	Y	Chart variable contains a null value	Chart
ENR_1_06_00-0_121	Fail	Y	Chart variable contains an invalid non-missing value	Chart
ENR_1_07_00-0_110	Fail	Y	PlanType variable does not exist	PlanType
ENR_1_07_00-0_111	Note	N	PlanType variable is not populated	PlanType
ENR_1_07_00-0_112	Fail	Y	PlanType variable type does not conform to specifications	PlanType
ENR_1_07_00-0_113	Fail	Y	PlanType variable length does not conform to specifications	PlanType
ENR_1_07_00-0_121	Fail	Y	PlanType variable contains an invalid non-missing value	PlanType
ENR_1_08_00-0_110	Fail	Y	PayerType variable does not exist	PayerType
ENR_1_08_00-0_111	Note	N	PayerType variable is not populated	PayerType
ENR_1_08_00-0_112	Fail	Y	PayerType variable type does not conform to specifications	PayerType
ENR_1_08_00-0_113	Fail	Y	PayerType variable length does not conform to specifications	PayerType
ENR_1_08_00-0_121	Fail	Y	PayerType variable contains an invalid 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_01_00-0_112	Fail	Y	PatID variable type does not conform to specifications	PatID
VIT_1_01_00-0_115	Fail	Y	PatID variable length is less than needed to contain maximum value	PatID
VIT_1_01_00-0_116	Fail	Y	PatID variable is formatted with an inadequate format	PatID
VIT_1_01_00-0_120	Fail	Y	PatID variable contains a null value	PatID
VIT_1_02_00-0_110	Fail	Y	EncounterID variable does not exist	EncounterID
VIT_1_02_00-0_112	Fail	Y	EncounterID variable type does not conform to specifications	EncounterID
VIT_1_02_00-0_115	Fail	Y	EncounterID variable length is less than needed to contain maximum value	EncounterID
VIT_1_02_00-0_116	Fail	Y	EncounterID variable is formatted with an inadequate format	EncounterID
VIT_1_03_00-0_110	Fail	Y	Measure_Date variable does not exist	Measure_Date
VIT_1_03_00-0_112	Fail	Y	Measure_Date variable type does not conform to specifications	Measure_Date
VIT_1_03_00-0_113	Fail	Y	Measure_Date variable length does not conform to specifications	Measure_Date
VIT_1_03_00-0_120	Fail	Y	Measure_Date variable contains a null value	Measure_Date
VIT_1_04_00-0_110	Fail	Y	Measure_Time variable does not exist	Measure_Time
VIT_1_04_00-0_112	Fail	Y	Measure_Time variable type does not conform to specifications	Measure_Time
VIT_1_04_00-0_113	Fail	Y	Measure_Time variable length does not conform to specifications	Measure_Time
VIT_1_05_00-0_110	Fail	Y	HT variable does not exist	HT
VIT_1_05_00-0_112	Fail	Y	HT variable type does not conform to specifications	HT
VIT_1_05_00-0_113	Fail	Y	HT variable length does not conform to specifications	HT
VIT_1_05_00-0_121	Warn	N	HT variable contains an invalid non-missing value	HT
VIT_1_05_00-0_124	Warn	N	HT contains an unexpected value of zero (0)	HT
VIT_1_06_00-0_110	Fail	Y	WT variable does not exist	WT
VIT_1_06_00-0_112	Fail	Y	WT variable type does not conform to specifications	WT
VIT_1_06_00-0_113	Fail	Y	WT variable length does not conform to specifications	WT
VIT_1_06_00-0_121	Warn	N	WT variable contains an invalid non-missing value	WT
VIT_1_06_00-0_124	Warn	N	WT contains an unexpected value of zero (0)	WT
VIT_1_07_00-0_110	Fail	Y	Diastolic variable does not exist	Diastolic
VIT_1_07_00-0_112	Fail	Y	Diastolic variable type does not conform to specifications	Diastolic
VIT_1_07_00-0_113	Fail	Y	Diastolic variable length does not conform to specifications	Diastolic
VIT_1_07_00-0_121	Warn	N	Diastolic variable contains an invalid non-missing value	Diastolic
VIT_1_07_00-0_124	Warn	N	Diastolic contains an unexpected value of zero (0)	Diastolic
VIT_1_08_00-0_110	Fail	Y	Systolic variable does not exist	Systolic
VIT_1_08_00-0_112	Fail	Y	Systolic variable type does not conform to specifications	Systolic
VIT_1_08_00-0_113	Fail	Y	Systolic variable length does not conform to specifications	Systolic
VIT_1_08_00-0_121	Warn	N	Systolic variable contains an invalid non-missing value	Systolic
VIT_1_08_00-0_124	Warn	N	Systolic contains an unexpected value of zero (0)	Systolic
VIT_1_09_00-0_110	Fail	Y	BP_Type variable does not exist	BP_Type
VIT_1_09_00-0_112	Fail	Y	BP_Type variable type does not conform to specifications	BP_Type
VIT_1_09_00-0_113	Fail	Y	BP_Type variable length does not conform to specifications	BP_Type
VIT_1_09_00-0_121	Fail	Y	BP_Type variable contains an invalid non-missing value	BP_Type
VIT_1_10_00-0_110	Fail	Y	Position variable does not exist	Position
VIT_1_10_00-0_112	Fail	Y	Position variable type does not conform to specifications	Position
VIT_1_10_00-0_113	Fail	Y	Position variable length does not conform to specifications	Position
VIT_1_10_00-0_121	Fail	Y	Position variable contains an invalid non-missing value	Position
VIT_1_11_00-0_110	Fail	Y	Tobacco variable does not exist	Tobacco
VIT_1_11_00-0_112	Fail	Y	Tobacco variable type does not conform to specifications	Tobacco
VIT_1_11_00-0_113	Fail	Y	Tobacco variable length does not conform to specifications	Tobacco
VIT_1_11_00-0_121	Fail	Y	Tobacco variable contains an invalid non-missing value	Tobacco
VIT_1_12_00-0_110	Fail	Y	Tobacco_Type variable does not exist	Tobacco_Type
VIT_1_12_00-0_112	Fail	Y	Tobacco_Type variable type does not conform to specifications	Tobacco_Type
VIT_1_12_00-0_113	Fail	Y	Tobacco_Type variable length does not conform to specifications	Tobacco_Type
VIT_1_12_00-0_121	Fail	Y	Tobacco_Type variable contains an invalid non-missing value	Tobacco_Type

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_01_00-0_112	Fail	Y	PatID variable type does not conform to specifications	PatID
IRX_1_01_00-0_115	Fail	Y	PatID variable length is less than needed to contain maximum value	PatID
IRX_1_01_00-0_116	Fail	Y	PatID variable is formatted with an inadequate format	PatID
IRX_1_01_00-0_120	Fail	Y	PatID variable contains a null value	PatID
IRX_1_02_00-0_110	Fail	Y	EncounterID variable does not exist	EncounterID
IRX_1_02_00-0_112	Fail	Y	EncounterID variable type does not conform to specifications	EncounterID
IRX_1_02_00-0_115	Fail	Y	EncounterID variable length is less than needed to contain maximum value	EncounterID
IRX_1_02_00-0_116	Fail	Y	EncounterID variable is formatted with an inadequate format	EncounterID
IRX_1_02_00-0_120	Fail	Y	EncounterID variable contains a null value	EncounterID
IRX_1_03_00-0_110	Fail	Y	NDC variable does not exist	NDC
IRX_1_03_00-0_112	Fail	Y	NDC variable type does not conform to specifications	NDC
IRX_1_03_00-0_113	Fail	Y	NDC variable length does not conform to specifications	NDC
IRX_1_03_00-0_120	Fail	Y	NDC variable contains a null value	NDC
IRX_1_03_00-0_122	Fail	Y	NDC value contains leading spaces	NDC
IRX_1_04_00-0_110	Fail	Y	RxID variable does not exist	RxID
IRX_1_04_00-0_112	Fail	Y	RxID variable type does not conform to specifications	RxID
IRX_1_04_00-0_115	Fail	Y	RxID variable length is less than needed to contain maximum value	RxID
IRX_1_04_00-0_116	Fail	Y	RxID variable is formatted with an inadequate format	RxID
IRX_1_04_00-0_120	Fail	Y	RxID variable contains a null value	RxID
IRX_1_05_00-0_110	Fail	Y	RxADate variable does not exist	RxADate
IRX_1_05_00-0_112	Fail	Y	RxADate variable type does not conform to specifications	RxADate
IRX_1_05_00-0_113	Fail	Y	RxADate variable length does not conform to specifications	RxADate
IRX_1_05_00-0_120	Fail	Y	RxADate variable contains a null value	RxADate
IRX_1_06_00-0_110	Fail	Y	RxATime variable does not exist	RxATime
IRX_1_06_00-0_112	Fail	Y	RxATime variable type does not conform to specifications	RxATime
IRX_1_06_00-0_113	Fail	Y	RxATime variable length does not conform to specifications	RxATime
IRX_1_07_00-0_110	Fail	Y	RxRoute variable does not exist	RxRoute
IRX_1_07_00-0_112	Fail	Y	RxRoute variable type does not conform to specifications	RxRoute
IRX_1_07_00-0_113	Fail	Y	RxRoute variable length does not conform to specifications	RxRoute
IRX_1_07_00-0_122	Fail	Y	RxRoute value contains leading spaces	RxRoute
IRX_1_08_00-0_110	Fail	Y	RxDose variable does not exist	RxDose
IRX_1_08_00-0_112	Fail	Y	RxDose variable type does not conform to specifications	RxDose
IRX_1_08_00-0_113	Fail	Y	RxDose variable length does not conform to specifications	RxDose
IRX_1_08_00-0_121	Fail	Y	RxDose variable contains an invalid non-missing value	RxDose
IRX_1_09_00-0_110	Fail	Y	RxUOM variable does not exist	RxUOM
IRX_1_09_00-0_112	Fail	Y	RxUOM variable type does not conform to specifications	RxUOM
IRX_1_09_00-0_113	Fail	Y	RxUOM variable length does not conform to specifications	RxUOM
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_01_00-0_112	Fail	Y	PatID variable type does not conform to specifications	PatID
TXN_1_01_00-0_115	Fail	Y	PatID variable length is less than needed to contain maximum value	PatID
TXN_1_01_00-0_116	Fail	Y	PatID variable is formatted with an inadequate format	PatID
TXN_1_01_00-0_120	Fail	Y	PatID variable contains a null value	PatID
TXN_1_02_00-0_110	Fail	Y	EncounterID variable does not exist	EncounterID
TXN_1_02_00-0_112	Fail	Y	EncounterID variable type does not conform to specifications	EncounterID
TXN_1_02_00-0_115	Fail	Y	EncounterID variable length is less than needed to contain maximum value	EncounterID
TXN_1_02_00-0_116	Fail	Y	EncounterID variable is formatted with an inadequate format	EncounterID
TXN_1_02_00-0_120	Fail	Y	EncounterID variable contains a null value	EncounterID
TXN_1_03_00-0_110	Fail	Y	TransID variable does not exist	TransID
TXN_1_03_00-0_112	Fail	Y	TransID variable type does not conform to specifications	TransID
TXN_1_03_00-0_115	Fail	Y	TransID variable length is less than needed to contain maximum value	TransID
TXN_1_03_00-0_116	Fail	Y	TransID variable is formatted with an inadequate format	TransID
TXN_1_03_00-0_120	Fail	Y	TransID variable contains a null value	TransID
TXN_1_04_00-0_110	Fail	Y	TransCode variable does not exist	TransCode
TXN_1_04_00-0_112	Fail	Y	TransCode variable type does not conform to specifications	TransCode
TXN_1_04_00-0_113	Fail	Y	TransCode variable length does not conform to specifications	TransCode
TXN_1_04_00-0_120	Fail	Y	TransCode variable contains a null value	TransCode
TXN_1_04_00-0_122	Fail	Y	TransCode value contains leading spaces	TransCode
TXN_1_05_00-0_110	Fail	Y	TransCode_Type variable does not exist	TransCode_Type
TXN_1_05_00-0_112	Fail	Y	TransCode_Type variable type does not conform to specifications	TransCode_Type
TXN_1_05_00-0_113	Fail	Y	TransCode_Type variable length does not conform to specifications	TransCode_Type
TXN_1_05_00-0_120	Fail	Y	TransCode_Type variable contains a null value	TransCode_Type
TXN_1_05_00-0_121	Fail	Y	TransCode_Type variable contains an invalid non-missing value	TransCode_Type
TXN_1_06_00-0_110	Fail	Y	Orig_TransProd variable does not exist	Orig_TransProd
TXN_1_06_00-0_112	Fail	Y	Orig_TransProd variable type does not conform to specifications	Orig_TransProd
TXN_1_07_00-0_110	Fail	Y	BloodType variable does not exist	BloodType
TXN_1_07_00-0_112	Fail	Y	BloodType variable type does not conform to specifications	BloodType
TXN_1_07_00-0_113	Fail	Y	BloodType variable length does not conform to specifications	BloodType
TXN_1_07_00-0_120	Fail	Y	BloodType variable contains a null value	BloodType
TXN_1_07_00-0_121	Fail	Y	BloodType variable contains an invalid non-missing value	BloodType
TXN_1_08_00-0_110	Fail	Y	TDate_Start variable does not exist	TDate_Start
TXN_1_08_00-0_112	Fail	Y	TDate_Start variable type does not conform to specifications	TDate_Start
TXN_1_08_00-0_113	Fail	Y	TDate_Start variable length does not conform to specifications	TDate_Start
TXN_1_08_00-0_120	Fail	Y	TDate_Start variable contains a null value	TDate_Start
TXN_1_09_00-0_110	Fail	Y	TTime_Start variable does not exist	TTime_Start
TXN_1_09_00-0_112	Fail	Y	TTime_Start variable type does not conform to specifications	TTime_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_110	Fail	Y	TDate_End variable does not exist	TDate_End
TXN_1_10_00-0_112	Fail	Y	TDate_End variable type does not conform to specifications	TDate_End
TXN_1_10_00-0_113	Fail	Y	TDate_End variable length does not conform to specifications	TDate_End
TXN_1_11_00-0_110	Fail	Y	TTime_End variable does not exist	TTime_End
TXN_1_11_00-0_112	Fail	Y	TTime_End variable type does not conform to specifications	TTime_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_110	Fail	Y	EncType variable does not exist	EncType
TXN_1_12_00-0_112	Fail	Y	EncType variable type does not conform to specifications	EncType
TXN_1_12_00-0_113	Fail	Y	EncType variable length does not conform to specifications	EncType
TXN_1_12_00-0_121	Fail	Y	EncType variable contains an invalid non-missing value	EncType

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_01_00-0_112	Fail	Y	PatID variable type does not conform to specifications	PatID
PRE_1_01_00-0_115	Fail	Y	PatID variable length is less than needed to contain maximum value	PatID
PRE_1_01_00-0_116	Fail	Y	PatID variable is formatted with an inadequate format	PatID
PRE_1_01_00-0_120	Fail	Y	PatID variable contains a null value	PatID
PRE_1_02_00-0_110	Fail	Y	EncounterID variable does not exist	EncounterID
PRE_1_02_00-0_112	Fail	Y	EncounterID variable type does not conform to specifications	EncounterID
PRE_1_02_00-0_115	Fail	Y	EncounterID variable length is less than needed to contain maximum value	EncounterID
PRE_1_02_00-0_116	Fail	Y	EncounterID variable is formatted with an inadequate format	EncounterID
PRE_1_03_00-0_110	Fail	Y	PrescribingID variable does not exist	PrescribingID
PRE_1_03_00-0_112	Fail	Y	PrescribingID variable type does not conform to specifications	PrescribingID
PRE_1_03_00-0_115	Fail	Y	PrescribingID variable length is less than needed to contain maximum value	PrescribingID
PRE_1_03_00-0_116	Fail	Y	PrescribingID variable is formatted with an inadequate format	PrescribingID
PRE_1_03_00-0_120	Fail	Y	PrescribingID variable contains a null value	PrescribingID
PRE_1_04_00-0_110	Fail	Y	ProviderID variable does not exist	ProviderID
PRE_1_04_00-0_112	Fail	Y	ProviderID variable type does not conform to specifications	ProviderID
PRE_1_04_00-0_115	Fail	Y	ProviderID variable length is less than needed to contain maximum value	ProviderID
PRE_1_04_00-0_116	Fail	Y	ProviderID variable is formatted with an inadequate format	ProviderID
PRE_1_04_00-0_120	Fail	Y	ProviderID variable contains a null value	ProviderID
PRE_1_04_00-0_121	Fail	Y	ProviderID variable contains an invalid non-missing value	ProviderID
PRE_1_05_00-0_110	Fail	Y	OrderDate variable does not exist	OrderDate
PRE_1_05_00-0_112	Fail	Y	OrderDate variable type does not conform to specifications	OrderDate
PRE_1_05_00-0_113	Fail	Y	OrderDate variable length does not conform to specifications	OrderDate
PRE_1_05_00-0_120	Fail	Y	OrderDate variable contains a null value	OrderDate
PRE_1_06_00-0_110	Fail	Y	Rx_CodeType variable does not exist	Rx_CodeType
PRE_1_06_00-0_112	Fail	Y	Rx_CodeType variable type does not conform to specifications	Rx_CodeType
PRE_1_06_00-0_113	Fail	Y	Rx_CodeType variable length does not conform to specifications	Rx_CodeType
PRE_1_06_00-0_120	Fail	Y	Rx_CodeType variable contains a null value	Rx_CodeType
PRE_1_06_00-0_121	Fail	Y	Rx_CodeType variable contains an invalid non-missing value	Rx_CodeType
PRE_1_07_00-0_110	Fail	Y	Rx variable does not exist	Rx
PRE_1_07_00-0_112	Fail	Y	Rx variable type does not conform to specifications	Rx
PRE_1_07_00-0_120	Fail	Y	Rx variable contains a null value	Rx
PRE_1_08_00-0_110	Fail	Y	RxSup variable does not exist	RxSup
PRE_1_08_00-0_112	Fail	Y	RxSup variable type does not conform to specifications	RxSup
PRE_1_08_00-0_113	Fail	Y	RxSup variable length does not conform to specifications	RxSup
PRE_1_08_00-0_120	Warn	N	RxSup variable contains a null value	RxSup
PRE_1_08_00-0_121	Warn	N	RxSup variable contains an invalid non-missing value	RxSup
PRE_1_08_00-0_124	Warn	N	RxSup contains an unexpected value of zero (0)	RxSup
PRE_1_09_00-0_110	Fail	Y	RxAmt variable does not exist	RxAmt
PRE_1_09_00-0_112	Fail	Y	RxAmt variable type does not conform to specifications	RxAmt
PRE_1_09_00-0_113	Fail	Y	RxAmt variable length does not conform to specifications	RxAmt
PRE_1_09_00-0_120	Warn	N	RxAmt variable contains a null value	RxAmt
PRE_1_09_00-0_121	Warn	N	RxAmt variable contains an invalid non-missing value	RxAmt
PRE_1_09_00-0_124	Warn	N	RxAmt contains an unexpected value of zero (0)	RxAmt
PRE_1_10_00-0_110	Fail	Y	RxSource variable does not exist	RxSource
PRE_1_10_00-0_112	Fail	Y	RxSource variable type does not conform to specifications	RxSource
PRE_1_10_00-0_113	Fail	Y	RxSource variable length does not conform to specifications	RxSource
PRE_1_10_00-0_120	Fail	Y	RxSource variable contains a null value	RxSource
PRE_1_10_00-0_121	Fail	Y	RxSource variable contains an invalid non-missing value	RxSource
PRE_1_11_00-0_110	Fail	Y	RxRoute variable does not exist	RxRoute
PRE_1_11_00-0_112	Fail	Y	RxRoute variable type does not conform to specifications	RxRoute
PRE_1_11_00-0_113	Fail	Y	RxRoute variable length does not conform to specifications	RxRoute
PRE_1_11_00-0_120	Fail	Y	RxRoute variable contains a null value	RxRoute
PRE_1_11_00-0_121	Fail	Y	RxRoute variable contains an invalid non-missing value	RxRoute
PRE_1_12_00-0_110	Fail	Y	RxDoseQuantity variable does not exist	RxDoseQuantity
PRE_1_12_00-0_112	Fail	Y	RxDoseQuantity variable type does not conform to specifications	RxDoseQuantity
PRE_1_12_00-0_113	Fail	Y	RxDoseQuantity variable length does not conform to specifications	RxDoseQuantity
PRE_1_12_00-0_120	Warn	N	RxDoseQuantity variable contains a null value	RxDoseQuantity
PRE_1_12_00-0_121	Warn	N	RxDoseQuantity variable contains an invalid non-missing value	RxDoseQuantity
PRE_1_13_00-0_110	Fail	Y	RxDoseUnit variable does not exist	RxDoseUnit
PRE_1_13_00-0_112	Fail	Y	RxDoseUnit variable type does not conform to specifications	RxDoseUnit
PRE_1_13_00-0_113	Fail	Y	RxDoseUnit variable length does not conform to specifications	RxDoseUnit
PRE_1_13_00-0_120	Fail	Y	RxDoseUnit variable contains a null value	RxDoseUnit
PRE_1_13_00-0_121	Fail	Y	RxDoseUnit variable contains an invalid non-missing value	RxDoseUnit
PRE_1_14_00-0_110	Fail	Y	RxDoseForm variable does not exist	RxDoseForm
PRE_1_14_00-0_112	Fail	Y	RxDoseForm variable type does not conform to specifications	RxDoseForm
PRE_1_14_00-0_113	Fail	Y	RxDoseForm variable length does not conform to specifications	RxDoseForm
PRE_1_14_00-0_121	Fail	Y	RxDoseForm variable contains an invalid non-missing value	RxDoseForm
PRE_1_15_00-0_110	Fail	Y	RxFreqQuantity variable does not exist	RxFreqQuantity
PRE_1_15_00-0_112	Fail	Y	RxFreqQuantity variable type does not conform to specifications	RxFreqQuantity
PRE_1_15_00-0_113	Fail	Y	RxFreqQuantity variable length does not conform to specifications	RxFreqQuantity
PRE_1_15_00-0_120	Warn	N	RxFreqQuantity variable contains a null value	RxFreqQuantity
PRE_1_15_00-0_121	Warn	N	RxFreqQuantity variable contains an invalid non-missing value	RxFreqQuantity
PRE_1_16_00-0_110	Fail	Y	RxFreqUnit variable does not exist	RxFreqUnit
PRE_1_16_00-0_112	Fail	Y	RxFreqUnit variable type does not conform to specifications	RxFreqUnit
PRE_1_16_00-0_113	Fail	Y	RxFreqUnit variable length does not conform to specifications	RxFreqUnit
PRE_1_16_00-0_120	Fail	Y	RxFreqUnit variable contains a null value	RxFreqUnit
PRE_1_16_00-0_121	Fail	Y	RxFreqUnit variable contains an invalid non-missing value	RxFreqUnit
PRE_1_17_00-0_110	Fail	Y	RxRefills variable does not exist	RxRefills
PRE_1_17_00-0_112	Fail	Y	RxRefills variable type does not conform to specifications	RxRefills
PRE_1_17_00-0_113	Fail	Y	RxRefills variable length does not conform to specifications	RxRefills
PRE_1_17_00-0_120	Warn	N	RxRefills variable contains a null value	RxRefills
PRE_1_17_00-0_121	Warn	N	RxRefills variable contains an invalid non-missing value	RxRefills
PRE_1_18_00-0_110	Fail	Y	RxPrnFlag variable does not exist	RxPrnFlag
PRE_1_18_00-0_112	Fail	Y	RxPrnFlag variable type does not conform to specifications	RxPrnFlag
PRE_1_18_00-0_113	Fail	Y	RxPrnFlag variable length does not conform to specifications	RxPrnFlag
PRE_1_18_00-0_120	Fail	Y	RxPrnFlag variable contains a null value	RxPrnFlag
PRE_1_18_00-0_121	Fail	Y	RxPrnFlag variable contains an invalid non-missing value	RxPrnFlag
PRE_1_19_00-0_110	Fail	Y	RxDAW variable does not exist	RxDAW
PRE_1_19_00-0_112	Fail	Y	RxDAW variable type does not conform to specifications	RxDAW
PRE_1_19_00-0_113	Fail	Y	RxDAW variable length does not conform to specifications	RxDAW
PRE_1_19_00-0_120	Fail	Y	RxDAW variable contains a null value	RxDAW
PRE_1_19_00-0_121	Fail	Y	RxDAW variable contains an invalid non-missing value	RxDAW

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_01_00-0_112	Fail	Y	FacilityID variable type does not conform to specifications	FacilityID
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 invalid non-missing value	FacilityID
FAC_1_02_00-0_110	Fail	Y	Facility_Location variable does not exist	Facility_Location
FAC_1_02_00-0_112	Fail	Y	Facility_Location variable type does not conform to specifications	Facility_Location

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_01_00-0_112	Fail	Y	ProviderID variable type does not conform to specifications	ProviderID
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_01_00-0_121	Fail	Y	ProviderID variable contains an invalid non-missing value	ProviderID
PVD_1_02_00-0_110	Fail	Y	Specialty variable does not exist	Specialty
PVD_1_02_00-0_112	Fail	Y	Specialty variable type does not conform to specifications	Specialty
PVD_1_02_00-0_113	Fail	Y	Specialty variable length does not conform to specifications	Specialty
PVD_1_02_00-0_120	Fail	Y	Specialty variable contains a null value	Specialty
PVD_1_02_00-0_121	Fail	Y	Specialty variable contains an invalid non-missing value	Specialty
PVD_1_03_00-0_110	Fail	Y	Specialty_CodeType variable does not exist	Specialty_CodeType
PVD_1_03_00-0_112	Fail	Y	Specialty_CodeType variable type does not conform to specifications	Specialty_CodeType
PVD_1_03_00-0_113	Fail	Y	Specialty_CodeType variable length does not conform to specifications	Specialty_CodeType
PVD_1_03_00-0_120	Fail	Y	Specialty_CodeType variable contains a null value	Specialty_CodeType
PVD_1_03_00-0_121	Fail	Y	Specialty_CodeType variable contains an invalid 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_01_00-0_112	Fail	Y	PatID variable type does not conform to specifications	PatID
PRR_1_01_00-0_115	Fail	Y	PatID variable length is less than needed to contain maximum value	PatID
PRR_1_01_00-0_116	Fail	Y	PatID variable is formatted with an inadequate format	PatID
PRR_1_01_00-0_120	Fail	Y	PatID variable contains a null value	PatID
PRR_1_02_00-0_110	Fail	Y	EncounterID variable does not exist	EncounterID
PRR_1_02_00-0_112	Fail	Y	EncounterID variable type does not conform to specifications	EncounterID
PRR_1_02_00-0_115	Fail	Y	EncounterID variable length is less than needed to contain maximum value	EncounterID
PRR_1_02_00-0_116	Fail	Y	EncounterID variable is formatted with an inadequate format	EncounterID
PRR_1_03_00-0_110	Fail	Y	PRM_Code variable does not exist	PRM_Code
PRR_1_03_00-0_112	Fail	Y	PRM_Code variable type does not conform to specifications	PRM_Code
PRR_1_03_00-0_113	Fail	Y	PRM_Code variable length does not conform to specifications	PRM_Code
PRR_1_03_00-0_120	Fail	Y	PRM_Code variable contains a null value	PRM_Code
PRR_1_03_00-0_121	Fail	Y	PRM_Code variable contains an invalid non-missing value	PRM_Code
PRR_1_04_00-0_110	Fail	Y	SurveyID variable does not exist	SurveyID
PRR_1_04_00-0_112	Fail	Y	SurveyID variable type does not conform to specifications	SurveyID
PRR_1_04_00-0_115	Fail	Y	SurveyID variable length is less than needed to contain maximum value	SurveyID
PRR_1_04_00-0_116	Fail	Y	SurveyID variable is formatted with an inadequate format	SurveyID
PRR_1_04_00-0_120	Fail	Y	SurveyID variable contains a null value	SurveyID
PRR_1_04_00-0_121	Fail	Y	SurveyID variable contains an invalid non-missing value	SurveyID
PRR_1_05_00-0_110	Fail	Y	QuestionID variable does not exist	QuestionID
PRR_1_05_00-0_112	Fail	Y	QuestionID variable type does not conform to specifications	QuestionID
PRR_1_05_00-0_113	Fail	Y	QuestionID variable length does not conform to specifications	QuestionID
PRR_1_05_00-0_120	Fail	Y	QuestionID variable contains a null value	QuestionID
PRR_1_05_00-0_121	Fail	Y	QuestionID variable contains an invalid non-missing value	QuestionID
PRR_1_06_00-0_110	Fail	Y	QuestionVerID variable does not exist	QuestionVerID
PRR_1_06_00-0_112	Fail	Y	QuestionVerID variable type does not conform to specifications	QuestionVerID
PRR_1_06_00-0_115	Fail	Y	QuestionVerID variable length is less than needed to contain maximum value	QuestionVerID
PRR_1_06_00-0_116	Fail	Y	QuestionVerID variable is formatted with an inadequate format	QuestionVerID
PRR_1_06_00-0_120	Fail	Y	QuestionVerID variable contains a null value	QuestionVerID
PRR_1_06_00-0_121	Fail	Y	QuestionVerID variable contains an invalid non-missing value	QuestionVerID
PRR_1_07_00-0_110	Fail	Y	Response_Dt variable does not exist	Response_Dt
PRR_1_07_00-0_112	Fail	Y	Response_Dt variable type does not conform to specifications	Response_Dt
PRR_1_07_00-0_113	Fail	Y	Response_Dt variable length does not conform to specifications	Response_Dt
PRR_1_07_00-0_120	Fail	Y	Response_Dt variable contains a null value	Response_Dt
PRR_1_08_00-0_110	Fail	Y	Response_Tm variable does not exist	Response_Tm
PRR_1_08_00-0_112	Fail	Y	Response_Tm variable type does not conform to specifications	Response_Tm
PRR_1_08_00-0_113	Fail	Y	Response_Tm variable length does not conform to specifications	Response_Tm
PRR_1_08_00-0_120	Fail	Y	Response_Tm variable contains a null value	Response_Tm
PRR_1_09_00-0_110	Fail	Y	Response_Text variable does not exist	Response_Text
PRR_1_09_00-0_112	Fail	Y	Response_Text variable type does not conform to specifications	Response_Text
PRR_1_09_00-0_120	Fail	Y	Response_Text variable contains a null value	Response_Text
PRR_1_10_00-0_110	Fail	Y	Survey_Mode variable does not exist	Survey_Mode
PRR_1_10_00-0_112	Fail	Y	Survey_Mode variable type does not conform to specifications	Survey_Mode
PRR_1_10_00-0_113	Fail	Y	Survey_Mode variable length does not conform to specifications	Survey_Mode
PRR_1_10_00-0_120	Fail	Y	Survey_Mode variable contains a null value	Survey_Mode
PRR_1_10_00-0_121	Fail	Y	Survey_Mode variable contains an invalid 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_01_00-0_112	Fail	Y	PRM_Code variable type does not conform to specifications	PRM_Code
PRS_1_01_00-0_113	Fail	Y	PRM_Code variable length does not conform to specifications	PRM_Code
PRS_1_01_00-0_120	Fail	Y	PRM_Code variable contains a null value	PRM_Code
PRS_1_01_00-0_121	Fail	Y	PRM_Code variable contains an invalid non-missing value	PRM_Code
PRS_1_02_00-0_110	Fail	Y	SurveyID variable does not exist	SurveyID
PRS_1_02_00-0_112	Fail	Y	SurveyID variable type does not conform to specifications	SurveyID
PRS_1_02_00-0_115	Fail	Y	SurveyID variable length is less than needed to contain maximum value	SurveyID
PRS_1_02_00-0_116	Fail	Y	SurveyID variable is formatted with an inadequate format	SurveyID
PRS_1_02_00-0_120	Fail	Y	SurveyID variable contains a null value	SurveyID
PRS_1_02_00-0_121	Fail	Y	SurveyID variable contains an invalid non-missing value	SurveyID
PRS_1_03_00-0_110	Fail	Y	QuestionID variable does not exist	QuestionID
PRS_1_03_00-0_112	Fail	Y	QuestionID variable type does not conform to specifications	QuestionID
PRS_1_03_00-0_115	Fail	Y	QuestionID variable length is less than needed to contain maximum value	QuestionID
PRS_1_03_00-0_116	Fail	Y	QuestionID variable is formatted with an inadequate format	QuestionID
PRS_1_03_00-0_120	Fail	Y	QuestionID variable contains a null value	QuestionID
PRS_1_03_00-0_121	Fail	Y	QuestionID variable contains an invalid non-missing value	QuestionID
PRS_1_04_00-0_110	Fail	Y	QuestionVerID variable does not exist	QuestionVerID
PRS_1_04_00-0_112	Fail	Y	QuestionVerID variable type does not conform to specifications	QuestionVerID
PRS_1_04_00-0_115	Fail	Y	QuestionVerID variable length is less than needed to contain maximum value	QuestionVerID
PRS_1_04_00-0_116	Fail	Y	QuestionVerID variable is formatted with an inadequate format	QuestionVerID
PRS_1_04_00-0_120	Fail	Y	QuestionVerID variable contains a null value	QuestionVerID
PRS_1_04_00-0_121	Fail	Y	QuestionVerID variable contains an invalid non-missing value	QuestionVerID
PRS_1_05_00-0_110	Fail	Y	Survey_Data_Source variable does not exist	Survey_Data_Source
PRS_1_05_00-0_112	Fail	Y	Survey_Data_Source variable type does not conform to specifications	Survey_Data_Source
PRS_1_05_00-0_113	Fail	Y	Survey_Data_Source variable length does not conform to specifications	Survey_Data_Source
PRS_1_05_00-0_120	Fail	Y	Survey_Data_Source variable contains a null value	Survey_Data_Source
PRS_1_05_00-0_121	Fail	Y	Survey_Data_Source variable contains an invalid non-missing value	Survey_Data_Source
PRS_1_06_00-0_110	Fail	Y	Survey_Name variable does not exist	Survey_Name
PRS_1_06_00-0_112	Fail	Y	Survey_Name variable type does not conform to specifications	Survey_Name
PRS_1_06_00-0_120	Fail	Y	Survey_Name variable contains a null value	Survey_Name
PRS_1_07_00-0_110	Fail	Y	Question_Dt variable does not exist	Question_Dt
PRS_1_07_00-0_112	Fail	Y	Question_Dt variable type does not conform to specifications	Question_Dt
PRS_1_07_00-0_113	Fail	Y	Question_Dt variable length does not conform to specifications	Question_Dt
PRS_1_07_00-0_120	Fail	Y	Question_Dt variable contains a null value	Question_Dt
PRS_1_08_00-0_110	Fail	Y	Question_Text variable does not exist	Question_Text
PRS_1_08_00-0_112	Fail	Y	Question_Text variable type does not conform to specifications	Question_Text
PRS_1_08_00-0_120	Fail	Y	Question_Text variable contains a null value	Question_Text

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_01_00-0_112	Fail	Y	PatID variable type does not conform to specifications	PatID
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_02_00-0_110	Fail	Y	Birth_Date variable does not exist	Birth_Date
DEM_1_02_00-0_112	Fail	Y	Birth_Date variable type does not conform to specifications	Birth_Date
DEM_1_02_00-0_113	Fail	Y	Birth_Date variable length does not conform to specifications	Birth_Date
DEM_1_03_00-0_110	Fail	Y	Sex variable does not exist	Sex
DEM_1_03_00-0_112	Fail	Y	Sex variable type does not conform to specifications	Sex
DEM_1_03_00-0_113	Fail	Y	Sex variable length does not conform to specifications	Sex
DEM_1_03_00-0_120	Fail	Y	Sex variable contains a null value	Sex
DEM_1_03_00-0_121	Fail	Y	Sex variable contains an invalid non-missing value	Sex
DEM_1_04_00-0_110	Fail	Y	Hispanic variable does not exist	Hispanic
DEM_1_04_00-0_112	Fail	Y	Hispanic variable type does not conform to specifications	Hispanic
DEM_1_04_00-0_113	Fail	Y	Hispanic variable length does not conform to specifications	Hispanic
DEM_1_04_00-0_120	Fail	Y	Hispanic variable contains a null value	Hispanic
DEM_1_04_00-0_121	Fail	Y	Hispanic variable contains an invalid non-missing value	Hispanic
DEM_1_05_00-0_110	Fail	Y	Race variable does not exist	Race
DEM_1_05_00-0_112	Fail	Y	Race variable type does not conform to specifications	Race
DEM_1_05_00-0_113	Fail	Y	Race variable length does not conform to specifications	Race
DEM_1_05_00-0_120	Fail	Y	Race variable contains a null value	Race
DEM_1_05_00-0_121	Fail	Y	Race variable contains an invalid non-missing value	Race
DEM_1_06_00-0_110	Fail	Y	PostalCode variable does not exist	PostalCode
DEM_1_06_00-0_112	Fail	Y	PostalCode variable type does not conform to specifications	PostalCode
DEM_1_07_00-0_110	Fail	Y	PostalCode_Date variable does not exist	PostalCode_Date
DEM_1_07_00-0_112	Fail	Y	PostalCode_Date variable type does not conform to specifications	PostalCode_Date
DEM_1_07_00-0_113	Fail	Y	PostalCode_Date variable length does not conform to specifications	PostalCode_Date
DEM_1_08_00-0_110	Fail	Y	ImputedHispanic variable does not exist	ImputedHispanic
DEM_1_08_00-0_111	Note	N	ImputedHispanic variable is not populated	ImputedHispanic
DEM_1_08_00-0_112	Fail	Y	ImputedHispanic variable type does not conform to specifications	ImputedHispanic
DEM_1_08_00-0_113	Fail	Y	ImputedHispanic variable length does not conform to specifications	ImputedHispanic
DEM_1_08_00-0_121	Fail	Y	ImputedHispanic variable contains an invalid non-missing value	ImputedHispanic
DEM_1_09_00-0_110	Fail	Y	ImputedRace variable does not exist	ImputedRace
DEM_1_09_00-0_111	Note	N	ImputedRace variable is not populated	ImputedRace
DEM_1_09_00-0_112	Fail	Y	ImputedRace variable type does not conform to specifications	ImputedRace
DEM_1_09_00-0_113	Fail	Y	ImputedRace variable length does not conform to specifications	ImputedRace
DEM_1_09_00-0_121	Fail	Y	ImputedRace variable contains an invalid 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_01_00-0_112	Fail	Y	PatID variable type does not conform to specifications	PatID
DIS_1_01_00-0_115	Fail	Y	PatID variable length is less than needed to contain maximum value	PatID
DIS_1_01_00-0_116	Fail	Y	PatID variable is formatted with an inadequate format	PatID
DIS_1_01_00-0_120	Fail	Y	PatID variable contains a null value	PatID
DIS_1_02_00-0_110	Fail	Y	RxDate variable does not exist	RxDate
DIS_1_02_00-0_112	Fail	Y	RxDate variable type does not conform to specifications	RxDate
DIS_1_02_00-0_113	Fail	Y	RxDate variable length does not conform to specifications	RxDate
DIS_1_02_00-0_120	Fail	Y	RxDate variable contains a null value	RxDate
DIS_1_03_00-0_110	Fail	Y	Rx variable does not exist	Rx
DIS_1_03_00-0_112	Fail	Y	Rx variable type does not conform to specifications	Rx
DIS_1_03_00-0_120	Fail	Y	Rx variable contains a null value	Rx
DIS_1_04_00-0_110	Fail	Y	RxSup variable does not exist	RxSup
DIS_1_04_00-0_112	Fail	Y	RxSup variable type does not conform to specifications	RxSup
DIS_1_04_00-0_113	Fail	Y	RxSup variable length does not conform to specifications	RxSup
DIS_1_04_00-0_121	Fail	Y	RxSup variable contains an invalid non-missing value	RxSup
DIS_1_04_00-0_124	Warn	N	RxSup contains an unexpected value of zero (0)	RxSup
DIS_1_05_00-0_110	Fail	Y	RxAmt variable does not exist	RxAmt
DIS_1_05_00-0_112	Fail	Y	RxAmt variable type does not conform to specifications	RxAmt
DIS_1_05_00-0_113	Fail	Y	RxAmt variable length does not conform to specifications	RxAmt
DIS_1_05_00-0_121	Fail	Y	RxAmt variable contains an invalid non-missing value	RxAmt
DIS_1_05_00-0_124	Warn	N	RxAmt contains an unexpected value of zero (0)	RxAmt
DIS_1_06_00-0_110	Fail	Y	Rx_Codetype variable does not exist	Rx_Codetype
DIS_1_06_00-0_112	Fail	Y	Rx_Codetype variable type does not conform to specifications	Rx_Codetype
DIS_1_06_00-0_113	Fail	Y	Rx_Codetype variable length does not conform to specifications	Rx_Codetype
DIS_1_06_00-0_120	Fail	Y	Rx_Codetype variable contains a null value	Rx_Codetype
DIS_1_06_00-0_121	Fail	Y	Rx_Codetype variable contains an invalid non-missing value	Rx_Codetype
DIS_1_07_00-0_110	Fail	Y	ProviderID variable does not exist	ProviderID
DIS_1_07_00-0_112	Fail	Y	ProviderID variable type does not conform to specifications	ProviderID
DIS_1_07_00-0_115	Fail	Y	ProviderID variable length is less than needed to contain maximum value	ProviderID
DIS_1_07_00-0_116	Fail	Y	ProviderID variable is formatted with an inadequate format	ProviderID
DIS_1_07_00-0_120	Fail	Y	ProviderID variable contains a null value	ProviderID
DIS_1_07_00-0_121	Fail	Y	ProviderID variable contains an invalid non-missing value	ProviderID

Table 5.36: Laboratory Result Table Level 2 Quality Checks
FlagID	FlagType	AbortYN	Flag_Descr	Variable1	Variable2
LAB_2_00_00-0_211	Fail	Y	Duplicate record(s) present for unique key variable(s): LabID
LAB-ENR_2_01_00-0_201	Warn	N	PatID value present in LAB table, but not in the ENR table	PatID
LAB-ENR_2_01_00-0_203	Fail	Y	PatID variable length is not consistent between tables	PatID
LAB_2_01_00-0_209	Warn	N	PatID variable length is greater than needed to contain maximum value across tables	PatID
LAB_2_02_01-N_210	Warn	N	There are 0 records where MS_Test_Name=ALP and Result_Type=N	MS_Test_Name	Result_Type
LAB_2_02_02-N_210	Warn	N	There are 0 records where MS_Test_Name=ALT and Result_Type=N	MS_Test_Name	Result_Type
LAB_2_02_03-N_210	Warn	N	There are 0 records where MS_Test_Name=ANC and Result_Type=N	MS_Test_Name	Result_Type
LAB_2_02_04-N_210	Warn	N	There are 0 records where MS_Test_Name=BILI_TOT and Result_Type=N	MS_Test_Name	Result_Type
LAB_2_02_05-N_210	Warn	N	There are 0 records where MS_Test_Name=CK and Result_Type=N	MS_Test_Name	Result_Type
LAB_2_02_06-N_210	Warn	N	There are 0 records where MS_Test_Name=CK_MB and Result_Type=N	MS_Test_Name	Result_Type
LAB_2_02_07-N_210	Warn	N	There are 0 records where MS_Test_Name=CK_MBI and Result_Type=N	MS_Test_Name	Result_Type
LAB_2_02_08-N_210	Warn	N	There are 0 records where MS_Test_Name=CREATININE and Result_Type=N	MS_Test_Name	Result_Type
LAB_2_02_09-C_210	Warn	N	There are 0 records where MS_Test_Name=D_DIMER and Result_Type=C	MS_Test_Name	Result_Type
LAB_2_02_09-N_210	Warn	N	There are 0 records where MS_Test_Name=D_DIMER and Result_Type=N	MS_Test_Name	Result_Type
LAB_2_02_10-N_210	Warn	N	There are 0 records where MS_Test_Name=SODIUM and Result_Type=N	MS_Test_Name	Result_Type
LAB_2_02_11-N_210	Warn	N	There are 0 records where MS_Test_Name=GLUCOSE and Result_Type=N	MS_Test_Name	Result_Type
LAB_2_02_12-N_210	Warn	N	There are 0 records where MS_Test_Name=HGB and Result_Type=N	MS_Test_Name	Result_Type
LAB_2_02_13-N_210	Warn	N	There are 0 records where MS_Test_Name=HGBA1C and Result_Type=N	MS_Test_Name	Result_Type
LAB_2_02_14-C_210	Warn	N	There are 0 records where MS_Test_Name=INF_A and Result_Type=C	MS_Test_Name	Result_Type
LAB_2_02_15-C_210	Warn	N	There are 0 records where MS_Test_Name=INF_AB and Result_Type=C	MS_Test_Name	Result_Type
LAB_2_02_16-C_210	Warn	N	There are 0 records where MS_Test_Name=INF_B and Result_Type=C	MS_Test_Name	Result_Type
LAB_2_02_17-C_210	Warn	N	There are 0 records where MS_Test_Name=INF_NS and Result_Type=C	MS_Test_Name	Result_Type
LAB_2_02_18-N_210	Warn	N	There are 0 records where MS_Test_Name=INR and Result_Type=N	MS_Test_Name	Result_Type
LAB_2_02_19-N_210	Warn	N	There are 0 records where MS_Test_Name=LIPASE and Result_Type=N	MS_Test_Name	Result_Type
LAB_2_02_20-C_210	Warn	N	There are 0 records where MS_Test_Name=PG and Result_Type=C	MS_Test_Name	Result_Type
LAB_2_02_20-N_210	Warn	N	There are 0 records where MS_Test_Name=PG and Result_Type=N	MS_Test_Name	Result_Type
LAB_2_02_21-N_210	Warn	N	There are 0 records where MS_Test_Name=TRIG and Result_Type=N	MS_Test_Name	Result_Type
LAB_2_02_22-N_210	Warn	N	There are 0 records where MS_Test_Name=PLATELETS and Result_Type=N	MS_Test_Name	Result_Type
LAB_2_02_23-N_210	Warn	N	There are 0 records where MS_Test_Name=TROP_I and Result_Type=N	MS_Test_Name	Result_Type
LAB_2_02_24-C_210	Warn	N	There are 0 records where MS_Test_Name=TROP_T and Result_Type=C	MS_Test_Name	Result_Type
LAB_2_02_24-N_210	Warn	N	There are 0 records where MS_Test_Name=TROP_T and Result_Type=N	MS_Test_Name	Result_Type
LAB_2_02_25-N_210	Warn	N	There are 0 records where MS_Test_Name=CHOL_HDL and Result_Type=N	MS_Test_Name	Result_Type
LAB_2_02_26-N_210	Warn	N	There are 0 records where MS_Test_Name=CHOL_LDL and Result_Type=N	MS_Test_Name	Result_Type
LAB_2_02_27-N_210	Warn	N	There are 0 records where MS_Test_Name=CHOL_TOT and Result_Type=N	MS_Test_Name	Result_Type
LAB_2_02_28-N_210	Warn	N	There are 0 records where MS_Test_Name=TSH and Result_Type=N	MS_Test_Name	Result_Type
LAB_2_02_29-C_210	Warn	N	There are 0 records where MS_Test_Name=SARS_COV_2 and Result_Type=C	MS_Test_Name	Result_Type
LAB_2_02_30-C_210	Warn	N	There are 0 records where MS_Test_Name=SARS_COV_2_AB_TOTAL and Result_Type=C	MS_Test_Name	Result_Type
LAB_2_02_30-N_210	Warn	N	There are 0 records where MS_Test_Name=SARS_COV_2_AB_TOTAL and Result_Type=N	MS_Test_Name	Result_Type
LAB_2_02_31-C_210	Warn	N	There are 0 records where MS_Test_Name=SARS_COV_2_AB_A and Result_Type=C	MS_Test_Name	Result_Type
LAB_2_02_31-N_210	Warn	N	There are 0 records where MS_Test_Name=SARS_COV_2_AB_A and Result_Type=N	MS_Test_Name	Result_Type

Table 5.37: Enrollment Table Level 3 Quality Checks
FlagID	FlagType	AbortYN	Flag_Descr	Variable1	Variable2	Variable3	Variable4
ENR_3_00_00-0_300	Warn	N	Notable change in record count of ENR table
ENR-DIS_3_00_00-0_395	Warn	N	Notable change in distribution of average of unique ENR records by key variables: PatID, Enr_Start, Enr_End, MedCov, DrugCov, Chart, PlanType, PayerType
ENR_3_01_00-0_315	Warn	N	Notable change in count of unique PatID values	PatID
ENR_3_02_00-0_380	Warn	N	Notable change in distribution of unique counts of Enr_Start	Enr_Start
ENR_3_02_00-0_393	Warn	N	Notable change in distribution of length of distinct ENR spans in months (based on Enr_Start and Enr_End) where MedCov and DrugCov=‘Y’	Enr_Start	Enr_End	MedCov	DrugCov
ENR_3_03_00-0_380	Warn	N	Notable change in distribution of unique counts of Enr_End	Enr_End
ENR_3_04_00-0_310	Warn	N	Notable change in record count by MedCov values	MedCov
ENR_3_04_00-0_320	Warn	N	Notable change in record count of MedCov values by DrugCov	MedCov	DrugCov
ENR_3_04_00-0_322	Warn	N	Notable change in record count of MedCov by year-month (Enr_Start)	MedCov	Enr_Start
ENR_3_04_00-0_332	Warn	N	Notable change in record count of MedCov by DrugCov and year-month (Enr_Start)	MedCov	DrugCov	Enr_Start
ENR_3_05_00-0_310	Warn	N	Notable change in record count by DrugCov values	DrugCov
ENR_3_05_00-0_322	Warn	N	Notable change in record count of DrugCov by year-month (Enr_Start)	DrugCov	Enr_Start
ENR_3_06_00-0_310	Warn	N	Notable change in record count by Chart values	Chart
ENR_3_06_00-0_321	Warn	N	Notable change in record count of Chart by year (Enr_Start)	Chart	Enr_Start
ENR_3_07_00-0_310	Warn	N	Notable change in record count by PlanType values	PlanType
ENR_3_08_00-0_310	Warn	N	Notable change in record count by PayerType values	PayerType

Table 5.40: Prescribing Table Level 3 Quality Checks
FlagID	FlagType	AbortYN	Flag_Descr	Variable1	Variable2	Variable3
PRE_3_00_00-0_300	Warn	N	Notable change in record count of PRE table
PRE-DIS_3_00_00-0_395	Warn	N	Notable change in distribution of average of unique PRE records by key variables: PrescribingID
PRE_3_01_00-0_315	Warn	N	Notable change in count of unique PatID values	PatID
PRE-ENR_3_01_00-0_316	Warn	N	Notable change in count of unique PatID in PRE table, but not in the ENR table	PatID
PRE-ENR_3_01_00-0_317	Warn	N	Notable change in count of unique PatID in ENR table, but not in the PRE table	PatID
PRE_3_01_00-0_384	Warn	N	Notable change in distribution of unique counts of PatID by PrescribingID and year-month (OrderDate)	PatID	PrescribingID	OrderDate
PRE_3_02_00-0_315	Warn	N	Notable change in count of unique EncounterID values	EncounterID
PRE-ENC_3_02_00-0_316	Warn	N	Notable change in count of unique EncounterID in PRE table, but not in the ENC table	EncounterID	EncounterID
PRE-ENC_3_02_00-0_317	Warn	N	Notable change in count of unique EncounterID in ENC table, but not in the PRE table	EncounterID	EncounterID
PRE_3_02_00-0_350	Warn	N	Notable change in record count where EncounterID variable contains a null value	EncounterID
PRE_3_04_00-0_315	Warn	N	Notable change in count of unique ProviderID values	ProviderID
PRE-PVD_3_04_00-0_316	Warn	N	Notable change in count of unique ProviderID in PRE table, but not in the PVD table	ProviderID	ProviderID
PRE-PVD_3_04_00-0_317	Warn	N	Notable change in count of unique ProviderID in PVD table, but not in the PRE table	ProviderID	ProviderID
PRE_3_04_00-0_357	Warn	N	Notable change in record count where ProviderID variable contains a special missing value	ProviderID
PRE_3_05_00-0_312	Warn	N	Notable change in record count by year-month (OrderDate)	OrderDate
PRE_3_05_00-0_380	Warn	N	Notable change in distribution of unique counts of OrderDate	OrderDate
PRE_3_06_00-0_310	Warn	N	Notable change in record count by Rx_CodeType values	Rx_CodeType
PRE_3_07_00-0_320	Warn	N	Notable change in record count of Rx values by Rx_CodeType	Rx	Rx_CodeType
PRE_3_08_00-0_350	Warn	N	Notable change in record count where RxSup variable contains a null value	RxSup
PRE_3_08_00-0_354	Warn	N	Notable change in record count where RxSup contains an unexpected value of zero (0)	RxSup
PRE_3_09_00-0_350	Warn	N	Notable change in record count where RxAmt variable contains a null value	RxAmt
PRE_3_09_00-0_354	Warn	N	Notable change in record count where RxAmt contains an unexpected value of zero (0)	RxAmt
PRE_3_14_00-0_350	Warn	N	Notable change in record count where RxDoseForm variable contains a null value	RxDoseForm

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_01_00-0_112	Fail	Y	PatID variable type does not conform to specifications	PatID
ENC_1_01_00-0_115	Fail	Y	PatID variable length is less than needed to contain maximum value	PatID
ENC_1_01_00-0_116	Fail	Y	PatID variable is formatted with an inadequate format	PatID
ENC_1_01_00-0_120	Fail	Y	PatID variable contains a null value	PatID
ENC_1_02_00-0_110	Fail	Y	EncounterID variable does not exist	EncounterID
ENC_1_02_00-0_112	Fail	Y	EncounterID variable type does not conform to specifications	EncounterID
ENC_1_02_00-0_115	Fail	Y	EncounterID variable length is less than needed to contain maximum value	EncounterID
ENC_1_02_00-0_116	Fail	Y	EncounterID variable is formatted with an inadequate format	EncounterID
ENC_1_02_00-0_120	Fail	Y	EncounterID variable contains a null value	EncounterID
ENC_1_03_00-0_110	Fail	Y	ADate variable does not exist	ADate
ENC_1_03_00-0_112	Fail	Y	ADate variable type does not conform to specifications	ADate
ENC_1_03_00-0_113	Fail	Y	ADate variable length does not conform to specifications	ADate
ENC_1_03_00-0_120	Fail	Y	ADate variable contains a null value	ADate
ENC_1_04_00-0_110	Fail	Y	DDate variable does not exist	DDate
ENC_1_04_00-0_111	Fail	Y	DDate variable is not populated	DDate
ENC_1_04_00-0_112	Fail	Y	DDate variable type does not conform to specifications	DDate
ENC_1_04_00-0_113	Fail	Y	DDate variable length does not conform to specifications	DDate
ENC_1_04_00-0_121	Fail	Y	DDate variable contains an invalid non-missing value	DDate
ENC_1_06_00-0_110	Fail	Y	FacilityID variable does not exist	FacilityID
ENC_1_06_00-0_112	Fail	Y	FacilityID variable type does not conform to specifications	FacilityID
ENC_1_06_00-0_115	Fail	Y	FacilityID variable length is less than needed to contain maximum value	FacilityID
ENC_1_06_00-0_116	Fail	Y	FacilityID variable is formatted with an inadequate format	FacilityID
ENC_1_06_00-0_120	Fail	Y	FacilityID variable contains a null value	FacilityID
ENC_1_06_00-0_121	Fail	Y	FacilityID variable contains an invalid non-missing value	FacilityID
ENC_1_07_00-0_110	Fail	Y	EncType variable does not exist	EncType
ENC_1_07_00-0_112	Fail	Y	EncType variable type does not conform to specifications	EncType
ENC_1_07_00-0_113	Fail	Y	EncType variable length does not conform to specifications	EncType
ENC_1_07_00-0_120	Fail	Y	EncType variable contains a null value	EncType
ENC_1_07_00-0_121	Fail	Y	EncType variable contains an invalid non-missing value	EncType
ENC_1_09_00-0_110	Fail	Y	Discharge_Disposition variable does not exist	Discharge_Disposition
ENC_1_09_00-0_111	Fail	Y	Discharge_Disposition variable is not populated	Discharge_Disposition
ENC_1_09_00-0_112	Fail	Y	Discharge_Disposition variable type does not conform to specifications	Discharge_Disposition
ENC_1_09_00-0_113	Fail	Y	Discharge_Disposition variable length does not conform to specifications	Discharge_Disposition
ENC_1_09_00-0_121	Fail	Y	Discharge_Disposition variable contains an invalid non-missing value	Discharge_Disposition
ENC_1_10_00-0_110	Fail	Y	Discharge_Status variable does not exist	Discharge_Status
ENC_1_10_00-0_111	Fail	Y	Discharge_Status variable is not populated	Discharge_Status
ENC_1_10_00-0_112	Fail	Y	Discharge_Status variable type does not conform to specifications	Discharge_Status
ENC_1_10_00-0_113	Fail	Y	Discharge_Status variable length does not conform to specifications	Discharge_Status
ENC_1_10_00-0_121	Fail	Y	Discharge_Status variable contains an invalid non-missing value	Discharge_Status
ENC_1_11_00-0_110	Fail	Y	DRG variable does not exist	DRG
ENC_1_11_00-0_112	Fail	Y	DRG variable type does not conform to specifications	DRG
ENC_1_11_00-0_113	Fail	Y	DRG variable length does not conform to specifications	DRG
ENC_1_11_00-0_122	Fail	Y	DRG value contains leading spaces	DRG
ENC_1_12_00-0_110	Fail	Y	DRG_Type variable does not exist	DRG_Type
ENC_1_12_00-0_112	Fail	Y	DRG_Type variable type does not conform to specifications	DRG_Type
ENC_1_12_00-0_113	Fail	Y	DRG_Type variable length does not conform to specifications	DRG_Type
ENC_1_12_00-0_121	Fail	Y	DRG_Type variable contains an invalid non-missing value	DRG_Type
ENC_1_13_00-0_110	Fail	Y	Admitting_Source variable does not exist	Admitting_Source
ENC_1_13_00-0_111	Fail	Y	Admitting_Source variable is not populated	Admitting_Source
ENC_1_13_00-0_112	Fail	Y	Admitting_Source variable type does not conform to specifications	Admitting_Source
ENC_1_13_00-0_113	Fail	Y	Admitting_Source variable length does not conform to specifications	Admitting_Source
ENC_1_13_00-0_121	Fail	Y	Admitting_Source variable contains an invalid non-missing value	Admitting_Source

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_01_00-0_112	Fail	Y	PatID variable type does not conform to specifications	PatID
DIA_1_01_00-0_115	Fail	Y	PatID variable length is less than needed to contain maximum value	PatID
DIA_1_01_00-0_116	Fail	Y	PatID variable is formatted with an inadequate format	PatID
DIA_1_01_00-0_120	Fail	Y	PatID variable contains a null value	PatID
DIA_1_02_00-0_110	Fail	Y	EncounterID variable does not exist	EncounterID
DIA_1_02_00-0_112	Fail	Y	EncounterID variable type does not conform to specifications	EncounterID
DIA_1_02_00-0_115	Fail	Y	EncounterID variable length is less than needed to contain maximum value	EncounterID
DIA_1_02_00-0_116	Fail	Y	EncounterID variable is formatted with an inadequate format	EncounterID
DIA_1_02_00-0_120	Fail	Y	EncounterID variable contains a null value	EncounterID
DIA_1_03_00-0_110	Fail	Y	ADate variable does not exist	ADate
DIA_1_03_00-0_112	Fail	Y	ADate variable type does not conform to specifications	ADate
DIA_1_03_00-0_113	Fail	Y	ADate variable length does not conform to specifications	ADate
DIA_1_03_00-0_120	Fail	Y	ADate variable contains a null value	ADate
DIA_1_04_00-0_110	Fail	Y	ProviderID variable does not exist	ProviderID
DIA_1_04_00-0_112	Fail	Y	ProviderID variable type does not conform to specifications	ProviderID
DIA_1_04_00-0_115	Fail	Y	ProviderID variable length is less than needed to contain maximum value	ProviderID
DIA_1_04_00-0_116	Fail	Y	ProviderID variable is formatted with an inadequate format	ProviderID
DIA_1_04_00-0_120	Fail	Y	ProviderID variable contains a null value	ProviderID
DIA_1_04_00-0_121	Fail	Y	ProviderID variable contains an invalid non-missing value	ProviderID
DIA_1_05_00-0_110	Fail	Y	EncType variable does not exist	EncType
DIA_1_05_00-0_112	Fail	Y	EncType variable type does not conform to specifications	EncType
DIA_1_05_00-0_113	Fail	Y	EncType variable length does not conform to specifications	EncType
DIA_1_05_00-0_120	Fail	Y	EncType variable contains a null value	EncType
DIA_1_05_00-0_121	Fail	Y	EncType variable contains an invalid non-missing value	EncType
DIA_1_06_00-0_110	Fail	Y	Dx variable does not exist	Dx
DIA_1_06_00-0_112	Fail	Y	Dx variable type does not conform to specifications	Dx
DIA_1_06_00-0_120	Fail	Y	Dx variable contains a null value	Dx
DIA_1_07_00-0_110	Fail	Y	Dx_CodeType variable does not exist	Dx_CodeType
DIA_1_07_00-0_112	Fail	Y	Dx_CodeType variable type does not conform to specifications	Dx_CodeType
DIA_1_07_00-0_113	Fail	Y	Dx_CodeType variable length does not conform to specifications	Dx_CodeType
DIA_1_07_00-0_120	Fail	Y	Dx_CodeType variable contains a null value	Dx_CodeType
DIA_1_07_00-0_121	Fail	Y	Dx_CodeType variable contains an invalid non-missing value	Dx_CodeType
DIA_1_08_00-0_110	Fail	Y	OrigDx variable does not exist	OrigDx
DIA_1_08_00-0_112	Fail	Y	OrigDx variable type does not conform to specifications	OrigDx
DIA_1_09_00-0_110	Fail	Y	PDX variable does not exist	PDX
DIA_1_09_00-0_111	Fail	Y	PDX variable is not populated	PDX
DIA_1_09_00-0_112	Fail	Y	PDX variable type does not conform to specifications	PDX
DIA_1_09_00-0_113	Fail	Y	PDX variable length does not conform to specifications	PDX
DIA_1_09_00-0_121	Fail	Y	PDX variable contains an invalid non-missing value	PDX
DIA_1_10_00-0_110	Fail	Y	Padmit variable does not exist	Padmit
DIA_1_10_00-0_112	Fail	Y	Padmit variable type does not conform to specifications	Padmit
DIA_1_10_00-0_113	Fail	Y	Padmit variable length does not conform to specifications	Padmit
DIA_1_10_00-0_120	Fail	Y	Padmit variable contains a null value	Padmit
DIA_1_10_00-0_121	Fail	Y	Padmit variable contains an invalid 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_01_00-0_112	Fail	Y	PatID variable type does not conform to specifications	PatID
PRO_1_01_00-0_115	Fail	Y	PatID variable length is less than needed to contain maximum value	PatID
PRO_1_01_00-0_116	Fail	Y	PatID variable is formatted with an inadequate format	PatID
PRO_1_01_00-0_120	Fail	Y	PatID variable contains a null value	PatID
PRO_1_02_00-0_110	Fail	Y	EncounterID variable does not exist	EncounterID
PRO_1_02_00-0_112	Fail	Y	EncounterID variable type does not conform to specifications	EncounterID
PRO_1_02_00-0_115	Fail	Y	EncounterID variable length is less than needed to contain maximum value	EncounterID
PRO_1_02_00-0_116	Fail	Y	EncounterID variable is formatted with an inadequate format	EncounterID
PRO_1_02_00-0_120	Fail	Y	EncounterID variable contains a null value	EncounterID
PRO_1_03_00-0_110	Fail	Y	ADate variable does not exist	ADate
PRO_1_03_00-0_112	Fail	Y	ADate variable type does not conform to specifications	ADate
PRO_1_03_00-0_113	Fail	Y	ADate variable length does not conform to specifications	ADate
PRO_1_03_00-0_120	Fail	Y	ADate variable contains a null value	ADate
PRO_1_04_00-0_110	Fail	Y	ProviderID variable does not exist	ProviderID
PRO_1_04_00-0_112	Fail	Y	ProviderID variable type does not conform to specifications	ProviderID
PRO_1_04_00-0_115	Fail	Y	ProviderID variable length is less than needed to contain maximum value	ProviderID
PRO_1_04_00-0_116	Fail	Y	ProviderID variable is formatted with an inadequate format	ProviderID
PRO_1_04_00-0_120	Fail	Y	ProviderID variable contains a null value	ProviderID
PRO_1_04_00-0_121	Fail	Y	ProviderID variable contains an invalid non-missing value	ProviderID
PRO_1_05_00-0_110	Fail	Y	EncType variable does not exist	EncType
PRO_1_05_00-0_112	Fail	Y	EncType variable type does not conform to specifications	EncType
PRO_1_05_00-0_113	Fail	Y	EncType variable length does not conform to specifications	EncType
PRO_1_05_00-0_120	Fail	Y	EncType variable contains a null value	EncType
PRO_1_05_00-0_121	Fail	Y	EncType variable contains an invalid non-missing value	EncType
PRO_1_06_00-0_110	Fail	Y	Px variable does not exist	Px
PRO_1_06_00-0_112	Fail	Y	Px variable type does not conform to specifications	Px
PRO_1_06_00-0_120	Fail	Y	Px variable contains a null value	Px
PRO_1_07_00-0_110	Fail	Y	Px_CodeType variable does not exist	Px_CodeType
PRO_1_07_00-0_112	Fail	Y	Px_CodeType variable type does not conform to specifications	Px_CodeType
PRO_1_07_00-0_113	Fail	Y	Px_CodeType variable length does not conform to specifications	Px_CodeType
PRO_1_07_00-0_120	Fail	Y	Px_CodeType variable contains a null value	Px_CodeType
PRO_1_07_00-0_121	Fail	Y	Px_CodeType variable contains an invalid non-missing value	Px_CodeType
PRO_1_08_00-0_110	Fail	Y	OrigPx variable does not exist	OrigPx
PRO_1_08_00-0_112	Fail	Y	OrigPx variable type does not conform to specifications	OrigPx

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_01_00-0_112	Fail	Y	PatID variable type does not conform to specifications	PatID
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_110	Fail	Y	DeathDt variable does not exist	DeathDt
DTH_1_02_00-0_112	Fail	Y	DeathDt variable type does not conform to specifications	DeathDt
DTH_1_02_00-0_113	Fail	Y	DeathDt variable length does not conform to specifications	DeathDt
DTH_1_02_00-0_120	Fail	Y	DeathDt variable contains a null value	DeathDt
DTH_1_03_00-0_110	Fail	Y	Dtimpute variable does not exist	Dtimpute
DTH_1_03_00-0_112	Fail	Y	Dtimpute variable type does not conform to specifications	Dtimpute
DTH_1_03_00-0_113	Fail	Y	Dtimpute variable length does not conform to specifications	Dtimpute
DTH_1_03_00-0_120	Fail	Y	Dtimpute variable contains a null value	Dtimpute
DTH_1_03_00-0_121	Fail	Y	Dtimpute variable contains an invalid non-missing value	Dtimpute
DTH_1_04_00-0_110	Fail	Y	Source variable does not exist	Source
DTH_1_04_00-0_112	Fail	Y	Source variable type does not conform to specifications	Source
DTH_1_04_00-0_113	Fail	Y	Source variable length does not conform to specifications	Source
DTH_1_04_00-0_120	Fail	Y	Source variable contains a null value	Source
DTH_1_04_00-0_121	Fail	Y	Source variable contains an invalid non-missing value	Source
DTH_1_05_00-0_110	Fail	Y	Confidence variable does not exist	Confidence
DTH_1_05_00-0_112	Fail	Y	Confidence variable type does not conform to specifications	Confidence
DTH_1_05_00-0_113	Fail	Y	Confidence variable length does not conform to specifications	Confidence
DTH_1_05_00-0_120	Fail	Y	Confidence variable contains a null value	Confidence
DTH_1_05_00-0_121	Fail	Y	Confidence variable contains an invalid 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_01_00-0_112	Fail	Y	PatID variable type does not conform to specifications	PatID
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_110	Fail	Y	COD variable does not exist	COD
COD_1_02_00-0_112	Fail	Y	COD variable type does not conform to specifications	COD
COD_1_02_00-0_113	Fail	Y	COD variable length does not conform to specifications	COD
COD_1_02_00-0_120	Fail	Y	COD variable contains a null value	COD
COD_1_02_00-0_122	Fail	Y	COD value contains leading spaces	COD
COD_1_03_00-0_110	Fail	Y	CodeType variable does not exist	CodeType
COD_1_03_00-0_112	Fail	Y	CodeType variable type does not conform to specifications	CodeType
COD_1_03_00-0_113	Fail	Y	CodeType variable length does not conform to specifications	CodeType
COD_1_03_00-0_120	Fail	Y	CodeType variable contains a null value	CodeType
COD_1_03_00-0_121	Fail	Y	CodeType variable contains an invalid non-missing value	CodeType
COD_1_04_00-0_110	Fail	Y	Source variable does not exist	Source
COD_1_04_00-0_112	Fail	Y	Source variable type does not conform to specifications	Source
COD_1_04_00-0_113	Fail	Y	Source variable length does not conform to specifications	Source
COD_1_04_00-0_120	Fail	Y	Source variable contains a null value	Source
COD_1_04_00-0_121	Fail	Y	Source variable contains an invalid non-missing value	Source
COD_1_05_00-0_110	Fail	Y	Confidence variable does not exist	Confidence
COD_1_05_00-0_112	Fail	Y	Confidence variable type does not conform to specifications	Confidence
COD_1_05_00-0_113	Fail	Y	Confidence variable length does not conform to specifications	Confidence
COD_1_05_00-0_120	Fail	Y	Confidence variable contains a null value	Confidence
COD_1_05_00-0_121	Fail	Y	Confidence variable contains an invalid non-missing value	Confidence
COD_1_06_00-0_110	Fail	Y	CauseType variable does not exist	CauseType
COD_1_06_00-0_112	Fail	Y	CauseType variable type does not conform to specifications	CauseType
COD_1_06_00-0_113	Fail	Y	CauseType variable length does not conform to specifications	CauseType
COD_1_06_00-0_120	Fail	Y	CauseType variable contains a null value	CauseType
COD_1_06_00-0_121	Fail	Y	CauseType variable contains an invalid non-missing value	CauseType

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_01_00-0_112	Fail	Y	PatID variable type does not conform to specifications	PatID
LAB_1_01_00-0_115	Fail	Y	PatID variable length is less than needed to contain maximum value	PatID
LAB_1_01_00-0_116	Fail	Y	PatID variable is formatted with an inadequate format	PatID
LAB_1_01_00-0_120	Fail	Y	PatID variable contains a null value	PatID
LAB_1_02_00-0_110	Fail	Y	MS_Test_Name variable does not exist	MS_Test_Name
LAB_1_02_00-0_112	Fail	Y	MS_Test_Name variable type does not conform to specifications	MS_Test_Name
LAB_1_02_00-0_113	Fail	Y	MS_Test_Name variable length does not conform to specifications	MS_Test_Name
LAB_1_02_00-0_120	Fail	Y	MS_Test_Name variable contains a null value	MS_Test_Name
LAB_1_02_00-0_121	Fail	Y	MS_Test_Name variable contains an invalid non-missing value	MS_Test_Name
LAB_1_03_00-0_110	Fail	Y	Result_Type variable does not exist	Result_Type
LAB_1_03_00-0_112	Fail	Y	Result_Type variable type does not conform to specifications	Result_Type
LAB_1_03_00-0_113	Fail	Y	Result_Type variable length does not conform to specifications	Result_Type
LAB_1_03_00-0_120	Fail	Y	Result_Type variable contains a null value	Result_Type
LAB_1_03_00-0_121	Fail	Y	Result_Type variable contains an invalid non-missing value	Result_Type
LAB_1_04_00-0_110	Fail	Y	MS_Test_Sub_Category variable does not exist	MS_Test_Sub_Category
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_04_00-0_113	Fail	Y	MS_Test_Sub_Category variable length does not conform to specifications	MS_Test_Sub_Category
LAB_1_04_00-0_121	Fail	Y	MS_Test_Sub_Category variable contains an invalid non-missing value	MS_Test_Sub_Category
LAB_1_05_00-0_110	Fail	Y	Fast_Ind variable does not exist	Fast_Ind
LAB_1_05_00-0_112	Fail	Y	Fast_Ind variable type does not conform to specifications	Fast_Ind
LAB_1_05_00-0_113	Fail	Y	Fast_Ind variable length does not conform to specifications	Fast_Ind
LAB_1_05_00-0_120	Fail	Y	Fast_Ind variable contains a null value	Fast_Ind
LAB_1_05_00-0_121	Fail	Y	Fast_Ind variable contains an invalid non-missing value	Fast_Ind
LAB_1_06_00-0_110	Fail	Y	Specimen_Source variable does not exist	Specimen_Source
LAB_1_06_00-0_112	Fail	Y	Specimen_Source variable type does not conform to specifications	Specimen_Source
LAB_1_06_00-0_113	Fail	Y	Specimen_Source variable length does not conform to specifications	Specimen_Source
LAB_1_06_00-0_120	Fail	Y	Specimen_Source variable contains a null value	Specimen_Source
LAB_1_06_00-0_121	Fail	Y	Specimen_Source variable contains an invalid non-missing value	Specimen_Source
LAB_1_07_00-0_110	Fail	Y	LOINC variable does not exist	LOINC
LAB_1_07_00-0_112	Fail	Y	LOINC variable type does not conform to specifications	LOINC
LAB_1_07_00-0_113	Fail	Y	LOINC variable length does not conform to specifications	LOINC
LAB_1_07_00-0_122	Fail	Y	LOINC value contains leading spaces	LOINC
LAB_1_08_00-0_110	Fail	Y	Stat variable does not exist	Stat
LAB_1_08_00-0_112	Fail	Y	Stat variable type does not conform to specifications	Stat
LAB_1_08_00-0_113	Fail	Y	Stat variable length does not conform to specifications	Stat
LAB_1_08_00-0_120	Fail	Y	Stat variable contains a null value	Stat
LAB_1_08_00-0_121	Fail	Y	Stat variable contains an invalid non-missing value	Stat
LAB_1_09_00-0_110	Fail	Y	Pt_Loc variable does not exist	Pt_Loc
LAB_1_09_00-0_112	Fail	Y	Pt_Loc variable type does not conform to specifications	Pt_Loc
LAB_1_09_00-0_113	Fail	Y	Pt_Loc variable length does not conform to specifications	Pt_Loc
LAB_1_09_00-0_120	Fail	Y	Pt_Loc variable contains a null value	Pt_Loc
LAB_1_09_00-0_121	Fail	Y	Pt_Loc variable contains an invalid non-missing value	Pt_Loc
LAB_1_10_00-0_110	Fail	Y	Result_Loc variable does not exist	Result_Loc
LAB_1_10_00-0_112	Fail	Y	Result_Loc variable type does not conform to specifications	Result_Loc
LAB_1_10_00-0_113	Fail	Y	Result_Loc variable length does not conform to specifications	Result_Loc
LAB_1_10_00-0_121	Fail	Y	Result_Loc variable contains an invalid non-missing value	Result_Loc
LAB_1_11_00-0_110	Fail	Y	LOCAL_CD variable does not exist	LOCAL_CD
LAB_1_11_00-0_112	Fail	Y	LOCAL_CD variable type does not conform to specifications	LOCAL_CD
LAB_1_12_00-0_110	Fail	Y	BATTERY_CD variable does not exist	BATTERY_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_110	Fail	Y	PX variable does not exist	PX
LAB_1_13_00-0_112	Fail	Y	PX variable type does not conform to specifications	PX
LAB_1_14_00-0_110	Fail	Y	PX_CodeType variable does not exist	PX_CodeType
LAB_1_14_00-0_112	Fail	Y	PX_CodeType variable type does not conform to specifications	PX_CodeType
LAB_1_14_00-0_113	Fail	Y	PX_CodeType variable length does not conform to specifications	PX_CodeType
LAB_1_14_00-0_121	Fail	Y	PX_CodeType variable contains an invalid non-missing value	PX_CodeType
LAB_1_15_00-0_110	Fail	Y	Order_dt variable does not exist	Order_dt
LAB_1_15_00-0_112	Fail	Y	Order_dt variable type does not conform to specifications	Order_dt
LAB_1_15_00-0_113	Fail	Y	Order_dt variable length does not conform to specifications	Order_dt
LAB_1_16_00-0_110	Fail	Y	Lab_dt variable does not exist	Lab_dt
LAB_1_16_00-0_112	Fail	Y	Lab_dt variable type does not conform to specifications	Lab_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_110	Fail	Y	Lab_tm variable does not exist	Lab_tm
LAB_1_17_00-0_112	Fail	Y	Lab_tm variable type does not conform to specifications	Lab_tm
LAB_1_17_00-0_113	Fail	Y	Lab_tm variable length does not conform to specifications	Lab_tm
LAB_1_18_00-0_110	Fail	Y	Result_dt variable does not exist	Result_dt
LAB_1_18_00-0_112	Fail	Y	Result_dt variable type does not conform to specifications	Result_dt
LAB_1_18_00-0_113	Fail	Y	Result_dt variable length does not conform to specifications	Result_dt
LAB_1_19_00-0_110	Fail	Y	Result_tm variable does not exist	Result_tm
LAB_1_19_00-0_112	Fail	Y	Result_tm variable type does not conform to specifications	Result_tm
LAB_1_19_00-0_113	Fail	Y	Result_tm variable length does not conform to specifications	Result_tm
LAB_1_20_00-0_110	Fail	Y	Orig_Result variable does not exist	Orig_Result
LAB_1_20_00-0_112	Fail	Y	Orig_Result variable type does not conform to specifications	Orig_Result
LAB_1_20_00-0_113	Fail	Y	Orig_Result variable length does not conform to specifications	Orig_Result
LAB_1_20_00-0_120	Fail	Y	Orig_Result variable contains a null value	Orig_Result
LAB_1_21_00-0_110	Fail	Y	MS_Result_C variable does not exist	MS_Result_C
LAB_1_21_00-0_112	Fail	Y	MS_Result_C variable type does not conform to specifications	MS_Result_C
LAB_1_21_00-0_113	Fail	Y	MS_Result_C variable length does not conform to specifications	MS_Result_C
LAB_1_21_00-0_121	Warn	N	MS_Result_C variable contains an invalid non-missing value	MS_Result_C
LAB_1_22_00-0_110	Fail	Y	MS_Result_N variable does not exist	MS_Result_N
LAB_1_22_00-0_112	Fail	Y	MS_Result_N variable type does not conform to specifications	MS_Result_N
LAB_1_22_00-0_113	Fail	Y	MS_Result_N variable length does not conform to specifications	MS_Result_N
LAB_1_22_00-0_121	Warn	N	MS_Result_N variable contains an invalid non-missing value	MS_Result_N
LAB_1_23_00-0_110	Fail	Y	Modifier variable does not exist	Modifier
LAB_1_23_00-0_112	Fail	Y	Modifier variable type does not conform to specifications	Modifier
LAB_1_23_00-0_113	Fail	Y	Modifier variable length does not conform to specifications	Modifier
LAB_1_23_00-0_120	Fail	Y	Modifier variable contains a null value	Modifier
LAB_1_23_00-0_121	Fail	Y	Modifier variable contains an invalid non-missing value	Modifier
LAB_1_24_00-0_110	Fail	Y	Orig_Result_unit variable does not exist	Orig_Result_unit
LAB_1_24_00-0_112	Fail	Y	Orig_Result_unit variable type does not conform to specifications	Orig_Result_unit
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_110	Fail	Y	Std_Result_unit variable does not exist	Std_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_25_00-0_113	Fail	Y	Std_Result_unit variable length does not conform to specifications	Std_Result_unit
LAB_1_26_00-0_110	Fail	Y	MS_Result_unit variable does not exist	MS_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_26_00-0_113	Fail	Y	MS_Result_unit variable length does not conform to specifications	MS_Result_unit
LAB_1_26_00-0_121	Warn	N	MS_Result_unit variable contains an invalid non-missing value	MS_Result_unit
LAB_1_26_00-0_122	Fail	Y	MS_Result_unit value contains leading spaces	MS_Result_unit
LAB_1_27_00-0_110	Fail	Y	Norm_Range_low variable does not exist	Norm_Range_low
LAB_1_27_00-0_112	Fail	Y	Norm_Range_low variable type does not conform to specifications	Norm_Range_low
LAB_1_27_00-0_113	Fail	Y	Norm_Range_low variable length does not conform to specifications	Norm_Range_low
LAB_1_27_00-0_121	Warn	N	Norm_Range_low variable contains an invalid non-missing value	Norm_Range_low
LAB_1_27_00-0_122	Fail	Y	Norm_Range_low value contains leading spaces	Norm_Range_low
LAB_1_28_00-0_110	Fail	Y	Modifier_low variable does not exist	Modifier_low
LAB_1_28_00-0_112	Fail	Y	Modifier_low variable type does not conform to specifications	Modifier_low
LAB_1_28_00-0_113	Fail	Y	Modifier_low variable length does not conform to specifications	Modifier_low
LAB_1_28_00-0_121	Fail	Y	Modifier_low variable contains an invalid non-missing value	Modifier_low
LAB_1_29_00-0_110	Fail	Y	Norm_Range_high variable does not exist	Norm_Range_high
LAB_1_29_00-0_112	Fail	Y	Norm_Range_high variable type does not conform to specifications	Norm_Range_high
LAB_1_29_00-0_113	Fail	Y	Norm_Range_high variable length does not conform to specifications	Norm_Range_high
LAB_1_29_00-0_121	Warn	N	Norm_Range_high variable contains an invalid non-missing value	Norm_Range_high
LAB_1_29_00-0_122	Fail	Y	Norm_Range_high value contains leading spaces	Norm_Range_high
LAB_1_30_00-0_110	Fail	Y	Modifier_high variable does not exist	Modifier_high
LAB_1_30_00-0_112	Fail	Y	Modifier_high variable type does not conform to specifications	Modifier_high
LAB_1_30_00-0_113	Fail	Y	Modifier_high variable length does not conform to specifications	Modifier_high
LAB_1_30_00-0_121	Fail	Y	Modifier_high variable contains an invalid non-missing value	Modifier_high
LAB_1_31_00-0_110	Fail	Y	Abn_ind variable does not exist	Abn_ind
LAB_1_31_00-0_112	Fail	Y	Abn_ind variable type does not conform to specifications	Abn_ind
LAB_1_31_00-0_113	Fail	Y	Abn_ind variable length does not conform to specifications	Abn_ind
LAB_1_31_00-0_120	Fail	Y	Abn_ind variable contains a null value	Abn_ind
LAB_1_31_00-0_121	Fail	Y	Abn_ind variable contains an invalid non-missing value	Abn_ind
LAB_1_32_00-0_110	Fail	Y	Order_dept variable does not exist	Order_dept
LAB_1_32_00-0_112	Fail	Y	Order_dept variable type does not conform to specifications	Order_dept
LAB_1_33_00-0_110	Fail	Y	FacilityID variable does not exist	FacilityID
LAB_1_33_00-0_112	Fail	Y	FacilityID variable type does not conform to specifications	FacilityID
LAB_1_33_00-0_115	Fail	Y	FacilityID variable length is less than needed to contain maximum value	FacilityID
LAB_1_33_00-0_116	Fail	Y	FacilityID variable is formatted with an inadequate format	FacilityID
LAB_1_33_00-0_121	Fail	Y	FacilityID variable contains an invalid non-missing value	FacilityID
LAB_1_34_00-0_110	Fail	Y	LabID variable does not exist	LabID
LAB_1_34_00-0_112	Fail	Y	LabID variable type does not conform to specifications	LabID
LAB_1_34_00-0_115	Fail	Y	LabID variable length is less than needed to contain maximum value	LabID
LAB_1_34_00-0_116	Fail	Y	LabID variable is formatted with an inadequate format	LabID
LAB_1_34_00-0_120	Fail	Y	LabID variable contains a null value	LabID

FlagID	FlagType	AbortYN	Flag_Descr	Variable1	Variable2	Variable3
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-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_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-ENR_2_01_00-0_203	Fail	Y	PatID variable length is not consistent between tables	PatID
VIT_2_01_00-0_209	Warn	N	PatID variable length is greater than needed to contain maximum value across tables	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-ENC_2_02_00-0_203	Fail	Y	EncounterID variable length is not consistent between tables	EncounterID	EncounterID
VIT_2_02_00-0_209	Warn	N	EncounterID variable length is greater than needed to contain maximum value across tables	EncounterID
VIT-DEM_2_03_00-0_206	Warn	N	Measure_Date value occurs before Birth_Date value	Measure_Date	Birth_Date

FlagID	FlagType	AbortYN	Flag_Descr	Variable1	Variable2
IRX_2_00_00-0_211	Fail	Y	Duplicate record(s) present for unique key variable(s): RxID
IRX-ENR_2_01_00-0_201	Warn	N	PatID value present in IRX table, but not in the ENR table	PatID
IRX-ENR_2_01_00-0_203	Fail	Y	PatID variable length is not consistent between tables	PatID
IRX_2_01_00-0_209	Warn	N	PatID variable length is greater than needed to contain maximum value across tables	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-ENC_2_02_00-0_203	Fail	Y	EncounterID variable length is not consistent between tables	EncounterID	EncounterID
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-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

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

5 Quality Checks

5.1 Basic Integrity Checks

5.2 Level 1 Quality Checks

5.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

5.3 Level 2 Quality Checks

5.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

5.4 Level 3 Quality Checks

5.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_2_00_00-0_211	Fail	Y	Duplicate record(s) present for unique key variable(s): PrescribingID
PRE-ENR_2_01_00-0_201	Warn	N	PatID value present in PRE table, but not in the ENR table	PatID
PRE-ENR_2_01_00-0_203	Fail	Y	PatID variable length is not consistent between tables	PatID
PRE_2_01_00-0_209	Warn	N	PatID variable length is greater than needed to contain maximum value across tables	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-ENC_2_02_00-0_203	Fail	Y	EncounterID variable length is not consistent between tables	EncounterID	EncounterID
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-PVD_2_04_00-0_201	Fail	Y	ProviderID value present in PRE table, but not in the PVD table	ProviderID	ProviderID
PRE-PVD_2_04_00-0_203	Fail	Y	ProviderID variable length is not consistent between tables	ProviderID	ProviderID
PRE_2_04_00-0_209	Warn	N	ProviderID variable length is greater than needed to contain maximum value across tables	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_07_00-0_223	Warn	N	Rx value is invalid based on Rx_CodeType value	Rx	Rx_CodeType
PRE_2_07_00-0_228	Warn	N	Rx value length is invalid based on Rx_CodeType	Rx	Rx_CodeType

FlagID	FlagType	AbortYN	Flag_Descr	Variable1	Variable2
FAC_2_00_00-0_211	Fail	Y	Duplicate record(s) present for unique key variable(s): FacilityID
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_02_00-0_223	Warn	N	Facility_Location value is invalid based on FacilityID value	Facility_Location	FacilityID

FlagID	FlagType	AbortYN	Flag_Descr	Variable1	Variable2
PVD_2_00_00-0_211	Fail	Y	Duplicate record(s) present for unique key variable(s): ProviderID
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_03_00-0_228	Warn	N	Specialty_CodeType value length is invalid 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-ENR_2_01_00-0_203	Fail	Y	PatID variable length is not consistent between tables	PatID
PRR_2_01_00-0_209	Warn	N	PatID variable length is greater than needed to contain maximum value across tables	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-ENC_2_02_00-0_203	Fail	Y	EncounterID variable length is not consistent between tables	EncounterID	EncounterID
PRR_2_02_00-0_209	Warn	N	EncounterID variable length is greater than needed to contain maximum value across tables	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_2_04_00-0_209	Warn	N	SurveyID variable length is greater than needed to contain maximum value across tables	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_2_06_00-0_209	Warn	N	QuestionVerID variable length is greater than needed to contain maximum value across tables	QuestionVerID
PRR-PRS_2_07_00-0_206	Warn	N	Response_Dt value occurs before Question_Dt value	Response_Dt	Question_Dt

FlagID	FlagType	AbortYN	Flag_Descr	Variable1	Variable2
PRS_2_00_00-0_211	Fail	Y	Duplicate record(s) present for unique key variable(s): PRM_Code, SurveyID, QuestionID, QuestionVerID
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_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_201	Note	N	SurveyID value present in PRS table, but not in the PRR table	SurveyID	SurveyID
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-PRR_2_03_00-0_201	Note	N	QuestionID value present in PRS table, but not in the PRR table	QuestionID	QuestionID
PRS_2_03_00-0_209	Warn	N	QuestionID variable length is greater than needed to contain maximum value across tables	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_2_04_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
DEM_2_00_00-0_211	Fail	Y	Duplicate record(s) present for unique key variable(s): PatID
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_2_01_00-0_209	Warn	N	PatID variable length is greater than needed to contain maximum value across 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_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_2_00_00-0_211	Fail	Y	Duplicate record(s) present for unique key variable(s): PatID, RxDate, Rx, Rx_Codetype, ProviderID
DIS-ENR_2_01_00-0_201	Warn	N	PatID value present in DIS table, but not in the ENR table	PatID
DIS-ENR_2_01_00-0_203	Fail	Y	PatID variable length is not consistent between tables	PatID
DIS_2_01_00-0_209	Warn	N	PatID variable length is greater than needed to contain maximum value across tables	PatID
DIS-DEM_2_02_00-0_206	Warn	N	RxDate value occurs before Birth_Date value	RxDate	Birth_Date
DIS_2_03_00-0_223	Warn	N	Rx value is invalid based on Rx_Codetype value	Rx	Rx_Codetype
DIS_2_03_00-0_228	Warn	N	Rx value length is invalid based on Rx_Codetype	Rx	Rx_Codetype
DIS-PVD_2_07_00-0_201	Fail	Y	ProviderID value present in DIS table, but not in the PVD table	ProviderID	ProviderID
DIS-PVD_2_07_00-0_203	Fail	Y	ProviderID variable length is not consistent between tables	ProviderID	ProviderID
DIS_2_07_00-0_209	Warn	N	ProviderID variable length is greater than needed to contain maximum value across tables	ProviderID

FlagID	FlagType	AbortYN	Flag_Descr	Variable1	Variable2	Variable3	Variable4
ENC_2_00_00-0_211	Fail	Y	Duplicate record(s) present for unique key variable(s): EncounterID
ENC-ENR_2_01_00-0_201	Warn	N	PatID value present in ENC table, but not in the ENR table	PatID
ENC-ENR_2_01_00-0_203	Fail	Y	PatID variable length is not consistent between tables	PatID
ENC_2_01_00-0_209	Warn	N	PatID variable length is greater than needed to contain maximum value across tables	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_2_02_00-0_209	Warn	N	EncounterID variable length is greater than needed to contain maximum value across tables	EncounterID
ENC-DEM_2_03_00-0_206	Warn	N	ADate value occurs before Birth_Date value	ADate	Birth_Date
ENC_2_03_00-0_226	Warn	N	ADate value occurs after DDate value	ADate	DDate
ENC_2_04_00-0_223	Warn	N	DDate value is invalid based on EncType value	DDate	EncType
ENC-FAC_2_06_00-0_201	Fail	Y	FacilityID value present in ENC table, but not in the FAC table	FacilityID	FacilityID
ENC-FAC_2_06_00-0_203	Fail	Y	FacilityID variable length is not consistent between tables	FacilityID	FacilityID
ENC_2_06_00-0_209	Warn	N	FacilityID variable length is greater than needed to contain maximum value across tables	FacilityID
ENC_2_07_00-0_244	Warn	N	Invalid 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 invalid 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 invalid 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 invalid combination of EncType, DDate, Discharge_Disposition, Discharge_Status	EncType	DDate	Discharge_Disposition	Discharge_Status
ENC_2_09_00-0_223	Warn	N	Discharge_Disposition value is invalid based on EncType value	Discharge_Disposition	EncType
ENC_2_10_00-0_223	Warn	N	Discharge_Status value is invalid based on EncType value	Discharge_Status	EncType
ENC_2_12_00-0_229	Warn	N	DRG_Type value is invalid based on the date value of ADate	DRG_Type	ADate
ENC_2_13_00-0_223	Warn	N	Admitting_Source value is invalid based on EncType value	Admitting_Source	EncType

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

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