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

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
 
(17 intermediate revisions by 2 users not shown)
Line 2: Line 2:


This article contains requested changes for [[Centralized data front end.accdb]]. See [[Centralized data front end.accdb 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.
<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>


==New change request==
==New change request==
* add TDI column to query L_CCI_Combined
<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>
* fix dc treatment box that isn't showing up in form Ttenbergen 15:52, 2018 April 11 (CDT)
* fix table reconnector to not look for L_Labs_DSM any longer, since it's now elsewhere. Ttenbergen 15:52, 2018 April 11 (CDT)


===Postal code table and PCH Pre Acte Living situation===
{{Todo
{{DT | Postal Code vs Pre-acute }}
| who = Tina
The listed postal codes are correlated to the items ‘PCH’  and ‘Chronic Health facility’  of the Pre-Acute Living Situation.  Since the data collectors are collecting the postal code from the patient’s address, will it be possible to automatically fill up the  Pre-Acute Living Situation as PCH or Chronic Health facility if the PCH postal codes are entered or ‘other ways’ to link the two fields and make them  consistent.    Info about PCH is now getting  more attention/request. Tina, Will this be hard to do? Any suggestions?
  | todo_added = 2021-07-15  
*I have changed my mind to add the PCH postal code to the Postal_Code_Master due to the possible effect on its size  (when adding a new column containing text where most of the records will only be blanks).  It is better to have it in separate table since this pertains to Winnipeg area only.  I have added the exact address of these PCH facilities  -  link to table in email sent on Jan 12.18 at 1224 hrs from [[p:Julie Mojica]]
  | todo_action =
  | question = _dev_CFE
* CCI and ICD10 make button for Pagasa}}


=== Move Linked Pairs ===
=== Move Linked Pairs ===
{{DT | Linked pairs, better storage }}
{{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.  
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.  
* 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?
** How will that work for individual older records that were edited?


== See also ==
== Related articles ==
* [[Questioning data back to collectors]]
{{Related Articles}}


[[Category: Development Documentation]]
[[Category: Development Documentation]]
[[Category: 2013 data upgrades]]
[[Category: 2013 data upgrades]]
[[Category: Centralized data front end.accdb]]
[[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: