Query check CCI Date: Difference between revisions

(15 intermediate revisions by 3 users 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 =

| DIC_timing = complete

| DIC_app = CCMDB.~~mdb~~

| DIC_app = CCMDB.accdb

| DIC_coding =

| DIC_coding = query ''check_CCI_Date''

| DIC_status = ~~needs review~~

| DIC_status = implemented

| DIC_implementation_date =

| DIC_implementation_date = 2018-10-14

}}

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

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

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

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

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

* not allowed for procedures with [[Px Type]] '''admit''' / [[Admit 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 =
+| DIC_timing = complete
-| DIC_app = CCMDB.mdb
+| DIC_app = CCMDB.accdb
-| DIC_coding =
+| DIC_coding =  query ''check_CCI_Date''
-| DIC_status = needs review
+| DIC_status =  implemented
-| DIC_implementation_date =
+| DIC_implementation_date = 2018-10-14
 }}
 '''If this check changes, consider whether [[Query check ICD10 date]] should be changed the same way.'''
-* If exists, [[Dx_Date]] must be between [[Arrive_DtTm]] and [[Dispo_DtTm]]
+* If exists, [[Px_Date]] must be between first [[Service tmp entry]] and [[Dispo_DtTm]]
-* mandatory for procedures with [[Px Type]] '''acquired''' / [[Acquired Procedure]]
+* [[Px_Date]] mandatory for procedures with [[Px Type]] '''acquired''' / [[Acquired Procedure]]
-* not allowed for procedures with [[Px Type]] '''admit''' / [[Admit 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 ==