View source for Link suspect visitAdmitDtTm mult to-from-home query

{{DISPLAYTITLE:Link_suspect_visitAdmitDtTm_mult_to-from-home query}}
{{Data Integrity Check
|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_firmness=soft check
|DIC_coding=''Link_suspect_visitAdmitDtTm_mult_to-from-home'' query
|DIC_status=
|DIC_LProblem=no
|DIC_app=Centralized data front end.accdb
|DIC_backlogged=No
}}

{{DT | implement this}}

== What does this actually check? ==
The query looks for records that: 
* have one [[Visit Admit DtTm]] 
** less than 2 years ago if full query is too slow
* more than 1 [[dispo]] entry that is [[Discharged to community]] 
* more than 1 [[Previous Location]] entry that is [[Discharged to community]] 

== Log ==
* 2025-03-11 requirement for this query was discussed during [[JALT Meeting - Rolling Agenda and Minutes 2025#JALT 2025-03-11]] to address counterpart to [[Visit Admit DtTm differences within same admission]] i.e. same [[Visit Admit DtTm]] for different admissions

== Related articles ==
{{Related Articles}}

[[Category:Registry checks]]