Centralized data front end.accdb Change Log 2022

From CCMDB Wiki

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

2022-09-20

not rolled out yet Ttenbergen 13:40, 2022 September 22 (CDT)

2022-08-31

copied to serverTtenbergen 13:40, 2022 September 22 (CDT)

2022-08-23

rolled out Ttenbergen 16:39, 2022 August 29 (CDT)

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)

2022-07-29

copied to server Ttenbergen 10:24, 2022 July 28 (CDT)

2022-07-26

copied to server Ttenbergen 14:05, 2022 July 26 (CDT)

2022-07-06

copied to server Ttenbergen 10:35, 2022 July 6 (CDT)

2022-06-30

copied to server Ttenbergen 10:49, 2022 June 30 (CDT)

2022-06-29

copied to server Ttenbergen 15:30, 2022 June 29 (CDT)

2022-06-28

copied to server Ttenbergen 13:25, 2022 June 28 (CDT)

2022-06-16

copied to server Ttenbergen 14:44, 2022 June 16 (CDT)

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)

2022-05-26-1

copied to server Ttenbergen 16:50, 2022 May 26 (CDT)

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)

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)

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)

2022-04-05

copied to server

2022-03-24

copied to server Ttenbergen 16:12, 2022 April 5 (CDT)

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)

2022-02-16

rolled out Ttenbergen 15:45, 2022 March 2 (CST)

2022-01-05

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

Earlier changes

See Centralized data front end.accdb Change Log 2021

Related articles

Related articles: