Centralized data front end.accdb Change Request
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.
Sorting on Patient LIST Form
Need to be able to sort by, LN, FN and may a third option if needed. Only sorting by one column and not grouping it by first name. This is a problematic for processor to find a same patient in the the patient list form.
Edit Bug?
Edits from Patient list, using binoc's to get into each patient profile the following fields: ADL, DOB, Chart number, Sur or Exp Hosp previous, and a few other field for practice.
- Filed edited: HSC_B3_8286, HSC_D5_8311
- after editing, using "Cat button" I can find 6 encounter for this patient, however, in Patient LIST, only showing 4. 2 missing. Sorted by last name, sorted by PHIN in patient list and still could not find them. (but the cat button seems to know where they are.....meow mix).
D_ID EDITS
D_ID cannot edit. Var 1 and Var 2 no downlist to edit
Name Editing
Ed's export, all names are capitalized. When editing centralized if I use small letter they are not saving as capital letter.
S_Locations table
Editing location in centralized front end and drop down list is blank. The table does not appear to be linked in?PTorres 13:50, 2014 February 21 (CST)
- Trish and Pagasa hacking into layout, field properties. No luck. We were only able toto change it so we see Hosp and not location. Dont' understand what the TableQuery is doing here really.Trish Ostryzniuk 14:51, 2014 February 21 (CST)
s_ALLDiagnosis
- Please ADD the abbreviation HAP to code 3800 please, otherwise hard to search.PTorres 15:47, 2014 February 20 (CST)
- Diagnosis is hard to edit.
- Hard to find the codes.-PTorres 16:00, 2014 February 20 (CST)
- DX codes not visible for individual patients Feb 11.14 Version Patient list,click on bincoculars, DX tab, no DX codes visible. Showing up as blank screen.Trish Ostryzniuk 20:10, 2014 February 13 (CST)
- S_allDiagnosis is not hooked up to centralized front end. Have to use link manager to link it in to front end.-Trish Ostryzniuk 13:42, 2014 February 21 (CST)
other spot that might contain requirements...
Patient List-Tweek needed for PHIN column Feb 11.14 version
On Pagasa’s monitor she can see PHIN column, but on mine I cannot it not wide enough but just a tad. Would like you to tweak this column to be slightly wider. Thanks you.Trish Ostryzniuk 20:03, 2014 February 13 (CST)
Error Checking Queries required
we should probably revisit Category:Cleaner.mdb Data Integrity Checks in this context.
Please fix SPEED
- BOTH EDITS AND NDC QUERIES
- Edits: change VBA from executing queries to making tables. Brad
EMAIL GENERATOR
FOR PAGASA TO FEED UP WITH THE COLLECTOR
SAS Views
- implement Created Variables in TMSX or Med TMS
HSC Labs importing
Do we need functionality to import this into the new system or do we add them to HSC collection same as other sites? Ttenbergen 13:58, 2014 January 30 (CST)