Centralized data.accdb Change Log: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) m Ttenbergen moved page Centralized data.mdb Change Log to Centralized data.accdb Change Log without leaving a redirect |
||
| (36 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
__NOTOC__ <!-- This hides the table of contents so collectors can immediately see the most recent change without scrolling. --> | __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. | 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 == | == 2018-04-03 == | ||
| Line 55: | 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 | * 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 109: | Line 145: | ||
** [[Service/Location field]] | ** [[Service/Location field]] | ||
** [[Dispo field]] | ** [[Dispo field]] | ||
** | ** ''Accept_DtTm field'' | ||
** | ** ''Arrive_DtTm field'' | ||
** [[Dispo_DtTm field]] | ** [[Dispo_DtTm field]] | ||
** [[Transfer_Ready_DtTm field]] | ** [[Transfer_Ready_DtTm field]] | ||
| Line 192: | 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 [[ | * 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 198: | 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 | * Eliminated s_ tables; will be pulled from [[CCMDB.accdb]] by [[CFE]] as of 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) | * 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) | ||
| Line 221: | Line 257: | ||
== ver 2013-11-18 == | == ver 2013-11-18 == | ||
* imported [[s-tables]] from current version of [[ | * 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 | * 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 248: | Line 284: | ||
[[Category:Development Documentation]] | [[Category:Development Documentation]] | ||
[[ | [[Category:2013 data upgrades]] | ||
[[Category:Centralized_data.accdb]] | |||