Change Priorities

From CCMDB Wiki
Jump to navigation Jump to search

for info on the priority Re-sort button see that article

This article contains links to pages (and headings if applicable) in the order of priorities of changes. Primarily it's a tool for Tina and Trish to communicate, but if you have a problem with the prioritization please feel free to comment.

Prioritized List of Changes

CCMDB - Labs counts =

  • target date to stop lab item collection for ICU for CCMDB
    • stop counting labs (chemistry, hematology and microbilogy) for any discharges the occur on of: April 1, 2017 00:01 hrs.
    • continue count labs for all discharges up to March 31.17 2359 hrs.

DSM labs exchange

TISS28

TISS updates

  • Structure:
    • Discussed to change TISS to have tblTISSitem link to L_Log directly and only reference tblTISSform separately; this will make adding a new line manually trivial (next requirement), and will also make the data faster and easier to use.
  • CFE:
    • need to be able to add an item here
  • Importer:
    • needs work - should not create duplicate patients
    • Should import D_ID lowercase

integrate TISS28 Scanning quality checks into front end

  • Tina can you please review and clean up article as some of this stuff may no longer be applicable. Trish Ostryzniuk 15:31, 2016 September 26 (CDT)
    • TISS28 data specifications#Views Views and completeness for form checking. Include those that Pagasa is using printed out registry list to manually check TISS before scanning. Pagasa and Julie have made a LIST and put it on X under TISS28. -more work to do here Fred with Julie.Trish Ostryzniuk 16:52, 2013 April 5 (EDT)
  • In the process of validating the output with Julie. Time permitting, work will start on other Views next week. -- Fred Schumacher 11:44, 2013 February 15 (EST)
  • see Data processing checks for TISS
  • when this is finally worked on we need to address how tiss.mdb does not link together patients if the location is changed after initial scanning. Ttenbergen 13:30, 2015 October 5 (CDT)

Post code

  • Fix master table - removed unnecessary columns of data and put RHA's
    • in the interm, Pagasa only has to enter postal code, town and RHA until this table is fixed up.

change APACHE tab to ICU tab and Medicine Tab (Alert)

  • when fixing up CCMDB tabs, to reduce confusion, change APACHE tab to ICU tab and the medicine one to Medicine tab.
  • APACHE article refers to ICU
  • ALERT article refers Medicine not APACHE article

Reports into Access

Critical Care Inter-facility Transfer Report


Multiple encounter consistency checks

  • Tina to review further with Julie when at this point. Must check it if consistent with Visit Admit DtTm field.Trish Ostryzniuk 15:38, 2016 September 26 (CDT)
  • Linking - priority because alot of report rely on it.Trish Ostryzniuk 12:56, 2014 September 23 (CDT)
  • Large diff in time
  • Short diff but inconsistent locations (incl EMIP)

Ttenbergen 13:56, 2014 August 18 (CDT) --Trish Ostryzniuk 17:43, 2014 May 2 (CDT

ICD10 DX list

  • Trish to set up meeting with Allan, Laura, Joyce, Con. Trish Ostryzniuk 14:54, 2016 September 26 (CDT)

Changes to CCMDB needed to get rid of Data collection Log sheet

See Minutes Team Meeting June 8, 2016 item 3.

Transition to Database Server

MCHP data

Manitoba Centre for Health Policy export

  • give them what we have, let them know how it has changed, we will not update to their structure.
  • what is the least work we can send them it in? Basic raw tables and relationships explained. send them CCMDB and CFE and centralized data and TISS when integrated.
  • Tell them to: Ignore rest, just use L_tables and S_tables Tina has it ready, except has to add s_tables. Tina but would have to add s-table relationships. Not done yet.
  • Wiki articles need to updated and data dictionary has to be done first.
  • how to send? As an Access.mdb. They can tie into it with other programs.
  • 2016 - Dr. Manjit asking when we are going to sent next data, only has up to 2012.
  • take suggestion to task Template:Discuss@task


Need and NDC: for ARF, CRF & Task dialysis

--Trish Ostryzniuk 19:12, 2014 May 8 (CDT)details to be obtained from Pagasa and Julie.


PCH

MBH.mdb

in progress, see MB Health Tool.mdb

CFE editing - need integrity checks in place to catch editing errors

  • Admit transfer discharge DOB range as from CCMDB

Dispo Field clean-up

Julie is finishing last cross check, can remove fields when she is done Ttenbergen 11:25, 2016 September 26 (CDT) 2016_Time_and_Place_changes

potential change

Holding Zone to move up into the change Queue when details finalized

Metablic DX code label (definition changes) in L_DX and on Wiki

HOLD - METABOLIC stuff: don't change June 18.15

Template:Discussion If anyone has idea how they would like to relabel in CCMDB L_DX, open to suggestions, my suggestion below.

Registry Patient Type

  • Almost done. Discussion not complete at TASK MEET May 6.15. By next meet: June 3.15 - Allan talk to Boyan P final details. See minuetes from meeting on this Date. Will push to keep this visible on priority list to finish!! Collector workload reduction.
  • next task meet June 11.15.

Check ORDx

Patient copier button

wiki re-work

things that used to be part of article "TMSX MedTMS to Centralized go-live"

legacy data storage

clean-up processes and data

new functionality

ALERT Score APP

this is in Dr Robert's court as of 2015-12, waiting to hear back from him.

  • had gone to Trevor Strome, who has gone to DSS since. Status of this not clear.Trish Ostryzniuk 17:04, 2016 August 25 (CDT)