Centralized data Vetting Process: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) |
||
| Line 25: | Line 25: | ||
# NDC_SameChart_site_Diff_PHIN | # NDC_SameChart_site_Diff_PHIN | ||
# NDC_Missing_TransferDate_wPivot | # NDC_Missing_TransferDate_wPivot | ||
#a | # NDC_VAPinAcqDX_NoVAP_DateinTMPV2 | ||
#* | #* query finds all records for which a complication 3900 exists and for whom a corresponding tmp entry with item "VAP" and datevar <> null does not exist | ||
#* uses subquery "ND_Sub_VAPinAcqDX_NoVAP_DateinTMPV2_Sub_TMPV2_Component" | |||
#a) '''fix : NDC_No_VAPinAcqDX_VAP_dateinTMPV2-Not working. | #a) '''fix : NDC_No_VAPinAcqDX_VAP_dateinTMPV2-Not working. | ||
#*b)'''fix : ND_sub_NoVAPinAcqDX_VAP_DateinTMPV2_sub_had_VAP_acqDX | #*b)'''fix : ND_sub_NoVAPinAcqDX_VAP_DateinTMPV2_sub_had_VAP_acqDX | ||