Centralized data Vetting Process: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) |
||
| Line 26: | Line 26: | ||
# NDC_Missing_TransferDate_wPivot | # NDC_Missing_TransferDate_wPivot | ||
# NDC_VAPinAcqDX_NoVAP_DateinTMPV2 | # NDC_VAPinAcqDX_NoVAP_DateinTMPV2 | ||
#* | #* records for which a complication 3900 exists and for which a corresponding tmp entry with item "VAP" and datevar <> null does not exist | ||
#* uses subquery "ND_Sub_VAPinAcqDX_NoVAP_DateinTMPV2_Sub_TMPV2_Component" | #* uses subquery "ND_Sub_VAPinAcqDX_NoVAP_DateinTMPV2_Sub_TMPV2_Component" | ||
# NDC_No_VAPinAcqDX_VAP_dateinTMPV2 | # NDC_No_VAPinAcqDX_VAP_dateinTMPV2 | ||
#* | #* 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 | #* 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" | |||
#'''need to create: No_CLIinAcqDX_CLI_DateinTMPV2 | #'''need to create: No_CLIinAcqDX_CLI_DateinTMPV2 | ||