Query s tmp comfort care gt one: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m Text replacement - "CCMDB.mdb" to "CCMDB.accdb" |
Ttenbergen (talk | contribs) No edit summary |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
{{Data Integrity Check | {{Data Integrity Check | ||
| DIC_summary = Only one entry allowed per patient. | |DIC_summary=Only one entry allowed per patient. | ||
| DIC_related_concepts = Comfort Care | |DIC_related_concepts=Comfort Care | ||
| DIC_firmness = hard check | |DIC_firmness=hard check | ||
|DIC_coding=query ''s_tmp_comfort_care_gt_one'' | |||
|DIC_status=retired | |||
| DIC_coding = query ''s_tmp_comfort_care_gt_one'' | |DIC_app=CCMDB.accdb | ||
| DIC_status = | |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)); | |||
Latest 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: | 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));