Link suspect not same visitAdmitDtTm query: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
No edit summary
Line 1: Line 1:
{{Data Integrity Check
{{Data Integrity Check
|DIC_summary= Checks for records that are likely part of the same admission but have different [[Visit Admit DtTm field]].
|DIC_summary=Checks for records that are likely part of the same admission but have different [[Visit Admit DtTm field]].
|DIC_related_concepts=Visit Admit DtTm field; Dispo; Service/Location; Previous Location; Pre-admit Inpatient Institution
|DIC_related_concepts=Visit Admit DtTm field; Dispo; Service/Location; Previous Location; Pre-admit Inpatient Institution
|DIC_firmness=soft check
|DIC_firmness=soft check
|DIC_coding=''Link_suspect_not_same_visitAdmitDtTm'' query  
|DIC_coding=''Link_suspect_not_same_visitAdmitDtTm'' query
|DIC_status=implemented
|DIC_status=implemented
|DIC_LProblem=No
|DIC_LProblem=no
|DIC_app=Centralized data front end.accdb
|DIC_app=Centralized data front end.accdb
|DIC_backlogged=No
}}
}}
== What does this actually check? ==
== What does this actually check? ==
As of 2022-02-16 the query looks for records that:  
As of 2022-02-16 the query looks for records that:  

Revision as of 15:25, 2022 March 18

Data Integrity Checks
Summary: Checks for records that are likely part of the same admission but have different Visit Admit DtTm field.
Related: Visit Admit DtTm field, Dispo, Service/Location, Previous Location, Pre-admit Inpatient Institution
Firmness: soft check
Timing: always
App: Centralized data front end.accdb
Coding: Link_suspect_not_same_visitAdmitDtTm query
Uses L Problem table: no
Status: implemented
Implementation Date: not entered
Backlogged: No
  • Cargo


  • SMW


  • Categories: 
  • form:

What does this actually check?

As of 2022-02-16 the query looks for records that:

  • have different Visit Admit DtTm
  • the both Visit Admit DtTms are less than 2 years ago (to reduce query size)
  • the earlier is not Dispo to "Home" or "AMA (left against medical advice)"
  • both profiles are at the same site
  • have a difference of less than 1 day between the dispo at the first location and the Arrive at the second.
  • have a difference of less than 7 days between the dispo at the first location and the Arrive at the second and
(
)

Log

  • 2022-03-09 - tweaked query to only consider 4th option if at same site.
  • 2022-02-16 - updated query to use new Created AdmitDtTm query instead of Accept or Arrive dttm; also pulled some filters into intermediate query to filter earlier to make more efficient Ttenbergen 15:37, 2022 February 16 (CST)

Related articles

Related articles: