Query check pt from ER: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m (category query is for pages about using queries, not to list them.)
mNo edit summary
Line 1: Line 1:
{{Data Integrity Check
| DIC_summary = part of validating [[Accept DtTm]]
| DIC_related_concepts = Accept DtTm; Previous Location
| DIC_firmness = soft check
| DIC_timing = always
| DIC_app = CCMDB.accdb
| DIC_coding = query ''check_pt_from_ER'', function Validate_Accept_DtTm(); function from_ER()
| DIC_status = needs review
| DIC_implementation_date = date change was rolled out / first applied
}}
This query in [[CCMDB.accdb]] identifies patients from ER. The name would lead you to think it's a cross check query, but it isn't.
This query in [[CCMDB.accdb]] identifies patients from ER. The name would lead you to think it's a cross check query, but it isn't.



Revision as of 10:05, 2021 May 13

Data Integrity Checks
Summary: part of validating Accept DtTm
Related: Accept DtTm, Previous Location
Firmness: soft check
Timing: always
App: CCMDB.accdb
Coding: query check_pt_from_ER, function Validate_Accept_DtTm(); function from_ER()
Uses L Problem table: not relevant for this app
Status: needs review
Implementation Date: date change was rolled out / first applied
Backlogged: true
  • Cargo


  • SMW


  • Categories: 
  • form:

This query in CCMDB.accdb identifies patients from ER. The name would lead you to think it's a cross check query, but it isn't.

Query is used by by function from_ER() which is in turn used by function Validate_Accept_DtTm() which validates the Accept DtTm.

Related articles

Related articles: