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

Dispo Fields Conversions

• Finish conversion of old dispo field data
• preacute, previous location and dispo (Julie has sent Tina emails)

2016_Time_and_Place_changes

off ward checked off box hooked up to pharmacy field

• ICU pt since beginning of July we don't have offward data, because the check off box was hooked up to Pharm complete box.
• Medicine: Tina to make a query to shift across pharmacy complete box will be transferred to off ward checkbox. started July 1.16
• ICU: No query. Cannot reclaim. Will report started on Sept 1.16

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.

CFE - Service Location Field

• Service Location field in CFE should allow inactive option
• FORM VIEW LOCATION DROPDOWN HAS TO RESOLVE TO NAME BUT GO TO FORM WHEN TRYING TO EDIT

GSC tag if sedated or paralyzed

• Need to ID if GCS was done whether a pt was sedated/paralyzed. Check box somewhere? Trish Ostryzniuk 17:11, 2016 August 25 (CDT)

DSM labs exchange

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

TISS importer

• needs work - should not create duplicate patients
• Should import D_ID lowercase

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

Add Venous Blood gas count

ABG to count separate to ABG, so need to add to lab_flow.

• document
• add to CFE interfaces
• add field to centralized_data
• add to CCMDB interfaces
• add field to CCMDB_data
• add to sending

Might want to hold off until we do the bigger round of updates to sending and data structure we have on the books. See Requested_CCMDB_changes_for_the_next_version#Data_and_Sending_related_changes Need to discuss I think.

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

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

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

• 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.

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

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)