|
|
| (156 intermediate revisions by 3 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. |
|
| |
|
| === Created Variable ===
| | <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> |
| Message 'Undefined function 'ApTotal_Physiological' in expression ' is showing up when clicking Created_Variables query. [[User:JMojica|JMojica]] 16:55, 2014 February 28 (CST)
| |
|
| |
|
| === Pharmacy YES/N0 === | | ==New change request== |
| Records from Jan 2012 have nothing marked in all pharmacy columns at L_LOG
| | <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> |
| [[User:JMojica|JMojica]] 16:31, 2014 February 28 (CST)
| |
| === 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 === | | {{Todo |
| | | who = Tina |
| | | todo_added = 2021-07-15 |
| | | todo_action = |
| | | question = _dev_CFE |
| | * CCI and ICD10 make button for Pagasa}} |
|
| |
|
| === test for orphans === | | === Move Linked Pairs === |
| list anyone not complete for whom the sent date is not the max date for that location. Ttenbergen 13:41, 2014 February 28 (CST)
| | {{Todo |
| | | who = Tina |
| | | todo_added = 2021-07-15 |
| | | todo_action = |
| | | question = _dev_CFE |
| | * Linked pairs, better storage }} |
| | 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. |
| | ** How will that work for individual older records that were edited? |
|
| |
|
| === Where should s-tables live === | | == Related articles == |
| * consider logical solution for where s_tables should live
| | {{Related Articles}} |
|
| |
|
| ===Please fix SPEED===
| | [[Category:Development Documentation]] |
| *BOTH EDITS AND NDC QUERIES
| | [[Category:2013 data upgrades]] |
| **Edits: change VBA from executing queries to making tables. [[User:Bcloutier | Brad]]
| | [[Category:Centralized data front end.accdb]] |
| *** will import Brad's code for this when it's ready, hoping for before Thursday Ttenbergen 22:58, 2014 February 24 (CST)
| |
| **** emailed Brad to request status Ttenbergen 13:43, 2014 February 27 (CST)
| |
| | |
| === ability to sort and search combined-name column ===
| |
| 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)
| |
| | |
| === Comorbid DX ===
| |
| *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]]
| |
| | |
| | |
| [[Category: Development Documentation]]
| |
| [[category:2013 data upgrades]]
| |
see the Development Documentation Category for other development logs
This article contains requested changes for Centralized data front end.accdb. See Centralized data front end.accdb Change Log for it's change log.
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.
New change request
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.
|
_dev_CFE
- CCI and ICD10 make button for Pagasa
|
- added: 2021-07-15
- action:
|
Move Linked Pairs
|
|
_dev_CFE
- Linked pairs, better storage
|
- added: 2021-07-15
- action:
|
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.
- How will that work for individual older records that were edited?
Related articles