Change Priorities

From CCMDB Wiki
Revision as of 16:06, 2014 June 20 by TOstryzniuk (talk | contribs) (Tmp files dates backwards)
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

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

where:

  1. Ed's Medicine, PDA reader: runt time error 5.Trish Ostryzniuk 15:46, 2014 June 20 (CDT)
  2. comparing SENT files to centralized against Ed's.Trish Ostryzniuk 15:46, 2014 June 20 (CDT)
  3. Created Variables
  4. fix tmp import dates that are backwards. See item 4 below. Ttenbergen 09:47, 2014 June 12 (CDT)
  5. there are two comments in TMPV2 for. 1. CLI, 2. CLI (call Basil Evan if MICU/SICU/IICU) should only be second one.PTorres 12:13, 2014 June 20 (CDT)
  6. Wegener's Granulomatosis / Granulomatosis with polyangiitis - clean up s-allDiagnosis. Remove the -P ANCA+. Trish Ostryzniuk 17:51, 2014 June 16 (CDT)
  7. Centralized data front end.mdb - set up a Basic Patient Info Button for pagasa-Trish Ostryzniuk 12:47, 2014 June 19 (CDT)
    • ADD to MASTER centralized front end: Query: 1_In_L_Log_BUT_NOT_In_L_Phi. The SQL script for this query emailed to Tina today.Trish Ostryzniuk 14:08, 2014 June 19 (CDT)
  8. SEE: Centralized data front end.mdb Change Request-PTorres 12:05, 2014 June 20 (CDT)
  9. orphans must allow "questioned" pts in record statusfield in centralized.PTorres 12:09, 2014 June 20 (CDT)
  10. ADD to MASTER centralized front end: Pivot: P_Count_of_Sent_PAGASA_Likes. A Copy of current centralized front end copied to X is is renamed as: Pagasa Pivot centralized front end.mdb.--PTorres 15:45, 2014 June 19 (CDT)
  11. TISS28 Data.mdb on X. Need to make a scheduled task to have a copy of this database and the images files elsewhere. X went down 1650 hrs on Mon June 16.14. Connection is restore Jun 18.14 but data restored does not contain the 10 batches scanned prior to X drive failure. 1. Trish to ask ehealth to restore to prior to 1645 hrs Jun 16 or if they cannot 2. Pagasa will have to rescan all.Trish Ostryzniuk 12:09, 2014 June 18 (CDT)
  12. bad dates in tmp: date_var entries are reversed in centralized_data vs real data in tmp_v2; need to fix and re-import. Ttenbergen 09:37, 2014 June 4 (CDT)
  13. figure out date setting for access generically.
  14. Labs collected list Items 136. pentaspan and item 142 Voluven to be taken off L_Labs_Flowsheet. They are not longer given to patients.Trish Ostryzniuk 16:52, 2014 June 4 (CDT)
  15. Multiple encounter consistency checks.--Trish Ostryzniuk 17:43, 2014 May 2 (CDT)
  16. Lab Collection at HSC: Progress as June 3.14: once Reflections is installed on HSC ICU laptops Gail Hall & Joyce Peterson and both are shown know how to hook up their laptops to monitors in JJ387, then Tina can proceed make changes to L Labs Flowsheet, Labs collected list. The absolute target date to have HSC ICU collectors doing additional lab counts on their laptops as of Aug 1.14 for all new ICU admissions. Pagasa to stop downloading ICU admissions as of Aug 1.14Trish Ostryzniuk 18:02, 2014 June 3 (CDT)
  17. Need and NDC: for ARF, CRF & Task dialysis.--Trish Ostryzniuk 19:12, 2014 May 8 (CDT)details to be obtained from Pagasa and Julie.Trish Ostryzniuk 19:12, 2014 May 8 (CDT)
    • is this Check Renal Tasks? If so, there are questions there. Ttenbergen 14:09, 2014 May 14 (CDT)
  18. 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)
  19. address Centralized data front end.mdb Change Request
  20. address TMSX MedTMS to Centralized go-live
    • consolidate and re-link that article
  21. L_Log - we don't understand the logic why there is a difference "counts" when you sort and filter and don't sort and filter. For For example, we have to sort record status field first before we filter, otherwise not counting all the same way. Example: filter by vetted without sorting this field first and counts are different. Review with Pagasa. Both Julie and Trish getting error because we don't know why you have to sort before you filter. Pagasa only one that know this trick. Why should here be this trick. I guess we don't understand what Access is doing or we expect it should be doing something regardless doing it in this order.Trish Ostryzniuk 20:21, 2014 April 30 (CDT)
    • catch me when I am in. Ttenbergen 20:07, 2014 May 1 (CDT)

likely fixed, please delete as confirmed

  1. Laptop files copier.bat, All shortcuts fixer.bat & Timesheet - web desktop shortcut - some shortcuts no longer needed. Timecard shortcut needs to be changed. The excel template one is going out of business as of June 13.14. Trish Ostryzniuk 17:51, 2014 June 10 (CDT)
    • deleted hours and forms ordering shortcuts Ttenbergen 16:36, 2014 June 16 (CDT)
  2. Location field#Drop Down limitation for ccmdb.mdb to locally collected. List for table sent back to Tina May 28.14.
  3. see Pagasa - to review issues with:
    • Editing orphans (L_Log AND L_PHI), examples 18279_MICU_HSC but should be SICU has to clean in 2 tables in centralized
    • fixing location error 3226 HSC_H4 but should be H4H- has to fix in centralized in 2 tables.
    • the process of Vetting is actually creating orphans (316 of them this week).
    • L_log: column B_MY - exported from Ed's has YYYY/MMM/01, but newly sent data is BLANK.
  4. NDC_CLI. Trish Ostryzniuk 16:50, 2014 May 30 (CDT)
    • what about? Ttenbergen 11:03, 2014 June 2 (CDT)
      • not reporting correctly. CLI in DX and TMP.
        • Also, need to restrict date for Medicine Jan 1.14 onward. We were doing it for medicine Dan had wanted to include it in the past but Julie was not QA checking it because no reports requested and the fact that we had not line counts for medicine, just reporting numbers of line infections. Since no one checking it medicine has alot of errors.-Trish Ostryzniuk 12:01, 2014 June 2 (CDT
  5. Centralized Front end:
    • Aptotal_physiological points in the Created_Variables query. It is currently showing all zeros as the value. Thanks Tina!Trish Ostryzniuk 17:12, 2014 May 14 (CDT)
    • Chronic Health Points - if chronic health is 9NoCH then point are zero. Does not matter what the AP_Admit type is.
    • Age: what has happened, this was matching before? Could this because of the version issues from the other week?
    • transfer delay - as per Julie email May 16.14.
  6. NDC for centralized front end - VAP AND CLI. Check with Pagasa.
    • I think Pagasa explained but I can't remember; we should work on this together sometime I am in, please catch me. Ttenbergen 20:01, 2014 May 1 (CDT)
  7. Admit Type for APACHE II. The Centralized import from Ed.mdb possible conversion problem. Tina needs to check the coding of elective surgery, emergent surgery, medical. Imported, data not matching what is in Ed. Julie could advise further.
  8. Centralized - the diagnosis code for ACUTE PERITONEAL DIALYSIS (TASK) should be changed from 1003201 to 100301. Julie Mojica as per email sent April 30.14.
  9. ED’s has 8 missing CH data (due to missing APACHE elements – same with ES)Chronic Health APACHE. Centralized_data - assigns data to the missing 8 cases. These should have been treated as MISSING in the centralized data. Julie Mojica as per email sent: April 30.14.
  10. Updated Apache scoring in CCMDB.mdb, still need to import to Centralized front end
  11. Bug - Incomplete patients are being set to "sent" in Centralized data.mdb - likely fixed
  12. P_Outstanding_Admits would like the Incompletes with NO discharge date.Trish Ostryzniuk 19:54, 2014 April 25 (CDT)
  13. How to deal with Orphan in centralized. There are 55 showing up again. Review with Pagasa.Trish Ostryzniuk 18:06, 2014 April 11 (CDT)
  14. Centralized import from Ed.mdb - not sure if copy on X dated May 5.14, you had used the most current version to work on update with fixes. I ran the importer last evening which included Julie task.xls. L_task is showing blanks and L_DX is the missing tasks. Should be only things we still had issues with was CH and Elective Surgery fields for importer, so lots of other weird things showing up. Can review with Julie when you are in.Trish Ostryzniuk 19:20, 2014 May 7 (CDT)--Trish Ostryzniuk 19:12, 2014 May 8 (CDT)
  15. I am wondering is there is an issue with version controlling for both centralized front end and centralized import from Eds. I noted today that in the s_admitdischarge table Grace Nursing Home Ward (nursing home GRA) is missing from centralized front end. I added it back in on version on X. Let me know what you think may be going on. Note: It had been added to master on X on April 10.14 and it was added to this list to make sure you update. - Trish Ostryzniuk 15:45, 2014 May 6 (CDT)--Trish Ostryzniuk 19:12, 2014 May 8 (CDT)
  16. Created Variables. APACHE Scoring table- see Julie's email Wed May 28 at 11:04 hrs. coding in centralize front end for:
    • creatpts- ed's has some pts with decimal pointed values and they have been rounded on centralized which is okay. This may account for difference of total creatinine points. Ed is higher by 84.5 total.
    • agepts - age point for 8 valid blank apache data (4 in med and 4 in ICU) should not be included in total age points.
    • AaDO2
    • hopefully addressed Ttenbergen 18:33, 2014 May 28 (CDT)
  17. centralized front end-Transfer Ready Calculation_errors_due_to_dummy_year_and_dummy_times_in_blanks
    • calculated created variables button we get a runtime error message 94.Trish Ostryzniuk 17:51, 2014 May 28 (CDT)
    • hopefully addressed Ttenbergen 18:33, 2014 May 28 (CDT)
  18. Orphans in Centralized data.mdb in Centralized data Vetting Process not working.PTorres 11:32, 2014 May 28 (CDT)
    • hopefully addressed Ttenbergen 18:33, 2014 May 28 (CDT)
  19. one of the CLI and and both VAP NDC's not correct. See Pagasa.Trish Ostryzniuk 19:13, 2014 May 27 (CDT)
    • not enough info, asked Pagasa to talk to me tomorrow. Ttenbergen 18:33, 2014 May 28 (CDT)

Item to consider where to put on Priority list

  1. Gaps in CCMDB Dataset

Doesn't really need to be on here, it's in the potential change list. That makes me think, though. Trish and Tina ought to go through that category and the "bugs" category to see if any individual articles are actually a higher priority.

To do before go-life

  1. Process for editing between send weeks? How to manage master centralized.mdb and Front end and PHI.mdb each week.
  2. Edit process in new database if accidently deleted field or file when editing master mdbs in main office: back up before Edit, then back up after edits complete? Back up to which location?
  3. import part of iTISS that corresponds to specific Tasks into centralized. See Tasks vs iTISS for mapping.
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Change_Priorities&oldid=39220"