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

must update batch files to correspond with CCMDB coming from ccmdb_program now.

2016-07-11

not rolled yet Ttenbergen 09:24, 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)