Query check CCI must have entry: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m Text replacement - "CCMDB.mdb" to "CCMDB.accdb" |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 11: | Line 11: | ||
}} | }} | ||
{{ | {{Discuss | who = Pagasa | | ||
* Patients without CCI entries are slipping through and found by [[PL missing L Tables content]] , must fix [[User:PTorres|PTorres]] 09:42, 2019 February 7 (CST) | |||
** I seem to remember discussing this with Pagasa. There was a misconception that a "no CCIs" had to be present in both component and picklist, but that is not true: it only needs to be in the Picklist. Is this still a problem? If so, please tell me an example when one comes up. }} | |||
== Log == | |||
* updates so it only checks for Recordstatus = complete or incomplete. | |||
== Related articles == | == Related articles == | ||
{{Related Articles}} | {{Related Articles}} | ||
Revision as of 14:59, 27 October 2019
| Data Integrity Checks | |
| Summary: | There must be at least 1 CCI entry in L_CCI_Picklist table (which might be No procedure performed) |
| Related: | CCI Collection, No procedure performed, L_CCI_Picklist table |
| Firmness: | hard check |
| Timing: | complete |
| App: | CCMDB.accdb |
| Coding: | query check_CCI_must_have_entry |
| Uses L Problem table: | not relevant for this app |
| Status: | needs review |
| Implementation Date: | 2018/11/12 |
| Backlogged: | true |
|
|
Log
- updates so it only checks for Recordstatus = complete or incomplete.
Related articles
| Related articles: |