CCMDB.mdb Change Log 2018: Difference between revisions

m link fixes
m Text replacement - "STB Medicine Workload splitting" to "STB Medicine workload splitting"
Line 85: Line 85:
** [[Angioplasty, coronary (without stenting)]]
** [[Angioplasty, coronary (without stenting)]]
* [[ICUotherService]] project: added option "CICU under ACCU service"
* [[ICUotherService]] project: added option "CICU under ACCU service"
* [[STB Medicine Workload splitting]]: added STB_EMIPa, STB_EMIPb, STB_EMIPd
* [[STB Medicine workload splitting]]: added STB_EMIPa, STB_EMIPb, STB_EMIPd
** to [[S dispo table]]
** to [[S dispo table]]
** to [[s_locations_allowed_collection table]]
** to [[s_locations_allowed_collection table]]
Line 170: Line 170:
** [[Thrombolytic drug, overdose/toxicity]] from T44.5 to T45.6
** [[Thrombolytic drug, overdose/toxicity]] from T44.5 to T45.6
** [[Cardiac/cardiovascular drug NOS, adverse effect]] from Y52 to Y52.9
** [[Cardiac/cardiovascular drug NOS, adverse effect]] from Y52 to Y52.9
* tweaked [[S locations allowed collection table]] for [[STB Medicine Workload splitting]] Ttenbergen 10:58, 2018 November 29 (CST)
* tweaked [[S locations allowed collection table]] for [[STB Medicine workload splitting]] Ttenbergen 10:58, 2018 November 29 (CST)
* [[S ICD10 table]] - removed columns important_wiki_info, Bug_req, min_nr_grouped_with because this is not how we are doing things now
* [[S ICD10 table]] - removed columns important_wiki_info, Bug_req, min_nr_grouped_with because this is not how we are doing things now
* re-updated the ICD10 and CCI categories from wiki
* re-updated the ICD10 and CCI categories from wiki
Line 227: Line 227:
* '''added "query check ICD10 ESRD vs AP CRF"
* '''added "query check ICD10 ESRD vs AP CRF"
* '''added [[query check_ICD10_needs_awaiting_if_TR_Dt_and_Dispo_Dt_on_diff_days]]
* '''added [[query check_ICD10_needs_awaiting_if_TR_Dt_and_Dispo_Dt_on_diff_days]]
* '''added the ...a ...b ...d codes to [[s_dispo table]] that will be needed to do [[STB Medicine Workload splitting]]
* '''added the ...a ...b ...d codes to [[s_dispo table]] that will be needed to do [[STB Medicine workload splitting]]
* '''inactivated the remaining specific Vic wards in [[s_dispo table]]
* '''inactivated the remaining specific Vic wards in [[s_dispo table]]
* '''tweaked [[L_CCI_Picklist subform]] so that "no procedure performed" sorts to the top of the dropdown  
* '''tweaked [[L_CCI_Picklist subform]] so that "no procedure performed" sorts to the top of the dropdown