Visit Admit DtTm field: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m (→‎Questions?: minor)
No edit summary
 
(94 intermediate revisions by 18 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. ''
{{Data_element
| field_name = Visit_Admit_DtTm
| CCMDB_label = Visit Admit DtTm
| CCMDB_tab = Dispo
| element_description = This field is used only as an identifier to combine data from the same hospitalization and should not be used as a date.  
| in_table = L_Log table
| data_type = date
| program_collecting = Med and CC
| created_raw = Raw
| data_element_start_date = Jan 1, 2003
| data_element_sort_index = 42
}}


The [[Visit Admit DtTm field]] contains the date and time triaged/arrived/present in ER  of the currrent hospitalization at your site.
The field it is automatically populated from [[Cognos EPR Report]]. For reference only, it contains the first entry in the visit location history in EPR for ''current'' visit at a hospital site.
  I still need to implement this in CCMDB, but would welcome your comments already!
 
== Purpose ==
The field is used as an identifier of '''a hospital encounter at your site'''. The info is used to:
* link together ICU and Ward admissions during the same hospital visit
* uniquely identify patient visits to Manitoba Health when we exchange data with them
 
We obtain this item from the ADT system (via Cognos) and it does not always accurately identify the timing of hospital admission. THUS, we are only using it as an identifier to link.
 
* The [[Statistician]] must not give this field to anyone requesting data from the database to avoid being misused.


== Collection Instruction ==
== Collection Instruction ==
For each patient,
*The field is pre-populated by [[Cognos2 Service Starter]] and should not be changed or altered 
* open the patient in [[EPR]]
* click on location history (was that the name? Could someone sent me a screen shot of the button?)
* find the '''earliest date/time in the list'''; e.g. this might be the ER Triage date
* enter that date into the [[Visit Admit DtTm field]].


== Questions? ==
{{Collapsable
{{discussion}}
| always= If a patient needs to be entered other than through Cognos
* Do you see any issues collecting this? Ttenbergen 15:35, 2016 April 18 (CDT)
| full=
** patient transferred from ICMS to ward, ICU would have captured the first date and time in the EPR, what should medicine capture? the same date/time that ICU captured? [[User:Lkaita|Lisa Kaita]] 09:37, 2016 April 21 (CDT)
* In [[EPR]] find Patient
*** Medicine would code the "Accept D/T" as admission to hospital D/T. Patients are not admitted until a service accepts them and admit orders are reflecting this as such.
* Under Patient Info tab
****My understanding is that no matter what, we put the first presentation to the hospital in the "visit admit dttm field".  In Lisa's example, the visit admit date and time will be the same as the ICU one as the pt presented to the hospital at the same time.  The accept date and time to medicine is not an issue for ICU transfers as this time is the same as the arrive time on the ward.--[[User:LKolesar|LKolesar]] 11:04, 2016 April 22 (CDT) 
* in the '''Summary Views''' on the left, click on '''Visit History'''
* find the earliest entry of an Inpatient Type for your current hospital admission
* enter the Admit/Reg date/time from the first column as your [[Visit Admit DtTm field]] in [[CCMDB.accdb]]
** for this field, you must use the date/time in the EPR,  and not from patient chart notes.


*Visit admit remains unclear to me...clients present to ER and are waiting to be seen etc prior their actual admission point...do you want this field representing the D/T when they present to ER?--[[User:Llemoine|Llemoine]] 11:20, 2016 April 21 (CDT)
Important NOTE:  All collector must look exactly in the same place in the EPR to get this information as indicated in the instructions above. EPR lists the time the pt became an inpatient as this time.  
**yes.


== Background ==
}}
Right now you guys collect detailed to/from info in Var1/2. The details are primarily used for linking. Collecting the Hospital Admit DtTm will make that information irrelevant for wards where we don't collect, so we will be able to code "from" for wards where we don't collect just as "HSC Ward"(eg).


== Data Use ==
== Data Use ==
This data is used to understand [[:Category:Length of stay| Length of Stay]] and for [[linking]].
This data is used to understand [[:Category:Length of stay| Length of Stay]] and for [[linking]].


== {{CCMDB Data Integrity Checks}} ==
{{Data Integrity Check List}}
* must be <= [[Arrive DtTm field]]


== Legacy ==
== Legacy ==
Line 35: Line 50:
It is being added to simplify the old [[linking]] - if we have the hospital admit date and time, we are done linking, none of the previous complex process will be needed any longer.  
It is being added to simplify the old [[linking]] - if we have the hospital admit date and time, we are done linking, none of the previous complex process will be needed any longer.  


== Start date and early data ==
* at some point before 2021-01-01 we started getting this field directly from [[Cognos]], likely from the beginning of using Cognos.
* July 1, 2016 - Data collectors entering the data from EPR
* Jan 1, 2003 to June 30,2016 - generated Pseudo Visit Date_time
** Julie has generated "pseudo - Visit Admit DtTm" data for records from Jan 1, 2003 until June 30,2016 based on "Accept DtTm" or "Arrive DtTm" to facilitate linking those as well. This data was imported using temporary query 2017-01-17_pseudoVisitAdmit_update in centralized_data.mdb
* before Jan 1, 2003 has a Visit Admit DtTm of '''null'''
== Related articles ==
{{Related Articles}}


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

Latest revision as of 13:38, 2024 March 25

Data Element (edit)
Field Name: Visit_Admit_DtTm
CCMDB Label: Visit Admit DtTm
CCMDB tab: Dispo
Table: L_Log table
Data type: date
Length: not stated
Program: Med and CC
Created/Raw: Raw
Start Date: Jan 1, 2003
End Date: 2300-01-01
Sort Index: 42

This field is used only as an identifier to combine data from the same hospitalization and should not be used as a date.

  • SMW

Legacy implementation right in the table

  • Cargo


  • Categories
  • Forms


The field it is automatically populated from Cognos EPR Report. For reference only, it contains the first entry in the visit location history in EPR for current visit at a hospital site.

Purpose

The field is used as an identifier of a hospital encounter at your site. The info is used to:

  • link together ICU and Ward admissions during the same hospital visit
  • uniquely identify patient visits to Manitoba Health when we exchange data with them

We obtain this item from the ADT system (via Cognos) and it does not always accurately identify the timing of hospital admission. THUS, we are only using it as an identifier to link.

  • The Statistician must not give this field to anyone requesting data from the database to avoid being misused.

Collection Instruction

If a patient needs to be entered other than through Cognos   
  • In EPR find Patient
  • Under Patient Info tab
  • in the Summary Views on the left, click on Visit History
  • find the earliest entry of an Inpatient Type for your current hospital admission
  • enter the Admit/Reg date/time from the first column as your Visit Admit DtTm field in CCMDB.accdb
    • for this field, you must use the date/time in the EPR, and not from patient chart notes.

Important NOTE: All collector must look exactly in the same place in the EPR to get this information as indicated in the instructions above. EPR lists the time the pt became an inpatient as this time.

Data Use

This data is used to understand Length of Stay and for linking.

Data Integrity Checks (automatic list)

 AppStatus
Link suspect not same visitAdmitDtTm queryCentralized data front end.accdbimplemented

Legacy

This field is part of the 2016 Time and Place changes.

It is being added to simplify the old linking - if we have the hospital admit date and time, we are done linking, none of the previous complex process will be needed any longer.

Start date and early data

  • at some point before 2021-01-01 we started getting this field directly from Cognos, likely from the beginning of using Cognos.
  • July 1, 2016 - Data collectors entering the data from EPR
  • Jan 1, 2003 to June 30,2016 - generated Pseudo Visit Date_time
    • Julie has generated "pseudo - Visit Admit DtTm" data for records from Jan 1, 2003 until June 30,2016 based on "Accept DtTm" or "Arrive DtTm" to facilitate linking those as well. This data was imported using temporary query 2017-01-17_pseudoVisitAdmit_update in centralized_data.mdb
  • before Jan 1, 2003 has a Visit Admit DtTm of null

Related articles

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