Requested CCMDB changes for the next version: Difference between revisions

← Older edit Newer edit →

@@ Line 25: / Line 25: @@
 === Changing the local data structure automatically ===
-Need a wayto make changes to data that is stored in \ccmdb_data\ccmdb.mdb, such as adding room numbers. By Access design, \ccmdb_program\ccmdb.mdb can not touch a linked table's structure. Will need to copy down new data structure and transfer existing data into that. This gives the opportunity to rename the data version into something less ambiguous.
+Need a way to make changes to data that is stored in \ccmdb_data\ccmdb.mdb, such as adding room numbers. By Access design, \ccmdb_program\ccmdb.mdb can not touch a linked table's structure. Will need to copy down new data structure and transfer existing data into that. This gives the opportunity to rename the data version into something less ambiguous.
 If it is renamed, I'll also need to change news and backup file.
-==== Data changes ====
+==== Specific changes to make to the data file ====
-When the trick to change the local data is figured out, do the following:
+* un-default DOB
-* why is the DOB defaulted to today?
+* add a field for room number to L_Log (update [[Patient List]] when done)
-* add a field for room number to list (update [[Patient List]] when done)
+* move over sL_AaDO2, call L_AaDO2 and add to automatic linking
-* store the ABG calculation table locally (sL_AaDO2 values)
+* make Final_check into dropdown, add s_FinalChecks, fix all spots that use FinalCheck (or make a function to check it)
-===== Final Check into drop-down =====
+** "CollectComplete"
-Make final check into a drop down to comply with requirement for stating the status within the process of data once we store data on U of M. [[User:Ttenbergen|Ttenbergen]] 13:25, 8 December 2009 (CST)
-* change can not be made via ccmdb.mdb since table structure for linked tables (as used by laptops) can not be manipulated externally.
-** option: Have ccmdb.mdb automatically generate a new .mdb based on the changes, and then change linking to that new .mdb
-* still required: change every spot that deals with finalcheck to deal with record_status instead. Easiest might be to make it a function finalcheck = (record_status = "CollectComplete")
 ==Changes Under Discussion==