Centralized data front end.accdb Change Request

From CCMDB Wiki
Revision as of 16:03, 2014 June 23 by Ttenbergen (talk | contribs) (change heading and category)
Jump to navigation Jump to search

see the 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.

see

Fix needed

QAInf missing

Template:Potential Change QAInf missing from centralized - Pagasa ID'd one patient from CON that in acq DX VAP, but centralized front end not seeing the VAP date. She checked TMPV2.mdb and VAP dates is there. Not sure if there are others.PTorres 12:03, 2014 June 20 (CDT)

Other change requests

preventing edits in borrowed data

Pagasa now uses push/pull scripts to pull data to a specific location. That is the only place where data should be edited. Update front end to colour code or lock if file is not in that location. IE, allow views, but not edits.

  • I can lock down editing in forms (eg in the patient list and viewer) but not directly in queries or tables. Will do that. Ttenbergen 11:12, 2014 May 22 (CDT)

Preventing inappropriate edits by data processor

  • 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.

Temp Studies - multiple rows

other spot that might contain requirements...

TMSX MedTMS to Centralized go-live

update process

see Update process for use of Centralized data front end.mdb

After go-live

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