Sending Patients: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
mNo edit summary
Line 1: Line 1:
'''Sending Patients''' is the process of using the [[CCMDB.mdb]] to export the data collected on the [[PDA]] to the [[sent file format|format]] that can be imported into [[TMSX]]. When you finalize your data and press the "send" button Access automatically exports it to the folder corresponding to that collection's location in the [[Output]] directory on the [[Regional Server]].   
'''Sending Patients''' is the process of using the [[CCMDB.mdb]] to export the data collected on the [[PDA]] to the [[sent file format|format]] that can be imported into [[TMSX]]. When you finalize your data and press the "send" button Access automatically exports it to the folder corresponding to that collection's location in the [[Output]] directory on the [[Regional Server]].   
If you wish to see your data after you send it, use the Regional Server shortcut on your desktop, navigate to the "Output" folder, then to the folder corresponding to your location.  
If you wish to see your data after you send it, use the Regional Server shortcut on your desktop, navigate to the "Output" folder, then to the folder corresponding to your location.  


The file names are:  
The file names are:  
* M_12_HSC_H4H_gh.csv - the actual data file
* <identifier>.csv - the actual data file
* M_12_HSC_H4H_gh_Pending.xls - pending patient lists for administration and LOS calculations
* <identifier>_Pending.xls - pending patient lists for administration and LOS calculations
* M_12_HSC_H4H_gh_PDA_STATUS.csv - pending patient lists for administration and LOS calculations
* <identifier>_PDA_STATUS.csv - pending patient lists for administration and LOS calculations
Where <identifier> stands for
<M for medicine or C for icu>_<batch #>_<3-letter hospital>_<2-3-letter ward>_<data collector initials>
for example: M_12_HSC_H4H_gh.csv


==Additional Info Required==
==Additional Info Required==

Revision as of 11:07, 2008 March 28

Sending Patients is the process of using the CCMDB.mdb to export the data collected on the PDA to the format that can be imported into TMSX. When you finalize your data and press the "send" button Access automatically exports it to the folder corresponding to that collection's location in the Output directory on the Regional Server. If you wish to see your data after you send it, use the Regional Server shortcut on your desktop, navigate to the "Output" folder, then to the folder corresponding to your location.

The file names are:

  • <identifier>.csv - the actual data file
  • <identifier>_Pending.xls - pending patient lists for administration and LOS calculations
  • <identifier>_PDA_STATUS.csv - pending patient lists for administration and LOS calculations

Where <identifier> stands for <M for medicine or C for icu>_<batch #>_<3-letter hospital>_<2-3-letter ward>_ for example: M_12_HSC_H4H_gh.csv

Additional Info Required

  • how to send
  • what happens when you send
  • what do to around sending time

Template:Stub