CCMDB Wiki

Centralized data front end.accdb Change Request: Difference between revisions

← Older edit
m Text replacement - "[[Category: " to "[[Category:"
 
(251 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]]


=== automate re-linking of tables ===
==New change request==
Ask for the phi and centralized directories and reconnect.
<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>


=== Error Checking Queries required ===
{{Todo
we should probably revisit [[:Category:Cleaner.mdb Data Integrity Checks‏‎]] in this context. 
| who = Tina
| todo_added = 2021-07-15 
| todo_action =  
| question = _dev_CFE
* CCI and ICD10 make button for Pagasa}}


=== Diagnosis vs Tasks ===
=== Move Linked Pairs ===
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). 
{{Todo
* 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)
| 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?


=== SAS Views ===
== Related articles ==
==== column headers ====
{{Related Articles}}
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 ====
[[Category:Development Documentation]]
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.
[[Category:2013 data upgrades]]
 
[[Category:Centralized data front end.accdb]]
==== exclude tasks from Dx listing ====
 
 
[[Category: Development Documentation]]
[[category:2013 data upgrades]]
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Centralized_data_front_end.accdb_Change_Request"