CCMDB.mdb Change Log 2018: Difference between revisions

Line 36:

** added "precedence" field to [[s_ICD10_Charlson_Como_conditions table]]

* updated [[Overstay Predictor Project Algorithm]]

* updated Function include_pt() that had previously only included D_IDs ending in 8 in CCI/ICD10 cross ~~checks~~

* updated Function include_pt() that had previously only included D_IDs ending in 8 in CCI/ICD10 [[cross check]]s

* re-imported [[CCI Categories for CCMDB.accdb]] and [[ICD10 Categories for CCMDB.accdb]]

Line 432:

** "Coronary angiogram (diagnostic cardiac catherization)" --> [[Angiogram, coronary (diagnostic cardiac catheterization)]]

* updated Sub Legacy_Hider() to properly hide the wiki links for ADLs for Critical Care patients. Ttenbergen 23:34, 2018 October 24 (CDT)

* tweaked cross ~~checks~~ that run when closing the [[Notes field]], which had been giving an error if the [[WBC]] field was empty Ttenbergen 23:52, 2018 October 24 (CDT)

* tweaked [[cross check]]s that run when closing the [[Notes field]], which had been giving an error if the [[WBC]] field was empty Ttenbergen 23:52, 2018 October 24 (CDT)

* fixed [[Query check dx primary lowest priority]], it was checking for lowest priority over all dxs, not just admit dxs Ttenbergen 09:33, 2018 October 25 (CDT)

Line 458:

rolled out Ttenbergen 18:24, 2018 October 14 (CDT)

* '''relevant to collectors: '''

** implemented CCI cross ~~checks~~:

** implemented CCI [[cross check]]s:

*** [[Query check CCI if no then none]]

*** [[Query check CCI component 1 and 2 compatible]]

Line 522:

* [[CCMDB.accdb links to CCMDB wiki]] - edited the label for [[DOB]] to no longer be link, added little link icon to left of label. Please see and provide feedback at [[CCMDB.accdb links to CCMDB wiki]].

* updated Function runQuery to generate an email with the relevant error rather than ask collectors to screen shoot and email.

* removed [[No procedure performed]] from [[S_CCI_1 table]] because [[CCI Collection]] says to enter this from [[CCI Picklist]] - this will facilitate cross ~~checks~~

* removed [[No procedure performed]] from [[S_CCI_1 table]] because [[CCI Collection]] says to enter this from [[CCI Picklist]] - this will facilitate [[cross check]]s

* implemented checks and added to Sub Dx_Checker():

* [[Query check_dx_primary_lowest_priority]]

Line 902:

**[[L CCI Picklist subform]]

**[[L CCI Component subform]]

* updated cross ~~checks~~ for [[ER_Delay]]

* updated [[cross check]]s for [[ER_Delay]]

** query ''check_ER_Delay_not_too_big''

** error msg in ''Function Dispo_Chronological()''

Line 928:

* added for [[Accept Loc Park]]:

** nursing stations Ttenbergen 13:51, 2018 January 21 (CST)

** added cross ~~checks~~:

** added [[cross check]]s:

*** query ''s_tmp_Accept_Log_Park_prev_no_tmp''

*** query ''s_tmp_Accept_Log_Park_tmp_no_prev''

@@ Line 36: / Line 36: @@
 ** added "precedence" field to [[s_ICD10_Charlson_Como_conditions table]]
 * updated [[Overstay Predictor Project Algorithm]]
-* updated Function include_pt() that had previously only included D_IDs ending in 8 in CCI/ICD10 cross checks
+* updated Function include_pt() that had previously only included D_IDs ending in 8 in CCI/ICD10 [[cross check]]s
 * re-imported [[CCI Categories for CCMDB.accdb]] and [[ICD10 Categories for CCMDB.accdb]]
@@ Line 432: / Line 432: @@
 ** "Coronary angiogram (diagnostic cardiac catherization)" --> [[Angiogram, coronary (diagnostic cardiac catheterization)]]
 * updated Sub Legacy_Hider() to properly hide the wiki links for ADLs for Critical Care patients. Ttenbergen 23:34, 2018 October 24 (CDT)
-* tweaked cross checks that run when closing the [[Notes field]], which had been giving an error if the [[WBC]] field was empty Ttenbergen 23:52, 2018 October 24 (CDT)
+* tweaked [[cross check]]s that run when closing the [[Notes field]], which had been giving an error if the [[WBC]] field was empty Ttenbergen 23:52, 2018 October 24 (CDT)
 * fixed [[Query check dx primary lowest priority]], it was checking for lowest priority over all dxs, not just admit dxs Ttenbergen 09:33, 2018 October 25 (CDT)
@@ Line 458: / Line 458: @@
 rolled out Ttenbergen 18:24, 2018 October 14 (CDT)
 * '''relevant to collectors: '''
-** implemented CCI cross checks:
+** implemented CCI [[cross check]]s:
 *** [[Query check CCI if no then none]]
 *** [[Query check CCI component 1 and 2 compatible]]
@@ Line 522: / Line 522: @@
 * [[CCMDB.accdb links to CCMDB wiki]] - edited the label for [[DOB]] to no longer be link, added little link icon to left of label. Please see and provide feedback at [[CCMDB.accdb links to CCMDB wiki]].
 * updated Function runQuery to generate an email with the relevant error rather than ask collectors to screen shoot and email.
-* removed [[No procedure performed]] from [[S_CCI_1 table]] because [[CCI Collection]] says to enter this from [[CCI Picklist]] - this will facilitate cross checks
+* removed [[No procedure performed]] from [[S_CCI_1 table]] because [[CCI Collection]] says to enter this from [[CCI Picklist]] - this will facilitate [[cross check]]s
 * implemented checks and added to Sub Dx_Checker():
 * [[Query check_dx_primary_lowest_priority]]
@@ Line 902: / Line 902: @@
 **[[L CCI Picklist subform]]
 **[[L CCI Component subform]]
-* updated cross checks for [[ER_Delay]]
+* updated [[cross check]]s for [[ER_Delay]]
 ** query ''check_ER_Delay_not_too_big''
 ** error msg in ''Function Dispo_Chronological()''
@@ Line 928: / Line 928: @@
 * added for [[Accept Loc Park]]:
 ** nursing stations Ttenbergen 13:51, 2018 January 21 (CST)
-** added cross checks:
+** added [[cross check]]s:
 *** query ''s_tmp_Accept_Log_Park_prev_no_tmp''
 *** query ''s_tmp_Accept_Log_Park_tmp_no_prev''