Output for TMSX and MedTMS: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older edit
mNo edit summary
 
(5 intermediate revisions by the same user not shown)
Line 1: Line 1:
When [[Sending Patients|sending patients]] from [[CCMDB.mdb]], among other things data is generated for import into [[TMSX]] via the [[PDA Uploader]].
 
{{LegacyContent
|explanation=No more TMSX
|successor=
|content= 
 
When sending patients from CCMDB.accdb, among other things data is generated for import into [[TMSX]] via the [[PDA Uploader]].


== File name and location ==
== File name and location ==
For Medicine:  
For Medicine:  
* [[Regional Server]]\Output\<hosp>_<ward>\'''M'''_<batch#>_<hosp>_<ward>_<initials>.csv
* Regional Server\Output\<hosp>_<ward>\'''M'''_<batch#>_<hosp>_<ward>_<initials>.csv
** e.g. [[Regional Server]]\Output\HSC_B3\M_33_HSC_B3_PS.csv
** e.g. Regional Server\Output\HSC_B3\M_33_HSC_B3_PS.csv


For Critical Care:  
For Critical Care:  
* [[Regional Server]]\Output\<hosp>_<ward>\'''C'''_<batch#>_<hosp>_<ward>_<initials>.csv
* Regional Server\Output\<hosp>_<ward>\'''C'''_<batch#>_<hosp>_<ward>_<initials>.csv
** e.g. [[Regional Server]]\Output\HSC_SICU\C_1_HSC_SICU_tt.csv
** e.g. Regional Server\Output\HSC_SICU\C_1_HSC_SICU_tt.csv
 


== Data Format ==
== Data Format ==
Line 15: Line 20:




== Test Data Convention ==
}}
see [[Sending_Patients#Test_Data]]
 


[[Category: Master Database Programs]]
[[Category: Legacy Data]]
[[Category: Data Processing ]]
[[Category: Questions Data Processing]]
[[Category: Data Repository]]

Latest revision as of 13:07, 2021 July 5

Legacy Content

This page contains Legacy Content.
  • Explanation: No more TMSX
  • Successor:

Click Expand to show legacy content.

When sending patients from CCMDB.accdb, among other things data is generated for import into TMSX via the PDA Uploader.

File name and location

For Medicine:

  • Regional Server\Output\<hosp>_<ward>\M_<batch#>_<hosp>_<ward>_<initials>.csv
    • e.g. Regional Server\Output\HSC_B3\M_33_HSC_B3_PS.csv

For Critical Care:

  • Regional Server\Output\<hosp>_<ward>\C_<batch#>_<hosp>_<ward>_<initials>.csv
    • e.g. Regional Server\Output\HSC_SICU\C_1_HSC_SICU_tt.csv

Data Format

The format of that data is defined by the queries EdsCC and EdsMed. This format is constrained by what the PDA Uploader expects. Even small changes such as the number of decimal digits can cause the uploader to fail. Great care must be taken with any changes.

Retrieved from "https://ccmdb.kuality.ca/index.php?title=Output_for_TMSX_and_MedTMS&oldid=150891"