CCMDB.accdb Change Log 2021: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) |
||
| Line 8: | Line 8: | ||
Changes collectors need to know about: | Changes collectors need to know about: | ||
* added cross-checks | * added cross-checks: | ||
** [[query check_CCI_TISS_if_no_then_none]] | ** [[query check_CCI_TISS_if_no_then_none]] | ||
* fixed problems with cross-checks: | |||
** [[query check_CCI_if_no_then_none]] - this query would have never found anything before, since it was not matching on Pat_ID correctly | |||
** [[query check_CCI_must_have_entry]] - updated so it will not be satisfied by TISS items | |||
Changes collectors probably don't care about (incl. bug fixes that should just make things work now): | Changes collectors probably don't care about (incl. bug fixes that should just make things work now): | ||
* updated [[Cognos2 No Service or Loc in some time query]] to also exclude records that have been opened in the last 2 weeks; should have been like that in the first place | * updated [[Cognos2 No Service or Loc in some time query]] to also exclude records that have been opened in the last 2 weeks; should have been like that in the first place | ||
* confirmed that [[Query check CCI Date]] catches dates before admit and after dispo; so how did the records Julie found get through? | * confirmed that [[Query check CCI Date]] catches dates before admit and after dispo; so how did the records Julie found get through? | ||
*confirmed and tweaked names for | |||
** [[query check_CCI_Picklist_unfilled]] | |||
<!-- | <!-- | ||
'''To do''' | '''To do''' | ||