|
|
| (146 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. |
|
| |
|
| see
| | <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> |
| * [[Validating Data Sending | Validating Data '''Sending''']]
| |
| * [[Validating Data Importing | Validating Data '''Importing''']]
| |
|
| |
|
| == Other change requests == | | ==New change request== |
| ===Editing===
| | <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> |
| currently if processor not careful, will be able to accidentally add ADL or TASK for ICU patients. Other than being careful, how do we avoid?
| |
| ====Editing of DX - bug with error message ====
| |
| Here are the steps
| |
| #Open the patient list
| |
| #go to Home tab. Select, advanced filter option on the top of the screen
| |
| #Select: advance filter/sort
| |
| #From the patient list table, I add the following to the FIELDS for the query: FirstName, LastName amd Phin number.
| |
| #I select the sorting criteria for FN & LN as ascending.
| |
| #For the PHIN field I manually type in a “specific” PHIN number
| |
| #Then I go to HOME, and click a button says apply filter
| |
| #Select a patient through the binoculars
| |
| #Go to Diagnosis tab
| |
| #ADD a complication
| |
| #Select the “?” to access the diagnosis list
| |
| #*If complication listed are a total of 9, I cannot ''add another complication or change it''. It get the error message shown below.
| |
| #*If total number of complication Dx listed are 6 and admit DX are full, cannot add another complication. Get the error message.
| |
| #*Cannot add more than one complication. If you try and add a second one complication, we get the error message shown below. As per email sent by Pagasa today. [[User:TOstryzniuk|Trish Ostryzniuk]] 18:28, 2014 March 4 (CST)
| |
|
| |
|
| === 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 - date editing ===
| |
| *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]]
| |
| | |
| == update process ==
| |
| When Trish and Pagasa edit front end queries, they put the .mdb at X:\CCMDB\centralized_FRONT_End with a different name starting with a "!". The queries will then be imported on the master next time it is updated. We will need to put a reference, likely into the requested changes for front end article to tell which queries need importing.
| |
| | |
| == 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]] |
