Centralized data.mdb Change Log

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

2014-Dec-01

changes made right on server Ttenbergen 18:39, 2014 December 1 (CST)

• changed indexes for L_Como and L_Dxs to see if this will speed up sending Ttenbergen 18:39, 2014 December 1 (CST)
• kept a diff backup for this since we also did b5->5B change at same time

2014-0ct-22

changes made right on server Ttenbergen 17:10, 2014 October 22 (CDT)

• moved Table Postal Code Master here Ttenbergen 17:10, 2014 October 22 (CDT)
• confirmed that the "new" tables use random IDs Ttenbergen 17:10, 2014 October 22 (CDT)
• confirmed that r_sex is female male, had changed it to F M without thinking it through at some point Ttenbergen 17:10, 2014 October 22 (CDT)

2014-Oct-09

rolled out Ttenbergen 18:12, 2014 October 9 (CDT)

• Eliminated s_ tables; will be pulled from ccmdb.mdb by CFE as of 18:12, 2014 October 9 (CDT)
• added tables L_PCH, L_Person, L_Hospitalization, S_PCH, I will probably still need to tweak the structure, just wanted them there for now. Ttenbergen 18:12, 2014 October 9 (CDT)

2014-Aug-12

after checking in CFE 3 times and using SAS to confirm changes ran 1 use only queries on centralized.mdb on Regional server.Trish Ostryzniuk 21:09, 2014 August 12 (CDT)

• 1-use only ARF fix (0,-1,yes,no, entered) so only yes, no or blank
• 1-use only fix DX casing
• 1-use only APACHE 0 after SAP Admits Jan 1.17 onward
• 1-use only recordstatus casing: vetted to Vetted (capital)
• 1-use only update 3000 transfer dates to null

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