Admit DtTm: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
 
(16 intermediate revisions by 2 users not shown)
Line 1: Line 1:
Admit DtTm is not as simple of a concept as it might seem, and it's definition and storage in our database has changed over time. This page gives some definitions and how we have implemented them.  
The {{PAGENAME}} is the start of a profile as per [[Definition of a Critical Care Laptop Admission]]/[[Definition of a Medicine Laptop Admission]].


== Proposed definition ==
== Definition ==
If [[Visit Admit DtTm]] > #2020-10-15# then 
The derivation of Admit DtTm has changed over time, involving the fields [[Accept DtTm]], [[Arrive DtTm]] and [[Service tmp entry]] DtTm. Admit DtTm is defined as follows:
    earliest [[Service tmp entry]] DtTm in profile
else
    if available, [[Accept DtTm]], else if [[Arrive DtTm]]


{{Todo
SELECT L_Log.Pat_ID, CDate(Nz([Service_DtTm],Nz([Accept_dttm],[Arrive_Dttm]))) AS Admit_DtTm
| who = Tina
FROM L_Log LEFT JOIN created_FirstService ON L_Log.Pat_ID = created_FirstService.Pat_ID;
| todo_added = 2021-07-27
 
| todo_action = 2021-08-10
This is implemented as [[Created_AdmitDtTm query]].
| question =
 
[[Service tmp entry]] is not yet part of [[Minimal Data Set]]; I have flagged on that page how it needs to be included; will need to be considered as part of [[Change to replace Accept DtTm with first Service tmp entry, and Arrive DtTm with first Boarding Loc]].
== Transition ==
}}
GRA changed to this Oct 1 and everyone else Oct 15. Julie cleaned all the data so we don't need to worry about this: we can simply say if Service tmp DtTm is available, use it.  
 
{{Data Integrity Check List}}


== Relevance ==
== Relevance ==
Line 21: Line 20:
* [[LOS]]
* [[LOS]]
* [[ER Delay]]
* [[ER Delay]]
* more to come as we refine things...
Also see "what links here"
Also see "what links here"
}}
}}
== Log ==
* 2022-04-04 confirmed that both CFE and CCMDB now use this as defined here.


== Related articles ==  
== Related articles ==  

Latest revision as of 15:34, 2022 April 4

The Admit DtTm is the start of a profile as per Definition of a Critical Care Laptop Admission/Definition of a Medicine Laptop Admission.

Definition

The derivation of Admit DtTm has changed over time, involving the fields Accept DtTm, Arrive DtTm and Service tmp entry DtTm. Admit DtTm is defined as follows:

SELECT L_Log.Pat_ID, CDate(Nz([Service_DtTm],Nz([Accept_dttm],[Arrive_Dttm]))) AS Admit_DtTm
FROM L_Log LEFT JOIN created_FirstService ON L_Log.Pat_ID = created_FirstService.Pat_ID;

This is implemented as Created_AdmitDtTm query.

Transition

GRA changed to this Oct 1 and everyone else Oct 15. Julie cleaned all the data so we don't need to worry about this: we can simply say if Service tmp DtTm is available, use it.

Data Integrity Checks (automatic list)

 AppStatus
Query check tmp Service and Boarding Loc during admission timeframeCCMDB.accdbimplemented
Function long LOS()CCMDB.accdbneeds review
Link suspect negative transit time queryCentralized data front end.accdbimplemented

Relevance

List of related concepts   

Also see "what links here"

Log

  • 2022-04-04 confirmed that both CFE and CCMDB now use this as defined here.

Related articles

Related articles: