CCMDB.mdb Change Log 2017: Difference between revisions
Ttenbergen (talk | contribs) m Text replacement - "Table S Pathogens" to "S_Pathogens table" |
Ttenbergen (talk | contribs) m Text replacement - "[[Category: " to "[[Category:" |
||
| (8 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 | * [[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 | * 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 | * [[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 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 | ** 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 | ** edited [[VIC_N5C]] and [[VIC_N5C]] to have service type ''SubAcute'', as discussed with Julie | ||
=== 2017-11-07 === | === 2017-11-07 === | ||
| 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 | ** 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 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 [[ | * 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 [[ | * 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 | * 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 | * inactivated [[s_tmp table]] entries for [[ACP Status Collection in ICU]] Ttenbergen 13:12, 2017 January 5 (CST) | ||
[[Category:CCMDB.accdb]] | [[Category:CCMDB.accdb]] | ||
[[Category: Change Logs CCMDB]] | [[Category:Change Logs CCMDB]] | ||