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

From CCMDB Wiki
Jump to navigation Jump to search
 
(179 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.


===Please fix SPEED===
<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>
*BOTH EDITS AND NDC QUERIES
**Edits: change VBA from executing queries to making tables. [[User:Bcloutier | Brad]]
*** will import Brad's code for this when it's ready, hoping for before Thursday Ttenbergen 22:58, 2014 February 24 (CST)
===Query===
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)


=== Comorbid DX ===
==New change request==
*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)
<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>


===Temp Studies===
{{Todo
#Listing multiple rows of information when looking in Tmp studies via the binoculars. email sent to tina and Brad. Feb 25.14.
| who = Tina
#Cannot use the down lists for Project or Items get error message “ undefined function in hosp expression”
| todo_added = 2021-07-15 
#What is the correct way to edit dates in TMP studies?
| todo_action =  
| question = _dev_CFE
* CCI and ICD10 make button for Pagasa}}


===Patient List===
=== Move Linked Pairs ===
#Difficulty in searching for patient full name.
{{Todo
 
| who = Tina
===Cat problem (meow...)===
| todo_added = 2021-07-15 
*Cat is not working this time. ''Run time error 94 Invalid use of Null''.
| todo_action =  
 
| question = _dev_CFE
=== ensure s_alldiagnoses part of re-linking ===
* Linked pairs, better storage }}
# S_allDiagnosis is not hooked up to centralized front end.  Have to use link manager to link it in to front end.-[[User:TOstryzniuk|Trish Ostryzniuk]] 13:42, 2014 February 21 (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.  
=== other spot that might contain requirements... ===
** How will that work for individual older records that were edited?
[[TMSX MedTMS to Centralized go-live]]
 
=== SAS Views ===
* implement [[Created Variables in TMSX or Med TMS]]
 
== 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]]

Latest revision as of 16:34, 2021 July 15

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"