Change Priorities: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
TOstryzniuk (talk | contribs)
mNo edit summary
TOstryzniuk (talk | contribs)
mNo edit summary
Line 6: Line 6:
Trish please fill from [[:Category:Potential Change]] as you see fit.
Trish please fill from [[:Category:Potential Change]] as you see fit.
#[[Admit Type for APACHE II]]. The [[Centralized import from Ed.mdb]] possible conversion problem. Tina needs to check the coding of elective, emergent surgery, medical.  Imported, data not matching what is in Ed. Julie could advise further.
#[[Admit Type for APACHE II]]. The [[Centralized import from Ed.mdb]] possible conversion problem. Tina needs to check the coding of elective, 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]].
#Sending to centralized data.mdb - problem can not be pin pointed yet.  For some reason random files going into centralized, and '''record status''' is changed to SENT, yet files had not been sent as complete to CVS for that date.  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, 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 is still incomplete on her laptop.  So far not able to figure out issue in regards to how she could these 2 without error message.  Not that we see there is some sort of problem, we will monitor this weeks send and see if we can figure out problem further.--[[User:TOstryzniuk|Trish Ostryzniuk]] 19:22, 2014 April 25 (CDT)
#Sending to centralized data.mdb - problem can not be pin pointed yet.  For some reason random files going into centralized, and '''record status''' is changed to SENT, yet files had not been sent as complete to CVS for that date.  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, 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 is still incomplete on her laptop.  So far not able to figure out issue in regards to how she could these 2 without error message.  Not that we see there is some sort of problem, we will monitor this weeks send and see if we can figure out problem further.--[[User:TOstryzniuk|Trish Ostryzniuk]] 19:22, 2014 April 25 (CDT)
# P_Outstanding_Admits would like the Incompletes with NO discharge date.[[User:TOstryzniuk|Trish Ostryzniuk]] 19:54, 2014 April 25 (CDT)
# P_Outstanding_Admits would like the Incompletes with NO discharge date.[[User:TOstryzniuk|Trish Ostryzniuk]] 19:54, 2014 April 25 (CDT)

Revision as of 09:58, 30 April 2014

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

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, emergent surgery, medical. Imported, data not matching what is in Ed. Julie could advise further.
  2. Sending to centralized data.mdb - problem can not be pin pointed yet. For some reason random files going into centralized, and record status is changed to SENT, yet files had not been sent as complete to CVS for that date. 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, 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 is still incomplete on her laptop. So far not able to figure out issue in regards to how she could these 2 without error message. Not that we see there is some sort of problem, we will monitor this weeks send and see if we can figure out problem further.--Trish Ostryzniuk 19:22, 2014 April 25 (CDT)
  3. P_Outstanding_Admits would like the Incompletes with NO discharge date.Trish Ostryzniuk 19:54, 2014 April 25 (CDT)
  4. NDC for centralized front end - VAP AND CLI. Check with Pagasa.
  5. How to deal with Orphan in centralized. There are 55 showing up again. Review with Pagasa.Trish Ostryzniuk 18:06, 2014 April 11 (CDT)
  6. Confirm data import and sending into centralized with Julie.Trish Ostryzniuk 16:01, 2014 February 24 (CST)
  7. Apache Value Reconciliation
  8. 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)
  9. address Centralized data front end.mdb Change Request
  10. 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.