Centralized data Vetting Process: Difference between revisions

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; if a patient shows up in one of the queries fix if possible; if question to collector is required, set recordstatus to "questioned"
# NDC_SamePHIN_Site_Diff_chart - fix
# NDC_SamePHIN_Site_Diff_chart - fix
# NDC_Chart_9_Digit - fix
# NDC_Chart_9_Digit - fix
Line 29: Line 29:
#a) started: NDC_No_VAPinAcqDX_VAP_dateinTMPV2
#a) started: NDC_No_VAPinAcqDX_VAP_dateinTMPV2
#*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: CLIinAcqDX_NoCLI_DateinTMPV2'''
#need to create: No_CLIinAcqDX_CLI_DateinTMPV2
#'''need to create: No_CLIinAcqDX_CLI_DateinTMPV2'''


== Set record as vetted ==
== Set record as vetted ==