Centralized data Vetting Process: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) |
||
| Line 28: | Line 28: | ||
#* 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 | #* 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" | #* uses subquery "ND_Sub_VAPinAcqDX_NoVAP_DateinTMPV2_Sub_TMPV2_Component" | ||
#a | # NDC_No_VAPinAcqDX_VAP_dateinTMPV2 | ||
#* | #* finds all 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 | |||
#'''need to create: CLIinAcqDX_NoCLI_DateinTMPV2 | #'''need to create: CLIinAcqDX_NoCLI_DateinTMPV2 | ||
#'''need to create: No_CLIinAcqDX_CLI_DateinTMPV2 | #'''need to create: No_CLIinAcqDX_CLI_DateinTMPV2 | ||