Centralized data front end.accdb Change Request

From CCMDB Wiki
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.

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)

s_ALLDiagnosis

  1. Please ADD the abbreviation HAP to code 3800 please, otherwise hard to search.PTorres 15:47, 2014 February 20 (CST)
  2. Diagnosis is hard to edit.
    • Hard to find the codes.-PTorres 16:00, 2014 February 20 (CST)
  3. 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...

TMSX to Centralized go-life


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

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)