Query s tmp comfort care gt one: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 8: | Line 8: | ||
|DIC_backlogged=No | |DIC_backlogged=No | ||
}} | }} | ||
===Log=== | |||
* 2023-11-26 - deleted query since it is long defunct. SQL was | |||
SELECT L_TmpV2.Pat_ID, "Pt has more than one comfort care tmp entry." AS Problem | |||
FROM L_TmpV2 | |||
WHERE (((L_TmpV2.Project)="Comfort Care")) | |||
GROUP BY L_TmpV2.Pat_ID, "Pt has more than one comfort care tmp entry." | |||
HAVING (((Count(L_TmpV2.Tmp_ID))>1)); | |||
Revision as of 10:28, 2023 November 26
| Data Integrity Checks | |
| Summary: | Only one entry allowed per patient. |
| Related: | Comfort Care |
| Firmness: | hard check |
| Timing: | always |
| App: | CCMDB.accdb |
| Coding: | query s_tmp_comfort_care_gt_one |
| Uses L Problem table: | not relevant for this app |
| Status: | implemented |
| Implementation Date: | not entered |
| Backlogged: | No |
Log
- 2023-11-26 - deleted query since it is long defunct. SQL was
SELECT L_TmpV2.Pat_ID, "Pt has more than one comfort care tmp entry." AS Problem FROM L_TmpV2 WHERE (((L_TmpV2.Project)="Comfort Care")) GROUP BY L_TmpV2.Pat_ID, "Pt has more than one comfort care tmp entry." HAVING (((Count(L_TmpV2.Tmp_ID))>1));