Hospital Encounters Flashcards
What does ADT stand for?
Admissions, discharge, and transfers 116
What does an ADT event represent?
An ADT event represents a change in a patient’s bed or the encounter’s billing drivers and contains information relating to the patients status at that time. 116
What is a billing driver?
A billing driver is a property that could change whether the system posts bed changes to the visits associated HAR. Examples include changes to patient class or level of care.
What is the main table for ADT events in clarity?
Clarity_ADT 116
What does ADT 30 represent?
It represents the event type.116
This item ADT 30 turns into Event_type_C in the table
In hospital encounters what does the event type describe?
The event type describes why the event record was created. In clarity_adt it becomes event_type_c 116
What does the Grand Central Application do?
The grand central application (formerly known as ADT) mains a history of events for each patient hospital encounter in the ADT master file.116
Admission
This event happens when the patient is first placed in a bed in the encounter 116
Discharge
This event happens when the patient id discharged from the hospital. It can also correspond to the closing of an HOV encounter.117
Transfer In
This event results from a transfer. It includes information about the bed the patient enters as a result of the transfer.117
Transfer Out
This event results from a transfer. It includes information about the bed the patient enters as a result of the transfer.117
Patient Update
This event represents a change to a billing driver that is not associated with a change in the patient’s bed. 117
Census
A census typically takes place at 11:59 PM every night. A census event is created for every bed, unless the patient admitted to that bed is on a leave of absence. If a patient occupies the bed, the event stores the patient’s record ID and the EPT contact’s CSN. 117
HOV
This event represents the date and time a patient arrived for an HOV. Note that corresponding discharge events are created during nightly processing.117
Leave of Absence Out
This event results from a patient leaving their room or bed for a limited amount of time, such as to have an encounter at another location, or leave the facility for a day or weekend.117
Leave of Absence Return
This event results from a patient returning to their room or bed after being away a limited amount of time.117
Leave of absence Census
If an admitted patient happens to be on a leave of absence during the nightly census, a leave o absence census event is created (rather than a standard census event).117
True or False: multiple ADT event records make up a single hospital encounter.
True, Multiple ADT event records make up a single hospital encounter. I ADT 40 orders these ADT event records chronologically.118
True or False: ADT 40 orders event records?
True118
What happens if an ADT event is the first event?
If an ADT event is the first event in its encounter, its value in I ADT 40 is 1. The next event in that same encounter has a value of 2. The next has 3, and so on. 118
In CLARITY_ADT, I ADT 40 becomes?
SEQ_NUM_IN_ENC
True or False (Video) does creating a pre-admission or an expected arrival create an ADT event?
It does not create an ADT event. ADT records generated once the patient gets a bed. Access day 2 part 9 @ 15:15-15:18
True or False:Preadmissions and expected arrivals are EPT contacts and ADT events?
False, only once the patient is admitted or an HOV begins that the system creates an ADT event. 118
When is it that the system creates an ADT event?
It is only once the patient is admitted or an HOV begins that they system creates an ADT event.118
True or false, every night the system generates a census event?
True, every night your system generates a census event (or leave of absence versus event) for every bed. The system checks whether a patient is in the bed at the time of the census.118
What does it mean for the EPT ID to be null?
The census event represents a bed that was empty at the time of the census.118
True or False: Census events do not occur for all beds?
False, census events occur for all beds, not just those set up to be part of your census.
How can you determine if you want to include a bed in a report?
To determine whether to include a bed, find the bed record and filter on I Bed 110 (Clarity_bed.census_inclusn_YN in clarity and departmentDim.BedInCensus in caboodle. 118
What does HOVs mean?
Hospital outpatient Visits. 118
Why are HOV events created?
HOV events are created to track outpatient visits to the hospital, like visits to physical therapy on an outpatient basis.
True or False: HOV’s are manually discharged?
False, these patients are not typically manually discharged when they leave the hospital instead, a nightly process discharges all HOV patients at the end of the day. 118
True or False: HOV’s do not have a discharge event?
False, HOV’s have discharge ADT events. 118
Why would I want to exclude discharges with empty rooms or beds when creating an activity or census report
Because HOV patients are discharged at the end of the day, the room and Bed ID’s are empty for those events because HOV visits are assign a unit but not a room or bed. Therefore, you might want to exclude discharges with empty rooms or beds when creating activity or census reports. 118
True or False, HOV’s do not have discharge ADT events?
False 118
True or False, are there times where a patient physically departs a bed?
True, but the bed remains assigned to the patient 118
When there is a patient with an HOV event, why is the room empty and bed ID empty?
The room and bed ID are empty for these events because HOV visits are assigned a unit but not a room or bed. 118
When creating a census report of rooms or beds, why would you want to exclude discharges?
because the room and Bed IDs would be empty because of HOV visits. 118
There are times where a patient physically departs a bed, but the bed remains assigned to the patient, what are the reasons and how does the system represent this?
Some reasons such a scenario may arise include a patient temporarily going home for a week from a long-term acute care facility or a patient in a rehabilitation unit having an acute event and being temporarily treated in the ED. The system represents these situations with a leave of absence (LOA) events.119
If a patient has a leave of absence, they system generates what?
The system represents these situations with leave of absence (LOA) events. The patient’s departure generates an LOA Out event, and the patient’s return generates an LOA Return event. If the patient’s leave of absence extends over a census, the system generates an LOA Census event.119
What happens if the patient is out on leave and will not be returning?
if a patient that is currently out on leave will not be returning, then the LOA out event is converted into a discharge event. Similarly, if a patient is discharged from a unit that supports LOAs but then returns, the discharge can be converted into the appropriate LOA events. 118
What is a PND record?
While the patient is on the leave of absence, the system holds the bed for the patient with a PND record. 119
When you edit event information, what happens with the original event?
When you edit event information, the original event is marked as canceled, and a new event is created to store the updated information. 121
What does ADT 35 represent?
Grand central uses ADT 35 to represent the update status of an ADT record. For a given record, it may store one of 3 possible values. 1 original, 2 canceled, 3 update. 121
In event subtypes, what do original, canceled, update mean?
Original: This event has not been modified
Canceled: This event has been undone.
Update: The event has been modified. 121
(Video) What filter would I want to include in most of my queries so that we are only including the valid data?
Subtype should not equal 2 because we do not want the canceled subtypes. We are generally including this in every single report we want. The SQL filter is Event_Subtype_C <> 2 or Event_Subtype_C In (1,3) Access Day 2 part 10 @ 9:50-10:40 121
What is ADT 35 in clarity?
The Clarity_ADT column is Event_Subtype_C 122
What does item ADT 92 do?
You may be interested to find the original event in a series of updated events. It is possible to do so by following the path formed by ADT 92 until you find an event that does not populated ADT 92. That event would be the original. 123
If I wanted to ind the original event, what would I do?
There are no ADT items that points directly to the original event. However, there is a clarity column that accomplishes this task: Clarity_ADT.Original_Event_Id 123
What does the clarity_ADT table consist of?
Every row in Clarity_ADt will store the ID of the original event o their series in this column, including the original event. Original events store their own record ID in this column/. 123
True or False: in the Clarity_ADT table the record ID stores the original event?
True 123
What does ADT item 59 do and the clarity column name?
The concept is the actual time the event occurred in real life and it is effective_time.124
Which of ADT 59 and 64 has the meaning of when the event occurred?
That would be Effective_Time ADT 59. This column is when the event occurred in real time.124
There is no ADT item that points directly to the original event. However, there is a Clarity column that accomplishes this task, what is it?
CLARITY_ADT.ORIGINAL_EVENT_ID. Every row in CLARITY_ADT will store the ID of the original event of their series in this column, including the original event. Original events store their own record ID in this column. 123
True or False: ADT 64 is when the event occurred in real life?
False, that is ADT item 59. ADT 64 is event_Time and the meaning behind that is when did the system save the event. 124
What does ADT 64 do and what is the clarity column name?
The concept is the time the event was created and the column name is event_time.124
What does item 90 do and the clarity column name?
The concept is the time the event was canceled or replaced by another event and the column name is delete_time. 124
What does ADT 1010 do and the clarity column name?
The time when the original su type record for this event was actually created and its name is PRIG_Event_time 124
If all you need is to know the location of a patient without knowing the preceding or following location what would you use?
PatientLocationEventFact in Caboodle 126
What does each row in the caboodle table, PatientLocationEventFact represent?
Each row represents a patient’s location for a given period of time. 126
What does the PatientLocationEventFact table include?
The PatientLocationEventFact table includes information from the ADT events and patient location updates, which are described in the patient location data section. 126
What do the StartInstant and EndInstant columns indicate in the PatientLocationEventFact table?
the StartInstant and EndInstant columns indicate the entry and exit of the patient from a bed. if you want to find a patient’s location for a given instant, filter these 2 columns.126
IF I want to find a patient’s location for a given instant, how would I filter this?
PatientLocationEventFact.StartInstant <= instant of interest and (PatientLocationEventFact.EndInstant >=
instant of interest OR PatientLocationEventFact.EndInstant IS NULL )
126
A patient’s bed location can change several times during a single hospital encounter. You may be ask to report on the bed a patient was assigned at a given point in time. What table can accomplish this?
V_PAT_ADT_LOCATION_HX can be used for this purpose. It returns one row for each admission, transfer in, or leave of absence return ADT event and contains columns for in and out times. 126
What is the granularity of the V_PAT_ADT_LOCATION_HX table?
It returns one row for each admission, transfer in, or leave of absence return ADT event and contains columns for in and out times. 126
What do the IN_DTTM and OUT_DTTM columns indicate?
The entry and exit of the patient from a bed. 126
If I want to find a patients location for a given instant, what would I do?
Filter like this
V_PAT_ADT_LOCATION_HX.IN_DTTM <= instant of interest and V_PAT_ADT_LOCATION_HX.OUT_DTTM >=
instant of interest 126
What does the V_Pat_ADT_Location_HX.Event_ID measure?
The unique ID number of the ADT event record. 126
What does the V_Pat_ADT_Location_HX.IN_DTTM measure?
The Instant when the patient was moved to the department/Room/Bed 126
What does the V_Pat_ADT_Location_HX.OUT_DTTM measure?
The instant when the patient was moved out of the department/Room/bed. If the patient is still in the department/room/bed, this column will return the current instant. The column PAT_OUT_DTTM will return the instant when the patient was moved out of the department /room/bed, but will return nothing if the patient is still in the department/room/bed. 126
