Centralized data Vetting Process: Difference between revisions

Line 18:

# NDC_SameChart_site_Diff_PHIN

# NDC_Missing_TransferDate_wPivot ([[Transfer_Ready_date_and_time]])

# NDC_VAPinAcqDX_NoVAP_DateinTMPV2

# NDC_VAPinAcqDX_NoVAP_DateinTMPV2 (see [[VAP Dx vs Tmp checking]])

~~#* records for which a complication 3900 exists and for which a corresponding tmp entry with item "~~VAP~~" and datevar <> null does not exist~~

# NDC_No_VAPinAcqDX_VAP_dateinTMPV2 (see [[VAP Dx vs Tmp checking]])

~~#* uses subquery "ND_Sub_VAPinAcqDX_NoVAP_DateinTMPV2_Sub_TMPV2_Component"~~

# NDC_CLIinAcqDX_NoCLI_DateinTMPV2 (see [[CLI Dx vs Tmp checking]])

# NDC_No_VAPinAcqDX_VAP_dateinTMPV2

# NDC_No_CLIinAcqDX_CLI_DateinTMPV2 (see [[CLI Dx vs Tmp checking]])

~~#* records that have a tmp entry with item "~~VAP~~" for which a l_dxs complication entry with code 3900 does not exist~~

~~#* uses query ND_sub_NoVAPinAcqDX_VAP_DateinTMPV2_sub_had_VAP_acqDX~~

# NDC_CLIinAcqDX_NoCLI_DateinTMPV2

~~#* records for which a complication 8600 exists and for which a corresponding tmp entry with item "~~CLI~~" and datevar <> null does not exist~~

~~#* uses subquery "ND_sub_CLI_DateinTMPV2"~~

# NDC_No_CLIinAcqDX_CLI_DateinTMPV2

~~#* records that have a tmp entry with item "~~CLI~~" for which a l_dxs complication entry with code 8600 does not exist~~

~~#* uses subquery "ND_sub_has_dx8600"~~

{{discussion}} where in here does [[Orphans in Centralized data.mdb| "NDC_orphans"]] best fit? Ttenbergen 20:19, 2014 May 1 (CDT)

@@ Line 18: / Line 18: @@
 # NDC_SameChart_site_Diff_PHIN
 # NDC_Missing_TransferDate_wPivot ([[Transfer_Ready_date_and_time]])
-# NDC_VAPinAcqDX_NoVAP_DateinTMPV2
+# NDC_VAPinAcqDX_NoVAP_DateinTMPV2 (see [[VAP Dx vs Tmp checking]])
-#* records for which a complication 3900 exists and for which a corresponding tmp entry with item "VAP" and datevar <> null does not exist
+# NDC_No_VAPinAcqDX_VAP_dateinTMPV2 (see [[VAP Dx vs Tmp checking]])
-#* uses subquery "ND_Sub_VAPinAcqDX_NoVAP_DateinTMPV2_Sub_TMPV2_Component"
+# NDC_CLIinAcqDX_NoCLI_DateinTMPV2 (see [[CLI Dx vs Tmp checking]])
-# NDC_No_VAPinAcqDX_VAP_dateinTMPV2
+# NDC_No_CLIinAcqDX_CLI_DateinTMPV2 (see [[CLI Dx vs Tmp checking]])
-#* records that have a tmp entry with item "VAP" for which a l_dxs complication entry with code 3900 does not exist
-#* uses query ND_sub_NoVAPinAcqDX_VAP_DateinTMPV2_sub_had_VAP_acqDX
-# NDC_CLIinAcqDX_NoCLI_DateinTMPV2
-#* records for which a complication 8600 exists and for which a corresponding tmp entry with item "CLI" and datevar <> null does not exist
-#* uses subquery "ND_sub_CLI_DateinTMPV2"
-# NDC_No_CLIinAcqDX_CLI_DateinTMPV2
-#* records that have a tmp entry with item "CLI" for which a l_dxs complication entry with code 8600 does not exist
-#* uses subquery "ND_sub_has_dx8600"
 {{discussion}} where in here does [[Orphans in Centralized data.mdb| "NDC_orphans"]] best fit? Ttenbergen 20:19, 2014 May 1 (CDT)