Centralized data front end.accdb Change Log 2018: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
Line 8: Line 8:
not uploaded yet
not uploaded yet
* updated to include CLI/ICD10
* updated to include CLI/ICD10
** [[NDC CLI vs NO TISS17]]
** [[NDC CLI No AcqDX but CLI DateinTMPV2]]
** [[NDC CLI No AcqDX but CLI DateinTMPV2]]
** [[NDC CLI AcqDX but NoCLI DateinTMPV2]]
** [[NDC CLI AcqDX but NoCLI DateinTMPV2]]
** [[NDC_CLI_vs_DX_but_no_TISS17_CentralLine]]
** [[NDC_CLI_vs_DX_but_no_TISS17_CentralLine]]
* tweaked [[ND_sub_CLI_has_CLI_TmpV2]]
* tweaked ND_sub_CLI_has_CLI_TmpV2


===2018-09-11===
===2018-09-11===

Revision as of 18:48, 2018 November 6

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-11-06

not uploaded yet

2018-09-11

  • made query NDC_CLIvsNoTISS17

copied to server

2018-06-28

copied to server

  • made queries L_CCI_Combined and L_CCI_Combined_ComponentSubQ to provide combined CCI data for Julie
  • removed the ICD10/CCI tab from patient viewer - with it there pt took 16s to open, now down to 1s
  • deleted a bunch of old dated queries (eg 20160101_Something)

2018-05-18

There was a version with that date for which no log entry had been made. Neither Pagasa nor Tina could remember what it was about when we next got ready to make a change a month later.

2018-04-19-2

copied to server

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

2018-04-19

sent to server

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