Sending Patients: Difference between revisions

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]].

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 filenames in the output folder are automatically generated by Access following the [[sent files naming conventions]].

~~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>_<data collector initials>~~

~~for example: M_12_HSC_H4H_gh.csv~~

==Additional Info Required==

@@ 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]].
-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 filenames in the output folder are automatically generated by Access following the [[sent files naming conventions]].
-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>_<data collector initials>
-for example: M_12_HSC_H4H_gh.csv
 ==Additional Info Required==