Service Sending to ICU: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) m →{{CCMDB Data Integrity Checks}}: link |
||
| Line 66: | Line 66: | ||
=={{CCMDB Data Integrity Checks}}== | =={{CCMDB Data Integrity Checks}}== | ||
* Query ''s_tmp_Service_Sending_to_ICU'' - Error if: | * Query ''s_tmp_Service_Sending_to_ICU'' - Error if: | ||
** not admitted from inpatient location (([[S AdmitDischarge]].inpatient = true)) but has "Srv to ICU" entry | ** not admitted from inpatient location (([[S AdmitDischarge table|S AdmitDischarge]].inpatient = true)) but has "Srv to ICU" entry | ||
** admitted from inpatient location and one of | ** admitted from inpatient location and one of | ||
*** no "Srv to ICU" entry | *** no "Srv to ICU" entry | ||