Admit DtTm: Difference between revisions

(9 intermediate revisions by 2 users not shown)

Line 1:

The {{PAGENAME}} is the start of a profile as per [[Definition of a Critical Care ~~Laptop~~ Admission]]/[[Definition of a Medicine ~~Laptop~~ Admission]].

The {{PAGENAME}} is the start of a profile as per [[Definition of a Critical Care Program Admission]]/[[Definition of a Medicine Program Admission]].

== Definition ==

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.

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:

~~{{DJ |~~

* somewhere I read 2021-10-01, elsewhere -15, ~~which one is right?~~

** I have looked at the tmp Service and the earliest date is Oct 17, 2019 (??) followed by Feb 12, 2020, then Mar 10,2020, etc. even earlier than oct 15, 2020. there are 175 records with date earlier than Oct 1, 2020. how about a cut-off OCT 1, 2020? --[[~~User:JMojica|JMojica~~]] ~~16:59~~, ~~2022 February 8 (CST)~~

*** Agreed, we should use -10-01. I will need to update [[~~Created_AdmitDtTm query~~]] ~~because it actually doesn't have a cut-off at all. Do we want to clean out any~~ [[Service tmp entry]] ~~from before Oct 1? We would need to update the start dttm on that page~~ as ~~well. Actually, now that I say this: didn't we start Oct 1 at GRA and everywhere else Oct 15? [[User:Ttenbergen|Ttenbergen]] 13~~:~~51, 2022 February 9 (CST) }}~~

~~{{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;

~~| question = ~~

* Once discussion above is settled I need to update [[~~Created AdmitDtTm query~~]] ~~accordingly.~~

~~| todo_added = 2022-02-09~~

~~| todo_action~~ = ~~2022-02-09~~

}}

If [[~~Visit Admit DtTm]] > #2020-10-01# then~~

This is implemented as [[Created_AdmitDtTm query]].

~~earliest [[Service tmp entry]] DtTm in profile~~

~~else~~

~~if available, [[Accept DtTm]], else [[Arrive DtTm~~]]

~~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.

Line 33:

Line 22:

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: @@
-The {{PAGENAME}} is the start of a profile as per [[Definition of a Critical Care Laptop Admission]]/[[Definition of a Medicine Laptop Admission]].
+The {{PAGENAME}} is the start of a profile as per [[Definition of a Critical Care Program Admission]]/[[Definition of a Medicine Program Admission]].
 == Definition ==
-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.
+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:
-{{DJ |
-* somewhere I read 2021-10-01, elsewhere -15, which one is right?
-** I have looked at the tmp Service and the earliest date is Oct 17, 2019 (??) followed by Feb 12, 2020, then Mar 10,2020, etc.  even earlier than oct 15, 2020. there are 175 records with date earlier than Oct 1, 2020.   how about a cut-off OCT 1, 2020? --[[User:JMojica|JMojica]] 16:59, 2022 February 8 (CST)
-*** Agreed, we should use -10-01. I will need to update [[Created_AdmitDtTm query]] because it actually doesn't have a cut-off at all. Do we want to clean out any [[Service tmp entry]] from before Oct 1? We would need to update the start dttm on that page as well. Actually, now that I say this: didn't we start Oct 1 at GRA and everywhere else Oct 15? [[User:Ttenbergen|Ttenbergen]] 13:51, 2022 February 9 (CST) }}
-{{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;
- | question =  <!-- _Dev_CFE; _Dev_CCMDB -->
-* Once discussion above is settled I need to update [[Created AdmitDtTm query]] accordingly.
-| todo_added = 2022-02-09
-  | todo_action = 2022-02-09
-}}
- If [[Visit Admit DtTm]] > #2020-10-01# then
+This is implemented as [[Created_AdmitDtTm query]].
-    earliest [[Service tmp entry]] DtTm in profile
- else
-    if available, [[Accept DtTm]], else [[Arrive DtTm]]
-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}}
@@ Line 33: / Line 22: @@
 Also see "what links here"
 }}
+== Log ==
+* 2022-04-04 confirmed that both CFE and CCMDB now use this as defined here.
 == Related articles ==