Link suspect visitAdmitDtTm mult to-from-home query: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) Created page with "{{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=Central..." |
Ttenbergen (talk | contribs) No edit summary |
||
| (One intermediate revision by the same user not shown) | |||
| 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 | |DIC_related_concepts=Visit Admit DtTm field; Dispo; Service/Location; Previous Location | ||
|DIC_firmness= | |DIC_firmness=hard check | ||
|DIC_coding=''Link_suspect_visitAdmitDtTm_mult_to-from-home'' query | |DIC_coding=''Link_suspect_visitAdmitDtTm_mult_to-from-home'' query | ||
|DIC_status= | |DIC_status=ready to implement | ||
|DIC_LProblem= | |DIC_LProblem=yes | ||
|DIC_app=Centralized data front end.accdb | |DIC_app=Centralized data front end.accdb | ||
|DIC_backlogged=No | |DIC_backlogged=No | ||
}} | }} | ||
{{DISPLAYTITLE:Link_suspect_visitAdmitDtTm_mult_to-from-home query}} | |||
{{DT | implement this}} | {{DT | | ||
* implement this | |||
* with L_Problems tie in? | |||
* tell Pagasa it exists}} | |||
== What does this actually check? == | == What does this actually check? == | ||
Latest revision as of 21:24, 11 March 2025
| 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 |
| Firmness: | hard check |
| Timing: | always |
| App: | Centralized data front end.accdb |
| Coding: | Link_suspect_visitAdmitDtTm_mult_to-from-home query |
| Uses L Problem table: | yes |
| Status: | ready to implement |
| Implementation Date: | not entered |
| Backlogged: | No |
|
|
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: |