Arrive DtTm field: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
TOstryzniuk (talk | contribs)
No edit summary
m integrated discussion and answer.
Line 1: Line 1:
{{Discuss|Cognos/CCMDB is not accepting 00:00 as an Arrive dtm
*Use 23:59.[[User:TOstryzniuk|Trish Ostryzniuk]] 12:48, 2021 March 4 (CST)}}
{{Data element
{{Data element
|field_name=Arrive_DtTm
|field_name=Arrive_DtTm
Line 29: Line 26:
=== pt never arrives on your unit ===
=== pt never arrives on your unit ===
* 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 ====
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.
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}}
{{Guideline Minimal Data Set}}

Revision as of 16:23, 2021 March 4

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

Cognos_Report_Integrator

Accept DtTm > Arrive DtTm

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

pt never arrives on your unit

time is exactly midnight

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.

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.

Minimal Data Set

This entry is part of the Minimal Data Set. Special collection instructions apply, see that page for more info.

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: