CCMDB Wiki

Centralized data front end.accdb Change Log 2022: Difference between revisions

← Older edit
m Text replacement - "Created_Variables_Common_maker query" to "Created_Variables_Common_maker query (see Created_Variables_Common_maker_2021 query)"
 
(113 intermediate revisions by the same user not shown)
Line 4: Line 4:


== Log ==
== Log ==
=== 2023 ===
See [[Centralized data front end.accdb Change Log 2023]]
=== 2022-11-29 ===
copied to server [[User:Ttenbergen|Ttenbergen]] 11:35, 2022 November 29 (CST)
* updated [[Created_APACHE_Chronic query]] (which is used by [[Created Variables CC maker 2021 query]]) to not look at CCIs any longer, ie to not reference query L_CCI_Component_APACHE_Comorbids or query L_CCI_Picklist_APACHE_Comorbids any longer
* updated [[created_AdmitDtTm query]] so it won't crash when there are nulls in all three dates
=== 2022-11-15 ===
copied to server (with same version, forgot to change it) [[User:Ttenbergen|Ttenbergen]] 12:15, 2022 November 17 (CST)
* updated [[S ICD10 APACHE Comorbids query]] to properly exclude the ends of pattern ranges, they were included before.
=== 2022-11-15 ===
copied to server [[User:Ttenbergen|Ttenbergen]] 08:52, 2022 November 15 (CST)
* changed [[Created TransferReady query]] to exclude null dates
* updated [[Patient Viewer]] to include [[Dispo DtTm]] on top row
* re-did Sub populate_created_transferDelay() entirely to fix contents of [[Created transferDelay table]]
* [[Change for Apache Chronic to ICD10 from separate variable]]: updated [[Created_Variables_CC_maker_2021 query]] - it was using [[created_APACHE_Chronic query]] for [hasChronic] and [chronic_pts], but not for [ApTotal_Chronic] and [ApTotal]. It now uses the combined definition from created_APACHE_Chronic for all four fields.
=== 2022-09-29 ===
copied to server
* Reverted update to [[Created_Variables_CC_2021 table]] / [[Created Variables CC maker 2021 query]] to use the profile-based transfer delay calculation again rather than the [[Level of care]] based calculation, after finding exceptions to that model for CC. [[User:Ttenbergen|Ttenbergen]] 16:36, 2022 September 28 (CDT)
=== 2022-08-31 ===
copied to server[[User:Ttenbergen|Ttenbergen]] 13:40, 2022 September 22 (CDT)
* deleted ''Created_transferDelay_int'' query because it's done different now to not require the combiner
* added [[created_BoardingLoc_plus_historical query]] to generate the [[Level of care hierarchy|level of care]]
* updated [[Sub populate created transferDelay()]] to use  [[created_BoardingLoc_plus_historical query]]
* deleted mystery tables after confirming with Julie: 1_MOST_bands, 1_MOST_gt3, 1_MOST_lept1
* updated [[created_FirstTransferReady query]] to use [[created_TransferReady query]]
* updated [[Created_TransferReady_cc query]] to use [[created_FirstTransferReady query]]
* updated [[Created Variables CC 2021 table]] to use the transfer delay from [[Created transferDelay table]] instead of calculating its own
* updated [[Query created PatientFollow]] to use [[Created AdmitDtTm query]] rather than use its own calculation
=== 2022-08-23 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 16:39, 2022 August 29 (CDT)
* tweak to [[PL_SameCHART_Site_Diff_PHIN]] to remove some unneeded columns
* tweak to code that runs the queries for the patient viewer form, it was using an old name for the admit dttm column
* tweak to [[Created TransferReady cc query]] which had somehow lost its D_ID column
=== 2022-08-16 ===
copied to server [[User:Ttenbergen|Ttenbergen]] 11:33, 2022 August 16 (CDT)
* updated query ''L_Log_PHI'' to exclude the defunct fields. [[User:Ttenbergen|Ttenbergen]] 09:40, 2022 August 16 (CDT)
* updated query ''Patient_List'' to exclude fields that aren't needed [[User:Ttenbergen|Ttenbergen]] 10:44, 2022 August 16 (CDT)
* simplified how Sub cbo_QuerySelector_Click() works
* adjusted column widths on form ''PatientList''
=== 2022-08-15 ===
copied to server [[User:Ttenbergen|Ttenbergen]] 22:49, 2022 August 15 (CDT)
* updated query Patientlist to remove defunct FinalCheck field [[User:Ttenbergen|Ttenbergen]] 22:49, 2022 August 15 (CDT)
=== 2022-08-03 ===
copied to server [[User:Ttenbergen|Ttenbergen]] 16:22, 2022 August 15 (CDT)
* updated [[created_TransferReady_cc query]] to remove a subquery that wasn't actually used.
* updated Function confirm_files_and_links() to connect [[L Dxs table]] and [[L Como table]] to [[Legacy TMS Data.mdb]] instead
=== 2022-07-29 ===
copied to server [[User:Ttenbergen|Ttenbergen]] 10:24, 2022 July 28 (CDT)
* changed "I27.81" to "I27.8*" in [[S ICD10 APACHE Como patterns table]]
=== 2022-07-26 ===
copied to server [[User:Ttenbergen|Ttenbergen]] 14:05, 2022 July 26 (CDT)
* updated [[Link suspect negative transit time query]] to only show if diff is > 30min
* updated [[Created Variables CC maker 2021 query]] because it was showing duplicates for records where more than one [[Transfer Ready DtTm tmp entry]] had a date
=== 2022-07-06 ===
copied to server [[User:Ttenbergen|Ttenbergen]] 10:35, 2022 July 6 (CDT)
* fix to [[Created APACHE Chronic query]] (used testing name for a variable still) and [[Created_Variables_CC_maker_2021 query]] (had duplicate RecordStatus output)
=== 2022-06-30 ===
copied to server [[User:Ttenbergen|Ttenbergen]] 10:49, 2022 June 30 (CDT)
* updated [[Created_APACHE_Chronic query]] to start using ICD10 derived Chronic Health scoring for values >= 2019-01-01
* confirmed that [[Created_Variables_CC_maker_2021 query]] already lists the value from [[Created_APACHE_Chronic query]] [[User:Ttenbergen|Ttenbergen]] 10:44, 2022 June 30 (CDT)
=== 2022-06-29 ===
copied to server [[User:Ttenbergen|Ttenbergen]] 15:30, 2022 June 29 (CDT)
* updated [[Transfer Delay (Critical Care)]]/[[Created _Variables_CC maker_2021 query]] to use [[Created_TransferReady query]], and to start populating field [[Transfer_Delay_CC]].
* updated [[Transfer Delay (Medicine)]]
===2022-06-28 ===
copied to server [[User:Ttenbergen|Ttenbergen]] 13:25, 2022 June 28 (CDT)
* removed old code in ''2016-07_dispo_convert''
* updated [[Created_Variables_Common_2021 table]] / [[Created_Variables_Common_maker_2021 query]] with new coding for [[ER Delay]]
===2022-06-16 ===
copied to server [[User:Ttenbergen|Ttenbergen]] 14:44, 2022 June 16 (CDT)
* added several recordset .close statements to see if this will fix [["cannot open any more tables" in Access]]
===2022-06-15 ===
copied to server
* re-do of last version, something got corrupted that made it impossible to change item or project in tmp tab [[User:Ttenbergen|Ttenbergen]] 12:26, 2022 June 15 (CDT)
===2022-06-14 ===
copied to server [[User:Ttenbergen|Ttenbergen]] 13:26, 2022 June 14 (CDT)
* changed Form_view to no longer filter the item list to only those relevant to the project; the functionality was broken to show no listings at all and not clear how to fix. [[User:Ttenbergen|Ttenbergen]] 13:18, 2022 June 14 (CDT)
===2022-06-01 ===
copied to server [[User:Ttenbergen|Ttenbergen]] 16:47, 2022 June 9 (CDT)
* changed Form_view to
** open to tmp table, since that is most used now
** include Dispo DtTm and Dispo in the top area, and remove ancient survive/expire field
* update to [[Created_Variables_Common_2021 table]]: updated definition for ER Delay and removed RecordStatus discontinued from the query
===2022-05-31===
copied to server [[User:Ttenbergen|Ttenbergen]] 15:29, 2022 May 31 (CDT)
* updated [[CT Outstandings Dispo query]] and [[CT Outstandings query]] to exclude [[RecordStatus]] "discontinued"
===2022-05-26-1===
copied to server [[User:Ttenbergen|Ttenbergen]] 16:50, 2022 May 26 (CDT)
* Fixed [[s_ICD10_APACHE_Dx query]] which was breaking [[L_ICD10_APACHE_Dx query]]
* work in progress to restrict false positives in [[Link suspect not same visitAdmitDtTm query]]; working on comparing it and link_suspect_not_same_visitAdmitDtTm_foo
===2022-05-26===
copied to server [[User:Ttenbergen|Ttenbergen]] 15:43, 2022 May 26 (CDT)
* Fixed sort order on Patient List, it still referred to the old "arr" in places, changed all to "adm" [[User:Ttenbergen|Ttenbergen]] 14:33, 2022 May 26 (CDT)
* updated the form behind the [[Cat button]] to sort by adm date by default. [[User:Ttenbergen|Ttenbergen]] 15:42, 2022 May 26 (CDT)
===2022-05-25===
copied to server [[User:Ttenbergen|Ttenbergen]] 13:54, 2022 May 26 (CDT)
* changed [[Link_suspect_mismatch_from_ours_incomplete query]] to fix false positives, see its log for details. [[User:Ttenbergen|Ttenbergen]] 13:51, 2022 May 26 (CDT)
===2022-05-19===
copied to server [[User:Ttenbergen|Ttenbergen]] 17:34, 2022 May 25 (CDT)
* fixed created_variables_common_deleter, it was deleting CC instead
* created_variables_common_maker wasn't working right for records with [[RecordStatus]] "discontinued" that don't have values for certain data. Excluded these.
* changed created_variables_common_maker and created_variables_CC_maker to use the new created_admit query instead of their old accept/arrive dates, since many records already don't have them now. Also changed these to exclude records with [[RecordStatus]] "discontinued".
===2022-05-04===
copied to server [[User:Ttenbergen|Ttenbergen]] 16:55, 2022 May 5 (CDT)
* updated Function Ap_Chronic and made a test function for it
* updated [[Created APACHE Chronic query]] to be explicit about the output, it was filling in the output value even for lines where it should have been blank.
===2022-04-27===
copied to server [[User:Ttenbergen|Ttenbergen]] 10:24, 2022 May 4 (CDT)
* removed "Form Covid rept" wiki page, and all associated parts in CFE
* updated [[Created_Variables_Common_maker_2021 query]] (documented in [[Created Variables Common 2021 table]]) to properly calculate LOS and to confirm it is now using the new [[Admit DtTm]] where appropriate, and to remove [[Transfer Delay]] since there can be more than one now. [[User:Ttenbergen|Ttenbergen]] 16:59, 2022 April 27 (CDT)
* updated [[Function LOS()]]
* updated Created_Variables_Common_maker query (see [[Created_Variables_Common_maker_2021 query]]) to stop using Accept and Arrive DtTm as it was breaking the query. We still need to move to the new queries to make sure we get reasonable results.
* updated [[Link_suspect_not_same_visitAdmitDtTm query]] to also check that the earlier and later record are at the same site
===2022-04-07===
copied to server [[User:Ttenbergen|Ttenbergen]] 09:42, 2022 April 14 (CDT)
* updated sort order used in PatientList when query is "PL_SameCHART_Site_Diff_PHIN"
* updated query [[PL_SamePHIN_Site_Diff_chart]] - it didn't have an explicit D_ID field so would not have worked with PatientList. Wonder if it has been working at all.
===2022-04-06===
rolled out [[User:Ttenbergen|Ttenbergen]] 00:06, 2022 April 7 (CDT)
* updated [[L_ICD10_APACHE_Comorbids query]] to only include [[Comorbid Diagnoses]]
* updated ''likely_match form'' ([[Cat button]]) to sort by [[Admit DtTm]] DESC
===2022-04-05===
copied to server
* fixed [[Link_suspect_not_same_visitAdmitDtTm query]]
* updated Patient_List query / Patient List form to show new [[Admit DtTm]]
===2022-03-24===
copied to server [[User:Ttenbergen|Ttenbergen]] 16:12, 2022 April 5 (CDT)
* updated [[ link_suspect_negative_transit_time query]] to use [[Admit DtTm]]
* updated code behind [[Cat button]] to not initially load all records, and to open with only likely match records instead.
* updated likely_match query to use [[Created AdmitDtTm query]]
* streamlining of re-connect activities:
** added [[Reconnect_check_Completes query]] and set it so it is run when the [["Re-connect Data" button]] is pressed
** made steps/checks in [[Reconnect CFE and initial error checks]] run automatically
** added process to facilitate changing "completes" to "incompletes"
===2022-03-09===
copied to server [[User:Ttenbergen|Ttenbergen]] 23:13, 2022 March 9 (CST)
something went wrong with the original copy to server, so re-copied it from my desktop. [[User:Ttenbergen|Ttenbergen]] 17:02, 2022 March 10 (CST)
* Tweaked [[Link_suspect_not_same_visitAdmitDtTm query#Log]]
===2022-02-16===
rolled out [[User:Ttenbergen|Ttenbergen]] 15:45, 2022 March 2 (CST)
* fields "ward" and "activeLocation" were missing from Created_Variables_CC table (see [[Created_Variables_CC 2021 table]]) for some reason, which was causing errors in running Created_Variables_CC_maker query (see [[Created_Variables_CC_maker_2021 query]]); restored field [[User:Ttenbergen|Ttenbergen]] 13:53, 2022 March 2 (CST)
===2022-01-05===
===2022-01-05===
not rolled out yet [[User:Ttenbergen|Ttenbergen]] 15:25, 2022 January 5 (CST)
rolled out [[User:Ttenbergen|Ttenbergen]] 16:49, 2022 February 16 (CST)
* updated [[Created_Variables_Common_maker_2021 query]] to eliminate duplicates [[User:Ttenbergen|Ttenbergen]] 16:47, 2021 December 29 (CST)
* updated [[Created_Variables_Common_maker_2021 query]] to eliminate duplicates [[User:Ttenbergen|Ttenbergen]] 16:47, 2021 December 29 (CST)
* updated [[Created Variables CC 2021 table]] to eliminate fields we no longer need [[User:Ttenbergen|Ttenbergen]] 16:02, 2022 January 11 (CST)
* updated [[Link_suspect_not_same_visitAdmitDtTm query #Log]] [[User:Ttenbergen|Ttenbergen]] 16:14, 2022 February 16 (CST)


== Earlier changes ==
== Earlier changes ==
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Centralized_data_front_end.accdb_Change_Log_2022"