Arrive DtTm field: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older edit
mNo edit summary
 
(16 intermediate revisions by 2 users not shown)
Line 1: Line 1:
{{Todo
| who = Tina
| todo_added = 2022-06-30
| todo_action = 2023-05-04
| question = _after
* Field is legacy; once no longer used, remove it from sending and then from ccmdb_data. Query to check:
::SELECT L_Log.D_ID, L_Log.RecordStatus, L_Log.Accept_DtTm, L_Log.Arrive_DtTm
::FROM L_Log
::WHERE (((L_Log.RecordStatus)="incomplete") AND ((L_Log.Accept_DtTm) Is Not Null) AND ((L_Log.Arrive_DtTm) Is Not Null));
* 98 left as of 2022-08-04
* None left as of 2023-05-04, field can be removed...
** remove from sending
** remove from CCMDB_data
}}
{{Data element
{{Data element
|field_name=Arrive_DtTm
|field_name=Arrive_DtTm
|CCMDB_label=Arrive DtTm
|CCMDB_label=Arrive DtTm
|CCMDB_tab=Dispo
|CCMDB_tab=Dispo
|in_table=L Log table
|data_type=date
|data_type=date
|program_collecting=Med and CC
|program_collecting=Med and CC
|created_raw=Raw
|created_raw=Raw
|data_element_start_date=2016-07-01
|data_element_start_date=2016-07-01
|data_element_end_date=2022-04-22
|data_element_sort_index=45
|data_element_sort_index=45
|element_description=Date and time when the patient '''physically arrived''' on unit ([[Service/Location field | Service Location]]) '''OR ''' in a '''[[Boarding Loc|Boarding location]]'''.
|element_description=First non-ER [[Boarding Loc|Boarding location]] date and time, or start of ([[Service/Location field | Service Location]]) for legacy records.
}}
}}
== Collection Instruction ==
== Collection Instruction ==
For each patient enter the date and time when the patient '''physically arrived''' on the unit ([[Service/Location field | Service Location]]) '''or''' in a [[Boarding Loc|Boarding location]].
For each patient enter the First non-ER [[Boarding Loc]] date and time as {{PAGENAME}}. Follow the instructions at [[Boarding Loc]].
 
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 ===
* 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}}
 
== 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 |
This means the {{PAGENAME}} should be equal to the first [[Boarding Loc]] DtTm.
* 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 =
}}


== Planned elimination of this field ==
see [[Change to replace Accept DtTm with first Service tmp entry, and Arrive DtTm with first Boarding Loc]]


{{Data Integrity Check List}}
{{Data Integrity Check List}}

Latest revision as of 16:18, 2023 May 4

_after

  • Field is legacy; once no longer used, remove it from sending and then from ccmdb_data. Query to check:
SELECT L_Log.D_ID, L_Log.RecordStatus, L_Log.Accept_DtTm, L_Log.Arrive_DtTm
FROM L_Log
WHERE (((L_Log.RecordStatus)="incomplete") AND ((L_Log.Accept_DtTm) Is Not Null) AND ((L_Log.Arrive_DtTm) Is Not Null));
  • 98 left as of 2022-08-04
  • None left as of 2023-05-04, field can be removed...
    • remove from sending
    • remove from CCMDB_data
  • added: 2022-06-30
  • action: 2023-05-04
  • Cargo


  • Categories


 
 
 
 

Legacy Content

This page contains Legacy Content.
  • Explanation: This is a legacy data field, its DataElementEndDate is in the past.
  • Successor: No successor was entered

Click Expand to show legacy content.

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

First non-ER Boarding location date and time, or start of ( Service Location) for legacy records.

  • SMW

Legacy implementation right in the table

  • Cargo


  • Categories
  • Forms


Collection Instruction

For each patient enter the First non-ER Boarding Loc date and time as Arrive DtTm field. Follow the instructions at Boarding Loc.

This means the Arrive DtTm field should be equal to the first Boarding Loc DtTm.

Planned elimination of this field

see Change to replace Accept DtTm with first Service tmp entry, and Arrive DtTm with first Boarding Loc

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=159263"