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

(6 intermediate revisions by the same user not shown)

Line 24:

uploaded to master. Ttenbergen 18:55, 2018 November 6 (CST)

* updated to include CLI/ICD10

** [[NDC CLI No AcqDX but CLI DateinTMPV2]]

** "NDC CLI No AcqDX but CLI DateinTMPV2"

** [[query NDC CLI AcqDX but NoCLI DateinTMPV2]]

** ''query NDC CLI AcqDX but NoCLI DateinTMPV2''

** [[query ~~NDC_CLI_vs_DX_but_no_TISS17_CentralLine~~]]

** [[query check_ICD10_CLI_vs_CCI_CentralLine]]

* 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.

Line 51:

* 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~~]]:

* imported forms from [[CCMDB.accdb]]:

** ICD10Chooser

** L_ICD10_subform

Line 84:

** 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)

* 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 ===

Line 92:

[[Category: Development Documentation]]

[[Category:Development Documentation]]

[[Category: Centralized data front end.accdb]]

[[Category:Centralized data front end.accdb]]

@@ Line 24: / Line 24: @@
 uploaded to master. Ttenbergen 18:55, 2018 November 6 (CST)
 * updated to include CLI/ICD10
-** [[NDC CLI No AcqDX but CLI DateinTMPV2]]
+** "NDC CLI No AcqDX but CLI DateinTMPV2"
-** [[query NDC CLI AcqDX but NoCLI DateinTMPV2]]
+** ''query NDC CLI AcqDX but NoCLI DateinTMPV2''
-** [[query NDC_CLI_vs_DX_but_no_TISS17_CentralLine]]
+** [[query check_ICD10_CLI_vs_CCI_CentralLine]]
 * 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.
@@ Line 51: / Line 51: @@
 * 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]]:
+* imported forms from [[CCMDB.accdb]]:
 ** ICD10Chooser
 ** L_ICD10_subform
@@ Line 84: / Line 84: @@
 ** 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)
-* 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 ===
@@ Line 92: / Line 92: @@
-[[Category: Development Documentation]]
+[[Category:Development Documentation]]
-[[Category: Centralized data front end.accdb]]
+[[Category:Centralized data front end.accdb]]