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

From CCMDB Wiki
Jump to navigation Jump to search
 
(196 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.


=== Missing information again===
<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>
Feb 24.14 Tina's version - this version on X, is missing displaying: Admit from, discharge to, hospital previous and patient type when looking at individual patient file from front end.  Main office will use Feb 20th version,which this was not a problem. Will wait for next update of front end.[[User:TOstryzniuk|Trish Ostryzniuk]] 19:04, 2014 February 24 (CST)


===Please fix SPEED===
==New change request==
*BOTH EDITS AND NDC QUERIES
<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>
**Edits: change VBA from executing queries to making tables. [[User:Bcloutier | Brad]]


=== ensure s_alldiagnoses part of re-linking ===
{{Todo
# 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)
| who = Tina
| todo_added = 2021-07-15 
| todo_action =  
  | question =  _dev_CFE
* CCI and ICD10 make button for Pagasa}}


=== HAP ===
=== Move Linked Pairs ===
#Please ADD the abbreviation HAP to code 3800 please, otherwise hard to search.[[User:PTorres|PTorres]] 15:47, 2014 February 20 (CST)
{{Todo
 
| who = Tina
=== generate unique identifiers for child tables ===
| todo_added = 2021-07-15
adding records fails becaus the *_id is not autogenerated.
| todo_action =
#Editing DX: when adding complication code, example, HAP, would go into registry screen but would not allow to save, hanging program and could not close.  Getting some Index or primary key cannot contain a NULL value,  something or other message. Email sent to you Feb 20 with picture.  Brad was here and may be able to explain.
| question = _dev_CFE
 
* Linked pairs, better storage }}
=== other spot that might contain requirements... ===
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.  
[[TMSX MedTMS to Centralized go-live]]
* 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?
=== SAS Views ===
* implement [[Created Variables in TMSX or Med TMS]]
 
== After go-live ==
=== Email Generator ===
* provide automation for generating email with particulars for collector to correct data for Pagasa to use
* Trish sent Tina several example emails
* revisit [[:Category:Cleaner.mdb Data Integrity Checks‏‎]]


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


[[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, 2021 July 15

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:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Centralized_data_front_end.accdb_Change_Request&oldid=151263"