Centralized data front end.accdb Change Log 2018

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.

Log

2018-04-19-2

copied to server

• changed Function confirm_files_and_links() to connect to DSM_Labs_data.accdb instead of DSM_Labs_Consistency_check.accdb Ttenbergen 12:14, 2018 May 18 (CDT)

2018-04-19-2

copied to server

• made DC Treatment field visible in patient viewer form, for some reason it was invisible.
• detached Lab_DSM data and labelled that tab as "not currently used" - the data is stored elsewhere and not currently being hooked up to CFE
• imported forms from CCMDB.mdb:
  • ICD10Chooser
  • L_ICD10_subform
  • CCI_Chooser
  • L_CCI_Component_subform
  • L_CCI_Picklist_subform
• made ICD10/CCI subform

• updated Function confirm_files_and_links() to include
  • L_CCI_Component table
  • L_CCI_Picklist table
  • L_ICD10 table
  • s_CCI_1 table
  • s_CCI_2 table
  • s_CCI_Picklist table
  • s_ICD10 table

2018-04-19

sent to server

• added query "L_tmp_SepticSet" to support Septic Shock Order Set Ttenbergen 09:21, 2018 April 19 (CDT)

2018-02-15

• fix to queries
  • ND_Sub_VAPinAcqDX_NoVAP_DateinTMPV2_Sub_TMPV2_Component
  • NDC_VAP_AcqDX_but_NoVAP_DateinTMPV2

2018-02-07

• Fixed queries that didn't have "D_ID" field and therefore did not populate form properly:
  • NDC_VAP_no_TISS
  • NDC_zCRRT_tmp_no_TISS
  • NDC_Pacemaker_acquired_wo_TISS
  • link_suspect_mismatch_pre_inpt_should_be_ours__incomplete
• ran data update query to change all entries for QA Infection CLI to "Central Line Infection" as currently used; informed Julie PTorres 11:08, 2018 February 7 (CST)
• updated query P_Outstanding_Dispo query to really only list those with Dispo_DtTm 11:25, 2018 February 7 (CST)
• deleted query P_Outstandings_Admits because it is a twin of P_Outstandings query

2018-01-02

• Rename NDC_missing_L_s to NDC_missing_L_Tables_content