|
|
| (631 intermediate revisions by 5 users not shown) |
| Line 1: |
Line 1: |
| ''for info on the priority [[Re-sort button]] see that article | | ''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.
| | See [[To do list]] - it's prioritized by whatever has soonest todo action item via [[:Template:Todo]]. If a change is relevant to multiple concepts/pages, a new page may need to be made to track it. |
| | |
| *Tina can clean this up as she sees fit.
| |
| ** I will comment and clean/summarize as I complete things, but the point of this page is '''for main office to rank this by their priority'''.Ttenbergen 22:11, 2014 April 30 (CDT)
| |
| | |
| == Prioritized List of Changes==
| |
| Trish please fill from [[:Category:Potential Change]] as you see fit.
| |
| #[[Centralized import from Ed.mdb]] - not sure if copy on X dated May 5.14 is the most current version you used to update with fixes. I ran the importer last evening which included Julie task.xls. L_task is showing blanks and L_DX is missing task.
| |
| #I think there is an issue with version controling 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. It was added to master on X a number of weeks ago and has gone missing.[[User:TOstryzniuk|Trish Ostryzniuk]] 15:45, 2014 May 6 (CDT)
| |
| #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.[[User:TOstryzniuk|Trish Ostryzniuk]] 20:21, 2014 April 30 (CDT)
| |
| #* catch me when I am in. Ttenbergen 20:07, 2014 May 1 (CDT)
| |
| # 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)
| |
| # [[Apache Value Reconciliation]]
| |
| # integrate [[TISS28 Scanning quality checks]] into front end.
| |
| #* [http://ccmdb.kuality.ca/index.php/TISS.mdb_Change_Log#Version_2013-02-28 tblPatientDateViewSAS] not being updated in TISS28.mdb.[[User:TOstryzniuk|Trish Ostryzniuk]] 16:52, 2013 April 5 (EDT)
| |
| #* [[TISS28 data specifications]] [http://ccmdb.kuality.ca/index.php/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.[[User:TOstryzniuk|Trish Ostryzniuk]] 16:52, 2013 April 5 (EDT)
| |
| #*In the process of validating the output with Julie. Time permitting, work will start on other [http://ccmdb.kuality.ca/index.php/TISS28_data_specifications#Views Views] next week. -- [[User:Fschumacher|Fred Schumacher]] 11:44, 2013 February 15 (EST)
| |
| # address [[Centralized data front end.mdb Change Request]]
| |
| # address [[TMSX MedTMS to Centralized go-live]]
| |
| #* consolidate and re-link that article
| |
| | |
| ==likely fixed, please delete as confirmed ==
| |
| #[[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]].
| |
| #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.
| |
| # 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.
| |
| #Updated Apache scoring in CCMDB.mdb, still need to import to Centralized front end
| |
| #[[Bug - Incomplete patients are being set to "sent" in Centralized data.mdb]] - likely fixed
| |
| # P_Outstanding_Admits would like the Incompletes with NO discharge date.[[User:TOstryzniuk|Trish Ostryzniuk]] 19:54, 2014 April 25 (CDT)
| |
| #* added a field "has_discharge_date"; Trish updating [[Pivot table for centralized]] to reflect. Ttenbergen 19:58, 2014 May 1 (CDT)
| |
| # How to deal with Orphan in centralized. There are 55 showing up again. Review with Pagasa.[[User:TOstryzniuk|Trish Ostryzniuk]] 18:06, 2014 April 11 (CDT)
| |
| #* see [[Orphans in Centralized data.mdb]] and let's talk. Ttenbergen 20:17, 2014 May 1 (CDT)
| |
| | |
| ==Item to consider where to put on Priority list==
| |
| #[[Multiple encounter consistency checks]][[User:TOstryzniuk|Trish Ostryzniuk]] 17:43, 2014 May 2 (CDT)
| |
| #[[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 ==
| |
| #Process for editing between send weeks? How to manage master centralized.mdb and Front end and PHI.mdb each week.
| |
| #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?
| |
| #import part of [[iTISS]] that corresponds to specific [[Tasks]] into centralized. See [[Tasks vs iTISS]] for mapping.
| |
| | |
| | |
| | |
| | |
| [[Category:Potential Change|*]]
| |
| [[Category:IT Instructions]]
| |