Centralized data.mdb Change Log: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
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.  
==2016-Mar-03==
not rolled yet Ttenbergen 10:51, 2016 March 3 (CST)
* ran following to fix blank ids in L_Tmp:
UPDATE L_TmpV2 SET L_TmpV2.D_Tmp_ID = [d_id] & "_ccusrvman" & Minute([obstime]) & Second([obstime])
WHERE (((L_TmpV2.D_Tmp_ID) Is Null) AND ((L_TmpV2.Project)="CCU_Service"));
* in table [[L_TmpV2]], made D_Tmp_ID the primary key Ttenbergen 10:51, 2016 March 3 (CST)


==2015-Nov-18==
==2015-Nov-18==

Revision as of 11:51, 2016 March 3

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

2016-Mar-03

not rolled yet Ttenbergen 10:51, 2016 March 3 (CST)

  • ran following to fix blank ids in L_Tmp:
UPDATE L_TmpV2 SET L_TmpV2.D_Tmp_ID = [d_id] & "_ccusrvman" & Minute([obstime]) & Second([obstime])
WHERE (((L_TmpV2.D_Tmp_ID) Is Null) AND ((L_TmpV2.Project)="CCU_Service"));
  • in table L_TmpV2, made D_Tmp_ID the primary key Ttenbergen 10:51, 2016 March 3 (CST)

2015-Nov-18

rolled Ttenbergen 17:33, 2015 November 18 (CST)

2015-Aug-17

done in place

2015-Jul-22

see also HSC Labs RE-import 2015-07

  • reverted the HSC lab imports from January 2015:
DELETE L_Labs_Flowsheet.D_Labs_Flowsheet_ID
FROM L_Labs_Flowsheet
WHERE (((InStr([D_Labs_Flowsheet_ID],"_i2014-12-30")>0)=True));
  • re-imported HSC labs with different parameters: import for all HSC ICU records who don't already have an entry for the labs we used to import:
INSERT INTO L_Labs_Flowsheet ( d_labs_flowsheet_id, D_ID, CBC, PT_PTT, Creatinine, MG, SGPT_ALT, Troponin, Sputum_CS, Blood_CS, Urine_CS, ABG )
SELECT Eds_Lab_formatter.d_labs_flowsheet_id, L_Log.D_ID, Eds_Lab_formatter.CBC, Eds_Lab_formatter.PT_PTT, Eds_Lab_formatter.Creatinine, Eds_Lab_formatter.MG, Eds_Lab_formatter.SGPT_ALT, Eds_Lab_formatter.Troponin, Eds_Lab_formatter.Sputum_CS, Eds_Lab_formatter.Blood_CS, Eds_Lab_formatter.Urine_CS, Eds_Lab_formatter.ABG
FROM (HSC_pts_without_importeds INNER JOIN L_Log ON HSC_pts_without_importeds.D_ID = L_Log.D_ID) INNER JOIN Eds_Lab_formatter ON L_Log.D_ID = Eds_Lab_formatter.D_ID;

2015-Jul-06

Cleaned up hospital codes that started with 0 to make consistent, ran 

UPDATE L_Log INNER JOIN s_HospitalCodes_updt ON L_Log.R_HospitalPrevious = s_HospitalCodes_updt.Code  
SET L_Log.[R_HospitalPrevious] = [CodeNr]
WHERE (((s_HospitalCodes_updt.Code)<>CStr([CodeNr])));

and 

UPDATE L_Log SET L_Log.R_HospitalPrevious = "" WHERE (((L_Log.R_HospitalPrevious)="0"));

2015-Jun-24

imported into master and updated version Ttenbergen 17:22, 2015 June 24 (CDT)

  • added table L Problem Ttenbergen 13:49, 2015 June 24 (CDT)

2015-May-26

Query: UPDATE L_TmpV2 SET L_TmpV2.date_var = DateValue([date_var]) WHERE (((Hour([date_var]))<>0));

  • Query run today in CFE. 1265 profiled fixed today. This query had to do with fix dat_var in TMPV2. Something about removing TIMES from this field.PTorres 15:56, 2015 May 26 (CDT)

2015-APR-01

rolled Ttenbergen 17:10, 2015 April 1 (CDT)

  • updated table L_Person
    • removed PHIN (long) - we can't be storing the PHIN in centralized, and it would result in update nightmare Ttenbergen 13:26, 2015 April 1 (CDT)

2015-Jan-29

  • updated table L_Person
    • added PHIN (long)
    • added field last_update (date)
    • updated indices
    • made Person_ID random from incremental
  • updated table L_Log
    • added field Person_ID (long)
    • added field Hospitalization_ID (long)
    • updated indices
  • updated table L_Hospitalization
    • update Hospitalization_ID to random from incremental
    • updated indices
  • ran encounter_processing to populate L_Person
  • imported remaining HSC Labs from the old lab export process

2015-Jan-19

running queries...

  • finishing move from Var2 -> Tmp BRR/XBR
    • ran query 1_Var2_BRR_1_to_Tmp to generate tmp entries; deleted query, but should be in pre-today backup
    • ran query 1_Var2_BRR_2_cleanout_Var2 to clear out Var2 in L_Log; deleted query, but should be in pre-today backup

2014-Dec-01

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

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
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Centralized_data.mdb_Change_Log&oldid=46934"