Arrive DtTm field: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older edit
SCortilet (talk | contribs)
CCMDB_legit, approved
1,248 edits
mNo edit summary
 
(85 intermediate revisions by 11 users not shown)
Line 1: Line 1:
  ''This field is currently being implemented, please check the instructions and put a discussion for anything that isn't clear. ''
{{Todo
 
| who = Tina
The [[Arrive DtTm field]] contains the time a patient changed status from what is documented in [[Previous Service field]] to [[Service/Location field]].
| 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
|field_name=Arrive_DtTm
|CCMDB_label=Arrive DtTm
|CCMDB_tab=Dispo
|data_type=date
|program_collecting=Med and CC
|created_raw=Raw
|data_element_start_date=2016-07-01
|data_element_end_date=2022-04-22
|data_element_sort_index=45
|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 the patient physically arrived on the ward.  
For each patient enter the First non-ER [[Boarding Loc]] date and time as {{PAGENAME}}. Follow the instructions at [[Boarding Loc]].


== Questions ==
This means the {{PAGENAME}} should be equal to the first [[Boarding Loc]] DtTm.
=== Is this the same as Accept DtTm?===
*This definition is a duplicate of the Accept dttm field, this is confusing. The accept time is when the screening medical resident takes over care of the patient and the arrive time is when the patient actually arrives on the given ward. --[[User:LKolesar|LKolesar]] 14:57, 2016 April 14 (CDT)
** The ''definition'' for sure is different, I don't know why you'd just claim it's the same, just read it. The date will sometimes be the same, but it might not be. Do CC docs never accept pt in ER or on the ward? And then the pt still needs to travel to ICU? Ttenbergen 19:47, 2016 April 25 (CDT)


== Feedback about date/time fields ==
== Planned elimination of this field ==
Let's discuss items common to the 4 time fields at [[Accept_DtTm_field#Feedback_about_date.2Ftime_fields]].
see [[Change to replace Accept DtTm with first Service tmp entry, and Arrive DtTm with first Boarding Loc]]
*EMIP pts will not have an arrive date or time as they do not physically leave the ER.


== Data Use ==
{{Data Integrity Check List}}
{{discussion}} Many things, need to pull them together Ttenbergen 12:59, 2016 March 21 (CDT)


== {{CCMDB Data Integrity Checks}} ==
== Legacy ==
* paneling; which of these actually runs?
{{Collapsable
** query ''check_panelled_primary_but_adm_NE_tr'' admit and transfer ready dttm must be same
| always=Click to see legacy info
** function Panelling_admit_transfer_same(Pat_ID)
| full=
* [[Minimal Data Set]] - or at least the date part is, will need instructions for that.
*For Medicine this concept is related to old [[ER Wait]] date an time.
{{discussion}} Need to pull together existing and implement for new situation
* Function ''ADT_Chronological()''


== Implementation ==
*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.
no comments


== Legacy ==
* For ICU this concept is related to the old [[Admit date and time]]. Resp L_Log.R_AdmDate and L_Log.R_AdmTime.
This field is part of the [[2016 Time and Place changes]].
}}


== Legacy ==
== Related Articles ==
For ICU:  Similar to the old [[Admit date and time]].
{{Related Articles}}


For medicine: it is like the time used for ER wait.  The old admit date and time are the accept date and time.--[[User:LKolesar|LKolesar]] 14:33, 2016 April 14 (CDT)


[[Category: 2016 Time and Place changes]]
[[Category:2016 Time and Place changes]]
[[Category: Admit/Discharge]]
[[Category:Admit/Discharge]]
[[Category:Data Collection Guide]]

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"