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:"
 
(46 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>
check for presence or "complete" records at same time as PHI/L_Log comparison. If there are any a send failed.


==RecordStatus Report if Complete in Centralized==
==New change request==
#'''Reconnect button''': could it also include count of COMPLETE?  Would like to ID this issues sooner in process so I notify there is a problem.
<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>
#When I click '''Vetted button''', I would also like you to include count that are marked COMPLETE in record status.  This would be helpful in the case I missed fixing all COMPLETE in RecordStatus in centralized. 
#other suggestion welcomed to catch these babies when there are changes or issues with sending.


=== PL queries ===
{{Todo
* I have replaced the med_from query with one called “link_suspect_from_partner_no_match”; now that we are using var1/2 elsewhere it only makes sense. I still need to make the counterpart *to query. This query finds pts where the second record says they should be from a partner site and there is no partner. I also need to make queries for prev encounter comes from a partner site and Var is not marked.
| who = Tina
| todo_added = 2021-07-15 
| todo_action =  
| question = _dev_CFE
* CCI and ICD10 make button for Pagasa}}


* need to make an  PL query where early and late have short transit times but locations don’t correspond.  
=== Move Linked Pairs ===
{{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?


* fix query ''link_suspect_medicine_*_partner'' - have false positives
== Related articles ==
** Not everyone from *W needs to come from a ward where we collect;
{{Related Articles}}
** need acceptable delay
** var1/2 etc


=== L_Log BirthMY ===
[[Category:Development Documentation]]
* BirthMY
[[Category:2013 data upgrades]]
** why are there blank BirthMYs?
[[Category:Centralized data front end.accdb]]
** what happens to BirthMY when Pagasa updates Birth?
 
=== collapse autopsy ===
what does that even mean? Ttenbergen 17:00, 2015 April 2 (CDT) {{discussion}}
 
=== Preventing inappropriate edits by data processor ===
 
== 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"