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.

Requested Changes

automate re-linking of tables

Ask for the phi and centralized directories and reconnect.

Error Checking Queries required

we should probably revisit Category:Cleaner.mdb Data Integrity Checks‏‎ in this context.

SAS Views

• implement Created Variables in TMSX or Med TMS

column headers

Variables headers for Registry, APACHE,SAPS, ADL elements – you may not necessarily make them in separate tables to be consistent with Ed’s output tables. Putting them together as in the L_Log but using the same headers as ED’s ( can be called as L_log of front end) are just fine. This will be less work in my end because I don’t need to merge these individual tables together.

Data formats

Data type/values for VERBAL, CHRONIC , ADMIT TYPE , RENAL, ADL - these need conversion as we had agreed and they are included under the L_Log of Front end.