| 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:
|
retired
|
| 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));