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

From CCMDB Wiki
Jump to navigation Jump to search
← Older edit
m Text replacement - "[[Category: " to "[[Category:"
 
(67 intermediate revisions by 2 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.


== Other change requests ==
<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>
* St B 5B vs B5 in var1/2
** not sure what this means, will confirm with Trish; query ''1tmp_var12_b5_5b''


* query ''link_suspect_from_ICU_but_single_encounter'' NEVER HAS LINES
==New change request==
**28532 STB SHOULD BE ON THERE.
<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>


* put back the sort buttons for the patient list
{{Todo
| who = Tina
| todo_added = 2021-07-15 
| todo_action =
| question =  _dev_CFE
* CCI and ICD10 make button for Pagasa}}


  Linking pairs – OPEN suspect links
=== Move Linked Pairs ===
Can the early D-ID and Late D_ID columns be wider?  
{{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?


* Links suspect Med from med (and med to med as well) - Not everyone from *W needs to come from a ward where we collect; need acceptable delay and var1/2 etc
== Related articles ==
{{Related Articles}}


* The copy and paste in CFE is broken
[[Category:Development Documentation]]
 
[[Category:2013 data upgrades]]
* fix query ''link_suspect_medicine_to_med_no_partner'' - has false positives
[[Category:Centralized data front end.accdb]]
 
* Highest pseudo is used to check “bad PHIN” for incompletes - better solution?
** this should be done in CCMDB instead, see [[Requested_CCMDB_changes_for_the_next_version#Important_change_request]]
 
* "Tina will work to implement this new “HASH” system."
 
* collapse autopsy...
 
* make query to set time part of tmp dateVar to nothing
 
* BirthMY
** why are there blank BirthMYs?
** what happens to BirthMY when Pagasa updates Birth?
 
=== Preventing inappropriate edits by data processor ===
 
=== other spot that might contain requirements... ===
[[TMSX MedTMS to Centralized go-live]]
 
== After go-live ==
* [[Questioning data back to collectors]]
* revisit [[:Category:Cleaner.mdb Data Integrity Checks‏‎]]
 
[[Category: Development Documentation]]
[[Category: 2013 data upgrades]]
[[Category: Centralized data front end.mdb]]

Latest revision as of 10:32, 30 July 2025

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=166111"