Output for TMSX and MedTMS

From CCMDB Wiki
Revision as of 10:43, 2019 September 22 by Ttenbergen (talk | contribs) (Text replacement - "CCMDB.mdb" to "CCMDB.accdb")
Jump to navigation Jump to search 
Legacy info only

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=139482"