Cognos2 matcher query: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
mNo edit summary
Line 1: Line 1:
Populates [[Cognos2 Service Starter]].  
Cognos2_matcher query populates [[Cognos2 Service Starter]].  


{{Todo  
{{Todo  
Line 11: Line 11:


== Log ==
== Log ==
* 2022-06-30 - confirmed that this uses [[S PatientFollow distribution table]] including start and end dates; made this more explicit in query by using query name explicitly in field name references
* 2021-01-27 - changed so match on end date is not required; necessary since the end date of services where the patient still is always list as ''today'', ie always keep changing.  
* 2021-01-27 - changed so match on end date is not required; necessary since the end date of services where the patient still is always list as ''today'', ie always keep changing.  



Revision as of 15:08, 2022 June 30

Cognos2_matcher query populates Cognos2 Service Starter.

_dev_CCMDB

  • waiting to have admin rights restored to have SQL functionality in Notepad++
  • Confirm that this actually uses S PatientFollow distribution table correctly, ie including start and end dttm. I suspect it does not factor in Admit DtTm right now, which will become an issue only if an assignment changes. Ttenbergen 15:53, 2022 April 19 (CDT)
  • added: 2022-04-19
  • action: 2022-06-21
  • Cargo


  • Categories

Log

  • 2022-06-30 - confirmed that this uses S PatientFollow distribution table including start and end dates; made this more explicit in query by using query name explicitly in field name references
  • 2021-01-27 - changed so match on end date is not required; necessary since the end date of services where the patient still is always list as today, ie always keep changing.

Related articles

Related articles: