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.

Tina can clean this up as she sees fit.

Prioritized List of Changes

Trish please fill from Category:Potential Change as you see fit.

1. 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.
   • The Elective Surgery (ES) of ED’s and the Centralized are still interchanged. See link. The Admit_TYPE categories are also shown based on the definition in wiki (http://ccmdb.kuality.ca/index.php/Admit_Type_for_APACHE_II ) and they are not matching in ED’s and Centralized. Julie Mojica.
2. 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.
3. 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 Mojicaas per email sent: April 30.14.
4. adjustments (in bracket) to APACHE Scoring table done on APRIL 23.14 (see edit history). Would need to check and update centralized front end.
   • AaDo: 201(200)-349
   • PO2: 61-69 (70)
   • CO2: <=14 ((<15)
   • PH: <=7.14 (<7.15)
   • K: <=2.4 (<2.5)
   • HCT: <=19.9 (<20)
   • WBC: <0.9 (<1)
5. Sending to centralized data.mdb - Record Status field changes in centralized that seem to occuring when send files are uploaded to centralized.mdb. For some reason random files going into centralized, and Record Status field is changed to SENT, yet files had not been sent as complete to CVS for that date. They remain as Incomplete in record status field on their laptops. Collector appear to be able to send file to CSV the following week, but we have not heard of error message that status is already SENT in centralized and they could not resend. Sites affected: HSC: A4, D4, H4 GRA N3, N5. Good example: HSC_D4. in centralized, 8 files are showing as SENT (as per PIVOT) April 17.14. There were actually 18 sent in CSV on this date. 3 of them, have record status SENT in centralized yet they were not sent to CSV on April 17. On April 23, Judy able to include the sending of 2 of the ones already marked SENT in centralized April 17, but she had no complaint of a ERROR message that we heard of. 2 patients 10669 & 10656 were sent CSV but date SENT remains in centralized as April 17. One record 10634, is marked as sent in centralized but record status field on her laptop is incomplete. So far not able to figure out issue in regards to how she could these 2 without error message. We will monitor this weeks send and see if we can clue in further.-Trish Ostryzniuk 20:03, 2014 April 30 (CDT)
   • April 30, 14: GRA_N5 was unable to send files today. 2 files in centralized have record status set as SENT, yet on laptop, they are incomplete and still in unit.Trish Ostryzniuk 11:10, 2014 April 30 (CDT)
   • April 30.14: HSC H4: Pat Stein - error message about missing Minimal Data Set first send attempt today she had to enter fake admit "times". She said that this was not an issue for some time but the problem is back again.
     • Second issue she had today when going in and out of patient list, some of the patient with LOCATION HSC MICU were showing up on her laptop. When she would get out of patient list then go back in, LOCATION HSC MICU was not showing. Don't understand this one.
     • Pat also had a patient that record status field was set to SENT in centralized on April 26.14 at 1436, but on laptop record status remains incomplete because it is a MR pt. She could not send. I had to go into centralized and reset record status so she could send.
   • April 30.14: HSC_D4: Judy Kublick - could not send because serial 10657 record status was set to SENT on April 15.14 1803 hrs, yet on laptop, record status is Incomplete and for MR. Made the change in centralized to record status field so she could sent.Trish Ostryzniuk 20:09, 2014 April 30 (CDT)
6. 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)
7. P_Outstanding_Admits would like the Incompletes with NO discharge date.Trish Ostryzniuk 19:54, 2014 April 25 (CDT)
8. NDC for centralized front end - VAP AND CLI. Check with Pagasa.
9. How to deal with Orphan in centralized. There are 55 showing up again. Review with Pagasa.Trish Ostryzniuk 18:06, 2014 April 11 (CDT)
10. Confirm data import and sending into centralized with Julie.Trish Ostryzniuk 16:01, 2014 February 24 (CST)
11. Apache Value Reconciliation
12. integrate TISS28 Scanning quality checks into front end.
    • tblPatientDateViewSAS not being updated in TISS28.mdb.Trish Ostryzniuk 16:52, 2013 April 5 (EDT)
    • 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)
13. address Centralized data front end.mdb Change Request
14. address TMSX MedTMS to Centralized go-live
    • consolidate and re-link that article

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. Record Status field: issue of it getting changed in centralzied somehow during sending process from INCOMPLETE to SENT. Not resolved Trish Ostryzniuk 19:55, 2014 April 25 (CDT)
4. import part of iTISS that corresponds to specific Tasks into centralized. See Tasks vs iTISS for mapping.