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

From CCMDB Wiki
Jump to navigation Jump to search
TOstryzniuk (talk | contribs)
 
(219 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)
*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.[[User:TOstryzniuk|Trish Ostryzniuk]] 14:51, 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 ==
=== Patient List-Tweek needed for PHIN column Feb 11.14 version===
{{Related Articles}}
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)
 
=== 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: Development Documentation]]
[[category:2013 data upgrades]]
[[Category: 2013 data upgrades]]
[[Category: Centralized data front end.accdb]]

Latest revision as of 16:34, 15 July 2021

see the Development Documentation Category for other development logs

This article contains requested changes for Centralized data front end.accdb. See Centralized data front end.accdb Change Log for it's change log.

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.

New change request

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.

_dev_CFE

  • CCI and ICD10 make button for Pagasa
  • added: 2021-07-15
  • action:
  • Cargo


  • Categories

Move Linked Pairs

_dev_CFE

  • Linked pairs, better storage
  • added: 2021-07-15
  • action:
  • Cargo


  • Categories

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: