CCMDB.accdb: Difference between revisions
TOstryzniuk (talk | contribs) mNo edit summary |
TOstryzniuk (talk | contribs) mNo edit summary |
||
| Line 1: | Line 1: | ||
The '''CCMDB.mdb''' stands for '''Critical Care Medicine Database'''. | The '''CCMDB.mdb''' stands for '''Critical Care Medicine Database'''. This is an '''ACCESS''' database that the [[PDA]]s synchronize into. It screens the data for internal consistency and ranges, and then exports it in a format that can be imported into [[TMSX]] or [[MedTMS]]. | ||
Each [[PDA]] has a combo of two ACCESS databases associated to it: a '''ccmdb.mdb''' file which is identical for all until synced into, and a [[settings.mdb]] which contains location specific information such as the path to the [[Regional Server]], and the hospital and ward names. Any data in the ccmdb.mdb is considered transient, the file can be replaced with an empty new version at any time. Rolling out new versions is done by batch and a file that is currently open will not be overwritten. | Each [[PDA]] has a combo of two ACCESS databases associated to it: a '''ccmdb.mdb''' file which is identical for all until synced into, and a [[settings.mdb]] which contains location specific information such as the path to the [[Regional Server]], and the hospital and ward names. Any data in the ccmdb.mdb is considered transient, the file can be replaced with an empty new version at any time. Rolling out new versions is done by batch and a file that is currently open will not be overwritten. | ||
| Line 121: | Line 121: | ||
{{discussion}} | {{discussion}} | ||
*After closing access I click on output, then your unit open up the info and check. eg the number of completes, admits, comorbs, etc. I then delete my completes on my PDA--[[User:PStein|PStein]] 08:36, 18 March 2009 (CDT) | *After closing access I click on output, then your unit open up the info and check. eg the number of completes, admits, comorbs, etc. I then delete my completes on my PDA--[[User:PStein|PStein]] 08:36, 18 March 2009 (CDT) | ||
~~discussion~~ | |||
*After sending you check your output by opening twister and clicking on output, then find your site and click on the batch number csv you just sent. Your sent files should appear, scroll across and make sure the areas that have to have information in them ie. admit date and time etc. are filled in. If everything looks OK close out and you can deiete your completed files. Lois -- [[User:LBilesky|LBilesky]] 14:47, 17 March 2009 (CDT) | |||
== Discussion == | == Discussion == | ||
| Line 128: | Line 130: | ||
**Confused, why gather this information when we are expecting lap-tops soon and the process will change?--[[User:JHutton|JHutton]] 09:53, 16 March 2009 (CDT) | **Confused, why gather this information when we are expecting lap-tops soon and the process will change?--[[User:JHutton|JHutton]] 09:53, 16 March 2009 (CDT) | ||
***Thank you for your contribution. All sites being able to use a lap-top is some time away. At this time we will only use laptops at one site for beta testing. Never-the-less, the lap top will employ the use of '''MS ACCESS''' for collection and entry, therefore the above steps are will still apply. --[[User:TOstryzniuk|TOstryzniuk]] 13:26, 16 March 2009 (CDT) | ***Thank you for your contribution. All sites being able to use a lap-top is some time away. At this time we will only use laptops at one site for beta testing. Never-the-less, the lap top will employ the use of '''MS ACCESS''' for collection and entry, therefore the above steps are will still apply. --[[User:TOstryzniuk|TOstryzniuk]] 13:26, 16 March 2009 (CDT) | ||
{{stub}} | {{stub}} | ||
[[Category:IT Instructions]] | [[Category:IT Instructions]] | ||
[[Category:Question for Data Collectors]] | [[Category:Question for Data Collectors]] | ||
[[Category: Questions_IT]] | [[Category: Questions_IT]] | ||