CCMDB.mdb Change Log 2018

see Log (disambiguation) for other uses of the term "Log" see the 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.

Enter requested CCMDB changes for the next version in that article.

Versions

next

• update component 2 on L_CCI_Component_subform so it only lists what is allowed. This turns out to be tricky...
• review and fix L_ICD10_APACHE_Dx query
• tab order
• Change code names for CCI Procedures coded once per ward admission to include something like (1ce)
• after fixing the CCI page names on wiki, add wiki link for CCI codes in CCMDB.mdb

2018-11-02

rolled out - PTorres 09:55, 2018 November 2 (CDT)

• Added in s_Record Status "Discontinued"
• Updated hospital names in s_dispo done by Julie Mojica

2018-10-31

not rolled yet - Ttenbergen 13:04, 2018 October 31 (CDT) when this rolls I need to test that the Windows 10 folks now get the log showing up

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)" --> Coronary angiogram (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.

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

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

• relevant to collectors:
  • implemented CCI cross checks:
    • Query check CCI if no then none
    • Query check CCI component 1 and 2 compatible
    • Query check CCI Component duplicates
    • Query check CCI Picklist duplicates
    • Query check CCI no admin entries
    • Query check CCI Component unfilled
    • Query check CCI Picklist unfilled
    • Query check CCI Date
  • in s_ICD10 table, changed following to omit "or current use"
    • Past history of immunosuppressive drugs or corticosteroids
    • Past history of radiation therapy
    • Past history of chemotherapy for neoplastic disease
  • updated Sub Send_Data() to stop sending when there is an error, i.e. records will not
  • 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

• 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

rolled out Ttenbergen 23:32, 2018 October 9 (CDT)

• messed around with the error message in sending but this is not done yet, waiting for more info from a collector.
• in s_CCI_Picklist table, added:
  • Pharmacotherapy, antineoplastic agent, whole body
  • Pharmacotherapy, immunostimulant, whole body
  • Pharmacotherapy, immunosuppressive, whole body

2018-10-03-2

rolled out Ttenbergen 12:39, 2018 October 3 (CDT)

• update to query check_dx_primary_not_exactly_one which didn't work right for 0 primary admits. Ttenbergen 12:39, 2018 October 3 (CDT)

2018-10-03

rolled out Ttenbergen 10:59, 2018 October 3 (CDT)

• s_locations_allowed_collection table
  • changed dropdowns to be driven by s_dispo table, they were still set to s_locations table.
  • added STB IMCU

2018-10-01

rolled out Ttenbergen 14:12, 2018 October 1 (CDT)

• fix to query check_dx_primary_lowest_priority Ttenbergen 08:36, 2018 October 1 (CDT)
• update to Dx_Checker to make the error messages more meaningful. Ttenbergen 08:41, 2018 October 1 (CDT)
• changed name of STB_HOBS to STB_IMCU
• tweak for call of query s_tmp_QAInf_basic that had somehow sprouted an "s" Ttenbergen 14:02, 2018 October 1 (CDT)

2018-09-25

rolled out Ttenbergen 22:02, 2018 September 30 (CDT)

• added call to Query s tmp QAInf basic that had been missed earlier. Ttenbergen 10:01, 2018 September 25 (CDT)
• deleted legacy queries
  • query s_tmp_Service_Sending_to_ICU
  • 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.
• 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 cross checks
• implemented checks and added to Sub Dx_Checker():
• Query check_dx_primary_lowest_priority
• Query check_dx_primary_not_exactly_one
• Query check_ICD10_date
• Query check_ICD10_unfilled
• Query check_ICD10_duplicates

2018-09-06

rolled out Ttenbergen 09:46, 2018 September 25 (CDT)

• in s_ICD10 table:
  • added Respiratory secretions, abnormal
• Project Borrow arrive - retired option "STB CCU" and added "STB ACCU"
• ACCU borrow - retired all options, replaced by Project Borrow arrive
• in S_CCI_1 table, changed "(T) Ventricle" to (T) Cardiac ventricle
• in S_CCI_Picklist table, added Tracheostomy creation
• confirmed that Postal_Code_field cross check doesn't allow lowercase
• actually deleted query deleted query check_OR_from_but_not_Surgical_Type; had logged this as done in #2018-05-09 but evidently never did then. Ttenbergen 10:50, 2018 September 20 (CDT)
• fixed Patient List sorting by Chart number; ages ago that field was called "chart#" and it seems the buttons have been broken ever since that was changed. Ttenbergen 15:35, 2018 September 21 (CDT)
• fixed "ICD10 Diagnosis" link in L ICD10 subform to go to ICD10_Diagnosis_List Ttenbergen 16:31, 2018 September 21 (CDT)
• deleted legacy queries that had been used in CCU Service Tracking as part of general cleanup of cross-checks:
  • query s_tmp_CCU_Service_shouldntve
  • query s_tmp_CCU_Service_twins
• changed s_dispo table so that GRA_N5a and GRA_S3a can only be used as Service/Location and no longer as previous location or dispo, which should never have been possible in the first place.

2018-09-05-2

rolled out Ttenbergen 10:11, 2018 September 6 (CDT)

• changed sending to use Function runQuery, which executes all queries using querydef.execute, rather than previous DoCmd.OpenQuery "...", acViewNormal, to enable us to get errors when something goes wrong during sending (e.g. PHI Loader.accdb errors, PHI sent, Log missing Bug or Problem with sent vs complete records). The old method masked any errors. Ttenbergen 15:19, 2018 September 5 (CDT)

2018-09-05

rolled out Ttenbergen 13:27, 2018 September 5 (CDT)

• S ICD10 APACHE Dx patterns table - replaced with Julies version which adds columns weight, index, DxGrp and DxGrp_label as requested by 2018-08-24 email from Julie Ttenbergen 13:26, 2018 September 5 (CDT)
• s_CCI_Picklist table - re-wrote code 1.HZ.53.GR-FS because it had some invisible character at the beginning that was displacing it in sorts. Ttenbergen 10:14, 2018 September 5 (CDT)
• Project Borrow arrive - changed "no borrow" option in s_tmp table so it could be entered manually in case it had been changed to a location and then needed to be changed back to "no borrow". Ttenbergen 09:33, 2018 September 5 (CDT)

2018-08-13

rolled out Ttenbergen 17:36, 2018 August 13 (CDT)

• updated s_tmp table to change dropdown for CRRT re. notification.

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.

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).
• in s_ICD10 table:
  • renamed "Uterus/cervix NOS, benign neoplasm" to Uterus/cervix NOS, benign neoplasm
  • renamed "Mesenteric ischemia, chronic" to Mesenteric ischemia, chronic
  • renamed "Mesenteric ischemia, acute" to Mesenteric ischemia, acute
  • renamed "Mesenteric ischemia, NOS" to Mesenteric ischemia, NOS
  • renamed "Colon (large intestine) or rectum or anus, benign neoplasm" to Colon (large intestine) or rectum or anus, benign neoplasm
• retired
  • Delivery by caesarean section

2018-07-17

rolled out Ttenbergen 22:13, 2018 July 17 (CDT)

• in s_ICD10 table:
  • retired Joint NOS, contracture
  • changed code for Medical Assistance In Dying; retired old code and added new.
• in s_CCI_Picklist table
  • changed "Defibrillator, insertion (transcutaneous, epicardial leads)" to Defibrillator, insertion

2018-07-12

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"
• in s_ICD10 table:
  • added Hypoalbuminemia, severe
  • consistent naming to make similar to Liver or biliary system, metastatic malignancy to it (also code primary site):
    • changed "Liver or bile ducts, benign neoplasm" to Liver or biliary system, benign neoplasm
• in s_tmp table, set up Project Borrow arrive

2018-06-27

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)
  • added
    • Hypoalbuminemia, severe
    • Infestation, NOS
    • Stimulants incl methamphetamine intoxication, acute
    • Stimulants incl methamphetamine abuse/dependence/addiction
    • 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:
    • (T) Nerves of Arm
    • (I) Arm
    • (T) Nerves of Lower Trunk, Leg
    • (I) Leg
  • changed all the entries in the table to be of format (T/D/I) <organ system> rather than the older, more verbose names; this should also allow entering into the CCI1 box by starting to type
    • for now, in CCMDB they are of format <organ system> (T/D/I) but on the wiki they are still (T/D/I) <organ system> because I am having some difficulties automating the change. A search for the entry will still get you there.

2018-06-20

rolled out Ttenbergen 11:07, 2018 June 21 (CDT)

• in s_CCI_Picklist table, added
  • "Defibrillator, insertion (transcutaneous, epicardial leads)"
  • IABP
• in s_ICD10 table, added
  • Vascular syndromes of brain in cerebrovascular diseases
  • Problem related to unspecified psychosocial circumstances
  • fixed spelling from pencillin for Resistance to antimicrobials, methicillin (anti-staph penicillins)
• in s_CCI_2 table:
  • added Inspection, Exploration (endoscopic)
  • renamed Inspection, Exploration to Inspection, Exploration (non-endoscopic)
  • added Biopsy (endoscopic)
  • renamed Biopsy to Biopsy (non-endoscopic)

2018-05-30-1

rolled out Ttenbergen 17:06, 2018 June 19 (CDT)

• in S_ICD10 table,
  • changed Marfan's syndrome to Marfan syndrome
  • changed Down's syndrome (trisomy 21) to Down syndrome (trisomy 21)
• in s_CCI_1 table
  • changed " (D) Stomach" to (D) Stomach or Pylorus
• in s_tmp table, updated entries for Accept Loc Park; we had updated s_dispo for VIC - UC to VIC - UC, need to make Accept Loc Park consistent with this:
  • made VIC - UC inactive
  • added VIC - UC (with two spaces after hyphen)
• in s_dispo table, fixed spelling from "Joceylyn House" to "Jocelyn House"
• in ICD10 Chooser form, changed the way dxs are listed to not be entirely links to the wiki; there is now a wiki link at the beginning of the line, and the rest of the line is inert.

2018-05-30-1

rolled out Ttenbergen 20:05, 2018 May 30 (CDT)

• in s_CCI_Picklist table,
  • added
    • Pacemaker insertion, permanent
    • Pacemaker insertion, temporary
  • set end date for
    • Transfusion of WBC
    • Transfusion of whole blood
    • Transfusion of stem cells

2018-05-30

rolled out Ttenbergen 10:51, 2018 May 30 (CDT)

• in s_dispo table,
  • inactivated Misericordia - ER
  • added Misericordia - UC (as inactive) in anticipation of updating data as per Urgent Care Ttenbergen 09:31, 2018 May 30 (CDT)
• in s_ICD10 table
  • 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
• 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.
• in L_CCI_Component 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.

2018-05-17

rolled out Ttenbergen 17:06, 2018 May 24 (CDT)

• 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 Blood gas, arterial from "Arterial blood gas"
  • changed to Blood gas, venous from "Venous blood gas"

2018-05-09-1

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)
  • added Transfusion of albumin Ttenbergen 12:38, 2018 May 16 (CDT)
• in s_AllDiagnoses table fixed spelling for
  • Portacaval shunt (was protocaval)
  • Central Pontine Myelinolysis (was Central Pointine Myelinolysis)
  • Hypovolemic/Hemorrhagic Shock (was Hypovol/Hemorrhagic Shock, inconsistent with wiki)
  • HIV+
  • Central Line Related Blood stream Infection (CLR-BSI) (was Central line-related infection)
• in L_ICD10 subform, updated default and magic wand sorting to only sort by type and priority, not date. Date sorting remains a manual option by clicking the button.
• in s_ICD10 table
  • retired Vascular access device, insertion/adjustment/management

2018-05-09

rolled out Ttenbergen 10:22, 2018 May 9 (CDT)

• removing Registry Patient Type
  • deleted from Dispo tab in Patient Viewer
  • deleted references from Sub Reg_Yellower()
  • deleted Function Validate_Pt_Type()
  • deleted Sub R_Type_AfterUpdate()
  • updated sending functions
    • query Send_Centralized_1L_Log_update
    • query Send_Centralized_1L_Log_append
    • there is no delete query for L_Log
    • query send_Centralized_1L_Log__intermediate
  • deleted query check_OR_from_but_not_Surgical_Type; did not find any calls to it so it appears it wasn't actually used.
• removed some code remnants that had long been commented out, mostly from the old date/time/location structure

2018-05-07

rolled out Ttenbergen 17:37, 2018 May 8 (CDT)

• in table s_ICD10 table
  • retired (set stop date) for:
    • Alcohol use
    • Tobacco use
    • Need for medical isolation
  • fixed spelling
    • from "Staphylococcal scalded skin syndrome" to Staphylococcal scalded skin syndrome
    • from "Rehabilitation care" to Physical rehabilitation care
    • from "Cardiomyopathy, due to drugs and external agents NOS" to Cardiomyopathy, due to infection, drugs or external agents NOS
  • changed code for Tonsillitis, chronic from J35 to J35.0

• in s_AllDiagnoses table, changed spelling:
  • "2nd to Neuromuscular Dis" to Respiratory failure 2nd to Neuromuscular Disease

• in s_CCI_Picklist table, added:
  • Mechanical ventilation, noninvasive
  • ECMO, VA
  • ECMO, VV

2018-05-03

rolled out Ttenbergen 09:36, 2018 May 3 (CDT)

• updated Sub Convert_DB() to import into CCMDB data.mdb Change Log#2018-05-03. Ttenbergen 09:33, 2018 May 3 (CDT)

2018-04-24

rolled out Ttenbergen 17:21, 2018 April 25 (CDT)

• in s_CCI_2 table:
  • fixed spelling for Procure, Harvest, Obtain for Further Use, updated on wiki as well
• in s_ICD10 table
  • 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
• in s_dispo table
  • allowed GRA_CAU, HSC_CAU, STB_CAU as Dispo
• in s_CCI_Picklist table
  • added Isolation, infectious

2018-04-12

rolled out Ttenbergen 09:23, 2018 April 19 (CDT)

• in s_CCI_2 table:
  • 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.
  • moved "Psychiatric drug NOS, overdose/poisoning" to Psychotropic/psychiatric drug NOS, overdose/poisoning for naming consistency, updated wiki.
• in s_tmp table
  • added records for Septic Shock Order Set Ttenbergen 09:12, 2018 April 19 (CDT)

2018-04-11

rolled out Ttenbergen 15:29, 2018 April 12 (CDT)

• in s_CCI_2 table:
  • 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 " (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
• in s_ICD10 table:
  • changed "Candida spp." to Candida species for consistency
  • changed "Bronchitis, not specified as acute or chronic, infectious or noninfectious" to Bronchitis, acute or chronic not specified, infectious or noninfectious

2018-04-10-1

rolled out Ttenbergen 21:31, 2018 April 10 (CDT)

• in s_ICD10 table:
  • changed Serratia to Serratia species Ttenbergen 18:15, 2018 April 10 (CDT)
  • changed Enterococcus to Enterococcus species Ttenbergen 18:23, 2018 April 10 (CDT)
  • added Medical Assistance In Dying Ttenbergen 18:45, 2018 April 10 (CDT)

2018-04-10

rolled out.Trish Ostryzniuk 16:21, 2018 April 10 (CDT)

• add New Tmp project: [[ICUotherService].-- Trish Ostryzniuk 16:16, 2018 April 10 (CDT)
• renamed AXR plain film to Abdominal plain X-ray (AXR)

2018-04-09-1

rolled outTtenbergen 11:43, 2018 April 9 (CDT)

• updated sorting and column labels in
  • L_CCI_Picklist subform
  • L_CCI_Component subform
  • L_ICD10 subform
• fix to ICD10 Chooser form to accommodate change removing the ICD10_ID field Ttenbergen 11:45, 2018 April 9 (CDT)

2018-04-09

rolled out Ttenbergen 09:35, 2018 April 9 (CDT)

• removed ICD10_ID field from L_ICD10 subform as well Ttenbergen 09:35, 2018 April 9 (CDT)

2018-04-05-1

rolled out Ttenbergen 14:13, 2018 April 6 (CDT)

• update to CCI Chooser form - the category filter was showing nothing for Obstetric and Misc. As it should not, since there are none. But then it should also not list them.
• fixed spelling for No Comorbidities (ICD10 code) in s_ICD10 table. Ttenbergen 16:56, 2018 April 5 (CDT)
• updated s_CCI_2 table to use different codes for Inspection, Exploration (non-endoscopic)/Inspection, Exploration (endoscopic) (70d) and Nuclear Imaging(70i). Both were 70 and that got them mixed up. Ttenbergen 13:43, 2018 April 6 (CDT)
• 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)
  • deleted ICD10_ID field since we won't be using it now (coding actual ICD10 code instead)

2018-04-05

rolled out Ttenbergen 09:37, 2018 April 5 (CDT)

• fixed Sub dx_pick_cb_Click() to work with new ICD10 table Ttenbergen 09:37, 2018 April 5 (CDT)

2018-04-03

rolled out Ttenbergen 21:49, 2018 April 4 (CDT)

• added Sequelae of poliomyelitis (chronic weakness) to s_ICD10 table

• changes to accommodate CCMDB_data.mdb_Change_Log#2017-Dec-20
  • updated module Convert_DB() to look for L_CCI_Component table and L_CCI_Picklist table instead of L_CCI as we figured initially
  • updated module Sending Sub OpenOutputDBs()
  • updated L_ICD10_subform to use new ICD10 code field
  • updated L_Charlson_Diagnoses query
  • updated L_ICD10_APACHE_Comorbids query
  • updated L_ICD10_APACHE_Dx query - as far as it goes, this one is still not right.
  • added send queries
    • Send_Centralized_L_CCI_Picklist__intermediate query
    • Send_Centralized_L_CCI_Picklist_delete
    • Send_Centralized_L_CCI_Picklist_update
    • Send_Centralized_L_CCI_Picklist_append
    • Send_Centralized_L_CCI_Component__intermediate
    • Send_Centralized_L_CCI_component_delete
    • Send_Centralized_L_CCI_Component_update
    • Send_Centralized_L_CCI_Component_append
    • Send_Centralized_L_ICD10__intermediate
    • Send_Centralized_L_ICD10_delete (confirmed, no change)
    • Send_Centralized_L_ICD10_update
    • Send_Centralized_L_ICD10_append

Non-to-do

• L_CCI needs no resolving, since it already has not had any contents for some time.
• moving the newer CCI tables won't work because this will be the new CCMDB.mdb and they will be already overwritten
• so, CCI will start out empty.

2018-04-02

rolled out Ttenbergen 11:52, 2018 April 3 (CDT)

• updated L ICD10 subform to conditionally format the priority and dx fields to have different colours for odd and even priorities to make it easier to visually group Combined ICD10 codes. Ttenbergen 21:25, 2018 April 2 (CDT)
• updated s_dispo table
  • inactivated VIC_S5, VIC_N5, VIC_S4, VIC_S3, and VIC_N4

2018-03-22

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
• in s_ICD10 table fixed spelling for
  • Raynaud's syndrome/phenomenon Ttenbergen 18:42, 2018 March 22 (CDT)
  • Breast, inflammatory or infectious disorder of breast Ttenbergen 19:44, 2018 March 22 (CDT)
  • Klebsiella species - this one now is all species of ...

2018-03-20

rolled out Ttenbergen 21:29, 2018 March 20 (CDT)

• s_AllDiagnoses table; removed:
  • Pneumothorax generic 1100, should use specific
  • Pneumothorax iatrogenic 1101, should use Pneumothorax (iatrogenic)
  • old code 98090, should use Pneumothorax (iatrogenic)
  • Hemothorax generic 1000; should use specific
  • Hemothorax iatrogenic 10101, should use Hemothorax (iatrogenic)
• s_dispo table;
  • disabled generic Interventional Radiology
  • added HSC - Interventional Radiology
  • added STB - Interventional Radiology
• Patient viewer - updated tab order

2018-03-14

rolled out Ttenbergen 21:05, 2018 March 14 (CDT)

• updating diagnosis names and spellings that had been added/changed on wiki over the last few months. Ttenbergen 19:48, 2018 March 14 (CDT)
• fixed links to the wiki pages from the CCI tab Ttenbergen 00:31, 2018 March 15 (CDT)

2018-03-08

rolled out Ttenbergen 13:22, 2018 March 13 (CDT)

• updated s_dispo table
  • to allow GRA_CAU as Dispo
  • set acuity_level to NULL rather than 0 for HSC Cardiac cath Lab and STB Cardiac cath Lab; this was causing a warning for patients with dispo = cath lab and no Transfer Ready DtTm

2018-03-07

rolled out Ttenbergen 18:29, 2018 March 7 (CST)

• added dxs as decided at task meeting:
  • Infectious organism, unknown
  • Stenotrophomonas species
  • Citrobacter species
  • Enterobacter species
  • Acinetobacter species
  • Kidney, acute renal failure, postprocedural
• updated L_CCI_Component_subform, component 2 wasn't working right.

2018-03-05

rolled out Ttenbergen 15:01, 2018 March 6 (CST)

• fixed CCI links to wiki
• fixed dropdowns on CCI tab to look for "Category" instead of "TDI" since we now have more than T, D, and I
• updated the L_CCI_Component subform and L_CCI_Picklist subform to get rid of some bugs.

2018-02-18

rolled out Ttenbergen 17:52, 2018 February 28 (CST)

• much further messing with CCI data and forms
• updated query check_previous_location_vs_service_inconsistent to allow STB_CICU to enter Cardiac Surgery as Previous Service.

2018-02-01

rolled out. Ttenbergen <late afternoon>, 2018 February 16 (CST)

• replaced L_CCI_subform with:
  • L CCI Picklist subform
  • L CCI Component subform
• updated cross checks for ER_Delay
  • query check_ER_Delay_not_too_big
  • error msg in Function Dispo_Chronological()
• updated Function Regional_server() to use Regional_server = "\\ad.wrha.mb.ca\wrha\REGION\Shared\ICU_DATA_COLLECTION\" (from REGIONWRHA to REGION)

2018-01-31

rolled out Ttenbergen 17:49, 2018 January 31 (CST)

• additional tweaks to Accept Loc Park
  • confirmed query s_tmp_Accept_Log_Park_prev_no_tmp
  • updated query s_tmp_Accept_Log_Park_tmp_no_prev

2018-01-30

rolled out Ttenbergen 13:54, 2018 January 30 (CST)

• fix to L ICD10 subform, still wasn't setting the primary dx checkbox properly, now does.

2018-02-02 (mis-dated)

had been rolled out... Ttenbergen 13:54, 2018 January 30 (CST)

• fixes to cross check for Accept Loc Park; include Pre-admit Inpatient Institution = "NA / not applicable":
  • query s_tmp_Accept_Log_Park_prev_no_tmp
  • query s_tmp_Accept_Log_Park_tmp_no_prev

2018-01-21

rolled out Ttenbergen 19:04, 2018 January 23 (CST)

• confirmed that pre-send-checker would catch duplicate diagnosesTtenbergen 13:51, 2018 January 21 (CST)
• added for Accept Loc Park:
  • nursing stations Ttenbergen 13:51, 2018 January 21 (CST)
  • added cross checks:
    • query s_tmp_Accept_Log_Park_prev_no_tmp
    • query s_tmp_Accept_Log_Park_tmp_no_prev
• in ICD10 tab, fixed the primary dx checkbox that had been linked to the date unknown field (as the date unknown field was linked to as well) Ttenbergen 14:19, 2018 January 21 (CST)
• ER_Delay#CCDMB_Data_Integrity_Checks_(implemented) (query check_ER_Delay_not_too_big)
  • reduced ICU delay to 4hrs
  • fixed problem where wasn't finding errors before, confirmed working
• confirmed that there will be an error if trying to send Pharmacy without at least one line. Ttenbergen 14:42, 2018 January 21 (CST)
• confirmed that can enter Previous Service "Cardiology" when Previous Location is STB_ACCU.
• Split CCI and ICD10 tabs. Ttenbergen 19:02, 2018 January 23 (CST)

2018-01-10

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

2018-01-09

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

• Added Awaiting Codes:
  • Awaiting/delayed transfer to home
  • Awaiting/delayed transfer to long-term care/PCH
  • Awaiting/delayed transfer to other acute care facility
  • Awaiting/delayed transfer to transitional care facility

2018-01-04

rolled out Ttenbergen 19:08, 2018 January 4 (CST)

• added sending for L_CCI table and L_ICD10 table Ttenbergen 17:31, 2018 January 4 (CST)
  • updated Send_Data()
  • updated Sub OpenOutputDBs Ttenbergen 17:35, 2018 January 4 (CST)
  • updated Sub CloseOutputDBs Ttenbergen 17:35, 2018 January 4 (CST)
  • added queries:
    • Send_Centralized_L_CCI__intermediate
    • Send_Centralized_L_ICD10__intermediate
    • Send_Centralized_L_CCI_delete
    • Send_Centralized_L_ICD10_delete
    • Send_Centralized_L_CCI_update
    • Send_Centralized_L_ICD10_update
    • Send_Centralized_L_CCI_append
    • Send_Centralized_L_ICd10_append

2017-12-28

Rolled out Ttenbergen 13:24, 2018 January 4 (CST)

• removed Angio coronary field and Angio others field from labs tab in patient viewer Ttenbergen 17:01, 2017 December 28 (CST)
• updated the pick button in ICD10 Chooser form to no longer requery the L ICD10 subform as this was resorting the dxs and collectors then had to find the one they had just entered to finish the entry. Ttenbergen 18:44, 2017 December 28 (CST)
• 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)