Query s tmp IICU consult DtTm: 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= "IICU consult" must have either a date or the check box checked. If they have a date, it has to be between | |DIC_summary= "IICU consult" must have either a date or the check box checked. If they have a date, it has to be between Arrive_DtTm and [[Dispo_DtTm]]. | ||
|DIC_related_concepts=IICU consult | |DIC_related_concepts=IICU consult | ||
|DIC_firmness=hard check | |DIC_firmness=hard check | ||
|DIC_coding=query ''s_tmp_IICU_consult_DtTm'' | |DIC_coding=query ''s_tmp_IICU_consult_DtTm'' | ||
|DIC_implementation_date= | |DIC_implementation_date= | ||
|DIC_status= | |DIC_status=retired | ||
|DIC_LProblem=No | |DIC_LProblem=No | ||
|DIC_app=CCMDB.accdb | |DIC_app=CCMDB.accdb | ||
| Line 11: | Line 11: | ||
== Log == | == Log == | ||
* 2022-04-19 - retired cross check for tmp that is no longer running | |||
* 2019-11-26 - tweaked query to make it easier to see specifically what is wrong. | * 2019-11-26 - tweaked query to make it easier to see specifically what is wrong. | ||
Revision as of 14:42, 19 April 2022
| Data Integrity Checks | |
| Summary: | "IICU consult" must have either a date or the check box checked. If they have a date, it has to be between Arrive_DtTm and Dispo_DtTm. |
| Related: | IICU consult |
| Firmness: | hard check |
| Timing: | always |
| App: | CCMDB.accdb |
| Coding: | query s_tmp_IICU_consult_DtTm |
| Uses L Problem table: | not relevant for this app |
| Status: | retired |
| Implementation Date: | |
| Backlogged: | true |
Log
- 2022-04-19 - retired cross check for tmp that is no longer running
- 2019-11-26 - tweaked query to make it easier to see specifically what is wrong.
Related articles
| Related articles: |