Query check CCI Date: Difference between revisions

(25 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_app = CCMDB.~~mdb~~

| DIC_timing = complete

| DIC_coding =

| DIC_app = CCMDB.accdb

| DIC_status = ~~needs review, ready to implement,~~ implemented~~, not feasible~~

| DIC_coding = query ''check_CCI_Date''

| DIC_implementation_date =

| DIC_status = implemented

| DIC_implementation_date = 2018-10-14

}}

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

[[~~Px Type#CCMDB Data Integrity Checks~~]]

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

~~Same as for~~ [[~~Dx Date~~]]

[[Category: CCI]]

* [[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 ==

[[Category:CCI Px check‎]]

@@ 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_app = CCMDB.mdb
+| DIC_timing = complete
-| DIC_coding =
+| DIC_app = CCMDB.accdb
-| DIC_status = needs review, ready to implement, implemented, not feasible
+| DIC_coding =  query ''check_CCI_Date''
-| DIC_implementation_date =
+| DIC_status =  implemented
+| DIC_implementation_date = 2018-10-14
 }}
+'''If this check changes, consider whether [[Query check ICD10 date]] should be changed the same way.'''
-[[Px Type#CCMDB Data Integrity Checks]]
+* If exists, [[Px_Date]] must be between first [[Service tmp entry]] and [[Dispo_DtTm]]
-Same as for [[Dx Date]]
-[[Category: CCI]]
+* [[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 ==
+{{Related Articles}}
+[[Category:CCI Px check‎]]