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

From CCMDB Wiki
Jump to navigation Jump to search
 
(131 intermediate revisions by 3 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.


see
<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>
* [[Validating Data Sending | Validating Data '''Sending''']]
* [[Validating Data Importing | Validating Data '''Importing''']]


== Other change requests ==
==New change request==
=== Preventing inappropriate edits by data processor ===
<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>
*Currently if processor not careful, will be able to accidentally add ADL or TASK for ICU patients.  Other than being careful, how do we avoid?
** I kept the editing interface as wide open as possible for the data processor to make sure that whatever unexpected things we may ask her to do, she can do. If we want something tighter, we will need to decide what that would be.
* ICU variables should be unavailable for med records and vice versa. Easiest would be to change the patient viewer and put program-specific data into their own tab. Could leave both tabs available for editing or hide one depending on value in r_location. Thoughts?
* Could apply the same error checks to e.g. Apache entries. Problem is that these are usually applied at bulk when setting patient to complete. To do them earlier has led to problems and repeat-triggers with some checks, especially ones that compare entries in different fields.  


=== Where should s-tables live ===
{{Todo
* consider logical solution for where s_tables should live
| who = Tina
| todo_added = 2021-07-15 
| todo_action =  
| question = _dev_CFE
* CCI and ICD10 make button for Pagasa}}


We changed the PatientList form so it doesn't requery automatically every time an edited patient is closed and the form is reactivated. Pagasa is testing to find out if this improves speed sufficiently. Ttenbergen 13:50, 2014 March 12 (CDT)
=== Move Linked Pairs ===
*Speed is faster than before and I can handle this speed.
{{Todo
[[User:PTorres|PTorres]] 15:01, 2014 March 12 (CDT)
  | who = Tina
 
  | todo_added = 2021-07-15 
*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)
| todo_action =  
** can't replicate this from the description. I am able to add or edit both comorbids and diagnoses. What exactly are you doing when this goes wrong? Show me tomorrow, probably easier than writing it out - Ttenbergen 11:50, 2014 February 26 (CST)
| question = _dev_CFE
** This is fixed.  
* Linked pairs, better storage }}
[[User:PTorres|PTorres]] 16:16, 2014 March 12 (CDT)
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.  
===Temp Studies - multiple rows ===
** How will that work for individual older records that were edited?
*Listing multiple rows of information when looking in Tmp studies via the binoculars. email sent to tina and Brad. Feb 25.14.
** see [[L TmpV2 multi-entry clean-up]]
 
*Cat is not working this time. ''Run time error 94 Invalid use of Null''.
** Can't replicate this either. Is it not working for all patients or are certain patients having the problem? - Ttenbergen 11:51, 2014 February 26 (CST)
*** is this still a problem? Ttenbergen 14:02, 2014 March 12 (CDT)
*** Not any more.
[[User:PTorres|PTorres]] 15:05, 2014 March 12 (CDT)
 
=== other spot that might contain requirements... ===
[[TMSX MedTMS to Centralized go-live]]
===Patient_List under Queries===
*Would it be possible if you can add the column '''"SentDtTm"''' on the Patient_List?  Patient_List is the counter part of Ed's Registry Log that I use when I am sending files to Manitoba Health.
[[User:PTorres|PTorres]] 15:54, 2014 March 12 (CDT)
 
== update process ==
When Trish and Pagasa edit front end queries, they put the .mdb at X:\CCMDB\centralized_FRONT_End with a different name starting with a "!". The queries will then be imported on the master next time it is updated. We will need to put a reference, likely into the requested changes for front end article to tell which queries need importing.  
 
== 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"