Query NDC TISS CCI endoscopic
Jump to navigation
Jump to search
Legacy Content
This page contains Legacy Content.- Explanation: No longer collecting Endoscopy (TISS Item), so nothing to check
- Successor: No successor was entered
Click Expand to show legacy content.
| Data Integrity Checks | |
| Summary: | If pt has T26 & 27 - Endoscopy (TISS Item) then there must be an endoscopic CCI for that day. |
| Related: | Endoscopy (TISS Item), ERCP (endoscopic retrograde cholangiopancreatography), Inspection, Exploration (endoscopic), Biopsy (endoscopic) |
| Firmness: | hard check |
| Timing: | complete |
| App: | Centralized data front end.accdb |
| Coding: | query NDC_TISS_CCI_endoscopic |
| Uses L Problem table: | Yes |
| Status: | retired |
| Implementation Date: | 2019/01/06 |
| Backlogged: | true |
This query is retired because T26 & 27 - Endoscopy (TISS Item) is no longer regularly collected.
CCI without T43
If there is at least one #Endoscopic CCI on a day, then T26 & 27 - Endoscopy (TISS Item) must be marked for that day.
T43 without CCI - can't be checked
Many of the CCIs are not defined as endoscopic or not, just as what was accomplished (e.g. Extraction ), so we will not be able to check that all T43 have a matching CCI.
Endoscopic CCI
We only track the route of procedures in a few exceptional cases:
- ERCP (endoscopic retrograde cholangiopancreatography)
- Inspection, Exploration (endoscopic)
- Biopsy (endoscopic)
See also
| Other procedure in Endoscopic Px: |
Log
- 2020-12-02 - retired query as part of Change to collect TISS data in CCI Picklist
- 2019-09-11 - updated component query "has_TISS_43_endoscopic_px" to actually look for TISS43, was looking for 42.