Quality Assurance queries in CFE: Difference between revisions

(36 intermediate revisions by 2 users not shown)

Line 3:

The easiest way to check these is to click the [[NDCs button]]. It will check every query but only display those where problems were found.

== NDC queries / [[~~CFE~~ Data Integrity Checks]]==

If any false positives are found that are unique special cases or if there are errors that we deliberately decide not to correct for some reasons, set them as [[Known data errors]] so they no longer show up in queries.

#[[Query NDC ~~missing L Tables content | NDC_missing_L_Tables_content~~]]

~~# NDC_discharged_incomplete (It is ok if there is a list of Incompletes)~~

When they have all been corrected you can move to the next step in [[Centralized data Vetting Process]], likely [["Vet all sent" button]].

# [[~~Postal_code_cross_check~~|~~NDC_Bad_Postal_Code~~]] ~~(This is corrected when time available)~~

~~# NDC_Missing_TransferDate_w_pivot (This is done during reports, OK to skip this one)~~

== List of NDC queries ==

~~# NDC_CLI_AcqDX_but_NoCLI_DateinTMPV2~~

{{#ask: [[Category:Data Integrity Checks]] [[~Query NDC*]] [[DICStatus::implemented||needs review]]

~~# NDC_CLI_vs_NO_TISS17~~

|?DICStatus

~~# NDC_CLI_No_AcqDX_but_CLI_DateinTMPV2~~

|format=table

~~# NDC_CLI_unacceptable_date~~

|default=none found

# ~~NDC_VAP_AcqDX_but_NoVAP_DateinTMPV2 (see~~ [[~~VAP Dx vs Tmp checking~~]])

|intro=Current list of queries

~~# NDC_VAP_No_AcqDX_but_VAP_DateinTMPV2 (see~~ [[~~VAP Dx vs Tmp checking~~]])

}}

~~# NDC_VAP_unacceptable_date (see [[VAP Dx vs Tmp checking]])~~

{{#ask: [[Category:Data Integrity Checks]] [[~Query NDC*]]

|?DICStatus

|format=table

|default=none found

|searchlabel=Full list of queries including declined, retired, etc

|limit=0

}}

== Related articles ==

[[Category:Data Processing]]

[[Category:Postal Codes]]

@@ Line 3: / Line 3: @@
 The easiest way to check these is to click the [[NDCs button]]. It will check every query but only display those where problems were found.
-== NDC queries / [[CFE Data Integrity Checks]]==
+If any false positives are found that are unique special cases or if there are errors that we deliberately decide not to correct for some reasons, set them as [[Known data errors]] so they no longer show up in queries.
-#[[Query NDC missing L Tables content | NDC_missing_L_Tables_content]]
-# NDC_discharged_incomplete (It is ok if there is a list of Incompletes)
+When they have all been corrected you can move to the next step in [[Centralized data Vetting Process]], likely [["Vet all sent" button]].
-# [[Postal_code_cross_check|NDC_Bad_Postal_Code]] (This is corrected when time available)
-# NDC_Missing_TransferDate_w_pivot (This is done during reports, OK to skip this one)
+== List of NDC queries ==
-# NDC_CLI_AcqDX_but_NoCLI_DateinTMPV2
+{{#ask: [[Category:Data Integrity Checks]] [[~Query NDC*]] [[DICStatus::implemented||needs review]]
-# NDC_CLI_vs_NO_TISS17
+|?DICStatus
-# NDC_CLI_No_AcqDX_but_CLI_DateinTMPV2
+|format=table
-# NDC_CLI_unacceptable_date
+|default=none found
-# NDC_VAP_AcqDX_but_NoVAP_DateinTMPV2 (see [[VAP Dx vs Tmp checking]])
+|intro=Current list of queries
-# NDC_VAP_No_AcqDX_but_VAP_DateinTMPV2 (see [[VAP Dx vs Tmp checking]])
+}}
-# NDC_VAP_unacceptable_date (see [[VAP Dx vs Tmp checking]])
+{{#ask: [[Category:Data Integrity Checks]] [[~Query NDC*]]
+|?DICStatus
+|format=table
+|default=none found
+|searchlabel=Full list of queries including declined, retired, etc
+|limit=0
+}}
+== Related articles ==
+{{Related Articles}}
 [[Category:Data Processing]]
 [[Category:Postal Codes]]