Query check CCI TISS NrDays GT LOS: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 1: | Line 1: | ||
{{Data Integrity Check | {{Data Integrity Check | ||
| DIC_summary = There has to be a TISS entry in [[CCI Picklist]] with a [[Px_Date]] for each date between [[Accept DtTm]] and [[Dispo DtTm]] | | DIC_summary = There has to be a TISS entry in [[CCI Picklist]] with a [[Px_Date]] for each date between [[Accept DtTm]] and [[Dispo DtTm]] | ||
| DIC_related_concepts = CCI Picklist; | | DIC_related_concepts = CCI Picklist; Accept DtTm; Dispo DtTm | ||
| DIC_firmness = hard check | | DIC_firmness = hard check | ||
| DIC_timing = complete | | DIC_timing = complete | ||
| Line 13: | Line 13: | ||
Likely implementation: Count the datevalue(px_dates) for the Pat_ID. There have to be at least as many PX dates as there are days between Accept and Dispo. That would not look for continuity explicitly, but it would do so implicitly when combined with the date check that doesn’t allow dates outside of the admission range. | Likely implementation: Count the datevalue(px_dates) for the Pat_ID. There have to be at least as many PX dates as there are days between Accept and Dispo. That would not look for continuity explicitly, but it would do so implicitly when combined with the date check that doesn’t allow dates outside of the admission range. | ||
== Log == | == Log == | ||
* 2021-01-20 - check defined | * 2021-01-20 - check defined | ||
== Related articles == | == Related articles == | ||
Revision as of 09:34, 21 January 2021
| Data Integrity Checks | |
| Summary: | There has to be a TISS entry in CCI Picklist with a Px_Date for each date between Accept DtTm and Dispo DtTm |
| Related: | CCI Picklist, Accept DtTm, Dispo DtTm |
| Firmness: | hard check |
| Timing: | complete |
| App: | CCMDB.accdb |
| Coding: | query check_CCI_TISS_each_day |
| Uses L Problem table: | not relevant for this app |
| Status: | ready to implement |
| Implementation Date: | |
| Backlogged: | true |
Will replace Query TISS Errors missing days; Query TISS Errors NrTISSDays NE LOS
Likely implementation: Count the datevalue(px_dates) for the Pat_ID. There have to be at least as many PX dates as there are days between Accept and Dispo. That would not look for continuity explicitly, but it would do so implicitly when combined with the date check that doesn’t allow dates outside of the admission range.
Log
- 2021-01-20 - check defined