Centralized data front end.mdb Change Log 2016

see the Development Documentation Category for other development logs

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

Change Log

next round

• These have to wait for back-populated data to be right.
  • query link_suspect_from_ours_single_encounter replaces following:
    • query link_suspect_from_ICU_but_single_encounter
    • query link_suspect_from_partner_no_match
  • query link_suspect_medicine_to_med_no_partner
  • query link_suspect_to_ICU_but_single_encounter

2016-07-28-2

not rolled yet Ttenbergen 16:48, 2016 July 28 (CDT)

• updated populate_linking_pairs() to use new dispo fields Ttenbergen 16:48, 2016 July 28 (CDT)
• changes of link_suspect_* queries to use new Dispo system:
  • query link_suspect_dead_then_alive - updated
  • query link_suspect_negative_transit_time - updated
• deleted unused query link_susp_intermediate_potential_location_partner

2016-07-28

rolled Ttenbergen 11:05, 2016 July 28 (CDT)

• updated Sub likely_match_finder to list patient even if previous_location or dispo are not yet filled in Ttenbergen 11:05, 2016 July 28 (CDT)

2016-07-27

rolled Ttenbergen 14:56, 2016 July 27 (CDT)

• updated code behind handshake button to use new dispo fields Ttenbergen 14:56, 2016 July 27 (CDT)

2016-07-25

rolled out Ttenbergen 17:09, 2016 July 25 (CDT)

• changed function cbo_QuerySelector_Click() to sort by arr (arrival date) rather than adm (admit date) Ttenbergen 17:05, 2016 July 25 (CDT)

2016-07-15

rolled Ttenbergen 09:28, 2016 July 15 (CDT)

• changed query for form_view to pull from s_dispo instead of s_location. Ttenbergen 09:06, 2016 July 15 (CDT)

2016-07-11

rolled Ttenbergen 18:03, 2016 July 11 (CDT)

• built query 20160706___postalcode_importer and 20160706___postalcode_maker
• fixed query 20160706___PreAcute_maker
• updated query PatientList to work while not all data has moved to dispo fields. Ttenbergen 15:58, 2016 July 11 (CDT)

2016-07-08

was rolled...

• more queries 20160706___*
• module 2016-07_dispo_convert

2016-07-06

(must have rolled)

• query Patient_List to use new fields. Ttenbergen 16:20, 2016 July 7 (CDT)
• form PatientList Ttenbergen 16:20, 2016 July 7 (CDT)
• many changes toward Conversion of old registry fields to new dispo fields Ttenbergen 16:20, 2016 July 7 (CDT)

2016-07-06

rolled Ttenbergen 15:06, 2016 July 7 (CDT)

• updated queries for new DISPO fields
  • query PL_SamePHIN_Diff_LN_FN_DOB_Sex
  • query PL_SameCHART_Site_Diff_PHIN
  • query PL_2PHIN _Fake_or_blank
  • query PL_1orphans
  • query P_Summary_Discharges_FiscalYear
  • query P_Summary_Discharges
  • query P_Outstandings_Discharges
  • query P_Outstandings_Admits
  • query P_Outstandings
  • query P_Count_of_sent
  • query P_Count_of_Admissions
  • query NDC_VAP_unacceptable_date
  • query NDC_VAP_No_AcqDX_but_VAP_DateinTMPV2
  • query NDC_VAP_AcqDX_but_NoVAP_DateinTMPV2
  • query NDC_Pacemaker_acquired_wo_TISS
  • query NDC_Missing_TransferDate_wPivot
  • query NDC_discharged_incomplete
  • query NDC_CLI_unacceptable_date
  • query NDC_CLI_No_AcqDX_but_CLI_DateinTMPV2
  • query NDC_CLI_AcqDX_but_NoCLI_DateinTMPV2
  • query ND_Sub_postalCode
  • query Multiple_Encounter
• for Conversion of old registry fields to new dispo fields
  • table 20160706 Pre acute living situation field_translator

2016-07-05

rolled with caution that push pull won't work right now. Ttenbergen 16:34, 2016 July 5 (CDT)

• Updates to
  • query Created_...
  • query Created_...
  • query L_Log_PHI

2016-07-04

rolled with caution that push pull won't work right now. Ttenbergen 16:34, 2016 July 5 (CDT)

• changed "Re-Connect Data" button to draw from c:\ccmdb_program\ccmdb.mdb instead; must update batch files to correspond
• changing to use new fields
  • query ages - age
  • query created_Apache_details - Created Variables
  • query L_Log_PHI - added new fields and changed ward, hosp, program to draw from s_dispo table
  • query J_in-process_records - now pulls Service/Location
  • query Labs_requester
  • query TISS_admitted_date_range
  • query PatientList
  • query PL_SamePHIN_Site_Diff_chart

• clean-up
  • deleted query created_variables_select
  • deleted query Created_Variables_ts
  • deleted query created_vars_selectonly
  • deleted table 's_HospitalCodes_updt
  • deleted query L_Log_PHI_time_hm, use L_Log_PHI instead
  • deleted query L_Dispo
  • deleted table R_completePTList
  • deleted table s_dispo_legacy_codes
  • deleted query s_dispo_combiner
  • deleted query s_locations_local

2016-05-26

rolled Ttenbergen 13:09, 2016 May 26 (CDT)

• removing some old one-of queries that should be done with Ttenbergen 11:01, 2016 May 26 (CDT)
  • 1_acp__test
  • 1_acp_admit
  • 1_acp_end
  • 1_change_complication_CAP_to_HAP
  • 11_5B_adm
  • 11_5B_dis
• added three queries starting with 2016-05-26_GRAW3_to_S3 to do conversion; emailed Pagasa to run them Ttenbergen 13:08, 2016 May 26 (CDT)

2016-05-05

rolled out Ttenbergen 21:24, 2016 May 4 (CDT)

• added three new tables S_dispo table, S_pre_acute_living_situation table, S_previous_service_table to reconnector code Ttenbergen 21:07, 2016 May 4 (CDT)
• added fields on Pagasa's form Ttenbergen 21:07, 2016 May 4 (CDT)
• added query L_Dispo for Julie to access in SAS to resolve the entries as text Ttenbergen 21:20, 2016 May 4 (CDT)

2016-04-14

rolled Ttenbergen 17:55, 2016 April 14 (CDT)

• fixed password protection to be same as our other programs. Ttenbergen 17:55, 2016 April 14 (CDT)

2016-01-28

rolled out Ttenbergen 15:50, 2016 January 28 (CST)

• updating Query NDC missing Ls to not list incompletes even for dxs. Ttenbergen 15:50, 2016 January 28 (CST)

2016-01-21

rolled out.--Ttenbergen 17:19, 2016 January 21 (CST)

• added CFE Query NDC missing Ls to find missing mandatory child entries Ttenbergen 17:19, 2016 January 21 (CST)
• updated query ADL_Scores to refer to ALERT rather than MOST Ttenbergen 17:26, 2016 January 21 (CST)