IP_HANDOFF
Description:
The table contains information of a handoff field.

Primary Key
Column Name Ordinal Position
HANDOFF_ID 1

Column Information
Name Type Discontinued?
1 HANDOFF_ID NUMERIC No
The unique identifier (.1 item) for the handoff data record.
2 PAT_CSN_ID NUMERIC No
The contact serial number (CSN) of the patient contact on which the Handoff was written.
3 SERVICE_C_NAME VARCHAR No
The service of the handoff field.
May contain organization-specific values: Yes
4 PURPOSE_C_NAME VARCHAR No
This item defines the purpose of the handoff field.
May contain organization-specific values: Yes
Category Entries:
Summary
To Do
Medications
Labs
Imaging
5 INSTANT_OF_UPDATE_DTTM DATETIME (Local) No
This item stores the instant the record was last locked/unlocked.
6 PREVIOUS_HANDOFF_ID NUMERIC No
When Handoff is edited 100+ times in a day, a new SOD record is created, and this item is used to link back to the original/previous SOD record.