CCMDB Wiki

Centralized data.accdb Change Log: Difference between revisions

← Older edit
No edit summary
m Ttenbergen moved page Centralized data.mdb Change Log to Centralized data.accdb Change Log without leaving a redirect
 
(57 intermediate revisions by 3 users not shown)
Line 1: Line 1:
This is the change log for [[Centralized_data.mdb]]. See [[Centralized data.mdb Requested Changes]] for its requested changes.  
__NOTOC__ <!-- This hides the table of contents so collectors can immediately see the most recent change without scrolling. -->
This is the change log for [[Centralized_data.accdb]]. See [[Centralized_data.accdb Requested Changes]] for its requested changes.  
 
==2023-01-17==
copied to regional server live location
* imported whole database into a new repository because there was corruption.
 
==2022-08-31==
Pagasa will put back into circulation as part of usual push/pulls [[User:Ttenbergen|Ttenbergen]] 11:49, 2022 August 31 (CDT)
* removed [[L Dxs table]] and [[L Como table]] [[User:Ttenbergen|Ttenbergen]] 11:49, 2022 August 31 (CDT)
 
==2022-08-15==
copied to server [[User:Ttenbergen|Ttenbergen]] 17:41, 2022 August 15 (CDT)
* reverted to file from 2022-08-10 and re-did the changes since the last change was done on an outdated version of centralized_data
* re-applied the data updates to [[Postal Code Master table]]
 
==2022-08-10==
copied to server [[User:Ttenbergen|Ttenbergen]] 14:34, 2022 August 10 (CDT)
* update [[L_Log table]]:
** added [[ClientGUID field]] and [[ClientVisitGUID field]]
** removed ''Room_nr'', ''Pharm Flow Complete'', ''ApLab_Complete'', ''FinalCheck field''
 
==2021-11-17==
copied to server [[User:Ttenbergen|Ttenbergen]] 00:17, 2021 November 18 (CST)
* moved [[L_Problems_D_ID table]] to this file from [[CFE]] so its contents will be preserved when [[CFE]] is updated. [[User:Ttenbergen|Ttenbergen]] 00:04, 2021 November 18 (CST)
 
==2019-09-26==
* Increase the field size of L_CCI_Component.CCI_2_Code from 7 to 10
[[User:PTorres|PTorres]] 17:41, 2019 September 26 (CDT)
 
== 2018-12-02 ==
* changed the subdatasheet parameter to "None", as this [http://www.fmsinc.com/microsoftaccess/performance/subdatasheet/index.htm allegedly improves performance]
 
== 2018-04-24 ==
* removed old table L_CCI (see instead * [[L_CCI_Component table]] and [[L_CCI_Picklist table]])
* removed old table L_ICD10_old (see instead [[L_ICD10 table]])
* removed old table L_Labs_Flowsheet_DSM, data is kept in [[DSM Labs data.accdb]] instead
* confirmed indexes and relationships for new tables
 
== 2018-04-03 ==
Added
* [[L_CCI_Component table]]
* [[L_CCI_Picklist table]]
* [[L_ICD10 table]] - the new version; old one renamed to '''L_ICD10_Old'''; data moved over
Then:
*    changed Patient_ID to D_ID
*    added relational integrity constraints
 
== 2018-Jan-04 ==
copied out to master Ttenbergen 17:29, 2018 January 4 (CST)
* added L_CCI table and [[L_ICD10 table]]
** imported from CCMDB_data.mdb
** changed Patient_ID to D_ID
** added relational integrity constraints
 
== 2017-Jan-30 ==
Rolled out [[User:Haubel|Haubel]] 16:30, 2017 January 30 (CST)
* Field size for Item field from L_TmpV2 table changed from 40 to 255.
 
== 2017-Jan-17 ==
Rolled out Ttenbergen 19:01, 2017 January 17 (CST)
* removed BirthMY field Ttenbergen 17:27, 2017 January 17 (CST)
* imported pseudo-[[Visit Admit DtTm field]] data provided by Julie Ttenbergen 18:58, 2017 January 17 (CST)


== 2016-Nov-24 (Rolled back) ==
== 2016-Nov-24 (Rolled back) ==
Rolled back [[User:Haubel|Haubel]] 17:07, 2016 November 25 (CST)
Rolled back [[User:Haubel|Haubel]] 17:07, 2016 November 25 (CST)
"R_DisDate", "R_DisTime", "Var1", "Var2", "Var3", "Var4", "Var5", "Var6" removed from L_Log table.
Fields "R_Location", "R_AdmitFrom", "R_DischargedTo", "R_HospitalPrevious", "R_SurviveExpire", "R_AdmDate", "R_AdmTime", "R_TRDate", "R_TRTime", "R_DisDate", "R_DisTime", "Var1", "Var2", "Var3", "Var4", "Var5", "Var6" removed from L_Log table.


== 2016-Nov-25 ==
== 2016-Nov-25 ==
Line 29: Line 91:
== 2016-Sep-14 ==
== 2016-Sep-14 ==
rolled out Ttenbergen 11:06, 2016 September 14 (CDT)
rolled out Ttenbergen 11:06, 2016 September 14 (CDT)
* added [[Accept DtTm missing field]] Ttenbergen 11:06, 2016 September 14 (CDT)
* added ''Accept DtTm missing field'' Ttenbergen 11:06, 2016 September 14 (CDT)
* changed any instance of "STB Cardiac Sciences" to [[STB CICU]] in  
* changed any instance of "STB Cardiac Sciences" to [[STB CICU]] in  
** [[Pre-admit Inpatient Institution field]]
** [[Pre-admit Inpatient Institution field]]
Line 76: Line 138:
* Added fields to [[L_Log]] in prep for starting [[2016 Time and Place changes]]
* Added fields to [[L_Log]] in prep for starting [[2016 Time and Place changes]]
** [[Postal Code field]]
** [[Postal Code field]]
** [[Last Opened field | LastOpened_DtTm]]
** [[LastOpened_DtTm field]]
** [[Pre acute living situation field]]
** [[Pre acute living situation field]]
** [[Pre-admit Inpatient Institution field]]
** [[Pre-admit Inpatient Institution field]]
Line 83: Line 145:
** [[Service/Location field]]
** [[Service/Location field]]
** [[Dispo field]]
** [[Dispo field]]
** [[Accept_DtTm field]]
** ''Accept_DtTm field''
** [[Arrive_DtTm field]]
** ''Arrive_DtTm field''
** [[Dispo_DtTm field]]
** [[Dispo_DtTm field]]
** [[Transfer_Ready_DtTm field]]
** [[Transfer_Ready_DtTm field]]
Line 97: Line 159:
==2015-Nov-18==
==2015-Nov-18==
rolled Ttenbergen 17:33, 2015 November 18 (CST)
rolled Ttenbergen 17:33, 2015 November 18 (CST)
* added table [[L Labs Flowsheet DSM table]] Ttenbergen 17:21, 2015 November 18 (CST)
* added table L Labs Flowsheet DSM table Ttenbergen 17:21, 2015 November 18 (CST)


==2015-Aug-17==
==2015-Aug-17==
Line 133: Line 195:
== 2015-APR-01 ==
== 2015-APR-01 ==
rolled Ttenbergen 17:10, 2015 April 1 (CDT)
rolled Ttenbergen 17:10, 2015 April 1 (CDT)
* updated table ''[[L_Person]]''
* updated ''[[L_Person table]]''
** 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)
** 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 ==
== 2015-Jan-29 ==
* updated table ''[[L_Person]]''
* updated table ''[[L_Person table]]''
** added PHIN (long)
** added PHIN (long)
** added field last_update (date)
** added field last_update (date)
** updated indices
** updated indices
** made Person_ID random from incremental
** made [[Person_ID]] random from incremental
* updated table ''[[L_Log]]''
* updated table ''[[L_Log]]''
** added field Person_ID (long)  
** added field [[Person_ID]] (long)  
** added field Hospitalization_ID (long)
** added field Hospitalization_ID (long)
** updated indices  
** updated indices  
Line 150: Line 212:
** updated indices
** updated indices


* ran encounter_processing to populate [[L_Person]]
* ran encounter_processing to populate [[L_Person table]]
* imported remaining HSC Labs from the old lab export process
* imported remaining HSC Labs from the old lab export process


Line 166: Line 228:
== 2014-0ct-22 ==
== 2014-0ct-22 ==
changes made right on server Ttenbergen 17:10, 2014 October 22 (CDT)
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)
* moved [[Postal_Code_Master table]] 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 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)
* 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)
Line 172: Line 234:
==2014-Oct-09==
==2014-Oct-09==
rolled out Ttenbergen 18:12, 2014 October 9 (CDT)
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)
* Eliminated s_ tables; will be pulled from [[CCMDB.accdb]] 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)
* added tables [[L_PCH table]], [[L_Person table]], [[L_Hospitalization table]], [[S_PCH table]], 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==
==2014-Aug-12==
Line 184: Line 246:


== ver 2014-02-24 ==
== ver 2014-02-24 ==
* updated s_alldiagnosis entry for [[HAP]] to list as "Pneumonia-Hospital Acquired HAP"
* updated [[s_AllDiagnoses table]] entry for [[HAP]] to list as "Pneumonia-Hospital Acquired HAP"


== ver 2014-02-03 ==
== ver 2014-02-03 ==
* added index to L_Log for [[r_sex]] and r_location to speed up linking
* added index to L_Log for [[r_sex]] and r_location to speed up linking
* changed built-in drop-down for [[r_sex]]
* changed built-in drop-down for [[r_sex]]
* [[S AllDiagnoses]] update to include all legacy codes and names where available...
* [[s_AllDiagnoses table]] update to include all legacy codes and names where available...


== ver 2014-01-10 ==
== ver 2014-01-10 ==
Line 195: Line 257:


== ver 2013-11-18 ==
== ver 2013-11-18 ==
* imported [[s-tables]] from current version of [[ccmdb.mdb]]Ttenbergen 21:25, 2013 November 18 (CST)
* imported [[s-tables]] from current version of [[CCMDB.accdb]] Ttenbergen 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)
* added L_Aux table to store some ed-data which we don't have in [[CCMDB.accdb]] Ttenbergen 15:13, 2013 November 18 (CST)
* fixed date and time formatting in L_LogTtenbergen 21:59, 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 and default in L_Labs_Flowsheet Ttenbergen 21:59, 2013 November 18 (CST)
Line 222: Line 284:


[[Category:Development Documentation]]
[[Category:Development Documentation]]
[[category:2013 data upgrades]]
[[Category:2013 data upgrades]]
[[Category:Centralized_data.accdb]]
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Centralized_data.accdb_Change_Log"