Arrive DtTm field: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older editNewer edit →
This field is not part of Minimal data set. If it ever was, it hasn't been for a long time.
Line 19: Line 19:


=== sources for Arrive DtTm ===
=== sources for Arrive DtTm ===
==== [[Cognos_Report_Integrator]] ====
==== EPR Reports ====
To find the arrive date & time when using EPR Reports:
* Go to "transfer Register" and enter all criteria ie. facility site, date parameters, unit/ward parameters, to or from location, filter for between unit transfers only, sort as desired, generate a report, the [[Arrive DtTm]] will be in the Transfer/Date/Time column
 
==== First set of vital signs ====
The first set of vital signs is used as ArriveDtTm in ICU collection, if it is different from the EPR Admit DtTm. The ADT Unit arrive DtTm will still show up in [[EPR Admit DtTm field]] if the patient was entered using one of the integrators.
 
{{Discuss |
* This may still be inconsistent with the dt and tm in [[Boarding Loc]], need to make sure we all use the same instructions. }}


=== [[Accept DtTm]] > [[Arrive DtTm]] ===
=== [[Accept DtTm]] > [[Arrive DtTm]] ===
Line 27: Line 35:
* if the patient never does arrive on your unit, then the [[Arrive DtTm]] will be the same time as the [[Accept DtTm]]
* if the patient never does arrive on your unit, then the [[Arrive DtTm]] will be the same time as the [[Accept DtTm]]


==== time is exactly midnight ====
== Data Use ==
If the [[Arrive DtTm]] is exactly midnight, enter 23:59 instead and then exclude the entry in [[CSS]] so it doesn't stay on the list.
Many things, need to pull them together Ttenbergen 12:59, 2016 March 21 (CDT)
 
If you try to enter an [[Arrive DtTm]] of exactly midnight you will get an error. This is because we want to check that the time was not forgotten (it might not initially be known), and in Access there is no distinction between a time that is blank and one that is 00:00.
 
{{Guideline Minimal Data Set}}
 
== Elimination of this field ==
The data in this field is now a duplication of the data in [[Boarding Loc]]. We plan to retire this field eventually, but it is relevant to many things so we need to be deliberate about it.
 
{{Discuss | who = Julie |
Is there a target date for eliminating this field? [[User:Ttenbergen|Ttenbergen]] 11:42, 2021 May 5 (CDT)
}}
 
{{Todo | who = Tina |
* work through [[#Data Integrity Checks SMW)]], update documentation in process
* remove ADT2 button that automatically populates this
* confirm no more actionable links to this
* hide field in [[CCMDB.accdb]] when all done
* [[Created Variables]]
| todo_added = 2021-05-05
| todo_action =
}}
 
{{Todo | who = Julie |
* work through any reports that currently use this concept, update documentation in process
** [[#Related articles]] provides a good starting list of related concepts
| todo_added = 2021-05-05
| todo_action =
}}
 


== Data Integrity Checks ==
{{Data Integrity Check List}}
{{Data Integrity Check List}}


Revision as of 19:03, 2021 June 23

Data Element (edit)
Field Name: Arrive_DtTm
CCMDB Label: Arrive DtTm
CCMDB tab: Dispo
Table: L Log table
Data type: date
Length: not stated
Program: Med and CC
Created/Raw: Raw
Start Date: 2016-07-01
End Date: 2300-01-01
Sort Index: 45

Date and time when the patient physically arrived on unit ( Service Location) OR in a Boarding location.

  • SMW

Legacy implementation right in the table

  • Cargo


  • Categories
  • Forms



Collection Instruction

For each patient enter the date and time when the patient physically arrived on the unit ( Service Location) or in a Boarding location.

Consider the Boarding Loc instructions when you enter decide what this field needs to be.

sources for Arrive DtTm

EPR Reports

To find the arrive date & time when using EPR Reports:

  • Go to "transfer Register" and enter all criteria ie. facility site, date parameters, unit/ward parameters, to or from location, filter for between unit transfers only, sort as desired, generate a report, the Arrive DtTm will be in the Transfer/Date/Time column

First set of vital signs

The first set of vital signs is used as ArriveDtTm in ICU collection, if it is different from the EPR Admit DtTm. The ADT Unit arrive DtTm will still show up in EPR Admit DtTm field if the patient was entered using one of the integrators.

  • This may still be inconsistent with the dt and tm in Boarding Loc, need to make sure we all use the same instructions.
  • SMW


  • Cargo


  • Categories

Accept DtTm > Arrive DtTm

If the Accept DtTm > Arrive DtTm, make accept = arrive.

pt never arrives on your unit

Data Use

Many things, need to pull them together Ttenbergen 12:59, 2016 March 21 (CDT)

Data Integrity Checks

Data Integrity Checks (automatic list)

none found

Legacy

Click to see legacy info   
  • For Medicine this concept is related to old ER Wait date an time.
  • From June 1, 2011 to June 30, 2016, the Arrive_DtTm in Medicine was in the Tmp project ER Wait and was migrated into the Arrive_DtTm field.
  • For ICU this concept is related to the old Admit date and time. Resp L_Log.R_AdmDate and L_Log.R_AdmTime.

Related Articles

Related articles:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Arrive_DtTm_field&oldid=150807"