|
|
| (157 intermediate revisions by 4 users not shown) |
| Line 1: |
Line 1: |
| ''see the [[:Category: Development Documentation | Development Documentation Category]] for other development logs'' | | ''see the [[:Category: Development Documentation | Development Documentation Category]] for other development logs'' |
|
| |
|
| This article contains requested changes for [[Centralized data front end.mdb]]. See [[Centralized data front end.mdb Change Log]] for it's change log. | | This article contains requested changes for [[Centralized data front end.accdb]]. See [[Centralized data front end.accdb Change Log]] for it's change log. |
| === APACHE & SAPS DATA VALUES ===
| |
| *Medicine - dummy values assigned to APACHE and SAPS elements no longer collected must be changed to NULL (ALL except Heart rate, respiratory rate, WBC, Systolic BP and GCS - EYE, MOTOR, VERBAL).
| |
| *Critical Care - SERUM,FiO2, PO2, CO2, PH = 0 must be changed to NULL.
| |
| *Patients having ALL APACHE/SAPS missing should be changed from zero to NULL. [[User:JMojica|JMojica]] 15:00, 2014 February 28 (CST)
| |
|
| |
|
| === misc ===
| | <big>'''Generally items should be discussed and flagged for change on their own page, and not here. Only changes that don't have wiki pages yet should be listed here.'''</big> |
|
| |
|
| === test for orphans === | | ==New change request== |
| list anyone not complete for whom the sent date is not the max date for that location. Ttenbergen 13:41, 2014 February 28 (CST)
| | <big>'''Generally items should be discussed and flagged for change on their own page, and not here. Only changes that don't have wiki pages yet should be listed here.'''</big> |
|
| |
|
| === Where should s-tables live === | | {{Todo |
| * consider logical solution for where s_tables should live | | | who = Tina |
| | | todo_added = 2021-07-15 |
| | | todo_action = |
| | | question = _dev_CFE |
| | * CCI and ICD10 make button for Pagasa}} |
|
| |
|
| ===Please fix SPEED=== | | === Move Linked Pairs === |
| *BOTH EDITS AND NDC QUERIES
| | {{Todo |
| **Edits: change VBA from executing queries to making tables. [[User:Bcloutier | Brad]]
| | | who = Tina |
| *** will import Brad's code for this when it's ready, hoping for before Thursday Ttenbergen 22:58, 2014 February 24 (CST)
| | | todo_added = 2021-07-15 |
| **** emailed Brad to request status Ttenbergen 13:43, 2014 February 27 (CST)
| | | todo_action = |
| | | | question = _dev_CFE |
| === ability to sort and search combined-name column === | | * Linked pairs, better storage }} |
| because first name and last name are now in one COLUMN in the query; NDC_DiffPhin_SameLN_FN_DOB, I cannot sort by the FN/LN column after the query is run. Would like the flexibility to be able to sort by this column.[[User:PTorres|PTorres]] 16:57, 2014 February 25 (CST)
| | As discussed with Julie to prevent her having to rerun it and to insure that what Pagasa queries against is same as what Julie uses. |
| | | * need to change the query and process from one that re-does all, every time, to one that only updates new. |
| === Comorbid DX ===
| | ** How will that work for individual older records that were edited? |
| *Comorbid is not working you cannot edit. Complication yes you can add but there is a pop up message as soon you get out of that screen. It says changes you requested on the table were not successful because they would create duplicate.[[User:PTorres|PTorres]] 14:47, 2014 February 25 (CST)
| |
| ** can't replicate this from the description. I am able to add or edit both comorbids and diagnoses. What exactly are you doing when this goes wrong? Show me tomorrow, probably easier than writing it out - Ttenbergen 11:50, 2014 February 26 (CST) | |
| | |
| ===Temp Studies - multiple rows ===
| |
| *Listing multiple rows of information when looking in Tmp studies via the binoculars. email sent to tina and Brad. Feb 25.14.
| |
| ** that's because there are multiple. Will need to clean up, it's on the list.
| |
| | |
| ===Temp Studies - multiple rows ===
| |
| *What is the correct way to edit dates in TMP studies?
| |
| ** format is dd-mon-yy. Or what is the question? Ttenbergen 13:47, 2014 February 27 (CST)
| |
| | |
| ===Patient List===
| |
| *Difficulty in searching for patient full name.
| |
| ** can't replicate the problem Ttenbergen 13:48, 2014 February 27 (CST) | |
| | |
| ===Cat problem (meow...)===
| |
| *Cat is not working this time. ''Run time error 94 Invalid use of Null''.
| |
| ** Can't replicate this either. Is it not working for all patients or are certain patients having the problem? - Ttenbergen 11:51, 2014 February 26 (CST)
| |
| | |
| === other spot that might contain requirements... ===
| |
| [[TMSX MedTMS to Centralized go-live]]
| |
| | |
| === SAS Views ===
| |
| * implement [[Created Variables in TMSX or Med TMS]] | |
| | |
| == After go-live ==
| |
| === Email Generator ===
| |
| * provide automation for generating email with particulars for collector to correct data for Pagasa to use | |
| * Trish sent Tina several example emails
| |
| * revisit [[:Category:Cleaner.mdb Data Integrity Checks]]
| |
|
| |
|
| | == Related articles == |
| | {{Related Articles}} |
|
| |
|
| [[Category: Development Documentation]] | | [[Category: Development Documentation]] |
| [[category:2013 data upgrades]] | | [[Category: 2013 data upgrades]] |
| | [[Category: Centralized data front end.accdb]] |