CCMDB Wiki

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

← Older edit
m Text replacement - "[[Category: " to "[[Category:"
 
(247 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>
=== automate re-linking of tables ===
Ask for the phi and centralized directories and reconnect.


=== Error Checking Queries required ===
==New change request==
we should probably revisit [[:Category:Cleaner.mdb Data Integrity Checks‏‎]] in this context.
<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>


=== SAS Views ===
{{Todo
* implement [[Created Variables in TMSX or Med TMS]]
| who = Tina
| todo_added = 2021-07-15 
| todo_action =  
| question = _dev_CFE
* CCI and ICD10 make button for Pagasa}}


==== column headers ====
=== Move Linked Pairs ===
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.   
{{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?


==== Data formats ====
== Related articles ==
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.
{{Related Articles}}


 
[[Category:Development Documentation]]
[[Category: Development Documentation]]
[[Category:2013 data upgrades]]
[[category:2013 data upgrades]]
[[Category:Centralized data front end.accdb]]
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Centralized_data_front_end.accdb_Change_Request"