Visit Admit DtTm field: Difference between revisions
No edit summary |
Ttenbergen (talk | contribs) m Text replacement - "ccmdb.accdb" to "CCMDB.accdb" |
||
| Line 23: | Line 23: | ||
* in the '''Summary Views''' on the left, click on '''Visit History''' | * in the '''Summary Views''' on the left, click on '''Visit History''' | ||
* find the earliest entry of an Inpatient Type for your current hospital admission | * 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 [[ | * 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. | ** for this field, you must use the date/time in the EPR, and not from patient chart notes. | ||
Revision as of 20:27, 2020 July 24
| 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 |
The Visit Admit DtTm field 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 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
Collection Instruction
For each patient,
- 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. We do not know how the EPR generates the fields internally. They might be the same 95% of the time however, we don't know.
Even if the time is obviously inconsistent with the real patient visit time, use time as in EPR.
Data Use
This data is used to understand Length of Stay and for linking.
Data Integrity Checks
Data Integrity Checks (automatic list)
| App | Status | |
|---|---|---|
| Link suspect not same visitAdmitDtTm query | Centralized data front end.accdb | implemented |
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
Accept or Arrive dttm
- 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 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