Centralized data front end.accdb Change Log 2022

see the Development Documentation Category for other development logs This article is the change log for Centralized data front end.accdb. Also see Centralized data front end.accdb Change Request and CFE Data Integrity Checks.

Log

2023

See Centralized data front end.accdb Change Log 2023

2022-11-29

copied to server 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) 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 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. Ttenbergen 16:36, 2022 September 28 (CDT)

2022-08-31

copied to serverTtenbergen 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
• 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 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 Ttenbergen 11:33, 2022 August 16 (CDT)

• updated query L_Log_PHI to exclude the defunct fields. Ttenbergen 09:40, 2022 August 16 (CDT)
• updated query Patient_List to exclude fields that aren't needed 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 Ttenbergen 22:49, 2022 August 15 (CDT)

• updated query Patientlist to remove defunct FinalCheck field Ttenbergen 22:49, 2022 August 15 (CDT)

2022-08-03

copied to server 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 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 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 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 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 Ttenbergen 10:44, 2022 June 30 (CDT)

2022-06-29

copied to server 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 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 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 Ttenbergen 12:26, 2022 June 15 (CDT)

2022-06-14

copied to server 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. Ttenbergen 13:18, 2022 June 14 (CDT)

2022-06-01

copied to server 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 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 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 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" Ttenbergen 14:33, 2022 May 26 (CDT)
• updated the form behind the Cat button to sort by adm date by default. Ttenbergen 15:42, 2022 May 26 (CDT)

2022-05-25

copied to server Ttenbergen 13:54, 2022 May 26 (CDT)

• changed Link_suspect_mismatch_from_ours_incomplete query to fix false positives, see its log for details. Ttenbergen 13:51, 2022 May 26 (CDT)

2022-05-19

copied to server 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 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 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. 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 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 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 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 Ttenbergen 23:13, 2022 March 9 (CST)

something went wrong with the original copy to server, so re-copied it from my desktop. Ttenbergen 17:02, 2022 March 10 (CST)

• Tweaked Link_suspect_not_same_visitAdmitDtTm query#Log

2022-02-16

rolled out 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 Ttenbergen 13:53, 2022 March 2 (CST)

2022-01-05

rolled out Ttenbergen 16:49, 2022 February 16 (CST)

• updated Created_Variables_Common_maker_2021 query to eliminate duplicates Ttenbergen 16:47, 2021 December 29 (CST)
• updated Created Variables CC 2021 table to eliminate fields we no longer need Ttenbergen 16:02, 2022 January 11 (CST)
• updated Link_suspect_not_same_visitAdmitDtTm query #Log Ttenbergen 16:14, 2022 February 16 (CST)

Earlier changes

See Centralized data front end.accdb Change Log 2021