CCMDB Wiki

Centralized data Vetting Process: Difference between revisions

← Older editNewer edit →
m →clean ups: eds import clean-up is done
m u
Line 14: Line 14:
**Print
**Print


===Check to see that everyone has sent===
==Check to see that everyone has sent==
*RegionalWRHA (wreath icon)
*RegionalWRHA (wreath icon)
*Output (folder)
*Output (folder)
Line 22: Line 22:
**when viewing these in the xls file, the header is included as Line 1, so the actual # of files sent will be one less, e.g. if it says 11, then there were 10 complete files sent
**when viewing these in the xls file, the header is included as Line 1, so the actual # of files sent will be one less, e.g. if it says 11, then there were 10 complete files sent


===To check the ''incomplete'' files===
==To check the ''incomplete'' files==
*make a copy of ''[[PDA Pending.mdb]]''
*make a copy of ''[[PDA Pending.mdb]]''
***we have stopped sending to pda pending, what if anything is being used now? Ttenbergen 20:41, 2014 September 29 (CDT) {{discussion}}
***we have stopped sending to pda pending, what if anything is being used now? Ttenbergen 20:41, 2014 September 29 (CDT) {{discussion}}
Line 39: Line 39:
*close PDA_Pending.mdb
*close PDA_Pending.mdb


===Then ===
*check L_Log
*check L_PHI
*check L_LogPhi
*write these numbers on the tracker sheet
** are we really checking all three? If we checked just L_Log_PHI and it's correct, could the others possibly be wrong? Ttenbergen 20:44, 2014 September 29 (CDT) {{discussion}}


These files are found under the heading [[#Open Centralized Data Front End]] below
==The Basic Steps==
 
[[User:Srusnak|Srusnak]] 13:50, 2014 July 31 (CDT)
 
 
===The Basic Steps===
# wait until the end of [[Designated sending times]]
# wait until the end of [[Designated sending times]]
# [["Pull" Centralized data.mdb]]
# [["Pull" Centralized data.mdb]]
# open [[CFE]]
# [[#prep CFE for use]]
# [[#See who Sent]]
# [[#See who Sent]]
# Run and correct [[NDC Queries]]
# Run and correct [[NDC Queries]]
Line 61: Line 50:




===See who Sent===
===prep CFE for use===
*Double click to open ''Centralized_data_front_end.mdb''
*click Reconnect
==== cross-check tables ====
*Open Patient List
*on the Left side,
*scroll All Access Objects
*Tables
**L_Log - write down the number
**L_PHI - write down the number
*click ''back to top''
**Queries
**L_Log_PHI - write down the number
'''**ALL 3 must be the same**'''


Pull --  ''[[Pull_down_centralized_data.vbs]]''
=== cross-check tracker sheet ===
Double check these numbers against the tracker sheet, which compares the old to the new combined centralized numbers


Queries
The ''complete'' numbers come from the xls csv file


P_Count_Of_Sent (double click)
The ''incomplete'' numbers come from the PDA_pending file


Home
L_Log,  L_PHI, and L_Log_PHI are part of the new combined centralized numbers.  These get checked after we ''Pull''


View
[[User:Srusnak|Srusnak]] 13:49, 2014 July 30 (CDT)


Pivot Table


View
===See who Sent===
 
*[["Pull" Centralized data.mdb]]
Filter by 'Date Sent'
* Queries
* P_Count_Of_Sent (double click)
*Home
*View
*Pivot Table
*View
*Filter by 'Date Sent'
*Right Click
*Right Click
*Field List
*Field List
*drag 'sent Dt Time'
*drag 'sent Dt Time'
*close dialog box
*close dialog box
 
*Home
Home
*Design View
 
*Change to 'Wed' date
Design View
*Home  
 
*View
Change to 'Wed' date
*Pivot Table View
 
**shows the number of ''incomplete'' and ''sent'' in 2 separate tables
Home  
**use + (plus symbol) to expand
 
***when you expand, it shows the serial number
View
**use - (minus symbol) to collapse
 
*Click inside the column and scroll down to do a quick check of the location
Pivot Table View
* what are we checking for? what if something is wrong? {{discussion}}
*shows the number of ''incomplete'' and ''sent'' in 2 separate tables
* When done
*use + (plus symbol) to expand
**click '''x'''(in top right) and '''DO NOT''' 'save'
**when you expand, it shows the serial number
**It will prompt you 'do you want to save'
*use - (minus symbol) to collapse
**say NO
 
**'''When finished viewing, just close, DO NOT 'save''''
Click inside the column and scroll down to do a quick check of the location
 
When done
 
click '''x'''(in top right) and '''DO NOT''' 'save'
 
It will prompt you 'do you want to save'
 
say NO
 
'''When finished viewing, just close, DO NOT 'save''''
 
 
 
 
===OPEN CENTRALIZED DATA FRONT END===
 
Double click to open ''Centralized_data_front_end.mdb''
 
Reconnect
 
Open Patient List
 
on the Left side,
 
scroll All Access Objects
 
Tables
 
L_Log
*write down the number
 
L_PHI
*write down the number
 
click ''back to top''
 
Queries
 
L_Log_PHI
*write down the number
 
'''**ALL 3 must be the same**'''
 
Double check these numbers against the tracker sheet, which compares the old to the new combined centralized numbers
 
The ''complete'' numbers come from the xls csv file
 
The ''incomplete'' numbers come from the PDA_pending file
 
L_Log,  L_PHI, and L_Log_PHI are part of the new combined centralized numbers.  These get checked after we ''Pull''
 
[[User:Srusnak|Srusnak]] 13:49, 2014 July 30 (CDT)


=== Option to view-only data ===
=== Option to view-only data ===
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Centralized_data_Vetting_Process"