Visit Admit DtTm field: Difference between revisions

(73 intermediate revisions by 13 users not shown)

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 first entry in the visit location history in EPR for ~~this~~ visit.

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 ~~the start of~~ a hospital encounter at your site. The info is ~~use~~ to:

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

~~(''in progress.~~ ~~Any collector can continue to rewrite to help make clearer - Thank you!'')~~

*The field is pre-populated by [[Cognos2 Service Starter]] and should not be changed or altered

~~For each~~ patient,

{{Collapsable

* In [[EPR]] find Patient ~~name~~

| always= If a patient needs to be entered other than through Cognos

* ~~go to:~~

| full=

**Registration

* In [[EPR]] find Patient

**Visit ~~Location~~

* Under Patient Info tab

**Location History

* in the '''Summary Views''' on the left, click on '''Visit History'''

***at the ~~bottom~~ of ~~the page, you will see the specific~~ hospital~~, and also the date/times in ER.~~

* find the earliest entry of an Inpatient Type for your current hospital admission

***find the ~~'''earliest~~ date/time in the ~~list; e.g. VGH-ED-Triage start. Use that date/time~~ as your ~~Visit Admit DtTm.~~

* enter the Admit/Reg date/time from the first column as your [[Visit Admit DtTm field]] in [[CCMDB.accdb]]

* enter that date into the [[Visit Admit DtTm field]] in [[~~ccmdb~~.~~mdb~~]]

** for this field, you must use the date/time in the EPR, and not from patient chart notes.

~~== Questions? ==~~

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.

~~=== Inter-Hospital Transfer ===~~

* If a patient is a direct admission from a different hospital (ie STB ward) to your ward (ie VIC ward), is your [[Arrive_DtTm field]] the same ~~as your [[Visit Admit DtTm field]]?~~

** Use the EPR ~~admit time~~ to ~~hospital. Some of you~~ get ~~your [[Admit DtTm]] from somewhere different~~. ~~We want the Visit Admit DtTm to come from the~~ EPR ~~because then the exact same will be used throughout the admission, not something that might be slightly off. This may be~~ the ~~same, or it may not. Ttenbergen 17:44, 2016 April 25 (CDT)~~

*I need clarification!!! Are we using the visit admit date and time ~~from our hospital only, or from~~ the ~~first time they visited any hospital within the current admission? For example, if they came to STB ER, and were sent from ER to VIC ICU, do I use the STB ER time~~ as ~~my visit admit, or my VIC admit~~ time~~? Also, for patients coming from outside of the city, they don't have EPR time entries~~. ~~MLagadi 10:43, 2016 April 26~~

*It is only your hospital. When the pt first presented at your hospital. --[[User:LKolesar|LKolesar]] 12:37, 2016 April 26 (CDT)

~~== 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 ==

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

== {{~~CCMDB~~ Data Integrity ~~Checks~~}} ==

* must be <= [[Arrive DtTm field]]

== Legacy ==

Line 42:

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.

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

[[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]]

@@ 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 first entry in the visit location history in EPR for this visit.
+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 the start of a hospital encounter at your site.  The info is use to:
+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 ==
-(''in progress.  Any collector can continue to rewrite to help make clearer - Thank you!'')
+*The field is pre-populated by [[Cognos2 Service Starter]] and should not be changed or altered
-For each patient,
+{{Collapsable
-* In [[EPR]] find Patient name
+| always= If a patient needs to be entered other than through Cognos
-* go to:
+| full=
-**Registration
+* In [[EPR]] find Patient
-**Visit Location
+* Under Patient Info tab
-**Location History
+* in the '''Summary Views''' on the left, click on '''Visit History'''
-***at the bottom of the page, you will see the specific hospital, and also the date/times in ER.
+* find the earliest entry of an Inpatient Type for your current hospital admission
-***find the '''earliest date/time in the list; e.g. VGH-ED-Triage start.  Use that date/time as your Visit Admit DtTm.
+* enter the Admit/Reg date/time from the first column as your [[Visit Admit DtTm field]] in [[CCMDB.accdb]]
-* enter that date into the [[Visit Admit DtTm field]] in [[ccmdb.mdb]]
+** for this field, you must use the date/time in the EPR,  and not from patient chart notes.
-== Questions? ==
+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.
-=== Inter-Hospital Transfer ===
-* If a patient is a direct admission from a different hospital (ie STB ward) to your ward (ie VIC ward), is your [[Arrive_DtTm field]] the same as your [[Visit Admit DtTm field]]?
-** Use the EPR admit time to hospital. Some of you get your [[Admit DtTm]] from somewhere different. We want the Visit Admit DtTm to come from the EPR because then the exact same will be used throughout the admission, not something that might be slightly off. This may be the same, or it may not. Ttenbergen 17:44, 2016 April 25 (CDT)
-*I need clarification!!! Are we using the visit admit date and time from our hospital only, or from the first time they visited any hospital within the current admission? For example, if they came to STB ER, and were sent from ER to VIC ICU, do I use the STB ER time as my visit admit, or my VIC admit time? Also, for patients coming from outside of the city, they don't have EPR time entries. MLagadi 10:43, 2016 April 26
-*It is only your hospital.  When the pt first presented at your hospital.  --[[User:LKolesar|LKolesar]] 12:37, 2016 April 26 (CDT)
-== 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 ==
 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 ==
@@ Line 42: / 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.
+== 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]]