Cognos2 matcher query: Difference between revisions

Revision as of 14:08, 30 June 2022

Cognos2_matcher query populates Cognos2 Service Starter.

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.

@@ Line 1: / Line 1: @@
 Cognos2_matcher query populates [[Cognos2 Service Starter]].
-{{Todo
- | who = Tina
- | todo_added = 2022-04-19
- | todo_action = 2022-06-21
- | question =  _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. [[User:Ttenbergen|Ttenbergen]] 15:53, 2022 April 19 (CDT)
-}}
 == Log ==