Query check CCI TISS time means must be two: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m (Text replacement - "TISS28 checks" to "TISS28 check") |
Ttenbergen (talk | contribs) mNo edit summary |
||
Line 3: | Line 3: | ||
| DIC_related_concepts = CCI Picklist; Boarding Loc | | DIC_related_concepts = CCI Picklist; Boarding Loc | ||
| DIC_firmness = soft check | | DIC_firmness = soft check | ||
| DIC_timing = | | DIC_timing = complete | ||
| DIC_app = CCMDB.accdb | | DIC_app = CCMDB.accdb | ||
| DIC_coding = query ''check_CCI_TISS_matching_BoardingLoc_time'' | | DIC_coding = query ''check_CCI_TISS_matching_BoardingLoc_time'' | ||
| DIC_status = | | DIC_status = ready to implement | ||
| DIC_implementation_date = | | DIC_implementation_date = | ||
}} | }} | ||
{{ | {{TT| | ||
* Julie had said in email: If any CCI date has a matching date on boarding loc, CCI must have at least two records (one with time and without time) if the yesterday and tomorrow have this same item. Here we are identifying missing line. Example H7-3316. Boarding loc move Dec 10 20:57 . CVC has dates Dec 9, 10,11. Dec 10 must have two lines one with time and another with time 20:57. | * Julie had said in email: If any CCI date has a matching date on boarding loc, CCI must have at least two records (one with time and without time) if the yesterday and tomorrow have this same item. Here we are identifying missing line. Example H7-3316. Boarding loc move Dec 10 20:57 . CVC has dates Dec 9, 10,11. Dec 10 must have two lines one with time and another with time 20:57. | ||
** Not necessarily... what if the CVC simply wasn’t there for the MICU portion of the switch day? | ** Not necessarily... what if the CVC simply wasn’t there for the MICU portion of the switch day? | ||
Line 29: | Line 29: | ||
* T38 Isolation | * T38 Isolation | ||
**** That can still at best be a soft check. They might have discontinued the therapy in prep for discharging from ICU and then have had to re-start it as pt got worse. And coincidentally the pt was moved to other loc. | **** That can still at best be a soft check. They might have discontinued the therapy in prep for discharging from ICU and then have had to re-start it as pt got worse. And coincidentally the pt was moved to other loc. | ||
***** This is ready to implement; Make a soft check: if there is a day before, or a day after, then there should be on day of. Needs to be a complete-check | |||
}} | }} | ||
Revision as of 16:15, 2021 October 20
Data Integrity Checks | |
Summary: | If the Px Date component of a CCI Picklist has a time, then there must be a corresponding Boarding Loc entry |
Related: | CCI Picklist, Boarding Loc |
Firmness: | soft check |
Timing: | complete |
App: | CCMDB.accdb |
Coding: | query check_CCI_TISS_matching_BoardingLoc_time |
Uses L Problem table: | not relevant for this app |
Status: | ready to implement |
Implementation Date: | |
Backlogged: | true |
![]() |
|
|
Log
- 2021-09-01 - requirement identified but there are questions