Centralized data Vetting Process: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) |
||
| Line 34: | Line 34: | ||
#* records for which a complication 8600 exists and for which a corresponding tmp entry with item "CLI" and datevar <> null does not exist | #* 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" | #* 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" | |||
== Set record as vetted == | == Set record as vetted == | ||