CCMDB.mdb Change Log 2018: Difference between revisions

(285 intermediate revisions by 3 users not shown)

Line 1:

__NOTOC__

~~'''''see~~ [[Log (disambiguation)]] for other uses of the term "Log"

See [[Log (disambiguation)]] for other uses of the term "Log". See the [[:Category: Development Documentation | Development Documentation Category]] for other development logs''. See [[Rolling out changes]] for the process of rolling out changes. Enter '''[[requested CCMDB changes for the next version]]''' in that article.

~~''see~~ the [[:Category: Development Documentation | Development Documentation Category]] for other development logs''. See [[Rolling out changes]] for the process of rolling out changes.

~~The~~ CCMDB.~~mdb~~ '''Change ~~Log~~''' ~~logs changes made~~ to the CCMDB.~~mdb~~. ~~New entries~~ should be made at the ~~top~~ to ~~be immediately apparent~~.

== Versions ==

==== 2018-12-21 ====

rolled out Ttenbergen 21:19, 2019 January 1 (CST)

Changes collectors will want to know about:

* in [[s_ICD10 table]]

** '''changed "Awaiting/transfer to other care facility (acute or chronic)" to "Awaiting/delayed transfer to other care facility NOS"

** '''added [[Inflammatory/immune arthritis, NOS]]

** '''retired [[Renal dialysis care, including dialysis itself]]

* in [[s_dispo table]], '''added "Institution NOS" as option for [[Previous Location]] / [[dispo]] option

* in [[S_CCI_2 table]]

** '''retired [[Installation of External Appliance]]

** '''added [[Debridement]] to allow for first-only coding

* '''added cross check:

** [[Query check_ICD10_ESRD_vs_ARF ]]

* '''made [[IABP project]] inactive in [[s_tmp table]]

Changes behind the scenes:

'''Collectors will only care about these if they went wrong...'''

* updated cross-checks to ICD10/CCI:

** [[Query s tmp QAInf dx no tmp]]: changed query s_tmp_QAInf__dx to use ICD10 codes

** [[Check if awaiting code is primary dx then Transfer Ready DtTm must be equal to Arrive DtTm]] - needed a tweak for the right codes, and VBA code to actually call it

** [[Query s tmp QASeptic tmp no dx]]

** "Query s tmp QASeptic Dx no tmp ICD10ICD10" - removed call to pre-ICD10 portion

** [[Query check_CCI_must_have_entry]] - made it so it applies to all pts with [[Dispo DtTm]] > 2019-01-01 not those ending w. 8

** [[Query check_ICD10_Comorbids_Dx_present]] - made it so it applies to all pts with [[Dispo DtTm]] > 2019-01-01 not those ending w. 8

* retired as part of moving to ICD10/CCI

** [[Check BRR/XBR vs cardiac arrest dx]] - retired and replaced

** [[Check Function Panelling admit transfer same]] - retired and replaced

** [[Query check ApARF CRF]] - retired and replaced

** [[Query Check Renal IncompatibleDxs]]

* commented out much general code in sub DX_Checker and sub Como_Checker

* Charlson implementation:

** 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

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

==== 2018-12-20-2 ====

rolled out Ttenbergen 21:27, 2018 December 20 (CST)

'''Change collectors will want to know about:

*''' updated [[L_CCI_Picklist_subform]] to show the respective [[CCI Collection Mode]].

behind the scenes...

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

==== 2018-12-20 ====

rolled out Ttenbergen 10:12, 2018 December 20 (CST)

* added to [[S ICD10 table]]: [[Nosocomial infection, NOS]]

==== 2018-12-17 ====

rolled out Ttenbergen 22:31, 2018 December 18 (CST)

Changes Collectors will want to know about:

* '''added to [[S_CCI_Picklist table]]

** [[Swan-Ganz (Pulmonary Artery Flotation) Catheter placement]]'''

** [[CVC placement, any location]]

** [[Arterial catheterization, any location]]

** [[Arthrocentesis, diagnostic]]

* '''retired''' from [[S_CCI_Picklist table]]:

** [[Bronchial thermoplasty]]

** [[Liver dialysis]]

** [[Pharmacotherapy, antineoplastic agent, whole body]]

** [[Pharmacotherapy, immunostimulant, whole body]]

** [[Pharmacotherapy, immunosuppressive, whole body]]

** [[Obstetrical Ultrasound (diagnostic imaging)]]

** [[Obstetrical Imaging NOS (diagnostic imaging)]]

* '''renamed''' in [[S_CCI_Picklist table]]:

** "Cardiac pressure measurements via catheter (done in cath lab)" to [[Right heart catheterization, in cardiac cath lab]]

* '''added to [[S CCI 1 table]]''':

** [[(T) Soft Tissue and Muscle of the Hip and Thigh]]

==== 2018-12-14 ====

rolled out Ttenbergen 20:22, 2018 December 16 (CST)

Changes collectors will want to know about:

* in [[S CCI Picklist table]]:

** switched codes for the following pxs because they were initially set up backwards. For collectors this might mean that if you had entered ...with stenting it will now be ...without stenting, and vice versa.

** fixed spelling of ""Cardiac nulcear scan (e.g. MUGA)"" to [[Cardiac nuclear scan (e.g. MUGA)]]

** [[Angioplasty, coronary (with stenting)]]

** [[Angioplasty, coronary (without stenting)]]

* [[ICUotherService]] project: added option "CICU under ACCU service"

* [[STB Medicine workload splitting]]: added STB_EMIPa, STB_EMIPb, STB_EMIPd

** to [[S dispo table]]

** to [[s_locations_allowed_collection table]]

==== 2018-12-04 ====

rolled out Ttenbergen 10:23, 2018 December 4 (CST)

* '''reduce the number of times that the ER Delay error shows up '''

** moved the call for "Query check_ER_Delay_not_too_big" from Function Dispo_Chronological to Function Validate_Accept_DtTm.

==== 2018-12-02 ====

SEE THE NEXT CHANGE AS WELL, BOTH DONE THIS WEEKEND

rolled out Ttenbergen 20:26, 2018 December 2 (CST)

* Collectors should see no difference, except maybe fewer of the lock errors during sending

** updated properties for all send*append and send*update query to Record Locks = no locks

==== 2018-11-27-1 ====

rolled out Ttenbergen 02:05, 2018 December 1 (CST)

'''Changes collectors will want to know about'''

* sorry guys, this is a big and hard to read one

* '''fixed query [[query check_ICD10_Inf_Infection_req_Pathogen_must_have_one]] which was giving false positives

* '''fixed [[query s_tmp_IICU_consult_DtTm]] which was giving false positives

* '''renamed [[CCI Picklist]] item "Whole body cooling" to [[Targeted Temperature Management (TTM)]]

* '''added [[CCI component 1 codes - what organ was something done to| CCI1 code]] [[(I) Spinal Cord and/or Vertebrae (any segments)]]

* '''added

**''' [[Cannabis/cannabinoids, acute intoxication]]

**''' [[Cannabis/cannabinoids, chronic abuse/dependence/addiction]]

**''' [[Cannabis/cannabinoids, withdrawal]]

* '''changed tab order on [[L ICD10 subform]] to correspond to new field order with prioroty on the left. Ttenbergen 10:02, 2018 November 28 (CST)

* '''renamed

** '''"Intracranial or intraspinous veins or venous sinuses, septic thromboembolism -- incl septic embolism" to [[Intracranial or intraspinous veins or venous sinuses, septic thromboembolism]]

** '''"Chemical gases or fumes or vapors NOS" to "Chemical gases or fumes or vapors NOS, poisoning with non-pharmaceuticals" (or sth)

{{Collapsable

| always= '''a bunch of spelling tweaks in the substance category

| full=

* minor

** "Alcohol (ethanol) intoxication, acute (drunkenness)" to [[Alcohol (ethanol) acute intoxication (drunkenness)]]

** "[[Alcohol (ethanol), poisoning]]" to "Alcohol (ethanol)"

** "Antibiotic or other anti-infective, overdose/toxicity" to [[Antibiotic/antimicrobial, overdose/toxicity]]

** "Antibiotic/anti-infective drug, adverse effect" to [[Antibiotic/antimicrobial, adverse effect]]

** "Anticoagulant drug, adverse effect" to [[Anticoagulant, adverse effect]]

** "Anticoagulant drug, overdose/toxicity" to [[Anticoagulant, overdose/toxicity]]

** "Antineoplastic drug (chemotherapy), adverse effect" to [[Antineoplastic/chemotherapy or immunosuppressive drugs, adverse effect]]

** "Antiseizure drug NOS,, adverse effect" to [[Antiseizure drug NOS, adverse effect]]

** "Aspirin or other salicylate, overdose/toxicity" to [[Aspirin or other salicylate or NSAID, overdose/toxicity]]

** "Aspirin or salicylate or nonsteroidal antiinflammatory drug, adverse effect" to [[Aspirin or other salicylate or NSAID, adverse effect]]

** "Benzodiazepine drug, adverse effect" to [[Benzodiazepine, adverse effect]]

** "Beta-blocker drug, overdose/toxicity" to [[Beta-blocker, overdose/toxicity]]

** "Beta-blocker drug, used appropriately, adverse effect" to [[Beta-blocker, adverse effect]]

** "Calcium channel blocker drug, adverse effect of agent used appropriately" to [[Calcium channel blocker drug, adverse effect]]

** "Calcium channel blocker drug, overdose/toxicity" to [[Calcium channel blocker, overdose/toxicity]]

** "Cardiac drug, adverse effect" to [[Cardiac/cardiovascular drug NOS, adverse effect]]

** "Cocaine intoxication, acute" to [[Cocaine, acute intoxication]]

** "Hallucinogen intoxication, acute" to "Hallucinogen, intoxication, acute"

** "Hallucinogen or psychodysleptic, adverse effect" to [[Hallucinogen, adverse effect]]

** "Hallucinogen or psychodysleptic, overdose/toxicity" to [[Hallucinogen, overdose/toxicity]]

** "Hallucinogen, intoxication, acute" to [[Hallucinogen, acute intoxication]]

** "Hemorrhage, due to anticoagulant drugs" to [[Hemorrhage, due to anticoagulant or thrombolytic drug]]

** "Hormone or hormone agonist drug, adverse effect" to [[Hormone or hormone agonist drug, adverse effect]]

** "Hormone or hormone agonist NOS, overdose/toxicity" to [[Hormone or hormone agonist NOS, overdose/toxicity]]

** "Opioid chronic abuse/dependence/addiction" to [[Opioid/narcotic, chronic abuse/dependence/addiction]]

** "Opioid intoxication, acute" to [[Opioid/narcotic, acute intoxication]]

** "Opioid withdrawal" to [[Opioid/narcotic, withdrawal]]

** "Opioid/narcotic drug, adverse effect" to [[Opioid/narcotic, adverse effect]]

** "Psychotropic/psychiatric drug NOS, overdose/toxicity" to [[Psychiatric drug NOS, overdose/toxicity]]

** "Psychotropic/psychiatric drug NOS,, adverse effect" to [[Psychiatric drug NOS, adverse effect]]

** "Sedative drug NOS, adverse effect" to [[Sedative or hypnotic, adverse effect]]

** "Sedative drug NOS, overdose/toxicity" to [[Sedative or hypnotic, overdose/toxicity]]

** "Sedative or hypnotic chronic abuse/dependence/addiction" to [[Sedative or hypnotic, chronic abuse/dependence/addiction]]

** "Sedative or hypnotic withdrawal" to [[Sedative or hypnotic, withdrawal]]

** "Sedative or hypnotic, acute intoxication" to [[Sedative or hypnotic, acute intoxication]]

** "Spinal cord infarction" to [[Spinal cord infarction, arterial thrombosis or thromboembolism]]

** "Stimulants incl methamphetamine abuse/dependence/addiction" to [[Stimulants incl methamphetamine, chronic abuse/dependence/addiction]]

** "Stimulants incl methamphetamine intoxication, acute" to [[Stimulants incl methamphetamine, acute intoxication]]

** "Stimulants incl methamphetamine withdrawal" to [[Stimulants incl methamphetamine, withdrawal]]

** "Transient ischemic attack (TIA), all types" to [[Transient ischemic attack (TIA), all types]]

** "Tricyclic antidepressant drug, adverse effect" to [[Tricyclic antidepressant, adverse effect]]

** "Tricyclic antidepressant drug, overdose/toxicity" to [[Tricyclic antidepressant, overdose/toxicity]]

** "Xray contrast agent, adverse effect of agent used appropriately" to [[Xray contrast agent, adverse effect]]}}

Changes that are mostly behind the scenes

* Changed codes:

** [[Antiseizure drug NOS, overdose/toxicity]] from 42.7 to 42.6

** [[Sedative or hypnotic, overdose/toxicity]] from nothing to 42.7

** [[Aspirin or other salicylate or NSAID, adverse effect]] from 45.3 to 45.1

** [[Thrombolytic drug, overdose/toxicity]] from T44.5 to T45.6

** [[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)

* [[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

==== 2018-11-27 ====

rolled out Ttenbergen 11:33, 2018 November 27 (CST)

'''Changes collectors will want to know

* '''changed [[Query check ICD10 needs awaiting if TR Dt and Dispo Dt on diff days]]

behind the scenes or minor changes

* tweaked wording of the error message given when a cross check finds an error.

* tweaked the size of the patient viewer form so it fits on a laptop screen without scrolling

==== 2018-11-26-1 ====

rolled out Ttenbergen 22:44, 2018 November 26 (CST)

* more tweaks on [[L ICD10 subform]]

==== 2018-11-26 ====

not rolled out yet Ttenbergen 13:27, 2018 November 26 (CST)

*[[Query check ICD10 needs awaiting if TR Dt and Dispo Dt on diff days]]

==== 2018-11-25 ====

rolled out Ttenbergen 00:27, 2018 November 26 (CST)

'''Changes collectors will want to know about

* '''added to [[s_ICD10 table]]:

** '''[[Anesthetic gas, overdose/toxicity]]

** '''[[Thrombolytic drug, overdose/toxicity]]

** '''[[Antineoplastic/chemotherapy or immunosuppressive drugs, overdose/toxicity]]

** '''[[Neuromuscular blocker/paralytic, overdose/toxicity]]

** '''[[Anticoagulant, adverse effect]]

** '''[[Hallucinogen, adverse effect]]

** '''[[Beta-blocker, adverse effect]]

** '''"Calcium channel blocker drug, adverse effect of agent used appropriately"

** '''"Xray contrast agent, adverse effect of agent used appropriately"

** '''[[Hypergammaglobulinemia]]

** '''[[Bronchitis, chronic, infectious or noninfectious]]

** '''[[Medical problem NOS]]

* '''renamed for consistency in [[s_ICD10 table]]

** '''"Neuromuscular blocking drug, adverse effect" to [[Neuromuscular blocker/paralytic, adverse effect]]

** '''"Solvent (organic)" to "[[Solvent (organic, inhaled or ingested), poisoning]] by non-pharmaceutialcs" or similar

** '''"Alcohol (ethanol) acute intoxication (drunkenness)" to [[Alcohol (ethanol) acute intoxication (drunkenness)]]

* '''changed all ICD10 dxs named "*, overdose/poisoning" to "*, overdose/toxicity"

* '''changed all ICD10 dxs named "*, poisoning/toxic effect" to "*"

* '''changed all ICD10 dxs named "*, used appropriately, adverse effect \(reaction, allergy, hypersensitivity\)" to "*, adverse effect", and added [[Template:ICD10 Guideline adverse effect]] to contain the instruction that was implied in the name before.

* '''re-imported CCI and ICD10 categories

==== 2018-11-23 ====

rolled out Ttenbergen 22:11, 2018 November 24 (CST)

'''Changes collectors will want to know about

* '''updated [[L ICD10 subform]] to better group dxs by type and colour, I'd like some feedback please at [[L ICD10 subform]].

* '''added [[Chest tube, left in place]] to [[s_CCI_Picklist table]]

* '''added [[query check ICD10 ESRD vs kidney transplant]]

* '''added "query check awaiting must have Transfer Ready DtTm"

* '''added [[query check VAP admit must be from ICU]]

* '''added [[query check ICD10 chronic vent acute resp failure]]

* '''added "query check ICD10 ESRD vs AP CRF"

* '''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]]

* '''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

Behind the scenes changes:

* removed old, unused queries:

** query Check_Dx_UniqueDx

** query Check_Dx_UniquePriority

** query Check_Como_Unique

* removed the Vic locations and added the STB Med locations to [[s_locations_allowed_collection table]]

* made inactive [[AcceptDateSource]] that was stopped in March

==== 2018-11-22 ====

rolled out

* re-imported CCI and ICD10 categories once more.

* fixed spelling "Respiratory syncitial virus (RSV)" to [[Respiratory syncytial virus (RSV)]]

==== 2018-11-21 ====

rolled out Ttenbergen 18:52, 2018 November 21 (CST)

* tweaked to only compare same dx types:

**[[Check Inf Infection with implied pathogen must not have a pathogen combined code]]

**[[ query Check_Inf_Pathogens_must_have_Infection_requiring_pathogen_or_Potential_Infection]]

**[[query check_ICD10_Inf_Infection_req_Pathogen_must_have_one]]

**[[Check Inf Antibiotic resistance must have pathogen or Infection with implied pathogen]]

* re-imported CCI and ICD10 categories once more.

==== 2018-11-19 ====

rolled out Ttenbergen 22:12, 2018 November 20 (CST)

changes collectors will want to know about

* ''' none, only fixes this time

behind the scenes changes

* changed how errors are displayed to provide a clickable URL to the wiki page for the error function Reject_a_query and function Reject_a_query_PatID

* updated [[ICD10 Categories for CCMDB.accdb]]

* updated [[CCI Categories for CCMDB.accdb]]

* updated [[query Check_Inf_Pathogens_must_have_Infection_requiring_pathogen_or_Potential_Infection]] to not trigger for [[:Category:Double duty pathogen]]

* updated [[Check Inf Infection with implied pathogen must not have a pathogen combined code]] to not compare a dx with itself

~~Enter '''[[requested CCMDB changes for~~ the ~~next version]]''' in that article.~~

==== 2018-11-19 ====

rolled out Ttenbergen 09:10, 2018 November 19 (CST)

* several minor tweaks to the last round of queries

== ~~Versions~~ ==

==== 2018-11-13 ====

==== ~~next~~ ====

rolled out Ttenbergen 00:42, 2018 November 19 (CST)

* ~~update component 2 on~~ [[~~L_CCI_Component_subform~~]] so it only ~~lists what~~ is ~~allowed~~. ~~This turns~~ out ~~to be tricky~~...

'''Collectors will want to know:

* ~~review and fix~~ [[~~L_ICD10_APACHE_Dx~~ query]]

* '''added infection cross-checks:

* ~~tab order~~

** '''[[Check Inf Infection with implied pathogen must not have a pathogen combined code]]

* start cross ~~checks~~

** '''[[query Check_Inf_Pathogens_must_have_Infection_requiring_pathogen_or_Potential_Infection]]

* ~~Change~~ code ~~names~~ for [[CCI ~~Procedures coded once per ward admission~~]] to ~~include something like~~ (~~1ce~~)

** '''[[query check_ICD10_Inf_Infection_req_Pathogen_must_have_one]]

* ~~after fixing~~ the ~~CCI page names~~ on ~~wiki~~, '''~~add~~ wiki link for ~~CCI codes~~ in ~~CCMDB~~.~~mdb'''~~

** '''[[Check Inf Antibiotic resistance must have pathogen or Infection with implied pathogen]]

* cross check for ~~properly combined CCI codes~~. (~~TDI~~)

* '''added "consult unknown" option to [[IICU consult]]

* ~~fix~~ [[~~CCMDB~~.~~mdb links to CCMDB wiki~~]]

* '''added [[query check_CCI_from_OR_no_CCI]]

* '''updated [[CCI Chooser form]] to include a category filter for CCI 1 items

* '''added [[CCI_Pick_Chooser form]] to include a category filter for CCI Picklist items

* '''updated [[s_ICD10 table]]: fixed spelling for "Pruritis (itching)" to [[Pruritus (itching)]]

* '''added [[Check if awaiting code is primary dx then Transfer Ready DtTm must be equal to Arrive DtTm]]

* '''retired [[Whole body warming - incl extracorporeal warming of blood]] which will no longer be needed after re-definition of [[Targeted Temperature Management (TTM)]]

* '''updated [[Proposed Notes field default]] as requested

Behind the scenes stuff...

* tweaked [[Query check_ICD10_Comorbids_NoComo_code_but_others]] which was giving error

==== 2018-11-12 ====

rolled out Ttenbergen 20:00, 2018 November 12 (CST)

Changed collectors should know about:

* '''implemented data integrity checks:'''

**

** '''[[Query check_ICD10_Comorbids_Dx_present]]

** '''[[Query check_CCI_must_have_entry]]

Behind the scenes changes:

* implemented function include_pt() to be able to only check patients with Pat_ID ending in 8, and later be able to change it to all patients by single place edit.

* deleted old temporary query "2018_04_03_L_ICD10_translator"

* imported from [[CFE]] [[query L_CCI_Combined]] and its subquery L_CCI_Combined_ComponentSubQ]]

* tweaked [[query check_dx_primary_not_exactly_one]] so it will only consider [[Admit Diagnosis]]

==== 2018-11-08-1 ====

rolled out Ttenbergen 20:54, 2018 November 9 (CST)

* update to [[IICU consult]], added new options and [[Query s tmp IICU consult DtTm]] cross check

* Added % of body area burn codes as discussed at task meeting

** T31.00: [[Burns, up to 9% or unspecified body surface area involved]]

** T31.10: [[Burns, 10-19% body surface area involved]]

** T31.20: [[Burns, 20-29% body surface area involved]]

** T31.30: [[Burns, 30-39% body surface area involved]]

** T31.40: [[Burns, 40-49% body surface area involved]]

** T31.50: [[Burns, 50-59% body surface area involved]]

** T31.60: [[Burns, 60-69% body surface area involved]]

** T31.70: [[Burns, 70-79% body surface area involved]]

** T31.80: [[Burns, 80-89% body surface area involved]]

** T31.90: [[Burns, 90% or more body surface area involved]]

* spelling fix from "entercolitis" -> [[Colitis, enteritis, enterocolitis, or gastroenteritis, noninfectious NOS]]

==== 2018-11-08 ====

rolled out Ttenbergen 22:06, 2018 November 8 (CST)

Changes Collectors should know about:

* updated Function cb_addPt_Click() which runs when "Add Patient" button is clicked to set the default entry for the [[Notes field]] as per [[Proposed Notes field default]]

* renamed "Aspiration pneumonitis/pneumonia" to [[Aspiration pneumonitis]]

* updated [[CCI Picklist]] as discussed:

** "AXR (abdominal plain X-ray)" --> [[AXR (abdominal plain X-ray)]]

** "Administration of intravenous immunoglobulin" --> [[IVIG (IV administration of immunoglobulin)]]

** "Angiogram of artery NOS (except specifically coded)" --> [[Angiogram, artery NOS (except specifically coded)]]

** "Angiogram of vein" --> [[Angiogram, vein]]

** "Aortic angiogram (any part of aorta)" -->[[ Angiogram, aortic (any part of aorta)]]

** "Bone marrow transplant or transfusion" --> [[BMT (Bone marrow transplant or transfusion)]]

** "Cardiac pressure measurements via a catheter in cath lab - incl right heart cath done for pressures and C.O." --> "Cardiac pressure measurements via catheter (done in cath lab)"

** "Cardiac stress test" --> [[Cardiac stress test (any kind)]]

** "Cardioversion -- excl defibrillation which we are not tracking separately --> [[Cardioversion (EXCLUDE defibrillation-we are not tracking)]]

** "Cerebral angiogram (including vertebral arteries)" --> [[Angiogram, cerebral (including vertebral arteries)]]

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

** "Coronary angioplasty with stenting" --> [[Angioplasty, coronary (with stenting)]]

** "Coronary angioplasty without stenting" --> [[Angioplasty, coronary (without stenting)]]

** "CRRT -- incl for volume removal via PRISMA device" --> [[CRRT (incl volume removal via PRISMA device)]]

** "CT Cardiac or CT Cardiac angiogram w or wo coronary arteries" --> [[Cardiac CT or Cardiac CT angiogram (with or without coronary arteries)]]

** "CXR plain film" --> [[CXR (plain film)]]

** "Diagnostic abdominal paracentesis" --> [[Paracentesis (diagnostic)]]

** "Diagnostic lumbar puncture" --> [[LP (lumbar puncture, diagnostic)]]

** "Diagnostic thoracentesis" --> [[Thoracentesis (diagnostic)]]

** "Echocardiogram of heart" --> [[ECHO (echocardiogram of heart)]]

** "Electroconvulsive (shock) Therapy to Brain" --> [[ECT (Electroconvulsive shock therapy to brain)]]

** "Hemodialysis (intermittent)" --> [[HD (Hemodialysis)]]

** "Mechanical ventilation, noninvasive" --> [[BiPAP, CPAP, NIV, own ventilator (Mechanical ventilation, noninvasive)]]

** "Non-Cesarean delivery (therapeutic) -- note separate code for Cesarean delivery" --> [[SVD (Spontaneous vaginal delivery)]] (I left out the "therapeutic" what does that even mean in this case...)

** "Peritoneal dialysis" --> [[PD (Peritoneal dialysis)]]

** "Placement of implanted (invasive) intracranial pressure monitoring device" --> [[ICP monitor (Placement of implanted, invasive intracranial pressure monitoring device)]]

** "Polysomnogram (done in Miseracordia Sleep lab)" --> [[Sleep Study (Polysomnogram, done in Miseracordia Sleep lab)]]

** "Pulmonary artery angiogram (pulmonary arteriogram)" --> [[Angiogram, pulmonary artery (pulmonary arteriogram)]]

** "Total parenteral nutrition (TPN)" --> [[TPN (Total parenteral nutrition)]]

==== 2018-11-07-1 ====

rolled out Ttenbergen 11:20, 2018 November 7 (CST)

* updated [[query check_CCI_CRRT_vs_Tmp]] to only trigger at HSC Ttenbergen 11:20, 2018 November 7 (CST)

==== 2018-11-07 ====

rolled out Ttenbergen 11:13, 2018 November 7 (CST)

* tweaked queries, it used field named Pat_ID field more than once, which was giving collectors errors:

** [[query check_AIDS_vs_HIV]]

** [[query check_cooling_vs_arrest]]

* tweaked error msg for [[Query_check_CCI_Date]]

==== 2018-11-05 ====

rolled out Ttenbergen 13:45, 2018 November 6 (CST)

''' when this rolls I need to test that the Windows 10 folks now get the log showing up '''

* '''Collection changes''':

** added [[IICU consult]] to [[s_tmp table]]

** added [[Query check_CCI_CRRT_vs_Tmp]] - '''you will need to start entering CCI entries for all CRRT patients'''

** added "Query s tmp QASeptic Dx no tmp", [[Query s tmp QASeptic tmp no dx]] checks for ICD10; '''[[QA Septic Shock]] will now also cross check against ICD10 diagnoses'''

** added [[Query check_cooling_vs_arrest]] - you can only use [[Targeted Temperature Management (TTM)]] if you have a [[Cardiac arrest]] dx in ICD10

** added [[Query check_AIDS_vs_HIV]] - can't code [[HIV infection, asymptomatic]] and [[AIDS (disease due to HIV)]] for same record

** added [[Check eliminated dx]] for ICD10 and CCI (query check_eliminated_ICD10, query check_eliminated_CCI_Pick, query check_eliminated_CCI_Comp

* other changes (minor, might be visible but should not require change in collection)

** updated description for renal codes in [[s_ICD10 table]] so they sort in order 1-5, thanks for the thought on how to do this Trish

*** Chronic kidney disease (chronic renal insufficiency, uremia) Stage 1

*** Chronic kidney disease (chronic renal insufficiency, uremia) Stage 2

*** Chronic kidney disease (chronic renal insufficiency, uremia) Stage 3

*** Chronic kidney disease (chronic renal insufficiency, uremia) Stage 4

==== 2018-11-02 ====

'''rolled out''' - [[User:PTorres|PTorres]] 09:55, 2018 November 2 (CDT)

*Added in s_Record Status "Discontinued"

*Updated hospital names in [[s_dispo table]] done by Julie Mojica

==== 2018-10-30 ====

rolled out Ttenbergen 11:31, 2018 October 31 (CDT)

* Added [[Diabetes mellitus acute complication: Non-ketotic hyperosmolar state]]

* Renamed the following dxs:

**[[Diabetes mellitus chronic complication: Nephropathy]] from "Diabetes chronic complication: Nephropathy"

**[[Diabetes mellitus chronic complication: Retinopathy]] from "Diabetes chronic complication: Retinopathy"

**[[Diabetes mellitus chronic complication: Neuropathy]] from " Diabetes chronic complication: Neuropathy"

**[[Diabetes mellitus chronic complication: Cardiovascular]] from "Diabetes chronic complication: Cardiovascular"

**[[Diabetes mellitus chronic complication: Musculoskeletal]] from "Diabetes mellitus chronic complication: Musculoskeletal"

**[[Diabetes mellitus chronic complication NOS]] from "Diabetes mellitus chronic complication NOS"

**[[Diabetes mellitus chronic complication: Foot ulcer]] from "Diabetes chronic complication: Foot ulcer"

==== 2018-10-30 ====

rolled out Ttenbergen 09:36, 2018 October 30 (CDT)

* further tweaking of notes field checks: commented out requery command that was causing re-set of form on tabbing out. Will need to find out a way to write before requery.Ttenbergen 09:36, 2018 October 30 (CDT)

==== 2018-10-26-1 ====

rolled out Ttenbergen 12:12, 2018 October 29 (CDT)

* changed function notes checker to requery data before checking it to prevent the error were getting when leaving notes field if there was bad data in WBC

* deleted old tables ''send_dxs_acqu'' and ''send_pharm''

* updated sending so that database gets closed after tables are linked (to clean up)

* changed queries ODBC Timeout to 120 to see if this will improve the disconnect network problem

* updated error email when sending goes wrong in hopes that now it will show the proper error Nr, not zero.

* updated L_ICD10_subform to default sort to

** Dx type (admit, …)

** Priority

** Date

** Description

==== 2018-10-26 ====

rolled out Ttenbergen 11:54, 2018 October 26 (CDT)

* reverted to 2015-10-17 due to problems introduced by ..-24

* re-imported from newer version [[Query check dx primary lowest priority]]

* re-applied ADL hiding from prev version

* re-applied picklist name fixes

* re-applied patient list wiki link update

==== 2018-10-25 ====

not rolled yet Ttenbergen 10:32, 2018 October 25 (CDT)

* updated Function runQuery to give more meaningful error when there is a problem during sending. Ttenbergen 10:32, 2018 October 25 (CDT)

* updated form [[Patient List]] to change the wiki links to the little icons like in form patient viewer. Corrected link to [[LastChanged DtTm field]]. Ttenbergen 16:22, 2018 October 25 (CDT)

==== 2018-10-24 ====

rolled out Ttenbergen 09:39, 2018 October 25 (CDT)

* updated [[s_CCI_Picklist table]] entries to be same as on wiki for:

** "Cardiac electrophysiology study (done in cath lab; for arrythmia mapping)" --> [[Cardiac electrophysiology study]]

** "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)

* 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)

==== 2018-10-17 ====

rolled out Ttenbergen 10:03, 2018 October 22 (CDT)

* improved error message for [[Query_check_CCI_Date]]. Ttenbergen 10:20, 2018 October 17 (CDT)

* made inactive the entries in [[s_tmp table]] for projects we are not doing any longer:

** [[Influenza treated]]

** [[Influenza tracking]]

* updated [[Query check ICD10 duplicates]] to also check for priorities; had to allow duplicate pathogens that way because pt might have e.g. two "unknown pathogen" entries. Ttenbergen 10:02, 2018 October 22 (CDT)

==== 2018-10-15-2 ====

rolled out Ttenbergen 22:46, 2018 October 15 (CDT)

* Corrected the bug where an [[Acquired Procedure]] on the arrive day would raise an error in [[Query check CCI Date]].

* ~~'''NEED TO FINISH''': messed around with the error message~~ in ~~sending but '''this is not done yet''', waiting for more info from a collector.~~

==== 2018-10-15-1 ====

rolled out Ttenbergen 15:59, 2018 October 15 (CDT)

* fixed sort buttons in [[L_ICD10_subform]]

==== 2018-10-15 ====

rolled out Ttenbergen 15:12, 2018 October 15 (CDT)

* made unavailable/expired [[No procedure performed]] from [[s_CCI_2 table]], it should not even have been there. Ttenbergen 14:16, 2018 October 15 (CDT)

==== 2018-10-11 ====

~~not~~ rolled ~~yet -~~ Ttenbergen 17:00, 2018 October 11 (CDT)

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

* in [[s_ICD10 table]], changed following to omit "or current use"

* '''relevant to collectors: '''

** [[Past history of immunosuppressive drugs or corticosteroids]]

** implemented CCI cross checks:

** [[Past history of radiation therapy]]

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

** [[Past history of chemotherapy for neoplastic disease]]

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

* updated Sub Send_Data() to stop sending when there is an error, i.e. records will not ~~be set~~ to ~~"sent". This means collectors will~~ be ~~able to re-send without having~~ to ~~engage Pagasa. This should have been that way all along, but had not been previously. Ttenbergen 17~~:~~58, 2018 October 11 (CDT)~~

*** [[Query check CCI Component duplicates]]

* updating a bunch of old code to improve error handling, should be invisible to collectors

*** [[Query check CCI Picklist duplicates]]

* removed a bunch of old calls to err_logger that did nothing from:

*** [[Query check CCI no admin entries]]

** Function get_a_info

*** [[Query check CCI Component unfilled]]

** Function initial_control_empty_check

*** [[Query check CCI Picklist unfilled]]

** Sub LabCheck

*** [[Query check CCI Date]]

** Validate_PHIN

** in [[s_ICD10 table]], changed following to omit "or current use"

** Function Reject_a_query

*** [[Past history of immunosuppressive drugs or corticosteroids]]

** Function Reject_a_query_PatID

*** [[Past history of radiation therapy]]

** Function reject_pharm

*** [[Past history of chemotherapy for neoplastic disease]]

** Function reject_lab

** updated Sub Send_Data() to stop sending when there is an error, i.e. records will not

** Sub Convert_DB()

** changed all label links on ICD10, CCI, dispo tabs and registry top of screen to plain labels with link button; added link buttons to ADLs

* deleted Function Reject_too_many that is no longer used

*Should not be visible to collecors:

** updating a bunch of old code to improve error handling, should be invisible to collectors

** removed a bunch of old calls to err_logger that did nothing from:

*** Function get_a_info

*** Function initial_control_empty_check

*** Sub LabCheck

*** Validate_PHIN

*** Function Reject_a_query

*** Function Reject_a_query_PatID

*** Function reject_pharm

*** Function reject_lab

*** Sub Convert_DB()

** deleted Function Reject_too_many that is no longer used

==== 2018-10-09 ====

Line 73:

Line 520:

** query s_tmp_Service_Sending_to_ICU_duplicate

* updated [[Check duplicate patient]] to properly accommodate [[PHIN_field#Location_Manitoba_and_no_PHIN]]

* [[CCMDB.~~mdb~~ 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.~~mdb~~ links to CCMDB wiki]].

* [[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 ~~[[Check fundamentals for CCI]]~~

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

* implemented checks and added to Sub Dx_Checker():

* [[Query check_dx_primary_lowest_priority]]

Line 116:

Line 563:

==== 2018-07-31 ====

rolled out Ttenbergen 20:23, 2018 July 31 (CDT)

* in [[s_ICD10 table]], corrected duplicate entry: set retired date for [[Drug or biological substance/agent NOS ~~used appropriately~~, adverse effect ~~(reaction, allergy, hypersensitivity)~~]] with code T88.7; the one with Y57.8 remains available.

* in [[s_ICD10 table]], corrected duplicate entry: set retired date for [[Drug or biological substance/agent NOS, adverse effect]] with code T88.7; the one with Y57.8 remains available.

==== 2018-07-26 ====

rolled out Ttenbergen 18:50, 2018 July 29 (CDT)

* in [[s_CCI_Picklist table]]

** changed "" to [[CT Cardiac or CT ~~Cardiac~~ angiogram w or wo coronary arteries]] to list it closer to [[CT of chest with PE protocol (CT angiogram of pulmonary vessels)]].

** changed "" to [[Cardiac CT or Cardiac CT angiogram (with or without coronary arteries)]] to list it closer to [[CT of chest with PE protocol (CT angiogram of pulmonary vessels)]].

* in [[s_ICD10 table]]:

** renamed "Uterus/cervix NOS, benign neoplasm" to [[Uterus/cervix NOS, benign neoplasm]]

Line 142:

Line 589:

rolled out Ttenbergen 11:46, 2018 July 17 (CDT)

* in [[s_CCI_Picklist table]]:

** renamed "Cardiac CT or CT angiogram" to "CT Cardiac or CT ~~Cardiac~~ angiogram w or wo coronary arteries"

** renamed "Cardiac CT or CT angiogram" to "Cardiac CT or Cardiac CT angiogram (with or without coronary arteries)"

* in [[s_ICD10 table]]:

** added [[Hypoalbuminemia, severe]]

Line 152:

Line 599:

rolled out Ttenbergen 16:44, 2018 July 11 (CDT)

* in [[s_ICD10 table]]:

** changed "Coronary angiogram (diagnostic cardiac catherization)" to [[~~Coronary angiogram~~ (diagnostic cardiac catheterization)]]

** changed "Coronary angiogram (diagnostic cardiac catherization)" to [[Angiogram, coronary (diagnostic cardiac catheterization)]]

** added

*** [[Hypoalbuminemia, severe]]

*** [[Infestation, NOS]]

*** [[Stimulants incl methamphetamine ~~intoxication~~, acute]]

*** [[Stimulants incl methamphetamine, acute intoxication]]

*** [[Stimulants incl methamphetamine abuse/dependence/addiction]]

*** [[Stimulants incl methamphetamine, chronic abuse/dependence/addiction]]

*** [[Stimulants incl methamphetamine withdrawal]]

*** [[Stimulants incl methamphetamine, withdrawal]]

* in [[s_CCI_1 table]]:

** changed procedure names to replace "lower limb" with leg, "upper limb" with arm, to make consistent among procedures; new codes are:

Line 215:

Line 662:

** changed "Obesity, NOS (BMI 30.0 to 30.9)" to [[Obesity, NOS (BMI 30.0 to 39.9)]]

** changed "Parthyroid gland, primary malignancy" to [[Parathyroid gland, primary malignancy]]

** updated code for U22.8 ([[Mixed pathogens, speciation not done or reported]], it had a tab character as first character

** updated code for U22.8 ("Mixed pathogens, speciation not done or reported", it had a tab character as first character

* in [[L_ICD10 subform]], added code to prevent error and give meaningful error msg when someone tries to simply delete a dx entry rather than the whole row. Ttenbergen 10:31, 2018 May 30 (CDT)

* in [[L_CCI_Picklist subform]], added code to prevent error and give meaningful error msg when someone tries to simply delete a dx entry rather than the whole row.

Line 224:

Line 671:

* in [[s_dispo table]], changed "VIC - UC" to "VIC - UC" so it sorts to the top. Ttenbergen 16:53, 2018 May 24 (CDT)

* in [[s_CCI_Picklist table]],

** changed to [[CRRT -- incl ~~for~~ volume removal via PRISMA device]] from "Continuous renal replacement therapy -- incl for volume removal via PRISMA device"

** changed to [[CRRT (incl volume removal via PRISMA device)]] from "Continuous renal replacement therapy -- incl for volume removal via PRISMA device"

** changed to [[Blood gas, arterial]] from "Arterial blood gas"

** changed to [[Blood gas, venous]] from "Venous blood gas"

Line 231:

Line 678:

rolled out Ttenbergen 18:23, 2018 May 16 (CDT)

* in [[s_CCI_Picklist table]]

** fixed spelling for [[Angiogram of artery NOS (except specifically coded)]], which had been ''Angiogram of artery NOS (except spefifically coded)'' in CCMDB.mdb Ttenbergen 10:39, 2018 May 9 (CDT)

** fixed spelling for [[Angiogram, artery NOS (except specifically coded)]], which had been ''Angiogram of artery NOS (except spefifically coded)'' in CCMDB.mdb Ttenbergen 10:39, 2018 May 9 (CDT)

** added [[Transfusion of albumin]] Ttenbergen 12:38, 2018 May 16 (CDT)

* in [[s_AllDiagnoses table]] fixed spelling for

Line 275:

Line 722:

* in [[s_CCI_Picklist table]], added:

** [[Mechanical ventilation, noninvasive]]

** [[BiPAP, CPAP, NIV, own ventilator (Mechanical ventilation, noninvasive)]]

** [[ECMO, VA]]

** [[ECMO, VV]]

Line 290:

Line 737:

** [[Physical rehabilitation care]] code changed from Z50 to Z50.1, definition etc updated on the wiki. Ttenbergen 14:28, 2018 April 25 (CDT)

** added [[Other type of infectious organism, NOS‎‎]] splitting up "Infectious disease NOS OR for buglist organism NOS" into this new one and [[Infectious disease NOS]] Ttenbergen 16:06, 2018 April 25 (CDT)

** added [[Mixed pathogens, speciation not done or reported]]

** added "Mixed pathogens, speciation not done or reported"

* in [[s_dispo table]]

** allowed GRA_CAU, HSC_CAU, STB_CAU as [[Dispo]]

Line 301:

Line 748:

** deleted "Removal of Internal Device"

* in [[s_ICD10 table]]:

** changed "Acetaminophen used appropriately (tylenol, paracematol), adverse effect (reaction, allergy, hypersensitivity)" to [[Acetaminophen (tylenol, paracematol) ~~used appropriately~~, adverse effect ~~(reaction, allergy, hypersensitivity)~~]] for naming consistency, updated wiki.

** changed "Acetaminophen used appropriately (tylenol, paracematol), adverse effect (reaction, allergy, hypersensitivity)" to [[Acetaminophen (tylenol, paracematol), adverse effect]] for naming consistency, updated wiki.

** moved "Psychiatric drug NOS, ~~overdose/poisoning~~" to [[~~Psychotropic/psychiatric~~ drug NOS, overdose/~~poisoning~~]] for naming consistency, updated wiki.

** moved "Psychiatric drug NOS, adverse effect" to [[Psychiatric drug NOS, overdose/toxicity]] for naming consistency, updated wiki.

* in [[s_tmp table]]

** added records for [[Septic Shock Order Set]] Ttenbergen 09:12, 2018 April 19 (CDT)

Line 311:

Line 758:

** added [[Pharmacotherapy, thrombolytic agent]] to be able to code such things as "MI aborted with TPN" (I have cleaned up the page that had been made just for that purpose.) Ttenbergen 12:50, 2018 April 11 (CDT)

* in [[S_CCI_1 table]]:

** updated " (T) Abdominal Cavity, NOS" to [[ (T) Abdominal or Pelvic Cavity, NOS]]

** updated " (T) Abdominal Cavity, NOS" to "(T) Abdominal or Pelvic Cavity, NOS"

** updated " (D) Abdominal Cavity, NOS" to [[ (D) Abdominal or Pelvic Cavity, NOS]]

** updated " (D) Abdominal Cavity, NOS" to "(D) Abdominal or Pelvic Cavity, NOS"

* in [[s_dispo table]]:

** updated "HSC - Interventional Radiology" and "STB - Interventional Radiology" to fill "site" field with hospital, and to allow as [[Dispo]]

Line 329:

Line 776:

rolled out.[[User:TOstryzniuk|Trish Ostryzniuk]] 16:21, 2018 April 10 (CDT)

* add New Tmp project: [[ICUotherService].-- [[User:TOstryzniuk|Trish Ostryzniuk]] 16:16, 2018 April 10 (CDT)

* renamed AXR plain film to [[Abdominal plain X-ray (AXR)]]

* renamed AXR plain film to "Abdominal plain X-ray (AXR)"

==== 2018-04-09-1 ====

Line 350:

Line 797:

* updated [[s_dispo table]]: disabled "VIC - ER" Ttenbergen 13:44, 2018 April 6 (CDT)

* updated [[s_ICD10 table]]:

** set end date for "Y57.8 - Drug NOS ~~used appropriately~~, adverse effect ~~(reaction, allergy, hypersensitivity)~~" to today Ttenbergen 13:50, 2018 April 6 (CDT)

** set end date for "Y57.8 - Drug NOS, adverse effect" to today Ttenbergen 13:50, 2018 April 6 (CDT)

** deleted ICD10_ID field since we won't be using it now (coding actual ICD10 code instead)

Line 397:

Line 844:

not rolled yet Ttenbergen 17:46, 2018 March 22 (CDT)

* changed [[L_CCI_Picklist subform]] dropdown to sort first by catgory, then by description, making it alphabetical. Was sorted by code but that made no sense Ttenbergen 17:46, 2018 March 22 (CDT)

* added 1.LZ.35.HH-C6 [[Total parenteral nutrition ~~(TPN~~)]] to [[s_CCI_Picklist table]]

* added 1.LZ.35.HH-C6 [[TPN (Total parenteral nutrition)]] to [[s_CCI_Picklist table]]

* in [[s_ICD10 table]] fixed spelling for

** [[Raynaud's syndrome/phenomenon]] Ttenbergen 18:42, 2018 March 22 (CDT)

Line 495:

Line 942:

rolled out Ttenbergen 18:01, 2018 January 10 (CST)

* added "negative" for [[Influenza tracking]]

* Implemented as query check_ER_Delay_not_too_big.[[ER Delay]]

* Implemented as "query check_ER_Delay_not_too_big".[[ER Delay]]

=== 2018-01-09 ===

rolled out Ttenbergen 09:18, 2018 January 9 (CST)

*Added Awaiting Codes:

*Added [[:Category:Awaiting/delayed transfer | Awaiting Codes]]:

** [[Awaiting/delayed transfer to home]]

** [[Awaiting/delayed transfer to long-term care/PCH]]

** "Awaiting/delayed transfer to long-term care/PCH"

** [[Awaiting/delayed transfer to other acute care facility]]

** "Awaiting/delayed transfer to other acute care facility"

** [[Awaiting/delayed transfer to transitional care facility]]

** "Awaiting/delayed transfer to transitional care facility"

=== 2018-01-04 ===

Line 527:

Line 974:

* [[ACCU borrow]] - fix to cross check query ''s_tmp_ACCU_Borrow_chronicity_hard''; was using obsdate and obstime, when it should have used date_var and time_var. Ttenbergen 13:13, 2018 January 4 (CST)

[[Category: CCMDB.~~mdb~~]]

[[Category:CCMDB.accdb]]

[[Category: Change Logs CCMDB]]

@@ Line 1: / Line 1: @@
 __NOTOC__ <!-- This hides the table of contents so collectors can immediately see the most recent change without scrolling. -->
-'''''see [[Log (disambiguation)]] for other uses of the term "Log"
+See [[Log (disambiguation)]] for other uses of the term "Log". See the [[:Category: Development Documentation | Development Documentation Category]] for other development logs''. See [[Rolling out changes]] for the process of rolling out changes. Enter '''[[requested CCMDB changes for the next version]]''' in that article.
-''see the [[:Category: Development Documentation | Development Documentation Category]] for other development logs''. See [[Rolling out changes]] for the process of rolling out changes.
-The CCMDB.mdb '''Change Log''' logs changes made to the CCMDB.mdb. New entries should be made at the top to be immediately apparent.
+== Versions ==
+==== 2018-12-21 ====
+rolled out Ttenbergen 21:19, 2019 January 1 (CST)
+Changes collectors will want to know about:
+* in [[s_ICD10 table]]
+** '''changed "Awaiting/transfer to other care facility (acute or chronic)" to "Awaiting/delayed transfer to other care facility NOS"
+** '''added [[Inflammatory/immune arthritis, NOS]]
+** '''retired [[Renal dialysis care, including dialysis itself]]
+* in [[s_dispo table]], '''added "Institution NOS" as option for [[Previous Location]] / [[dispo]] option
+* in [[S_CCI_2 table]]
+** '''retired [[Installation of External Appliance]]
+** '''added [[Debridement]] to allow for first-only coding
+* '''added cross check:
+** [[Query check_ICD10_ESRD_vs_ARF ]]
+* '''made [[IABP project]] inactive in [[s_tmp table]]
+Changes behind the scenes:
+'''Collectors will only care about these if they went wrong...'''
+* updated cross-checks to ICD10/CCI:
+** [[Query s tmp QAInf dx no tmp]]: changed query s_tmp_QAInf__dx to use ICD10 codes
+** [[Check if awaiting code is primary dx then Transfer Ready DtTm must be equal to Arrive DtTm]] - needed a tweak for the right codes, and VBA code to actually call it
+** [[Query s tmp QASeptic tmp no dx]]
+** "Query s tmp QASeptic Dx no tmp ICD10ICD10" - removed call to pre-ICD10 portion
+** [[Query check_CCI_must_have_entry]] - made it so it applies to all pts with [[Dispo DtTm]] > 2019-01-01 not those ending w. 8
+** [[Query check_ICD10_Comorbids_Dx_present]] - made it so it applies to all pts with [[Dispo DtTm]] > 2019-01-01 not those ending w. 8
+* retired as part of moving to ICD10/CCI
+** [[Check BRR/XBR vs cardiac arrest dx]] - retired and replaced
+** [[Check Function Panelling admit transfer same]] - retired and replaced
+** [[Query check ApARF CRF]] - retired and replaced
+** [[Query Check Renal IncompatibleDxs]]
+* commented out much general code in sub DX_Checker and sub Como_Checker
+* Charlson implementation:
+** 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
+* re-imported [[CCI Categories for CCMDB.accdb]] and [[ICD10 Categories for CCMDB.accdb]]
+==== 2018-12-20-2 ====
+rolled out Ttenbergen 21:27, 2018 December 20 (CST)
+'''Change collectors will want to know about:
+*''' updated [[L_CCI_Picklist_subform]] to show the respective [[CCI Collection Mode]].
+behind the scenes...
+* re-imported [[CCI_Categories_for_CCMDB.accdb]] and [[ICD10 Categories for CCMDB.accdb]]
+==== 2018-12-20 ====
+rolled out Ttenbergen 10:12, 2018 December 20 (CST)
+* added to [[S ICD10 table]]: [[Nosocomial infection, NOS]]
+==== 2018-12-17 ====
+rolled out Ttenbergen 22:31, 2018 December 18 (CST)
+Changes Collectors will want to know about:
+* '''added to [[S_CCI_Picklist table]]
+** [[Swan-Ganz (Pulmonary Artery Flotation) Catheter placement]]'''
+** [[CVC placement, any location]]
+** [[Arterial catheterization, any location]]
+** [[Arthrocentesis, diagnostic]]
+* '''retired''' from [[S_CCI_Picklist table]]:
+** [[Bronchial thermoplasty]]
+** [[Liver dialysis]]
+** [[Pharmacotherapy, antineoplastic agent, whole body]]
+** [[Pharmacotherapy, immunostimulant, whole body]]
+** [[Pharmacotherapy, immunosuppressive, whole body]]
+** [[Obstetrical Ultrasound (diagnostic imaging)]]
+** [[Obstetrical Imaging NOS (diagnostic imaging)]]
+* '''renamed''' in [[S_CCI_Picklist table]]:
+** "Cardiac pressure measurements via catheter (done in cath lab)" to [[Right heart catheterization, in cardiac cath lab]]
+*  '''added to [[S CCI 1 table]]''':
+** [[(T) Soft Tissue and Muscle of the Hip and Thigh]]
+==== 2018-12-14 ====
+rolled out Ttenbergen 20:22, 2018 December 16 (CST)
+Changes collectors will want to know about:
+* in [[S CCI Picklist table]]:
+** switched codes for the following pxs because they were initially set up backwards. For collectors this might mean that if you had entered ...with stenting it will now be ...without stenting, and vice versa.
+** fixed spelling of ""Cardiac nulcear scan (e.g. MUGA)"" to [[Cardiac nuclear scan (e.g. MUGA)]]
+** [[Angioplasty, coronary (with stenting)]]
+** [[Angioplasty, coronary (without stenting)]]
+* [[ICUotherService]] project: added option "CICU under ACCU service"
+* [[STB Medicine workload splitting]]: added STB_EMIPa, STB_EMIPb, STB_EMIPd
+** to [[S dispo table]]
+** to [[s_locations_allowed_collection table]]
+==== 2018-12-04 ====
+rolled out Ttenbergen 10:23, 2018 December 4 (CST)
+* '''reduce the number of times that the ER Delay error shows up '''
+** moved the call for "Query check_ER_Delay_not_too_big" from Function Dispo_Chronological to Function Validate_Accept_DtTm.
+==== 2018-12-02 ====
+ SEE THE NEXT CHANGE AS WELL, BOTH DONE THIS WEEKEND
+rolled out Ttenbergen 20:26, 2018 December 2 (CST)
+* Collectors should see no difference, except maybe fewer of the lock errors during sending
+** updated properties for all send*append and send*update query to Record Locks = no locks
+==== 2018-11-27-1 ====
+rolled out Ttenbergen 02:05, 2018 December 1 (CST)
+'''Changes collectors will want to know about'''
+* sorry guys, this is a big and hard to read one
+* '''fixed query [[query check_ICD10_Inf_Infection_req_Pathogen_must_have_one]] which was giving false positives
+* '''fixed [[query s_tmp_IICU_consult_DtTm]] which was giving false positives
+* '''renamed [[CCI Picklist]] item "Whole body cooling" to [[Targeted Temperature Management (TTM)]]
+* '''added [[CCI component 1 codes - what organ was something done to| CCI1 code]] [[(I) Spinal Cord and/or Vertebrae (any segments)]]
+* '''added
+**''' [[Cannabis/cannabinoids, acute intoxication]]
+**''' [[Cannabis/cannabinoids, chronic abuse/dependence/addiction]]
+**''' [[Cannabis/cannabinoids, withdrawal]]
+* '''changed tab order on [[L ICD10 subform]] to correspond to new field order with prioroty on the left. Ttenbergen 10:02, 2018 November 28 (CST)
+* '''renamed
+** '''"Intracranial or intraspinous veins or venous sinuses, septic thromboembolism -- incl septic embolism" to [[Intracranial or intraspinous veins or venous sinuses, septic thromboembolism]]
+** '''"Chemical gases or fumes or vapors NOS" to "Chemical gases or fumes or vapors NOS, poisoning with non-pharmaceuticals" (or sth)
+{{Collapsable
+| always= '''a bunch of spelling tweaks in the substance category
+| full=
+* minor
+** "Alcohol (ethanol) intoxication, acute (drunkenness)"  to [[Alcohol (ethanol) acute intoxication (drunkenness)]]
+** "[[Alcohol (ethanol), poisoning]]"  to "Alcohol (ethanol)"
+** "Antibiotic or other anti-infective, overdose/toxicity" to [[Antibiotic/antimicrobial, overdose/toxicity]]
+** "Antibiotic/anti-infective drug, adverse effect"  to [[Antibiotic/antimicrobial, adverse effect]]
+** "Anticoagulant drug, adverse effect"  to [[Anticoagulant, adverse effect]]
+** "Anticoagulant drug, overdose/toxicity"  to [[Anticoagulant, overdose/toxicity]]
+** "Antineoplastic drug (chemotherapy), adverse effect"  to [[Antineoplastic/chemotherapy or immunosuppressive drugs, adverse effect]]
+** "Antiseizure drug NOS,, adverse effect"  to [[Antiseizure drug NOS, adverse effect]]
+** "Aspirin or other salicylate, overdose/toxicity"  to [[Aspirin or other salicylate or NSAID, overdose/toxicity]]
+** "Aspirin or salicylate or nonsteroidal antiinflammatory drug, adverse effect"  to [[Aspirin or other salicylate or NSAID, adverse effect]]
+** "Benzodiazepine drug, adverse effect"  to [[Benzodiazepine, adverse effect]]
+** "Beta-blocker drug, overdose/toxicity"  to [[Beta-blocker, overdose/toxicity]]
+** "Beta-blocker drug, used appropriately, adverse effect"  to [[Beta-blocker, adverse effect]]
+** "Calcium channel blocker drug, adverse effect of agent used appropriately"  to [[Calcium channel blocker drug, adverse effect]]
+** "Calcium channel blocker drug, overdose/toxicity"  to [[Calcium channel blocker, overdose/toxicity]]
+** "Cardiac drug, adverse effect"  to [[Cardiac/cardiovascular drug NOS, adverse effect]]
+** "Cocaine intoxication, acute"  to [[Cocaine, acute intoxication]]
+** "Hallucinogen intoxication, acute"  to "Hallucinogen, intoxication, acute"
+** "Hallucinogen or psychodysleptic, adverse effect"  to [[Hallucinogen, adverse effect]]
+** "Hallucinogen or psychodysleptic, overdose/toxicity"  to [[Hallucinogen, overdose/toxicity]]
+** "Hallucinogen, intoxication, acute"  to [[Hallucinogen, acute intoxication]]
+** "Hemorrhage, due to anticoagulant drugs"  to [[Hemorrhage, due to anticoagulant or thrombolytic drug]]
+** "Hormone or hormone agonist drug, adverse effect"  to [[Hormone or hormone agonist drug, adverse effect]]
+** "Hormone or hormone agonist NOS, overdose/toxicity"  to [[Hormone or hormone agonist NOS, overdose/toxicity]]
+** "Opioid chronic abuse/dependence/addiction"  to [[Opioid/narcotic, chronic abuse/dependence/addiction]]
+** "Opioid intoxication, acute"  to [[Opioid/narcotic, acute intoxication]]
+** "Opioid withdrawal"  to [[Opioid/narcotic, withdrawal]]
+** "Opioid/narcotic drug, adverse effect"  to [[Opioid/narcotic, adverse effect]]
+** "Psychotropic/psychiatric drug NOS, overdose/toxicity"  to [[Psychiatric drug NOS, overdose/toxicity]]
+** "Psychotropic/psychiatric drug NOS,, adverse effect"  to [[Psychiatric drug NOS, adverse effect]]
+** "Sedative drug NOS, adverse effect"  to [[Sedative or hypnotic, adverse effect]]
+** "Sedative drug NOS, overdose/toxicity"  to [[Sedative or hypnotic, overdose/toxicity]]
+** "Sedative or hypnotic chronic abuse/dependence/addiction"  to [[Sedative or hypnotic, chronic abuse/dependence/addiction]]
+** "Sedative or hypnotic withdrawal"  to [[Sedative or hypnotic, withdrawal]]
+** "Sedative or hypnotic, acute intoxication"  to [[Sedative or hypnotic, acute intoxication]]
+** "Spinal cord infarction" to [[Spinal cord infarction, arterial thrombosis or thromboembolism]]
+** "Stimulants incl methamphetamine abuse/dependence/addiction"  to [[Stimulants incl methamphetamine, chronic abuse/dependence/addiction]]
+** "Stimulants incl methamphetamine intoxication, acute"  to [[Stimulants incl methamphetamine, acute intoxication]]
+** "Stimulants incl methamphetamine withdrawal"  to [[Stimulants incl methamphetamine, withdrawal]]
+** "Transient ischemic attack (TIA), all types" to [[Transient ischemic attack (TIA), all types]]
+** "Tricyclic antidepressant drug, adverse effect"  to [[Tricyclic antidepressant, adverse effect]]
+** "Tricyclic antidepressant drug, overdose/toxicity"  to [[Tricyclic antidepressant, overdose/toxicity]]
+** "Xray contrast agent, adverse effect of agent used appropriately"  to [[Xray contrast agent, adverse effect]]}}
+Changes that are mostly behind the scenes
+* Changed codes:
+** [[Antiseizure drug NOS, overdose/toxicity]] from 42.7 to 42.6
+** [[Sedative or hypnotic, overdose/toxicity]] from nothing to 42.7
+** [[Aspirin or other salicylate or NSAID, adverse effect]] from 45.3 to 45.1
+** [[Thrombolytic drug, overdose/toxicity]] from T44.5 to T45.6
+** [[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)
+* [[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
+==== 2018-11-27 ====
+rolled out Ttenbergen 11:33, 2018 November 27 (CST)
+'''Changes collectors will want to know
+* '''changed [[Query check ICD10 needs awaiting if TR Dt and Dispo Dt on diff days]]
+behind the scenes or minor changes
+* tweaked wording of the error message given when a cross check finds an error.
+* tweaked the size of the patient viewer form so it fits on a laptop screen without scrolling
+==== 2018-11-26-1 ====
+rolled out Ttenbergen 22:44, 2018 November 26 (CST)
+* more tweaks on [[L ICD10 subform]]
+==== 2018-11-26 ====
+not rolled out yet Ttenbergen 13:27, 2018 November 26 (CST)
+*[[Query check ICD10 needs awaiting if TR Dt and Dispo Dt on diff days]]
+==== 2018-11-25 ====
+rolled out Ttenbergen 00:27, 2018 November 26 (CST)
+'''Changes collectors will want to know about
+* '''added to [[s_ICD10 table]]:
+** '''[[Anesthetic gas, overdose/toxicity]]
+** '''[[Thrombolytic drug, overdose/toxicity]]
+** '''[[Antineoplastic/chemotherapy or immunosuppressive drugs, overdose/toxicity]]
+** '''[[Neuromuscular blocker/paralytic, overdose/toxicity]]
+** '''[[Anticoagulant, adverse effect]]
+** '''[[Hallucinogen, adverse effect]]
+** '''[[Beta-blocker, adverse effect]]
+** '''"Calcium channel blocker drug, adverse effect of agent used appropriately"
+** '''"Xray contrast agent, adverse effect of agent used appropriately"
+** '''[[Hypergammaglobulinemia]]
+** '''[[Bronchitis, chronic, infectious or noninfectious]]
+** '''[[Medical problem NOS]]
+* '''renamed for consistency in [[s_ICD10 table]]
+** '''"Neuromuscular blocking drug, adverse effect" to [[Neuromuscular blocker/paralytic, adverse effect]]
+** '''"Solvent (organic)" to "[[Solvent (organic, inhaled or ingested), poisoning]] by non-pharmaceutialcs" or similar
+** '''"Alcohol (ethanol) acute intoxication (drunkenness)" to [[Alcohol (ethanol) acute intoxication (drunkenness)]]
+* '''changed all ICD10 dxs named "*, overdose/poisoning" to "*, overdose/toxicity"
+* '''changed all ICD10 dxs named "*, poisoning/toxic effect" to "*"
+* '''changed all ICD10 dxs named "*,  used appropriately, adverse effect \(reaction, allergy, hypersensitivity\)" to "*, adverse effect", and added [[Template:ICD10 Guideline adverse effect]] to contain the instruction that was implied in the name before.
+* '''re-imported CCI and ICD10 categories
+==== 2018-11-23 ====
+rolled out Ttenbergen 22:11, 2018 November 24 (CST)
+'''Changes collectors will want to know about
+* '''updated [[L ICD10 subform]] to better group dxs by type and colour, I'd like some feedback please at [[L ICD10 subform]].
+* '''added [[Chest tube, left in place]] to [[s_CCI_Picklist table]]
+* '''added [[query check ICD10 ESRD vs kidney transplant]]
+* '''added "query check awaiting must have Transfer Ready DtTm"
+* '''added [[query check VAP admit must be from ICU]]
+* '''added [[query check ICD10 chronic vent acute resp failure]]
+* '''added "query check ICD10 ESRD vs AP CRF"
+* '''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]]
+* '''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
+Behind the scenes changes:
+* removed old, unused queries:
+** query Check_Dx_UniqueDx
+** query Check_Dx_UniquePriority
+** query Check_Como_Unique
+* removed the Vic locations and added the STB Med locations to [[s_locations_allowed_collection table]]
+* made inactive [[AcceptDateSource]] that was stopped in March
+==== 2018-11-22 ====
+rolled out
+* re-imported CCI and ICD10 categories once more.
+* fixed spelling "Respiratory syncitial virus (RSV)" to [[Respiratory syncytial virus (RSV)]]
+==== 2018-11-21 ====
+rolled out Ttenbergen 18:52, 2018 November 21 (CST)
+* tweaked to only compare same dx types:
+**[[Check Inf Infection with implied pathogen must not have a pathogen combined code]]
+**[[ query Check_Inf_Pathogens_must_have_Infection_requiring_pathogen_or_Potential_Infection]]
+**[[query check_ICD10_Inf_Infection_req_Pathogen_must_have_one]]
+**[[Check Inf Antibiotic resistance must have pathogen or Infection with implied pathogen]]
+* re-imported CCI and ICD10 categories once more.
+==== 2018-11-19 ====
+rolled out Ttenbergen 22:12, 2018 November 20 (CST)
+changes collectors will want to know about
+* ''' none, only fixes this time
+behind the scenes changes
+* changed how errors are displayed to provide a clickable URL to the wiki page for the error function Reject_a_query and function Reject_a_query_PatID
+* updated [[ICD10 Categories for CCMDB.accdb]]
+* updated [[CCI Categories for CCMDB.accdb]]
+* updated [[query Check_Inf_Pathogens_must_have_Infection_requiring_pathogen_or_Potential_Infection]] to not trigger for [[:Category:Double duty pathogen]]
+* updated [[Check Inf Infection with implied pathogen must not have a pathogen combined code]] to not compare a dx with itself
-Enter '''[[requested CCMDB changes for the next version]]''' in that article.
+==== 2018-11-19 ====
+rolled out Ttenbergen 09:10, 2018 November 19 (CST)
+* several minor tweaks to the last round of queries
-== Versions ==
+==== 2018-11-13 ====
-==== next  ====
+rolled out Ttenbergen 00:42, 2018 November 19 (CST)
-* update component 2 on [[L_CCI_Component_subform]] so it only lists what is allowed. This turns out to be tricky...
+'''Collectors will want to know:
-* review and fix [[L_ICD10_APACHE_Dx query]]
+* '''added infection cross-checks:
-* tab order
+** '''[[Check Inf Infection with implied pathogen must not have a pathogen combined code]]
-* start cross checks
+** '''[[query Check_Inf_Pathogens_must_have_Infection_requiring_pathogen_or_Potential_Infection]]
-* Change code names for [[CCI Procedures coded once per ward admission]] to include something like (1ce)
+** '''[[query check_ICD10_Inf_Infection_req_Pathogen_must_have_one]]
-* after fixing the CCI page names on wiki, '''add wiki link for CCI codes in CCMDB.mdb'''
+** '''[[Check Inf Antibiotic resistance must have pathogen or Infection with implied pathogen]]
-* cross check for properly combined CCI codes. (TDI)
+* '''added "consult unknown" option to [[IICU consult]]
-* fix [[CCMDB.mdb links to CCMDB wiki]]
+* '''added [[query check_CCI_from_OR_no_CCI]]
+* '''updated [[CCI Chooser form]] to include a category filter for CCI 1 items
+* '''added [[CCI_Pick_Chooser form]] to include a category filter for CCI Picklist items
+* '''updated [[s_ICD10 table]]: fixed spelling for "Pruritis (itching)" to [[Pruritus (itching)]]
+* '''added [[Check if awaiting code is primary dx then Transfer Ready DtTm must be equal to Arrive DtTm]]
+* '''retired [[Whole body warming - incl extracorporeal warming of blood]] which will no longer be needed after re-definition of [[Targeted Temperature Management (TTM)]]
+* '''updated [[Proposed Notes field default]] as requested
+Behind the scenes stuff...
+* tweaked [[Query check_ICD10_Comorbids_NoComo_code_but_others]] which was giving error
+==== 2018-11-12 ====
+rolled out Ttenbergen 20:00, 2018 November 12 (CST)
+Changed collectors should know about:
+* '''implemented data integrity checks:'''
+**
+** '''[[Query check_ICD10_Comorbids_Dx_present]]
+** '''[[Query check_CCI_must_have_entry]]
+Behind the scenes changes:
+* implemented function include_pt() to be able to only check patients with Pat_ID ending in 8, and later be able to change it to all patients by single place edit.
+* deleted old temporary query "2018_04_03_L_ICD10_translator"
+* imported from [[CFE]] [[query L_CCI_Combined]] and its subquery L_CCI_Combined_ComponentSubQ]]
+* tweaked [[query check_dx_primary_not_exactly_one]] so it will only consider [[Admit Diagnosis]]
+==== 2018-11-08-1 ====
+rolled out Ttenbergen 20:54, 2018 November 9 (CST)
+* update to [[IICU consult]], added new options and [[Query s tmp IICU consult DtTm]] cross check
+* Added % of body area burn codes as discussed at task meeting
+** T31.00: [[Burns, up to 9% or unspecified body surface area involved]]
+** T31.10: [[Burns, 10-19% body surface area involved]]
+** T31.20: [[Burns, 20-29% body surface area involved]]
+** T31.30: [[Burns, 30-39% body surface area involved]]
+** T31.40: [[Burns, 40-49% body surface area involved]]
+** T31.50: [[Burns, 50-59% body surface area involved]]
+** T31.60: [[Burns, 60-69% body surface area involved]]
+** T31.70: [[Burns, 70-79% body surface area involved]]
+** T31.80: [[Burns, 80-89% body surface area involved]]
+** T31.90: [[Burns, 90% or more body surface area involved]]
+* spelling fix from "entercolitis" -> [[Colitis, enteritis, enterocolitis, or gastroenteritis, noninfectious NOS]]
+==== 2018-11-08 ====
+rolled out Ttenbergen 22:06, 2018 November 8 (CST)
+Changes Collectors should know about:
+* updated Function cb_addPt_Click() which runs when "Add Patient" button is clicked to set the default entry for the [[Notes field]] as per [[Proposed Notes field default]]
+* renamed "Aspiration pneumonitis/pneumonia" to [[Aspiration pneumonitis]]
+* updated [[CCI Picklist]] as discussed:
+** "AXR (abdominal plain X-ray)" --> [[AXR (abdominal plain X-ray)]]
+** "Administration of intravenous immunoglobulin" --> [[IVIG (IV administration of immunoglobulin)]]
+** "Angiogram of artery NOS (except specifically coded)" --> [[Angiogram, artery NOS (except specifically coded)]]
+** "Angiogram of vein" --> [[Angiogram, vein]]
+** "Aortic angiogram (any part of aorta)" -->[[ Angiogram, aortic (any part of aorta)]]
+** "Bone marrow transplant or transfusion" --> [[BMT (Bone marrow transplant or transfusion)]]
+** "Cardiac pressure measurements via a catheter in cath lab - incl right heart cath done for pressures and C.O." --> "Cardiac pressure measurements via catheter (done in cath lab)"
+** "Cardiac stress test" --> [[Cardiac stress test (any kind)]]
+** "Cardioversion -- excl defibrillation which we are not tracking separately --> [[Cardioversion  (EXCLUDE defibrillation-we are not tracking)]]
+** "Cerebral angiogram (including vertebral arteries)" --> [[Angiogram, cerebral (including vertebral arteries)]]
+** "Coronary angiogram (diagnostic cardiac catheterization)" --> [[Angiogram, coronary (diagnostic cardiac catheterization)]]
+** "Coronary angioplasty with stenting" --> [[Angioplasty, coronary (with stenting)]]
+** "Coronary angioplasty without stenting" --> [[Angioplasty, coronary (without stenting)]]
+** "CRRT -- incl for volume removal via PRISMA device" --> [[CRRT (incl volume removal via PRISMA device)]]
+** "CT Cardiac or CT Cardiac angiogram w or wo coronary arteries" --> [[Cardiac CT or Cardiac CT angiogram (with or without coronary arteries)]]
+** "CXR plain film" --> [[CXR (plain film)]]
+** "Diagnostic abdominal paracentesis" --> [[Paracentesis (diagnostic)]]
+** "Diagnostic lumbar puncture" --> [[LP (lumbar puncture, diagnostic)]]
+** "Diagnostic thoracentesis" --> [[Thoracentesis (diagnostic)]]
+** "Echocardiogram of heart" --> [[ECHO (echocardiogram of heart)]]
+** "Electroconvulsive (shock) Therapy to Brain" --> [[ECT (Electroconvulsive shock therapy to brain)]]
+** "Hemodialysis (intermittent)" --> [[HD (Hemodialysis)]]
+** "Mechanical ventilation, noninvasive" --> [[BiPAP, CPAP, NIV, own ventilator (Mechanical ventilation, noninvasive)]]
+** "Non-Cesarean delivery (therapeutic) -- note separate code for Cesarean delivery" --> [[SVD (Spontaneous vaginal delivery)]] (I left out the "therapeutic" what does that even mean in this case...)
+** "Peritoneal dialysis" --> [[PD (Peritoneal dialysis)]]
+** "Placement of implanted (invasive) intracranial pressure monitoring device" --> [[ICP monitor (Placement of implanted, invasive intracranial pressure monitoring device)]]
+** "Polysomnogram (done in Miseracordia Sleep lab)" --> [[Sleep Study (Polysomnogram, done in Miseracordia Sleep lab)]]
+** "Pulmonary artery angiogram (pulmonary arteriogram)" --> [[Angiogram, pulmonary artery (pulmonary arteriogram)]]
+** "Total parenteral nutrition (TPN)" --> [[TPN (Total parenteral nutrition)]]
+==== 2018-11-07-1 ====
+rolled out Ttenbergen 11:20, 2018 November 7 (CST)
+* updated [[query check_CCI_CRRT_vs_Tmp]] to only trigger at HSC Ttenbergen 11:20, 2018 November 7 (CST)
+==== 2018-11-07 ====
+rolled out Ttenbergen 11:13, 2018 November 7 (CST)
+* tweaked queries, it used field named Pat_ID field more than once, which was giving collectors errors:
+** [[query check_AIDS_vs_HIV]]
+** [[query check_cooling_vs_arrest]]
+* tweaked error msg for [[Query_check_CCI_Date]]
+==== 2018-11-05 ====
+rolled out Ttenbergen 13:45, 2018 November 6 (CST)
+''' when this rolls I need to test that the Windows 10 folks now get the log showing up '''
+* '''Collection changes''':
+** added [[IICU consult]] to [[s_tmp table]]
+** added [[Query check_CCI_CRRT_vs_Tmp]] - '''you will need to start entering CCI entries for all CRRT patients'''
+** added "Query s tmp QASeptic Dx no tmp", [[Query s tmp QASeptic tmp no dx]] checks for ICD10; '''[[QA Septic Shock]] will now also cross check against ICD10 diagnoses'''
+** added [[Query check_cooling_vs_arrest]] - you can only use [[Targeted Temperature Management (TTM)]] if you have a [[Cardiac arrest]] dx in ICD10
+** added [[Query check_AIDS_vs_HIV]] - can't code [[HIV infection, asymptomatic]] and [[AIDS (disease due to HIV)]] for same record
+** added [[Check eliminated dx]] for ICD10 and CCI (query check_eliminated_ICD10, query check_eliminated_CCI_Pick, query check_eliminated_CCI_Comp
+* other changes (minor, might be visible but should not require change in collection)
+** updated description for renal codes in [[s_ICD10 table]] so they sort in order 1-5, thanks for the thought on how to do this Trish
+*** Chronic kidney disease (chronic renal insufficiency, uremia) Stage 1
+*** Chronic kidney disease (chronic renal insufficiency, uremia) Stage 2
+*** Chronic kidney disease (chronic renal insufficiency, uremia) Stage 3
+*** Chronic kidney disease (chronic renal insufficiency, uremia) Stage 4
+==== 2018-11-02 ====
+'''rolled out''' - [[User:PTorres|PTorres]] 09:55, 2018 November 2 (CDT)
+*Added in s_Record Status "Discontinued"
+*Updated hospital names in [[s_dispo table]] done by Julie Mojica
+==== 2018-10-30 ====
+rolled out Ttenbergen 11:31, 2018 October 31 (CDT)
+* Added [[Diabetes mellitus acute complication: Non-ketotic hyperosmolar state]]
+* Renamed the following dxs:
+**[[Diabetes mellitus chronic complication: Nephropathy]] from "Diabetes chronic complication: Nephropathy"
+**[[Diabetes mellitus chronic complication: Retinopathy]] from "Diabetes chronic complication: Retinopathy"
+**[[Diabetes mellitus chronic complication: Neuropathy]] from "	Diabetes chronic complication: Neuropathy"
+**[[Diabetes mellitus chronic complication: Cardiovascular]] from "Diabetes chronic complication: Cardiovascular"
+**[[Diabetes mellitus chronic complication: Musculoskeletal]] from "Diabetes mellitus chronic complication: Musculoskeletal"
+**[[Diabetes mellitus chronic complication NOS]] from "Diabetes mellitus chronic complication NOS"
+**[[Diabetes mellitus chronic complication: Foot ulcer]] from "Diabetes chronic complication: Foot ulcer"
+==== 2018-10-30 ====
+rolled out Ttenbergen 09:36, 2018 October 30 (CDT)
+* further tweaking of notes field checks: commented out requery command that was causing re-set of form on tabbing out. Will need to find out a way to write before requery.Ttenbergen 09:36, 2018 October 30 (CDT)
+==== 2018-10-26-1 ====
+rolled out Ttenbergen 12:12, 2018 October 29 (CDT)
+* changed function notes checker to requery data before checking it to prevent the error were getting when leaving notes field if there was bad data in WBC
+* deleted old tables ''send_dxs_acqu'' and ''send_pharm''
+* updated sending so that database gets closed after tables are linked (to clean up)
+* changed queries ODBC Timeout to 120 to see if this will improve the disconnect network problem
+* updated error email when sending goes wrong in hopes that now it will show the proper error Nr, not zero.
+* updated L_ICD10_subform to default sort to
+** Dx type (admit, …)
+** Priority
+** Date
+** Description
+==== 2018-10-26 ====
+rolled out Ttenbergen 11:54, 2018 October 26 (CDT)
+* reverted to 2015-10-17 due to problems introduced by ..-24
+* re-imported from newer version [[Query check dx primary lowest priority]]
+* re-applied ADL hiding from prev version
+* re-applied picklist name fixes
+* re-applied patient list wiki link update
+==== 2018-10-25 ====
+not rolled yet Ttenbergen 10:32, 2018 October 25 (CDT)
+* updated Function runQuery to give more meaningful error when there is a problem during sending. Ttenbergen 10:32, 2018 October 25 (CDT)
+* updated form [[Patient List]] to change the wiki links to the little icons like in form patient viewer. Corrected link to [[LastChanged DtTm field]]. Ttenbergen 16:22, 2018 October 25 (CDT)
+==== 2018-10-24 ====
+rolled out Ttenbergen 09:39, 2018 October 25 (CDT)
+* updated [[s_CCI_Picklist table]] entries to be same as on wiki for:
+** "Cardiac electrophysiology study (done in cath lab; for arrythmia mapping)" --> [[Cardiac electrophysiology study]]
+** "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)
+* 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)
+==== 2018-10-17 ====
+rolled out Ttenbergen 10:03, 2018 October 22 (CDT)
+* improved error message for [[Query_check_CCI_Date]]. Ttenbergen 10:20, 2018 October 17 (CDT)
+* made inactive the entries in [[s_tmp table]] for projects we are not doing any longer:
+** [[Influenza treated]]
+** [[Influenza tracking]]
+* updated [[Query check ICD10 duplicates]] to also check for priorities; had to allow duplicate pathogens that way because pt might have e.g. two "unknown pathogen" entries. Ttenbergen 10:02, 2018 October 22 (CDT)
+==== 2018-10-15-2 ====
+rolled out Ttenbergen 22:46, 2018 October 15 (CDT)
+* Corrected the bug where an [[Acquired Procedure]] on the arrive day would raise an error in [[Query check CCI Date]].
-* '''NEED TO FINISH''': messed around with the error message in sending but '''this is not done yet''', waiting for more info from a collector.
+==== 2018-10-15-1 ====
+rolled out Ttenbergen 15:59, 2018 October 15 (CDT)
+* fixed sort buttons in [[L_ICD10_subform]]
+==== 2018-10-15 ====
+rolled out Ttenbergen 15:12, 2018 October 15 (CDT)
+* made unavailable/expired [[No procedure performed]] from [[s_CCI_2 table]], it should not even have been there.  Ttenbergen 14:16, 2018 October 15 (CDT)
 ==== 2018-10-11 ====
-not rolled yet - Ttenbergen 17:00, 2018 October 11 (CDT)
+rolled out Ttenbergen 18:24, 2018 October 14 (CDT)
-* in [[s_ICD10 table]], changed following to omit "or current use"
+* '''relevant to collectors: '''
-** [[Past history of immunosuppressive drugs or corticosteroids]]
+** implemented CCI cross checks:
-** [[Past history of radiation therapy]]
+*** [[Query check CCI if no then none]]
-** [[Past history of chemotherapy for neoplastic disease]]
+*** [[Query check CCI component 1 and 2 compatible]]
-* updated Sub Send_Data() to stop sending when there is an error, i.e. records will not be set to "sent". This means collectors will be able to re-send without having to engage Pagasa. This should have been that way all along, but had not been previously. Ttenbergen 17:58, 2018 October 11 (CDT)
+*** [[Query check CCI Component duplicates]]
-* updating a bunch of old code to improve error handling, should be invisible to collectors
+*** [[Query check CCI Picklist duplicates]]
-* removed a bunch of old calls to err_logger that did nothing from:
+*** [[Query check CCI no admin entries]]
-** Function get_a_info
+*** [[Query check CCI Component unfilled]]
-** Function initial_control_empty_check
+*** [[Query check CCI Picklist unfilled]]
-** Sub LabCheck
+*** [[Query check CCI Date]]
-** Validate_PHIN
+** in [[s_ICD10 table]], changed following to omit "or current use"
-** Function Reject_a_query
+*** [[Past history of immunosuppressive drugs or corticosteroids]]
-** Function Reject_a_query_PatID
+*** [[Past history of radiation therapy]]
-** Function reject_pharm
+*** [[Past history of chemotherapy for neoplastic disease]]
-** Function reject_lab
+** updated Sub Send_Data() to stop sending when there is an error, i.e. records will not
-** Sub Convert_DB()
+** changed all label links on ICD10, CCI, dispo tabs and registry top of screen to plain labels with link button; added link buttons to ADLs
-* deleted Function Reject_too_many that is no longer used
+*Should not be visible to collecors:
+** updating a bunch of old code to improve error handling, should be invisible to collectors
+** removed a bunch of old calls to err_logger that did nothing from:
+*** Function get_a_info
+*** Function initial_control_empty_check
+*** Sub LabCheck
+*** Validate_PHIN
+*** Function Reject_a_query
+*** Function Reject_a_query_PatID
+*** Function reject_pharm
+*** Function reject_lab
+*** Sub Convert_DB()
+** deleted Function Reject_too_many that is no longer used
 ==== 2018-10-09 ====
@@ Line 73: / Line 520: @@
 ** query s_tmp_Service_Sending_to_ICU_duplicate
 * updated [[Check duplicate patient]] to properly accommodate [[PHIN_field#Location_Manitoba_and_no_PHIN]]
-* [[CCMDB.mdb 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.mdb links to CCMDB wiki]].
+* [[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 [[Check fundamentals for CCI]]
+* removed [[No procedure performed]] from [[S_CCI_1 table]] because [[CCI Collection]] says to enter this from [[CCI Picklist]] - this will facilitate cross checks
 * implemented checks and added to Sub Dx_Checker():
 * [[Query check_dx_primary_lowest_priority]]
@@ Line 116: / Line 563: @@
 ==== 2018-07-31 ====
 rolled out Ttenbergen 20:23, 2018 July 31 (CDT)
-* in [[s_ICD10 table]], corrected duplicate entry: set retired date for [[Drug or biological substance/agent NOS used appropriately, adverse effect (reaction, allergy, hypersensitivity)]] with code T88.7; the one with Y57.8 remains available.
+* in [[s_ICD10 table]], corrected duplicate entry: set retired date for [[Drug or biological substance/agent NOS, adverse effect]] with code T88.7; the one with Y57.8 remains available.
 ==== 2018-07-26 ====
 rolled out Ttenbergen 18:50, 2018 July 29 (CDT)
 * in [[s_CCI_Picklist table]]
-** changed "" to [[CT Cardiac or CT Cardiac angiogram w or wo coronary arteries]] to list it closer to [[CT of chest with PE protocol (CT angiogram of pulmonary vessels)]].
+** changed "" to [[Cardiac CT or Cardiac CT angiogram (with or without coronary arteries)]] to list it closer to [[CT of chest with PE protocol (CT angiogram of pulmonary vessels)]].
 * in [[s_ICD10 table]]:
 ** renamed "Uterus/cervix NOS, benign neoplasm" to [[Uterus/cervix NOS, benign neoplasm]]
@@ Line 142: / Line 589: @@
 rolled out Ttenbergen 11:46, 2018 July 17 (CDT)
 * in [[s_CCI_Picklist table]]:
-** renamed "Cardiac CT or CT angiogram" to "CT Cardiac or CT Cardiac angiogram w or wo coronary arteries"
+** renamed "Cardiac CT or CT angiogram" to "Cardiac CT or Cardiac CT angiogram (with or without coronary arteries)"
 * in [[s_ICD10 table]]:
 ** added [[Hypoalbuminemia, severe]]
@@ Line 152: / Line 599: @@
 rolled out Ttenbergen 16:44, 2018 July 11 (CDT)
 * in [[s_ICD10 table]]:
-** changed "Coronary angiogram (diagnostic cardiac catherization)" to [[Coronary angiogram (diagnostic cardiac catheterization)]]
+** changed "Coronary angiogram (diagnostic cardiac catherization)" to [[Angiogram, coronary (diagnostic cardiac catheterization)]]
 ** added
 *** [[Hypoalbuminemia, severe]]
 *** [[Infestation, NOS]]
-*** [[Stimulants incl methamphetamine intoxication, acute]]
+*** [[Stimulants incl methamphetamine, acute intoxication]]
-*** [[Stimulants incl methamphetamine abuse/dependence/addiction]]
+*** [[Stimulants incl methamphetamine, chronic abuse/dependence/addiction]]
-*** [[Stimulants incl methamphetamine withdrawal]]
+*** [[Stimulants incl methamphetamine, withdrawal]]
 * in [[s_CCI_1 table]]:
 ** changed procedure names to replace "lower limb" with leg, "upper limb" with arm, to make consistent among procedures; new codes are:
@@ Line 215: / Line 662: @@
 ** changed "Obesity, NOS (BMI 30.0 to 30.9)" to [[Obesity, NOS (BMI 30.0 to 39.9)]]
 ** changed "Parthyroid gland, primary malignancy" to [[Parathyroid gland, primary malignancy]]
-** updated code for U22.8 ([[Mixed pathogens, speciation not done or reported]], it had a tab character as first character
+** updated code for U22.8 ("Mixed pathogens, speciation not done or reported", it had a tab character as first character
 * in [[L_ICD10 subform]], added code to prevent error and give meaningful error msg when someone tries to simply delete a dx entry rather than the whole row. Ttenbergen 10:31, 2018 May 30 (CDT)
 * in [[L_CCI_Picklist subform]], added code to prevent error and give meaningful error msg when someone tries to simply delete a dx entry rather than the whole row.
@@ Line 224: / Line 671: @@
 * in [[s_dispo table]], changed "VIC - UC" to "VIC -  UC" so it sorts to the top. Ttenbergen 16:53, 2018 May 24 (CDT)
 * in [[s_CCI_Picklist table]],
-** changed to [[CRRT -- incl for volume removal via PRISMA device]] from "Continuous renal replacement therapy -- incl for volume removal via PRISMA device"
+** changed to [[CRRT (incl volume removal via PRISMA device)]] from "Continuous renal replacement therapy -- incl for volume removal via PRISMA device"
 ** changed to [[Blood gas, arterial]] from "Arterial blood gas"
 ** changed to [[Blood gas, venous]] from  "Venous blood gas"
@@ Line 231: / Line 678: @@
 rolled out Ttenbergen 18:23, 2018 May 16 (CDT)
 * in [[s_CCI_Picklist table]]
-** fixed spelling for [[Angiogram of artery NOS (except specifically coded)]], which had been ''Angiogram of artery NOS (except spefifically coded)'' in CCMDB.mdb Ttenbergen 10:39, 2018 May 9 (CDT)
+** fixed spelling for [[Angiogram, artery NOS (except specifically coded)]], which had been ''Angiogram of artery NOS (except spefifically coded)'' in CCMDB.mdb Ttenbergen 10:39, 2018 May 9 (CDT)
 ** added [[Transfusion of albumin]] Ttenbergen 12:38, 2018 May 16 (CDT)
 * in [[s_AllDiagnoses table]] fixed spelling for
@@ Line 275: / Line 722: @@
 * in [[s_CCI_Picklist table]], added:
-** [[Mechanical ventilation, noninvasive]]
+** [[BiPAP, CPAP, NIV, own ventilator (Mechanical ventilation, noninvasive)]]
 ** [[ECMO, VA]]
 ** [[ECMO, VV]]
@@ Line 290: / Line 737: @@
 ** [[Physical rehabilitation care]] code changed from Z50 to Z50.1, definition etc updated on the wiki. Ttenbergen 14:28, 2018 April 25 (CDT)
 ** added [[Other type of infectious organism, NOS‎‎]] splitting up "Infectious disease NOS OR for buglist organism NOS" into this new one and [[Infectious disease NOS]] Ttenbergen 16:06, 2018 April 25 (CDT)
-** added [[Mixed pathogens, speciation not done or reported]]
+** added "Mixed pathogens, speciation not done or reported"
 * in [[s_dispo table]]
 ** allowed  GRA_CAU, HSC_CAU, STB_CAU as [[Dispo]]
@@ Line 301: / Line 748: @@
 ** deleted "Removal of Internal Device"
 * in [[s_ICD10 table]]:
-** changed "Acetaminophen used appropriately (tylenol, paracematol), adverse effect (reaction, allergy, hypersensitivity)" to [[Acetaminophen (tylenol, paracematol) used appropriately, adverse effect (reaction, allergy, hypersensitivity)]] for naming consistency, updated wiki.
+** changed "Acetaminophen used appropriately (tylenol, paracematol), adverse effect (reaction, allergy, hypersensitivity)" to [[Acetaminophen (tylenol, paracematol), adverse effect]] for naming consistency, updated wiki.
-** moved "Psychiatric drug NOS, overdose/poisoning" to [[Psychotropic/psychiatric drug NOS, overdose/poisoning]] for naming consistency, updated wiki.
+** moved "Psychiatric drug NOS, adverse effect" to [[Psychiatric drug NOS, overdose/toxicity]] for naming consistency, updated wiki.
 * in [[s_tmp table]]
 ** added records for [[Septic Shock Order Set]] Ttenbergen 09:12, 2018 April 19 (CDT)
@@ Line 311: / Line 758: @@
 ** added [[Pharmacotherapy, thrombolytic agent]] to be able to code such things as "MI aborted with TPN" (I have cleaned up the page that had been made just for that purpose.) Ttenbergen 12:50, 2018 April 11 (CDT)
 * in [[S_CCI_1 table]]:
-** updated " (T) Abdominal Cavity, NOS" to [[ (T) Abdominal or Pelvic Cavity, NOS]]
+** updated " (T) Abdominal Cavity, NOS" to "(T) Abdominal or Pelvic Cavity, NOS"
-** updated " (D) Abdominal Cavity, NOS" to [[ (D) Abdominal or Pelvic Cavity, NOS]]
+** updated " (D) Abdominal Cavity, NOS" to "(D) Abdominal or Pelvic Cavity, NOS"
 * in [[s_dispo table]]:
 ** updated "HSC - Interventional Radiology" and "STB - Interventional Radiology" to fill "site" field with hospital, and to allow as [[Dispo]]
@@ Line 329: / Line 776: @@
 rolled out.[[User:TOstryzniuk|Trish Ostryzniuk]] 16:21, 2018 April 10 (CDT)
 * add New Tmp project: [[ICUotherService].-- [[User:TOstryzniuk|Trish Ostryzniuk]] 16:16, 2018 April 10 (CDT)
-* renamed AXR plain film to [[Abdominal plain X-ray (AXR)]]
+* renamed AXR plain film to "Abdominal plain X-ray (AXR)"
 ==== 2018-04-09-1 ====
@@ Line 350: / Line 797: @@
 * updated [[s_dispo table]]: disabled "VIC - ER" Ttenbergen 13:44, 2018 April 6 (CDT)
 * updated [[s_ICD10 table]]:
-** set end date for "Y57.8 - Drug NOS used appropriately, adverse effect (reaction, allergy, hypersensitivity)" to today Ttenbergen 13:50, 2018 April 6 (CDT)
+** set end date for "Y57.8 - Drug NOS, adverse effect" to today Ttenbergen 13:50, 2018 April 6 (CDT)
 ** deleted ICD10_ID field since we won't be using it now (coding actual ICD10 code instead)
@@ Line 397: / Line 844: @@
 not rolled yet Ttenbergen 17:46, 2018 March 22 (CDT)
 * changed [[L_CCI_Picklist subform]] dropdown to sort first by catgory, then by description, making it alphabetical. Was sorted by code but that made no sense Ttenbergen 17:46, 2018 March 22 (CDT)
-* added 1.LZ.35.HH-C6	[[Total parenteral nutrition (TPN)]] to [[s_CCI_Picklist table]]
+* added 1.LZ.35.HH-C6	[[TPN (Total parenteral nutrition)]] to [[s_CCI_Picklist table]]
 * in [[s_ICD10 table]] fixed spelling for
 ** [[Raynaud's syndrome/phenomenon]] Ttenbergen 18:42, 2018 March 22 (CDT)
@@ Line 495: / Line 942: @@
 rolled out Ttenbergen 18:01, 2018 January 10 (CST)
 * added "negative" for [[Influenza tracking]]
-* Implemented as query check_ER_Delay_not_too_big.[[ER Delay]]
+* Implemented as "query check_ER_Delay_not_too_big".[[ER Delay]]
 === 2018-01-09 ===
 rolled out Ttenbergen 09:18, 2018 January 9 (CST)
-*Added Awaiting Codes:
+*Added [[:Category:Awaiting/delayed transfer | Awaiting Codes]]:
 ** [[Awaiting/delayed transfer to home]]
-** [[Awaiting/delayed transfer to long-term care/PCH]]
+** "Awaiting/delayed transfer to long-term care/PCH"
-** [[Awaiting/delayed transfer to other acute care facility]]
+** "Awaiting/delayed transfer to other acute care facility"
-** [[Awaiting/delayed transfer to transitional care facility]]
+** "Awaiting/delayed transfer to transitional care facility"
 === 2018-01-04 ===
@@ Line 527: / Line 974: @@
 * [[ACCU borrow]] - fix to cross check query ''s_tmp_ACCU_Borrow_chronicity_hard''; was using obsdate and obstime, when it should have used date_var and time_var. Ttenbergen 13:13, 2018 January 4 (CST)
-[[Category: CCMDB.mdb]]
+[[Category:CCMDB.accdb]]
 [[Category: Change Logs CCMDB]]