|
|
| (254 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. |
|
| |
|
| == Requested Changes ==
| | <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> |
| * make SAS query show ADLs with score. or some other query. cross-reference with [[s_ADLOptions]], anyway.
| |
| * make SAS query show GCS scores using [[s_GCS]]
| |
| * implement [[Created Variables in TMSX or Med TMS]]
| |
|
| |
|
| === fix date format === | | ==New change request== |
| * as per [[Log#2013-11-18]]
| | <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> |
|
| |
|
| === automate re-linking of tables === | | {{Todo |
| Ask for the phi and centralized directories and reconnect.
| | | who = Tina |
| | | todo_added = 2021-07-15 |
| | | todo_action = |
| | | question = _dev_CFE |
| | * CCI and ICD10 make button for Pagasa}} |
|
| |
|
| === s_table reconciliation === | | === Move Linked Pairs === |
| Front end needs access to most s_table data. I set up a copy process to the regeional server, but Brad rightly pointed out that this would be better off right in the program. Need to import s_tables into front_end, update update-process to include this as part of the deal.
| | {{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? |
|
| |
|
| === Error Checking Queries required === | | == Related articles == |
| we should probably revisit [[:Category:Cleaner.mdb Data Integrity Checks]] in this context.
| | {{Related Articles}} |
|
| |
|
| === importing csvs ===
| | [[Category:Development Documentation]] |
| * '''problem importing csv files is with the date field... need to give it the right import specs'''Ttenbergen 17:34, 2013 November 4 (CST)
| | [[Category:2013 data upgrades]] |
| ** Brad will look into that one, in a different file.
| | [[Category:Centralized data front end.accdb]] |
| | |
| === Diagnosis vs Tasks ===
| |
| Diagnosis – can be in separate tables as you have now but exclude the TASKS data, must exclusively contain admit and acquired diagnosis only. In this way, I don’t need to filter and remove the TASKS. Also can I request another column of data which contain only the main diagnosis (first 3 number).
| |
| * need to figure out what to do here... I need to keep tasks in dxs table until we also change it for the laptops, but what do we want it to be in the end? Ttenbergen 10:10, 2013 December 2 (CST)
| |
| | |
| === SAS Views ===
| |
| ==== column headers ====
| |
| Variables headers for Registry, APACHE,SAPS, ADL elements – you may not necessarily make them in separate tables to be consistent with Ed’s output tables. Putting them together as in the L_Log but using the same headers as ED’s ( can be called as L_log of front end) are just fine. This will be less work in my end because I don’t need to merge these individual tables together.
| |
| | |
| ==== Data formats ====
| |
| Data type/values for VERBAL, CHRONIC , ADMIT TYPE , RENAL, ADL - these need conversion as we had agreed and they are included under the L_Log of Front end.
| |
| | |
| ==== exclude tasks from Dx listing ====
| |
| | |
| | |
| [[Category: Development Documentation]] | |
| [[category:2013 data upgrades]] | |