Centralized data.mdb Change Log: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
No edit summary
Line 1: Line 1:
This is the change log for [[Centralized_data.mdb]]. See [[Centralized data.mdb Requested Changes]] for its requested changes.  
This is the change log for [[Centralized_data.mdb]]. See [[Centralized data.mdb Requested Changes]] for its requested changes.  
== ver 2014-02-24 ==
* updated s_alldiagnosis entry for [[HAP]] to list as "Pneumonia-Hospital Acquired HAP"


== ver 2014-02-03 ==
== ver 2014-02-03 ==

Revision as of 22:22, 2014 February 24

This is the change log for Centralized_data.mdb. See Centralized data.mdb Requested Changes for its requested changes.

ver 2014-02-24

  • updated s_alldiagnosis entry for HAP to list as "Pneumonia-Hospital Acquired HAP"

ver 2014-02-03

  • added index to L_Log for r_sex and r_location to speed up linking
  • changed built-in drop-down for r_sex
  • S AllDiagnoses update to include all legacy codes and names where available...

ver 2014-01-10

  • added field L_Log.Data_Use_Option (text 10) to satisfy requirement from PHIA people that we have a place to store the concept of a patient opting out. Ttenbergen 11:12, 2014 January 10 (CST)

ver 2013-11-18

  • imported s-tables from current version of ccmdb.mdbTtenbergen 21:25, 2013 November 18 (CST)
  • added L_Aux table to store some ed-data which we don't have in ccmdb.mdb Ttenbergen 15:13, 2013 November 18 (CST)
  • fixed date and time formatting in L_LogTtenbergen 21:59, 2013 November 18 (CST)
  • fixed date format and default in L_Labs_Flowsheet Ttenbergen 21:59, 2013 November 18 (CST)
  • fixed date format in L_TmpV2 Ttenbergen 21:59, 2013 November 18 (CST)
  • for L_Dxs and L_Como:
    • changed lookup to show dxs rather than codes Ttenbergen 21:59, 2013 November 18 (CST)
    • updated lookup to show fullCodeName: [MainDiagnosis] & IIf([SubDiagnosis]>"" And [SubDiagnosis]<>[MainDiagnosis],"- " & [SubDiagnosis],"") Ttenbergen 21:59, 2013 November 18 (CST)

Ver 2013-10-03

  • added sentdttm field to accomodate new data from Log#ver_2013-10-03 - Ttenbergen 15:00, 2013 October 3 (CDT)

Ver 2013-09-25

  • added Serial field to accomodate import from Ed's
  • added field SentDtTm; won't get populated until after it is also implemented in ccmdb Ttenbergen 16:07, 2013 September 25 (CDT)

Ver 2013-08-12

Changes need to be timed with CCMDB_data.mdb_Change_Log#2013-08-12 and CCMDB.mdb_Change_Log_2013#ver_2013-08-12

  • change L_Como and others to proper format (d_id(txt 18) and d_*_id(txt 30)) and changed indices and keys
    • l_como
    • L_Labs_Flowsheet
    • L_Pharm_Flowsheet
    • L_TmpV2
      • added D_Tmp_ID;
  • added relationships
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Centralized_data.mdb_Change_Log&oldid=37059"