CCMDB Wiki

CCMDB.mdb Change Log 2017: Difference between revisions

← Older edit
mNo edit summary
m Text replacement - "[[Category: " to "[[Category:"
 
(13 intermediate revisions by the same user not shown)
Line 54: Line 54:
=== 2017-12-07-3 ===
=== 2017-12-07-3 ===
not rolled yet Ttenbergen 13:20, 2017 December 7 (CST)
not rolled yet Ttenbergen 13:20, 2017 December 7 (CST)
* [[ER Delay]] cross checks:
* [[ER Delay]] [[cross check]]s:
** added query ''check_ER_Delay_not_too_big''
** added query ''check_ER_Delay_not_too_big''
** updated ''Function Dispo_Chronological()'' to use the query to give warning when checking complete box
** updated ''Function Dispo_Chronological()'' to use the query to give warning when checking complete box
Line 104: Line 104:
=== 2017-12-07 ===
=== 2017-12-07 ===
rolled out Ttenbergen 13:20, 2017 December 7 (CST)
rolled out Ttenbergen 13:20, 2017 December 7 (CST)
* correction to tmp cross checks that went wrong in last update Ttenbergen 13:20, 2017 December 7 (CST)
* correction to tmp [[cross check]]s that went wrong in last update Ttenbergen 13:20, 2017 December 7 (CST)


=== 2017-12-06 ===
=== 2017-12-06 ===
Line 127: Line 127:
** removed category columns and some others we won't be using that way
** removed category columns and some others we won't be using that way
** imported new content from wiki
** imported new content from wiki
* [[ACCU borrow]] cross checks:  
* [[ACCU borrow]] [[cross check]]s:  
** s_tmp_ACCU_Borrow_chronicity_hard
** s_tmp_ACCU_Borrow_chronicity_hard
** s_tmp_ACCU_Borrow_2_hr_soft
** s_tmp_ACCU_Borrow_2_hr_soft
Line 165: Line 165:
* removed s_CCI table
* removed s_CCI table
* updated L_CCI table, added fields CCI_1_ID, CCI_2_ID, CCI_3_ID, removed field CCI_ID
* updated L_CCI table, added fields CCI_1_ID, CCI_2_ID, CCI_3_ID, removed field CCI_ID
* added [[query L CCI Resolver]]
* added [[query L_CCI_Combined]]
* updated L CCI subform
* updated L CCI subform
* in [[s_dispo table]], removed program "Med" to [[HSC_H6]]; should never have been added as per definition of program in [[s_dispo table]]
* in [[s_dispo table]], removed program "Med" to [[HSC_H6]]; should never have been added as per definition of program in [[s_dispo table]]
Line 174: Line 174:
* in [[s_dispo table]]:  
* in [[s_dispo table]]:  
** changed [[VIC_S4]] to be active again but only as [[Previous Location]]
** changed [[VIC_S4]] to be active again but only as [[Previous Location]]
** changed [[River Ridge Transition Care Environment]],[[VIC_N4]] and [[VIC_N4C]] to be [[service_type]] TC
** changed [[River Ridge Transition Care Environment]],[[VIC_N4]] and [[VIC_N4C]] to be "service_type" TC
** changed [[River Ridge Transition Care Environment]] to be [[loc_type]] TCE
** changed [[River Ridge Transition Care Environment]] to be [[loc_type]] TCE


Line 185: Line 185:
* in [[s_dispo table]]:  
* in [[s_dispo table]]:  
** updated names of the [[CAU]]s from * - CAU to *_CAU to be consistent with other inpatient locations
** updated names of the [[CAU]]s from * - CAU to *_CAU to be consistent with other inpatient locations
** edited [[VIC_N5C]] and [[VIC_N5C]] to have service type [[SubAcute]], as discussed with Julie
** edited [[VIC_N5C]] and [[VIC_N5C]] to have service type ''SubAcute'', as discussed with Julie


=== 2017-11-07 ===
=== 2017-11-07 ===
Line 219: Line 219:
** [[S ICD10 Charlson Como conditions table]]
** [[S ICD10 Charlson Como conditions table]]
** [[S ICD10 table]]
** [[S ICD10 table]]
** [[S ICD10 Blocks table]]
** S ICD10 Blocks table
** [[S ICD10 Block Dxs table]]
** S ICD10 Block Dxs table
* [[Influenza tracking]] - added "suspected"
* [[Influenza tracking]] - added "suspected"
* unchecked in [[s_dispo table]]: 'VIC UC(direct)' [[Previous Location]]
* unchecked in [[s_dispo table]]: 'VIC UC(direct)' [[Previous Location]]
Line 227: Line 227:
rolled out Ttenbergen 17:38, 2017 October 12 (CDT)
rolled out Ttenbergen 17:38, 2017 October 12 (CDT)
* added [[Influenza tracking]]
* added [[Influenza tracking]]
* added [[s_dispo table]] entries for [[:Category:CAU]] and [[Direct admit]] and [[Parked in ER]]
* added [[s_dispo table]] entries for [[:Category:CAU]] and [[Direct admit]] and [[Parked in ER tmp entry]]
* edited query ''check_previous_location_vs_service_inconsistent'' to allow  
* edited query ''check_previous_location_vs_service_inconsistent'' to allow  
** [[Previous Service]] = family medicine when [[Previous Location]] medicine ward where we collect.
** [[Previous Service]] = family medicine when [[Previous Location]] medicine ward where we collect.
Line 269: Line 269:
*** [[L_ICD10 table]], added some sample data
*** [[L_ICD10 table]], added some sample data
*** L_CCI table
*** L_CCI table
** added [[Patient viewer tab ICD10]]  
** added [[Patient Viewer Tab ICD10]]  
** added subform ''L_ICD10_subform''
** added subform ''L_ICD10_subform''
** added subform ''L_CCI_subform''
** added subform ''L_CCI_subform''
Line 317: Line 317:
** added call to CreateMail when red
** added call to CreateMail when red


* for [[QA_Septic_Shock#Consistency_Checks]], changed [[query s_tmp_QASeptic_Dx_no_tmp]] so it will only trigger for patients with [[RecordStatus]] complete - work-around of entering something wrong will no longer be required. As Requested by Trish in [[Requested CCMDB changes for the next version]] a while ago, just saw it. Ttenbergen 00:49, 2017 July 30 (CDT)
* for [[QA_Septic_Shock#Consistency_Checks]], changed "query s_tmp_QASeptic_Dx_no_tmp" so it will only trigger for patients with [[RecordStatus]] complete - work-around of entering something wrong will no longer be required. As Requested by Trish in [[Requested CCMDB changes for the next version]] a while ago, just saw it. Ttenbergen 00:49, 2017 July 30 (CDT)


=== 2017-06-28-3 ===
=== 2017-06-28-3 ===
Line 399: Line 399:
* made invisible on the labs tab the labs that will now come from [[:Category:DSM Labs Extract]], and [[Angio coronary field]] and [[Angio others field]] Ttenbergen 14:36, 2017 April 3 (CDT)
* made invisible on the labs tab the labs that will now come from [[:Category:DSM Labs Extract]], and [[Angio coronary field]] and [[Angio others field]] Ttenbergen 14:36, 2017 April 3 (CDT)
* updated [[Check_ORDx]] table to no longer make [[AAA Repair]], [[AVR Repair/Replace]] and [[TAA Repair]] require an OR as these are now often done in the cath lab Ttenbergen 14:06, 2017 April 3 (CDT)
* updated [[Check_ORDx]] table to no longer make [[AAA Repair]], [[AVR Repair/Replace]] and [[TAA Repair]] require an OR as these are now often done in the cath lab Ttenbergen 14:06, 2017 April 3 (CDT)
* we will stop using [[Aspiration (early presentation, documented aspiration)]] (see article for details); made inactive in the [[Table S Pathogens]]. Ttenbergen 14:42, 2017 April 3 (CDT)
* we will stop using [[Aspiration (early presentation, documented aspiration)]] (see article for details); made inactive in the [[S_Pathogens table]]. Ttenbergen 14:42, 2017 April 3 (CDT)


=== 2017-Mar-02 ===
=== 2017-Mar-02 ===
Line 407: Line 407:
=== 2017-Feb-07 ===
=== 2017-Feb-07 ===
rolled out Ttenbergen 17:48, 2017 February 7 (CST)
rolled out Ttenbergen 17:48, 2017 February 7 (CST)
* updated structure of [[S_Tmp]] table to make "order" into a single (real) rather than byte (integer) so sorting can include decimal point changes rather than updating everything lower in the list.- Ttenbergen 17:46, 2017 February 7 (CST)
* updated structure of [[s_tmp table]] table to make "order" into a single (real) rather than byte (integer) so sorting can include decimal point changes rather than updating everything lower in the list.- Ttenbergen 17:46, 2017 February 7 (CST)
* updated s_tmp table to accommodate dropdown changes for [[AcceptDateSource]]- Ttenbergen 17:46, 2017 February 7 (CST)
* updated s_tmp table to accommodate dropdown changes for [[AcceptDateSource]]- Ttenbergen 17:46, 2017 February 7 (CST)


Line 416: Line 416:
=== 2017-Jan-25 ===
=== 2017-Jan-25 ===
rolled out Ttenbergen 11:22, 2017 January 25 (CST)
rolled out Ttenbergen 11:22, 2017 January 25 (CST)
* adding entries for [[AcceptDateSource]] to [[S Tmp]] table Ttenbergen 11:22, 2017 January 25 (CST)
* adding entries for [[AcceptDateSource]] to [[s_tmp table]] table Ttenbergen 11:22, 2017 January 25 (CST)


=== 2017-Jan-23 ===
=== 2017-Jan-23 ===
Line 431: Line 431:
=== 2017-Jan-05 ===
=== 2017-Jan-05 ===
rolled out Ttenbergen 08:24, 2017 January 9 (CST)
rolled out Ttenbergen 08:24, 2017 January 9 (CST)
* removed requirement to fill in [[ACP Status collection in ICU]] Ttenbergen 08:24, 2017 January 9 (CST)
* removed requirement to fill in [[ACP Status Collection in ICU]] Ttenbergen 08:24, 2017 January 9 (CST)


=== 2017-Jan-05 ===
=== 2017-Jan-05 ===
Line 440: Line 440:
** send_Centralized_1L_Log__intermediate
** send_Centralized_1L_Log__intermediate
* removed reference that causes [[MSCOMCT2.ocx error]]: removed reference to MSCOMCTL.ocx. I can't remember why we needed it, and it didn't give a compile error when I removed it. Ttenbergen 13:19, 2017 January 5 (CST)
* removed reference that causes [[MSCOMCT2.ocx error]]: removed reference to MSCOMCTL.ocx. I can't remember why we needed it, and it didn't give a compile error when I removed it. Ttenbergen 13:19, 2017 January 5 (CST)
* inactivated [[s_tmp table]] entries for [[ACP Status collection in ICU]] Ttenbergen 13:12, 2017 January 5 (CST)
* inactivated [[s_tmp table]] entries for [[ACP Status Collection in ICU]] Ttenbergen 13:12, 2017 January 5 (CST)




[[Category: CCMDB.mdb]]
[[Category:CCMDB.accdb]]
[[Category: Change Logs CCMDB]]
[[Category:Change Logs CCMDB]]
Retrieved from "https://ccmdb.kuality.ca/index.php?title=CCMDB.mdb_Change_Log_2017"