Centralized data Vetting Process: Difference between revisions
Ttenbergen (talk | contribs) |
mNo edit summary |
||
| Line 18: | Line 18: | ||
== Check for problems == | == Check for problems == | ||
Use [[Centralized data front end.mdb]] "NDC" (New Data Check) queries and fix data as needed | Use [[Centralized data front end.mdb]] "NDC" (New Data Check) queries and fix data as needed: | ||
# NDC_SamePHIN_Site_Diff_chart - fix | # NDC_SamePHIN_Site_Diff_chart - fix | ||
# NDC_Chart_9_Digit - fix | # NDC_Chart_9_Digit - fix | ||
| Line 25: | Line 25: | ||
# NDC_SameChart_site_Diff_PHIN | # NDC_SameChart_site_Diff_PHIN | ||
# NDC_Missing_TransferDate_wPivot | # NDC_Missing_TransferDate_wPivot | ||
#a) started: NDC_VAPinAcqDX_NoVAP_DateinTMPV2 | #a) started: NDC_VAPinAcqDX_NoVAP_DateinTMPV2-Not working. | ||
#*b)started: ND_sub_VAPinAcqDX_NoVAP_DateinTMPV2_sub_TMPV2_component | #*b)started: ND_sub_VAPinAcqDX_NoVAP_DateinTMPV2_sub_TMPV2_component | ||
#a) started: NDC_No_VAPinAcqDX_VAP_dateinTMPV2 | #a) started: NDC_No_VAPinAcqDX_VAP_dateinTMPV2-Not working. | ||
#*b)started: ND_sub_NoVAPinAcqDX_VAP_DateinTMPV2_sub_had_VAP_acqDX | #*b)started: ND_sub_NoVAPinAcqDX_VAP_DateinTMPV2_sub_had_VAP_acqDX | ||
# | #need to create: CLIinAcqDX_NoCLI_DateinTMPV2 | ||
# | #need to create: No_CLIinAcqDX_CLI_DateinTMPV2 | ||
== Set record as vetted == | == Set record as vetted == | ||