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

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
Line 4: Line 4:


== Other change requests ==
== Other change requests ==
* Unhide the HSC LABS  in CFE
* St B 5B vs B5 in var1/2
** not sure what this means, will confirm with Trish; query ''1tmp_var12_b5_5b''


* St B 5B vs B5 in var1/2
* query ''link_suspect_from_ICU_but_single_encounter'' NEVER HAS LINES
 
* LING ICU SINGLE ENC NEVER HAS LINES
**28532 STB SHOULD BE ON THERE.
**28532 STB SHOULD BE ON THERE.


Line 31: Line 30:
* make query to set time part of tmp dateVar to nothing
* make query to set time part of tmp dateVar to nothing


* why are there blank BirthMYs?
* BirthMY
 
** why are there blank BirthMYs?
* what happens to BirthMY when Pagasa updates Birth?
** what happens to BirthMY when Pagasa updates Birth?


=== Preventing inappropriate edits by data processor ===
=== Preventing inappropriate edits by data processor ===

Revision as of 17:19, 2014 November 27

see the 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.

Other change requests

  • 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
    • 28532 STB SHOULD BE ON THERE.
  • put back the sort buttons for the patient list
Linking pairs – OPEN suspect links
Can the early D-ID and Late D_ID columns be wider? 
  • 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
  • The copy and paste in CFE is broken
  • fix query link_suspect_medicine_to_med_no_partner - has false positives
  • "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