Centralized data front end.mdb Change Log 2015

see the Development Documentation Category for other development logs

This article is the change log for Centralized data front end.accdb. See Centralized data front end.accdb Change Request for requested changes.

Change Log

2015-Aug-19

copied to x: Ttenbergen 14:13, 2015 August 24 (CDT)

• added one-time queries 1_acp__test, 1_acp_admit and 1_acp_end. Emailed Pagasa, Julie and Trish with details. Ttenbergen 13:20, 2015 August 24 (CDT)
• added one-time query 1_change_complication_CAP_to_HAP. Emailed Julie, Trish and Pagasa with details. Ttenbergen 13:35, 2015 August 24 (CDT)

2015-Aug-13

rolled out Ttenbergen 09:53, 2015 August 19 (CDT)

• as discussed with Julie, removed irrelevant fields from
  • query L_Tasks Ttenbergen 11:39, 2015 August 13 (CDT)
  • query L_Log_PHI_time_hm Ttenbergen 12:36, 2015 August 13 (CDT)
• added S dispo legacy codes (later removed) table and query s_dispo_combiner (later removed) to address some legacy data and reporting issues Ttenbergen 08:53, 2015 August 17 (CDT)
• update for Processing errors in patient data#Contact the data collector for additional info
  • added L Communication Notes table to Function confirm_files_and_links() Ttenbergen 09:22, 2015 August 17 (CDT)
  • added code to "email collector about patient data" button/Sub generate_mail_Click to add note to L Communication Notes table and to set RecordStatus field to "questioned" unless it was "incomplete" Ttenbergen 11:18, 2015 August 17 (CDT)
  • added L_Communication_Notes data to query Query J in-process records Ttenbergen 13:55, 2015 August 17 (CDT)
• checking for non-empty queries
  • added module Query_processor
  • added sub Query_processor.Check_Queries_matching
  • added "PLs" and "NDCs" button to PatientList Ttenbergen 14:42, 2015 August 17 (CDT)
  • added "link_suspects" button to LinkList Ttenbergen 14:49, 2015 August 17 (CDT)

2015-Aug-06

copied to x:\ Ttenbergen 17:40, 2015 August 6 (CDT)

• corected query NDC_Pacemaker_acquired_wo_TISS, had false positives Ttenbergen 17:40, 2015 August 6 (CDT)
• added S dispo table to connector function Ttenbergen 17:40, 2015 August 6 (CDT)

2015-Jul-16

copied to x:\ Ttenbergen 16:14, 2015 July 30 (CDT)

• removed queries SAS_* as requested by email from Julie 2015-07-15 -- Ttenbergen 10:43, 2015 July 16 (CDT)
• updated the following queries to omit records listed in L_Problem Ttenbergen 16:07, 2015 July 30 (CDT)
  • query link_suspect_medicine_to_med_no_partner
  • query link_suspect_from_partner_no_match
  • query link_suspect_from_ICU_but_single_encounter
  • query link_suspect_to_ICU_but_single_encounter
• wrote temporary queries to update L_Problem with these, then deleted those queries; updated Centralized_data.mdb L_Problem. Ttenbergen 16:07, 2015 July 30 (CDT)

2015-May-28

rolled Ttenbergen 17:18, 2015 June 24 (CDT)

• added L_Problem to the connector module Ttenbergen 14:13, 2015 June 24 (CDT)
• added query NDC_Pacemaker_acquired_wo_TISS as per SQL email from Pagasa Ttenbergen 17:16, 2015 June 22 (CDT)
• added TISS note to "Re-connect Data" button Ttenbergen 14:54, 2015 June 24 (CDT)
• updated query NDC_CLI_No_AcqDX_but_CLI_DateinTMPV2 to exclude medicine patients. Ttenbergen 16:18, 2015 June 24 (CDT)

2015-May-27

copied to master Ttenbergen 14:32, 2015 May 28 (CDT)

• removed temporary query 3_RnD_clean_tmp_dates, had been applied in Centralized_data.mdb_Change_Log#2015-May-26 Ttenbergen 11:41, 2015 May 27 (CDT)
• changed form PatientList, deleted sex and chart column and squished rest together so Pagasa won't have to scroll back and forth. Ttenbergen 14:30, 2015 May 28 (CDT)

2015-May-14

copied to master Ttenbergen 17:04, 2015 May 20 (CDT)

• updated function phins_cleaned , use L_PHI not L_Log Ttenbergen 12:56, 2015 May 14 (CDT)

2015-May-11

copied to master Ttenbergen 14:57, 2015 May 13 (CDT)

• corrections to algorithm for Generate Person IDs Ttenbergen 11:39, 2015 May 13 (CDT)
• added Function Complete_exists() to check for RecordStatus "complete" in CFE (which should not exist)
  • "Re-connect Data" button on main form
  • "vet all sent" button on PatientList

2015-Apr-16

copied to master Ttenbergen 14:31, 2015 April 20 (CDT)

• fixed Query L Labs total, was grouping rather than summing on most fields. Ttenbergen 14:14, 2015 April 16 (CDT)
• updating query link_suspect_medicine_to_med_no_partner, was including critical care locations.

2015-APR-02-2

rolled Ttenbergen 17:01, 2015 April 2 (CDT)

• added query NDC_Pacemaker_TISS_wo_acquired to find pts with TISS28 item 42 pacemaker insertion who don't have corresponding acquired dx 76334 Ttenbergen 15:58, 2015 April 2 (CDT)
• removed module SHA256 as we decided on different method. Ttenbergen 16:07, 2015 April 2 (CDT)
• added query 3_RnD_clean_tmp_dates to be run and deleted some day, tracked in Centralized data.mdb Requested Changes. Ttenbergen 17:01, 2015 April 2 (CDT)

2015-APR-02

rolled Ttenbergen 12:09, 2015 April 2 (CDT)

• added index L_Log for Person_ID Ttenbergen 11:10, 2015 April 2 (CDT)
• set L_Person.death to null for all since it will only be used for PCH deaths now Ttenbergen 11:10, 2015 April 2 (CDT)
• added code to Form View to blank out Person_ID when PHIN is edited or PseudoPHIN button is pushed. Ttenbergen 12:09, 2015 April 2 (CDT)

2015-APR-01

rolled Ttenbergen 17:07, 2015 April 1 (CDT)

• added Person_ID field to query L_Log_PHI Ttenbergen 15:05, 2015 April 1 (CDT)
• changing encounter_processing module Sub Encounter_processor() to delete inconsistent linkages and then replace with clean ones Ttenbergen 17:07, 2015 April 1 (CDT)

2015-Feb-11

rolled to x:\

• updated Encounter processing and hooked it up to button in main form.
• updated the count test on re-connecting that warns if the numbers in L_Log and L_PHI are not same; had wrong order of precedence

2015-Jan-22

rolled to x: Ttenbergen 17:40, 2015 February 5 (CST)

• setting up for Encounter processing
  • added tables L_Person table and L_Hospitalization to Function confirm_files_and_links() that is triggered by the "Re-connect data" button
  • added query encounter_lister
  • added module Encounter_processing with Sub Encounter_processor()
  • inf query L_Log_PHI_time_hm added fields Person_ID and Hospitalization_ID

• added Report R_CompletePt
  • created query L_Pharm_total
  • created query L_Labs_total
  • created table R_CompletePtList
  • created query r_completePtFilter to subset the report
  • created report R_completePT
  • created sub-report R_CompletePt_Comos
  • created sub-report R_CompletePT_Dxs
  • created sub-report R_CompletePT_Pharm_total
  • created sub-report R_CompletePT_Labs_total

• clean-up
  • deleted old query Labs_Flowsheet_sum_fungins

• updated query link_suspect_medicine_to_med_no_partner to eliminate false-positives for H4H; actually was a complete re-write, Pagasa please test

2015-Jan-20

rolled but with old version number I think Ttenbergen 15:30, 2015 January 20 (CST)

• updated query created_varibles_CC to calculate neuropoints properly. Ttenbergen 15:30, 2015 January 20 (CST)

2015-Jan-05

copied to x:\ Ttenbergen 21:34, 2015 January 19 (CST)

• added queries to move legacy BRR Entries from Var2 into Tmp
  • 1_Var2_BRR_1_to_Tmp
  • 1_Var2_BRR_2_cleanout_Var2
• updated query created_Apache_details to be 15-(GCS) (was just GCS).
• changed var2 dropdown to draw row content the same way as Var 1 (as in CCMDB.accdb) Ttenbergen 18:01, 2015 January 19 (CST)
• added query L_Dxs_w_primary which includes a field "is_primary" to allow easy searching for primary_dxs. uses query Primary_admit Ttenbergen 18:24, 2015 January 19 (CST)
• deleted old legacy query 1_time_only_set_3000_tr_date_to_null Ttenbergen 20:18, 2015 January 19 (CST)