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

PTorres (talk | contribs)
m Text replacement - "[[Category: " to "[[Category:"
 
(221 intermediate revisions by 4 users not shown)
Line 1: Line 1:
''see the [[:Category: Development Documentation | Development Documentation Category]] for other development logs''
''see the [[:Category: Development Documentation | 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.
This article contains requested changes for [[Centralized data front end.accdb]]. See [[Centralized data front end.accdb Change Log]] for it's change log.


==Name Editing==
<big>'''Generally items should be discussed and flagged for change on their own page, and not here. Only changes that don't have wiki pages yet should be listed here.'''</big>
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?[[User:PTorres|PTorres]] 13:50, 2014 February 21 (CST)


==s_ALLDiagnosis==
==New change request==
#Please ADD the abbreviation HAP to code 3800 please, otherwise hard to search.[[User:PTorres|PTorres]] 15:47, 2014 February 20 (CST)
<big>'''Generally items should be discussed and flagged for change on their own page, and not here. Only changes that don't have wiki pages yet should be listed here.'''</big>
#Diagnosis is hard to edit.
#*Hard to find the codes.-[[User:PTorres|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.[[User:TOstryzniuk|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.-[[User:TOstryzniuk|Trish Ostryzniuk]] 13:42, 2014 February 21 (CST)


{{Todo
| who = Tina
| todo_added = 2021-07-15 
| todo_action =
| question =  _dev_CFE
* CCI and ICD10 make button for Pagasa}}


=== other spot that might contain requirements... ===
=== Move Linked Pairs ===
[[TMSX to Centralized go-life]]
{{Todo
| who = Tina
| todo_added = 2021-07-15 
| todo_action =  
| question = _dev_CFE
* Linked pairs, better storage }}
As discussed with Julie to prevent her having to rerun it and to insure that what Pagasa queries against is same as what Julie uses.
* need to change the query and process from one that re-does all, every time, to one that only updates new.
** How will that work for individual older records that were edited?


== Related articles ==
{{Related Articles}}


=== Patient List-Tweek needed for PHIN column Feb 11.14 version===
[[Category:Development Documentation]]
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.[[User:TOstryzniuk|Trish Ostryzniuk]] 20:03, 2014 February 13 (CST)
[[Category:2013 data upgrades]]
 
[[Category:Centralized data front end.accdb]]
=== 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. [[User:Bcloutier | 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)
 
[[Category: Development Documentation]]
[[category:2013 data upgrades]]