Change Priorities

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

Main office team priorities. Please fill in from Category:Potential Change

DSM labs exchange

• DSM_Lab_Extract need to set up Ttenbergen 14:56, 2015 April 8 (CDT)
• Test DSM data testing

dispo

Discussed with Julie: do low-hanging fruit now and then reconvene. Julie emailed me newest notes from her meetings with Allan. Ttenbergen 16:08, 2015 April 15 (CDT)

• Dispo field (proposed)
• Hospice - needs addressing with above.

Multiple encounter consistency checks

• Tina to review further with Julie when at this point.
• Linking - priority because alot of report rely on it.Trish Ostryzniuk 12:56, 2014 September 23 (CDT)
• Negative discharge dt adm date diff (overlap, duplicate)
• 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

MCHP data

Manitoba Centre for Health Policy export

Reports into Access

Critical Care Inter-facility Transfer Report

Need and NDC: for ARF, CRF & Task dialysis

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

• Template:Discussion is this Check Renal Tasks? If so, there are questions there. Ttenbergen 14:09, 2014 May 14 (CDT)

integrate TISS28 Scanning quality checks into front end

• tblPatientDateViewSAS not being updated in TISS28.mdb.Trish Ostryzniuk 16:52, 2013 April 5 (EDT)
  • not sure why above article was deleted. If there is another article then this should be linked there.Trish Ostryzniuk 18:00, 2014 May 29 (CDT)
• TISS28 data specifications 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

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

potential change

• all of Category:Potential Change

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

add button to run NDC queries in sequence

Run each NDC query, and if nothing is found, just run the next one. Stop when something is found. Probably have it start from the “current” query so it can continue from where it stopped rather than start over. Trish Ostryzniuk 13:36, 2015 May 1 (CDT)

make L Problem table

NDC button only makes sense if there are few entries. There will be many unless we can manage false positives, which requires L_Problem.

• see also:
  • Known data errors old values like includes missing APACHE values, overlaps, no primary DX, admit brain dead can be added later.

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.

• Change both to: Hypernatremia NA, treated
  • Hypernatremia NA Greater Than 160.
  • 32500 - Hypernatremia NA greater than 160

• Change both to: Hyponatremia NA, treated
  • Hyponatremia NA Less Than 120.
  • 32600 - Hyponatremia-Na less that 120

• Change to: Hyperkalemia, K treated
  • Hyperkalemia K Greater Than 6.5.

• Change to: Hypokalemia K, treated
  • Hypokalemia K Less Than 2.5.

• Change to Hypocalcemia Ca, treated
  • Hypocalcemia Ca Less Than 1.8.

• Change both to: Hypercalcemia Ca, treated
  • Hypercalcemia Greater Than 3.0.
  • 32900 - HYPERCALCEMIA-great than 3.0

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.

PrevInptLocation field

• checked over article, added questions, please have a look over... Ttenbergen 15:27, 2015 May 27 (CDT)
  • scheduled to discuss at June 30 meeting, on hold till then Ttenbergen 13:12, 2015 June 22 (CDT)

wiki re-work

• break Serial number into articles in Category:Location and Serial Number Connections

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

legacy data storage

• address HMORT
• LTV - still called "R_Filter" behind scenes, nice to clean up
• Export and permanently store TMSX MedTMS legacy data

clean-up processes and data

• review and eliminate legacy fields in CCMDB that are no longer used; Category:Legacy Data is a likely starting point, or a look at mostly L_Log, pharm and labs would be.
  • eliminate Ap_SapsSysBP

new functionality

• integrate reporting
• see Dr Garland's running list in Task minutes
  • Which date of minutes?Trish Ostryzniuk 19:06, 2014 March 3 (CST)
    • I thought he kept a running list, ie updated as we add? Ttenbergen 13:43, 2014 March 11 (CDT)
• postal code field split out from tmp
• Check other things (checks currently being run in SAS)
• Apache Value Reconciliation
• Centralized_data_front_end.mdb_Change_Request#After_go-live
• imaging import from RisPacs