CCMDB Wiki

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

← Older edit
mNo edit summary
m Text replacement - "[[Category: " to "[[Category:"
 
(11 intermediate revisions by the same user not shown)
Line 19: Line 19:
===2018-11-18===
===2018-11-18===
'''not uploaded yet''' Ttenbergen 23:47, 2018 November 18 (CST)
'''not uploaded yet''' Ttenbergen 23:47, 2018 November 18 (CST)
* updated [[Check VAP vs TISS ventilated]] to no longer consider spontaneous breathing.  
* updated [[query NDC_VAP_no_TISS]] to no longer consider spontaneous breathing.  


===2018-11-06===
===2018-11-06===
uploaded to master. Ttenbergen 18:55, 2018 November 6 (CST)
uploaded to master. Ttenbergen 18:55, 2018 November 6 (CST)
* updated to include CLI/ICD10
* updated to include CLI/ICD10
** [[NDC CLI No AcqDX but CLI DateinTMPV2]]
** "NDC CLI No AcqDX but CLI DateinTMPV2"
** [[NDC CLI AcqDX but NoCLI DateinTMPV2]]
** ''query NDC CLI AcqDX but NoCLI DateinTMPV2''
** [[NDC_CLI_vs_DX_but_no_TISS17_CentralLine]]
** [[query check_ICD10_CLI_vs_CCI_CentralLine]]
* tweaked ND_sub_CLI_has_CLI_TmpV2
* tweaked ND_sub_CLI_has_CLI_TmpV2
* likely tweaked other NDC queries, got a little carried away; see wiki changes for 2018-11-06 if there are questions.
* likely tweaked other NDC queries, got a little carried away; see wiki changes for 2018-11-06 if there are questions.
Line 51: Line 51:
* made [[DC Treatment]] field visible in patient viewer form, for some reason it was invisible.
* 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
* 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]]:
* imported forms from [[CCMDB.accdb]]:
** ICD10Chooser
** ICD10Chooser
** L_ICD10_subform
** L_ICD10_subform
Line 75: Line 75:
* fix to queries
* fix to queries
** ''ND_Sub_VAPinAcqDX_NoVAP_DateinTMPV2_Sub_TMPV2_Component''
** ''ND_Sub_VAPinAcqDX_NoVAP_DateinTMPV2_Sub_TMPV2_Component''
** ''NDC_VAP_AcqDX_but_NoVAP_DateinTMPV2''
** ''Query query NDC_VAP_AcqDX_but_NoVAP_DateinTMPV2''


===2018-02-07===
===2018-02-07===
Line 84: Line 84:
** link_suspect_mismatch_pre_inpt_should_be_ours__incomplete
** 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 [[User:PTorres|PTorres]] 11:08, 2018 February 7 (CST)
* ran data update query to change all entries for [[QA Infection CLI]] to "Central Line Infection" as currently used; informed Julie [[User:PTorres|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)
* 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]]
*deleted query ''P_Outstandings_Admits'' because it is a twin of ''query P_Outstandings''


=== 2018-01-02 ===
=== 2018-01-02 ===
Line 92: Line 92:




[[Category: Development Documentation]]
[[Category:Development Documentation]]
[[Category: Centralized data front end.accdb]]
[[Category:Centralized data front end.accdb]]
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Centralized_data_front_end.accdb_Change_Log_2018"