Admit DtTm: Difference between revisions

(17 intermediate revisions by 2 users not shown)

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 Program Admission]]/[[Definition of a Medicine Program 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~~]]

This is implemented as [[query ~~created_AdmitDtTm]] in [[CFE~~]].

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.

== Relevance ==

Line 15:

Line 20:

* [[LOS]]

* [[ER Delay]]

* more to come as we refine things...

Also see "what links here"

}}

== Log ==

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

== Related articles ==

@@ 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 Program Admission]]/[[Definition of a Medicine Program 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]]
-This is implemented as [[query created_AdmitDtTm]] in [[CFE]].
+ 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 Check List}}
 == Relevance ==
@@ Line 15: / Line 20: @@
 * [[LOS]]
 * [[ER Delay]]
-* more to come as we refine things...
 Also see "what links here"
 }}
+== Log ==
+* 2022-04-04 confirmed that both CFE and CCMDB now use this as defined here.
 == Related articles ==