CCMDB Wiki

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

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