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

From CCMDB Wiki
Jump to navigation Jump to search
← Older edit
 
(255 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.


=== 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
=== Error Checking Queries required ===
| todo_added = 2021-07-15 
we should probably revisit [[:Category:Cleaner.mdb Data Integrity Checks‏‎]] in this context.  
| todo_action =  
 
  | question = _dev_CFE
=== importing csvs ===
* Linked pairs, better storage }}
* '''problem importing csv files is with the date field... need to give it the right import specs'''Ttenbergen 17:34, 2013 November 4 (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.  
** Brad will look into that one, in a different file.
* 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?
=== 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 ====


== Related articles ==
{{Related Articles}}


[[Category: Development Documentation]]
[[Category: Development Documentation]]
[[category:2013 data upgrades]]
[[Category: 2013 data upgrades]]
[[Category: Centralized data front end.accdb]]

Latest revision as of 16:34, 15 July 2021

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:
  • Cargo


  • Categories

Move Linked Pairs

_dev_CFE

  • Linked pairs, better storage
  • added: 2021-07-15
  • action:
  • Cargo


  • Categories

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

Related articles:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Centralized_data_front_end.accdb_Change_Request&oldid=151263"