Query check CCI Picklist duplicates: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) m (Text replacement - "CCMDB.mdb" to "CCMDB.accdb") |
||
(5 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
{{Data Integrity Check | {{Data Integrity Check | ||
| DIC_summary = No duplication of [[CCI Picklist]] [[Px_Type]], [[Px_Date]], [[Px_Count]] | | DIC_summary = No duplication of [[CCI Picklist]] [[Px_Type]], [[Px_Date]], [[Px_Count]] | ||
| DIC_related_concepts = | | DIC_related_concepts = CCI Picklist; Px Type; Dx_Priority; No Dx Entered | ||
| DIC_firmness = hard check | | DIC_firmness = hard check | ||
| DIC_timing = complete | | DIC_timing = complete | ||
| DIC_app = CCMDB. | | DIC_app = CCMDB.accdb | ||
| DIC_coding = query ''check_CCI_Picklist_duplicates'' | | DIC_coding = query ''check_CCI_Picklist_duplicates'' | ||
| DIC_status = | | DIC_status = implemented | ||
| DIC_implementation_date = | | DIC_implementation_date = 2018-10-14 | ||
}} | }} | ||
*[[Px Type]] = Acquired – no same [[Px_Date]] and CCI code | *[[Px Type]] = Acquired – no same [[Px_Date]] and CCI code | ||
*[[Px Type]] = Admit – no same CCI code (it should not have a [[Px_Date]] at all, dealt with by [[Query check CCI Date]]). | *[[Px Type]] = Admit – no same CCI code (it should not have a [[Px_Date]] at all, dealt with by [[Query check CCI Date]]). | ||
We are not currently planning to check for [[CCI | We are not currently planning to check for [[CCI Collection Mode]]s being used correctly but this may change. | ||
== Related articles == | == Related articles == |
Latest revision as of 11:43, 2019 September 22
Data Integrity Checks | |
Summary: | No duplication of CCI Picklist Px_Type, Px_Date, Px_Count |
Related: | CCI Picklist, Px Type, Dx_Priority, No Dx Entered |
Firmness: | hard check |
Timing: | complete |
App: | CCMDB.accdb |
Coding: | query check_CCI_Picklist_duplicates |
Uses L Problem table: | not relevant for this app |
Status: | implemented |
Implementation Date: | 2018-10-14 |
Backlogged: | true |
- Px Type = Acquired – no same Px_Date and CCI code
- Px Type = Admit – no same CCI code (it should not have a Px_Date at all, dealt with by Query check CCI Date).
We are not currently planning to check for CCI Collection Modes being used correctly but this may change.
Related articles
Related articles: |