Visit Admit DtTm field

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 is the start of the hospital registration for the current admission. If from ER, this is also the Triage DtTm.

• SMW

Legacy implementation right in the table

• Cargo

• Categories

• Forms

JALT Since the Visit Admit DtTm is an in-house use only just like the Patient_ID, RecordStatus, etc, this should not be listed in the Auto Data Dictionary to avoid any misinformation to the users. I always provide this WIKI link to new users. Do you agree? --JMojica 09:06, 2024 March 21 (CDT)

• SMW

• Cargo

• Categories

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 field is not going to be used or given to anyone requesting data from the database.

Collection Instruction

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

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)

	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

• 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