CCMDB data.mdb Change Log

From CCMDB Wiki
Revision as of 15:18, 25 October 2010 by Ttenbergen (talk | contribs) (New page: === V2 === not rolled out yet Ttenbergen * changed title to "CCMDB Data V2" Ttenbergen 10:16, 25 October 2010 (CDT) * deleted L_Green table [[User:T...)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

V2

not rolled out yet Ttenbergen

  • changed title to "CCMDB Data V2" Ttenbergen 10:16, 25 October 2010 (CDT)
  • deleted L_Green table Ttenbergen 10:16, 25 October 2010 (CDT)
  • un-defaulted DOB so it no longer enters Date() Ttenbergen 16:17, 25 October 2010 (CDT)
  • add a field for room number to L_Log Ttenbergen 16:17, 25 October 2010 (CDT)
  • added RecordStatus to L_Log; field to track whether the record is ready to send or rejected or similar; will replace FinalCheck; to be used with future functionality if we go to a new repository where a simple yes/no would not cover all possibilities Ttenbergen 16:17, 25 October 2010 (CDT)
  • sL_AaDO2 imported empty as L_AaDO2 Ttenbergen 16:17, 25 October 2010 (CDT)
  • sL_Record imported empty as L_Record Ttenbergen 16:17, 25 October 2010 (CDT)
  • added L_Errors table with
    • Date/time of error
    • patient ID (Hosp Loc Serial)
    • Field Identifier
    • error descriptor (text)
    • erroneous value
  • made a L_BPs to help with the BP chooser functionality