CCMDB.accdb Change Log 2021: Difference between revisions

(8 intermediate revisions by the same user not shown)

Line 27:

Changes collectors probably don't care about (incl. bug fixes that should just make hings work now):

* updated [[query check_CCI_TISS_Pharm_Vasoactive]] - query was only triggering for profiles that have an [[Accept DtTm]], changed it to use first [[Service tmp entry]] instead.

* updated [[query check_CCI_TISS_Pharm_Vasoactive]] - query was only triggering for profiles that have an "Accept DtTm", changed it to use first [[Service tmp entry]] instead.

=== 2021-12-02 ===

Line 36:

Changes collectors probably don't care about (incl. bug fixes that should just make hings work now):

* updated [[query check_CCI_TISS_Pharm_Vasoactive]] - query was only triggering for profiles that have an [[Accept DtTm]], changed it to use first [[Service tmp entry]] instead.

* updated [[query check_CCI_TISS_Pharm_Vasoactive]] - query was only triggering for profiles that have an "Accept DtTm", changed it to use first [[Service tmp entry]] instead.

=== 2021-11-17 ===

Line 46:

Changes collectors probably don't care about (incl. bug fixes that should just make hings work now):

* temporarily removed cross ~~checks~~ that ensure that [[Pre-admit Inpatient Institution]] , [[Previous Location]] and [[Dispo]] are not the same as [[Service/Location]] while we figure out how this should be collected for HSC CC. [[User:Ttenbergen|Ttenbergen]] 14:23, 2021 December 2 (CST)

* temporarily removed [[cross check]]s that ensure that [[Pre-admit Inpatient Institution]] , [[Previous Location]] and [[Dispo]] are not the same as [[Service/Location]] while we figure out how this should be collected for HSC CC. [[User:Ttenbergen|Ttenbergen]] 14:23, 2021 December 2 (CST)

=== 2021-11-12 ===

Line 58:

'''<mark>Changes collectors need to know about:</mark>'''

* added [[HSC ALC Medicine Service]]s to [[s_tmp table]] so they can be entered as [[Service tmp entry]] without [[Query s tmp project item consistent]] error [https://ccmdb.kuality.ca/index.php?title=HSC_ALC_Medicine_Service&action=history]

* added [[HSC and GRA ALC Medicine Service]]s to [[s_tmp table]] so they can be entered as [[Service tmp entry]] without [[Query s tmp project item consistent]] error [https://ccmdb.kuality.ca/index.php?title=HSC_ALC_Medicine_Service&action=history]

=== 2021-11-05 ===

Line 89:

* cleanup of [[Transitional Care]]: inactivated "STB - Transitional care" and "River Ridge Transition Care Environment" in [[s_dispo table]]

* changed the error handling in sending, it would have brushed right past some errors before without notifying user

* updated query 'send_set_oLog_to_sent' that runs as part of sending so it wont re-set previously sent records from "vetted" to "sent" in [[~~Centralized data~~.~~mdb~~]]

* updated query 'send_set_oLog_to_sent' that runs as part of sending so it wont re-set previously sent records from "vetted" to "sent" in [[Centralized_data.accdb]]

=== 2021-10-20 ===

Line 159:

Changes collectors probably don't care about (incl. bug fixes that should just make hings work now):

* created [[Cognos2_Hospital_Discharge query]]

* created ''Cognos2_Hospital_Discharge'' query

* updated ''L_First_Boarding_Loc_Non_ER query'', which was causing false positives in ''query check_ER_Delay_not_too_big''

Line 219:

** HSC Critical Care – SICU

* updated ''query check_ER_Delay_not_too_big'' to use [[Boarding Loc]] instead of [[Accept DtTm]] vs [[Arrive DtTm]], and increased warning delay for CC from 2hrs to 8hrs (which it should have been already)

* updated ''query check_ER_Delay_not_too_big'' to use [[Boarding Loc]] instead of "Accept DtTm" vs "Arrive DtTm", and increased warning delay for CC from 2hrs to 8hrs (which it should have been already)

=== 2021-09-07 ===

Line 307:

rolled out [[User:Ttenbergen|Ttenbergen]] 10:41, 2021 July 23 (CDT)

Changes collectors probably don't care about (incl. bug fixes that should just make hings work now):

* further tweaking on [[query check_minimal_data_set_incomplete]]; this must not check for [[Arrive DtTm]] since that may be empty for pt who is still in ER [[User:Ttenbergen|Ttenbergen]] 14:11, 2021 July 22 (CDT)

* further tweaking on [[query check_minimal_data_set_incomplete]]; this must not check for "Arrive DtTm" since that may be empty for pt who is still in ER [[User:Ttenbergen|Ttenbergen]] 14:11, 2021 July 22 (CDT)

=== 2021-07-21-2 ===

Line 383:

Changes collectors probably don't care about (incl. bug fixes that should just make hings work now):

* updated [[query check_minimal_data_set_incomplete]] to fix false positive on missing [[Arrive DtTm]] that had been accidentally introduced in [[#2021-06-17]].

* updated [[query check_minimal_data_set_incomplete]] to fix false positive on missing "Arrive DtTm" that had been accidentally introduced in [[#2021-06-17]].

=== 2021-06-20 ===

Line 413:

Changes collectors probably don't care about (incl. bug fixes that should just make hings work now):

* updated [[query check_CCI_Date]] which was failing with uninformative error when [[Arrive DtTm]] blank

* updated [[query check_CCI_Date]] which was failing with uninformative error when "Arrive DtTm" blank

* updated [[query check_minimal_data_set_incomplete]] to properly trigger for blank [[Arrive DtTm]]

* updated [[query check_minimal_data_set_incomplete]] to properly trigger for blank "Arrive DtTm"

* updated [[query check_ICD10_awaiting_has_Transfer_Ready_DtTm]] to fix scenario where multiple [[Transfer Ready DtTm tmp entry]] would cause false positive

Line 476:

Changes collectors need to know about:

* We used to collect the initial ER Boarding Loc with the start DtTm of the of the ER as per Cognos. Our cross ~~checks~~ worked in this scenario:

* We used to collect the initial ER Boarding Loc with the start DtTm of the of the ER as per Cognos. Our [[cross check]]s worked in this scenario:

::: [[query check_tmp_ER_Boarding_Loc_should_exist_if_from_ER]] requires the ER entry if prev location is ER

::: [[query check_tmp_service_or_location_duplicate]] doesn't allow two service lines to have same dttms

:* Now we changed to using the same start dttm for the first service and the first boarding loc, even in the ER where this clearly is not true; in any case, we added a cross check to ensure this is entered correctly: [[query check_tmp_Boarding_Loc_Service_first_same ]]

:* Now we changed to using the same start dttm for the first service and the first boarding loc, even in the ER where this clearly is not true; in any case, we added a [[cross check]] to ensure this is entered correctly: [[query check_tmp_Boarding_Loc_Service_first_same ]]

:* This made it impossible to enter a patient who came from ER but didn't spend time there. Could not enter the date and times the same, but also could not omit the ER entry. Discussed with Julie, and '''we decided to update [[query check_tmp_service_or_location_duplicate]] to exclude ER '''

Line 487:

Changes collectors probably don't care about (incl. bug fixes that should just make hings work now):

* updated [[query check_tmp_service_or_location_duplicate]] to catch a scenario it was missing

* removed the initial ICD10 version of [[Drug-induced immunosuppression]] from [[S ICD10 table]]

* removed the initial ICD10 version of ''Drug-induced immunosuppression'' from [[S ICD10 table]]

* re-enabled "HSC Critical Care / Intermediate" in [[Service tmp entry]]; had accidentally disabled it

Line 512:

* disabled [[query check_ICD10_Inf_Potential_Infection_must_have_pathogen_or_alt]] as discussed at Task meeting

* inactivated any HSC CC [[Service tmp entry]] other than "HSC Critical Care - MICU", "HSC Critical Care - SICU" and "HSC Critical Care / Intermediate"

* retired briefly available ICD10 version of [[Drug-induced immunosuppression]]

* retired briefly available ICD10 version of ''Drug-induced immunosuppression''

=== 2021-04-22 ===

Line 518:

Changes collectors need to know about:

* changed the "99" button on [[Patient Viewer Tab CCI Pick]] to add the record for [[Drug-induced immunosuppression]] as [[Px Type]] "Admit" rather than "Acquired" like all the other TISS records; this is assuming that the question on the page will be answered that way...

* changed the "99" button on [[Patient Viewer Tab CCI Pick]] to add the record for ''Drug-induced immunosuppression'' as [[Px Type]] "Admit" rather than "Acquired" like all the other TISS records; this is assuming that the question on the page will be answered that way...

Changes collectors probably don't care about (incl. bug fixes that should just make hings work now):

* changed [[query check_CCI_TISS_NrDays_GT_LOS]] and [[query check_CCI_TISS_NrDays_LT_LOS]] to exclude T99 [[Drug-induced immunosuppression]]

* changed [[query check_CCI_TISS_NrDays_GT_LOS]] and [[query check_CCI_TISS_NrDays_LT_LOS]] to exclude T99 ''Drug-induced immunosuppression''

=== 2021-04-21-1 ===

Line 534:

Changes collectors probably don't care about (incl. bug fixes that should just make hings work now):

* added [[CCI Collection Mode]] "[[CCI collect first]]" and "[[:Category:Pharmacotherapy]]" first to [[Drug-induced immunosuppression]]

* added [[CCI Collection Mode]] "[[CCI collect first]]" and "[[:Category:Pharmacotherapy]]" first to ''Drug-induced immunosuppression''

=== 2021-04-20 ===

Line 549:

Changes collectors need to know about:

* Added [[Drug-induced immunosuppression]] as CCI Picklist / TISS code, '''see instructions on that page on how the usage of this code is changing'''

* Added ''Drug-induced immunosuppression'' as CCI Picklist / TISS code, '''see instructions on that page on how the usage of this code is changing'''

=== 2021-04-08-4 ===

Line 633:

Changes collectors need to know about:

* added [[Drug-induced immunosuppression]] to [[S ICD10 table]]

* added ''Drug-induced immunosuppression'' to [[S ICD10 table]]

* tweaked [[query check_CCI_TISS_Pharm_Vasoactive]] to only include profiles with [[Accept DtTm]] after 2020-12-07 ([[Change_to_collect_TISS_data_in_CCI_Picklist#Change_date]]

* tweaked [[query check_CCI_TISS_Pharm_Vasoactive]] to only include profiles with "Accept DtTm" after 2020-12-07 ([[Change_to_collect_TISS_data_in_CCI_Picklist#Change_date]]

=== 2021-04-01 ===

Line 793:

Changes collectors need to know about:

* added ''Eyes button'' to facilitate [[Process for bad data in Cognos]]

* added ''Eyes button'' to facilitate ''Process for bad data in Cognos''

** for now this will only do anything for STB, since we still need to find out the contacts for HSC and GRA

@@ Line 27: / Line 27: @@
 Changes collectors probably don't care about (incl. bug fixes that should just make hings work now):
-* updated [[query check_CCI_TISS_Pharm_Vasoactive]] - query was only triggering for profiles that have an [[Accept DtTm]], changed it to use first [[Service tmp entry]] instead.
+* updated [[query check_CCI_TISS_Pharm_Vasoactive]] - query was only triggering for profiles that have an "Accept DtTm", changed it to use first [[Service tmp entry]] instead.
 === 2021-12-02 ===
@@ Line 36: / Line 36: @@
 Changes collectors probably don't care about (incl. bug fixes that should just make hings work now):
-* updated [[query check_CCI_TISS_Pharm_Vasoactive]] - query was only triggering for profiles that have an [[Accept DtTm]], changed it to use first [[Service tmp entry]] instead.
+* updated [[query check_CCI_TISS_Pharm_Vasoactive]] - query was only triggering for profiles that have an "Accept DtTm", changed it to use first [[Service tmp entry]] instead.
 === 2021-11-17 ===
@@ Line 46: / Line 46: @@
 Changes collectors probably don't care about (incl. bug fixes that should just make hings work now):
-* temporarily removed cross checks that ensure that [[Pre-admit Inpatient Institution]] , [[Previous Location]] and [[Dispo]] are not the same as [[Service/Location]] while we figure out how this should be collected for HSC CC. [[User:Ttenbergen|Ttenbergen]] 14:23, 2021 December 2 (CST)
+* temporarily removed [[cross check]]s that ensure that [[Pre-admit Inpatient Institution]] , [[Previous Location]] and [[Dispo]] are not the same as [[Service/Location]] while we figure out how this should be collected for HSC CC. [[User:Ttenbergen|Ttenbergen]] 14:23, 2021 December 2 (CST)
 === 2021-11-12 ===
@@ Line 58: / Line 58: @@
 '''<mark>Changes collectors need to know about:</mark>'''
-* added [[HSC ALC Medicine Service]]s to [[s_tmp table]] so they can be entered as [[Service tmp entry]] without [[Query s tmp project item consistent]] error [https://ccmdb.kuality.ca/index.php?title=HSC_ALC_Medicine_Service&action=history]
+* added [[HSC and GRA ALC Medicine Service]]s to [[s_tmp table]] so they can be entered as [[Service tmp entry]] without [[Query s tmp project item consistent]] error [https://ccmdb.kuality.ca/index.php?title=HSC_ALC_Medicine_Service&action=history]
 === 2021-11-05 ===
@@ Line 89: / Line 89: @@
 * cleanup of [[Transitional Care]]: inactivated "STB - Transitional care" and "River Ridge Transition Care Environment" in [[s_dispo table]]
 * changed the error handling in sending, it would have brushed right past some errors before without notifying user
-* updated query 'send_set_oLog_to_sent' that runs as part of sending so it wont re-set previously sent records from "vetted" to "sent" in [[Centralized data.mdb]]
+* updated query 'send_set_oLog_to_sent' that runs as part of sending so it wont re-set previously sent records from "vetted" to "sent" in [[Centralized_data.accdb]]
 === 2021-10-20 ===
@@ Line 159: / Line 159: @@
 Changes collectors probably don't care about (incl. bug fixes that should just make hings work now):
-* created [[Cognos2_Hospital_Discharge query]]
+* created ''Cognos2_Hospital_Discharge'' query
 * updated ''L_First_Boarding_Loc_Non_ER query'', which was causing false positives in ''query check_ER_Delay_not_too_big''
@@ Line 219: / Line 219: @@
 ** HSC Critical Care – SICU
-* updated ''query check_ER_Delay_not_too_big'' to use [[Boarding Loc]] instead of [[Accept DtTm]] vs [[Arrive DtTm]], and increased warning delay for CC from 2hrs to 8hrs (which it should have been already)
+* updated ''query check_ER_Delay_not_too_big'' to use [[Boarding Loc]] instead of "Accept DtTm" vs "Arrive DtTm", and increased warning delay for CC from 2hrs to 8hrs (which it should have been already)
 === 2021-09-07 ===
@@ Line 307: / Line 307: @@
 rolled out [[User:Ttenbergen|Ttenbergen]] 10:41, 2021 July 23 (CDT)
 Changes collectors probably don't care about (incl. bug fixes that should just make hings work now):
-* further tweaking on [[query check_minimal_data_set_incomplete]]; this must not check for [[Arrive DtTm]] since that may be empty for pt who is still in ER [[User:Ttenbergen|Ttenbergen]] 14:11, 2021 July 22 (CDT)
+* further tweaking on [[query check_minimal_data_set_incomplete]]; this must not check for "Arrive DtTm" since that may be empty for pt who is still in ER [[User:Ttenbergen|Ttenbergen]] 14:11, 2021 July 22 (CDT)
 === 2021-07-21-2 ===
@@ Line 383: / Line 383: @@
 Changes collectors probably don't care about (incl. bug fixes that should just make hings work now):
-* updated [[query check_minimal_data_set_incomplete]] to fix false positive on missing [[Arrive DtTm]] that had been accidentally introduced in [[#2021-06-17]].
+* updated [[query check_minimal_data_set_incomplete]] to fix false positive on missing "Arrive DtTm" that had been accidentally introduced in [[#2021-06-17]].
 === 2021-06-20 ===
@@ Line 413: / Line 413: @@
 Changes collectors probably don't care about (incl. bug fixes that should just make hings work now):
-* updated [[query check_CCI_Date]] which was failing with uninformative error when [[Arrive DtTm]] blank
+* updated [[query check_CCI_Date]] which was failing with uninformative error when "Arrive DtTm" blank
-* updated [[query check_minimal_data_set_incomplete]] to properly trigger for blank [[Arrive DtTm]]
+* updated [[query check_minimal_data_set_incomplete]] to properly trigger for blank "Arrive DtTm"
 * updated [[query check_ICD10_awaiting_has_Transfer_Ready_DtTm]] to fix scenario where multiple [[Transfer Ready DtTm tmp entry]] would cause false positive
@@ Line 476: / Line 476: @@
 Changes collectors need to know about:
-* We used to collect the initial ER Boarding Loc with the start DtTm of the of the ER as per Cognos. Our cross checks worked in this scenario:
+* We used to collect the initial ER Boarding Loc with the start DtTm of the of the ER as per Cognos. Our [[cross check]]s worked in this scenario:
 ::: [[query check_tmp_ER_Boarding_Loc_should_exist_if_from_ER]] requires the ER entry if prev location is ER
 ::: [[query check_tmp_service_or_location_duplicate]] doesn't allow two service lines to have same dttms
-:* Now we changed to using the same start dttm for the first service and the first boarding loc, even in the ER where this clearly is not true; in any case, we added a cross check to ensure this is entered correctly: [[query check_tmp_Boarding_Loc_Service_first_same ]]
+:* Now we changed to using the same start dttm for the first service and the first boarding loc, even in the ER where this clearly is not true; in any case, we added a [[cross check]] to ensure this is entered correctly: [[query check_tmp_Boarding_Loc_Service_first_same ]]
 :* This made it impossible to enter a patient who came from ER but didn't spend time there. Could not enter the date and times the same, but also could not omit the ER entry. Discussed with Julie, and '''we decided to update [[query check_tmp_service_or_location_duplicate]] to exclude ER '''
@@ Line 487: / Line 487: @@
 Changes collectors probably don't care about (incl. bug fixes that should just make hings work now):
 * updated [[query check_tmp_service_or_location_duplicate]] to catch a scenario it was missing
-* removed the initial ICD10 version of [[Drug-induced immunosuppression]] from [[S ICD10 table]]
+* removed the initial ICD10 version of ''Drug-induced immunosuppression'' from [[S ICD10 table]]
 * re-enabled "HSC Critical Care / Intermediate" in [[Service tmp entry]]; had accidentally disabled it
@@ Line 512: / Line 512: @@
 * disabled [[query check_ICD10_Inf_Potential_Infection_must_have_pathogen_or_alt]] as discussed at Task meeting
 * inactivated any HSC CC [[Service tmp entry]] other than "HSC Critical Care - MICU", "HSC Critical Care - SICU" and "HSC Critical Care / Intermediate"
-* retired briefly available ICD10 version of [[Drug-induced immunosuppression]]
+* retired briefly available ICD10 version of ''Drug-induced immunosuppression''
 === 2021-04-22 ===
@@ Line 518: / Line 518: @@
 Changes collectors need to know about:
-* changed the "99" button on [[Patient Viewer Tab CCI Pick]] to add the record for [[Drug-induced immunosuppression]] as [[Px Type]] "Admit" rather than "Acquired" like all the other TISS records; this is assuming that the question on the page will be answered that way...
+* changed the "99" button on [[Patient Viewer Tab CCI Pick]] to add the record for ''Drug-induced immunosuppression'' as [[Px Type]] "Admit" rather than "Acquired" like all the other TISS records; this is assuming that the question on the page will be answered that way...
 Changes collectors probably don't care about (incl. bug fixes that should just make hings work now):
-* changed [[query check_CCI_TISS_NrDays_GT_LOS]] and [[query check_CCI_TISS_NrDays_LT_LOS]] to exclude T99 [[Drug-induced immunosuppression]]
+* changed [[query check_CCI_TISS_NrDays_GT_LOS]] and [[query check_CCI_TISS_NrDays_LT_LOS]] to exclude T99 ''Drug-induced immunosuppression''
 === 2021-04-21-1 ===
@@ Line 534: / Line 534: @@
 Changes collectors probably don't care about (incl. bug fixes that should just make hings work now):
-* added [[CCI Collection Mode]] "[[CCI collect first]]" and "[[:Category:Pharmacotherapy]]" first to [[Drug-induced immunosuppression]]
+* added [[CCI Collection Mode]] "[[CCI collect first]]" and "[[:Category:Pharmacotherapy]]" first to ''Drug-induced immunosuppression''
 === 2021-04-20 ===
@@ Line 549: / Line 549: @@
 Changes collectors need to know about:
-* Added [[Drug-induced immunosuppression]] as CCI Picklist / TISS code, '''see instructions on that page on how the usage of this code is changing'''
+* Added ''Drug-induced immunosuppression'' as CCI Picklist / TISS code, '''see instructions on that page on how the usage of this code is changing'''
 === 2021-04-08-4 ===
@@ Line 633: / Line 633: @@
 Changes collectors need to know about:
-* added [[Drug-induced immunosuppression]] to [[S ICD10 table]]
+* added ''Drug-induced immunosuppression'' to [[S ICD10 table]]
-* tweaked [[query check_CCI_TISS_Pharm_Vasoactive]] to only include profiles with [[Accept DtTm]] after 2020-12-07 ([[Change_to_collect_TISS_data_in_CCI_Picklist#Change_date]]
+* tweaked [[query check_CCI_TISS_Pharm_Vasoactive]] to only include profiles with "Accept DtTm" after 2020-12-07 ([[Change_to_collect_TISS_data_in_CCI_Picklist#Change_date]]
 === 2021-04-01 ===
@@ Line 793: / Line 793: @@
 Changes collectors need to know about:
-* added ''Eyes button'' to facilitate [[Process for bad data in Cognos]]
+* added ''Eyes button'' to facilitate ''Process for bad data in Cognos''
 ** for now this will only do anything for STB, since we still need to find out the contacts for HSC and GRA