Query check CCI Date: Difference between revisions

(7 intermediate revisions by the same user not shown)

Line 1:

{{Data Integrity Check

| DIC_summary = [[Px Date]] must be sensible when compared to [[~~Arrive_DtTm~~]] and [[Dispo_DtTm]]

| DIC_summary = [[Px Date]] must be sensible when compared to first [[Service tmp entry]] and [[Dispo_DtTm]]

| DIC_related_concepts = Px Date; ~~Arrive_DtTm~~; Dispo_DtTm

| DIC_related_concepts = Px Date; Service tmp entry; Dispo_DtTm; Px Type

| DIC_firmness = hard check

| DIC_timing = complete

| DIC_app = CCMDB.~~mdb~~

| DIC_app = CCMDB.accdb

| DIC_coding = query ''check_CCI_Date''

| DIC_status = implemented

Line 12:

'''If this check changes, consider whether [[Query check ICD10 date]] should be changed the same way.'''

* If exists, [[Px_Date]] must be between [[~~Arrive_DtTm~~]] and [[Dispo_DtTm]]

* If exists, [[Px_Date]] must be between first [[Service tmp entry]] and [[Dispo_DtTm]]

* [[Px_Date]] mandatory for procedures with [[Px Type]] '''acquired''' / [[Acquired Procedure]]

* [[Px_Date]] not allowed for procedures with [[Px Type]] '''admit''' / [[Admit Procedure]]

== Log ==

* 2022-03-31 - updated to use first [[Service tmp entry]] instead of "Accept DtTm"

* 2021-03-24 - Julie flagged a false negative that was probably from before the last log

* 2021-01-20 - confirmed that both dates before admit and after dispo are caught.

* 2020-10-15 - changed start limit from "Arrive DtTm" to "Accept DtTm" since we now collect data on pts starting at ER arrival, and the EMIP distinction is going away.

== Related Articles ==

@@ Line 1: / Line 1: @@
 {{Data Integrity Check
-| DIC_summary = [[Px Date]] must be sensible when compared to [[Arrive_DtTm]] and [[Dispo_DtTm]]
+| DIC_summary = [[Px Date]] must be sensible when compared to first [[Service tmp entry]] and [[Dispo_DtTm]]
-| DIC_related_concepts = Px Date; Arrive_DtTm; Dispo_DtTm
+| DIC_related_concepts = Px Date; Service tmp entry; Dispo_DtTm; Px Type
 | DIC_firmness = hard check
 | DIC_timing = complete
-| DIC_app = CCMDB.mdb
+| DIC_app = CCMDB.accdb
 | DIC_coding =  query ''check_CCI_Date''
 | DIC_status =  implemented
@@ Line 12: / Line 12: @@
 '''If this check changes, consider whether [[Query check ICD10 date]] should be changed the same way.'''
-* If exists, [[Px_Date]] must be between [[Arrive_DtTm]] and [[Dispo_DtTm]]
+* If exists, [[Px_Date]] must be between first [[Service tmp entry]] and [[Dispo_DtTm]]
 * [[Px_Date]] mandatory for procedures with [[Px Type]] '''acquired''' / [[Acquired Procedure]]
 * [[Px_Date]] not allowed for procedures with [[Px Type]] '''admit''' / [[Admit Procedure]]
+== Log ==
+* 2022-03-31 - updated to use first [[Service tmp entry]] instead of "Accept DtTm"
+* 2021-03-24 - Julie flagged a false negative that was probably from before the last log
+* 2021-01-20 - confirmed that both dates before admit and after dispo are caught.
+* 2020-10-15 - changed start limit from "Arrive DtTm" to "Accept DtTm" since we now collect data on pts starting at ER arrival, and the EMIP distinction is going away.
 == Related Articles ==