CCMDB Wiki

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

← Older editNewer edit →
dx add bug was fixed.
→Other change requests: I think the sorting and filtering is worked out now that Pagasa uses the advanced filter built into Access.
Line 12: Line 12:
** 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.  
** 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?
* 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 ===
=== Where should s-tables live ===
Line 19: Line 19:
===Please fix SPEED===
===Please fix SPEED===
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)
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)
=== ability to sort and search combined-name column ===
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 ===
=== Comorbid DX ===
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Centralized_data_front_end.accdb_Change_Request"