HH_VO_INFO
Description:
Contains Home Health verbal orders noadd single items information.

Primary Key
Column Name Ordinal Position
VERBAL_ORDER_ID 1

Column Information
Name Type Discontinued?
1 VERBAL_ORDER_ID VARCHAR No
The unique identifier for the verbal order record.
2 ORDER_DATE DATETIME No
Local date for home care order. Since this a local date, it will not always match the date in ORDER_INSTANT_UTC_DTTM.
3 PROVIDER_ID VARCHAR No
Unique identifier for the provider who is the referring provider for the verbal order. Links to table REFERRAL_SOURCE. The unique ID associated with the provider record for this row. This column is frequently used to link to the REFERRAL_SOURCE table.
4 PROVIDER_ID_REFERRING_PROV_NAM VARCHAR No
The name of the referral source.
5 USER_RECEIVED_ID VARCHAR No
User ID of the verbal order receiving user. Links to table CLARITY_EMP.
6 USER_RECEIVED_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
7 CREATE_DATE DATETIME No
Date on which the verbal order was created.
8 PATIENT_ID VARCHAR No
Patient ID of the patient for whom the verbal order is created. Links to table PATIENT.
9 STATUS_C_NAME VARCHAR No
Verbal order status. Includes: not submitted, submitted, signed, sent, responded. Links to category table ZC_LVO_STATUS.
May contain organization-specific values: No
Category Entries:
Not Submitted
Submitted
Signed
Sent
Responded
Entered
Resubmitted
Waiting for Review
Retracted
Canceled
10 POC_CSN_ID NUMERIC No
The unique contact serial number of the patient associated with the hospice plan of care that generated the order.
11 PLAN_OF_CARE_ID NUMERIC No
This item contains the hospice plan of care ID associated with this verbal order.
12 COSIGN_PROVIDER_ID VARCHAR No
This item stores the cosign provider.
13 COSIGN_PROVIDER_ID_REFERRING_PROV_NAM VARCHAR No
The name of the referral source.
14 IS_COSIGN INTEGER No
This item contains whether the verbal order has been cosigned.
15 ORDER_MODE_C_NAME VARCHAR No
This item indicates how the order was communicated. This helps distinguish between orders sent in by the physician unsolicited, orders communicated verbally from the physician to the clinician, and orders sent to the physician by the clinician without prior verbal communication.
May contain organization-specific values: Yes
Category Entries:
Verbal
Physician Initiated
Clinician Initiated
Automatically Created
16 AUTH_LAST_EVENT_C_NAME VARCHAR No
The last event for the authorizing provider (in HH_VO_INFO.PROVIDER_ID). Use this column when an order is sent to multiple providers and to differentiate between orders that are signed electronically and manually.
May contain organization-specific values: Yes
Category Entries:
Submit
Received Signature
Sent
Replied With Changes
Printed
Faxed to Provider
Retract
Resent
Received Order
Admin Closed
Reviewed
Electronically Signed
Automatically Canceled
Waiting for Review
Failed Fax
POC Update Sent - No Signature Required
Removed Provider from Finalized POC
Sent via Care Everywhere
Updated via Care Everywhere
Retracted via Care Everywhere
Care Everywhere Submission Failed
Document Linked
Document Unlinked
17 PHY_CERT_CHARGE_ID VARCHAR No
The unique ID of the physician certification or recertification charge.
18 AUTO_CREATION_SRC_C_NAME VARCHAR No
This item stores how the home care order was automatically created.
May contain organization-specific values: No
Category Entries:
Created at sync
Created when HH POC was sent
Created by utility
Created by Rover DME
Created by Mobile Orders
19 ORDER_INSTANT_UTC_DTTM DATETIME (UTC) No
UTC date and time at which a home care order was placed. For orders created before we captured order time explicitly, the time saved here is equivalent to midnight local time.
20 FACE_TO_FACE_ENC_DATE DATETIME No
This item stores the encounter date for Face to Face orders. It is not used for other order types.
21 CODE_STATUS_C_NAME VARCHAR No
Document the type of code status this order placed (Full Code, DNR, etc.).
May contain organization-specific values: Yes
Category Entries:
<Disabled>
Full Code
DNR
Partial Code
22 PLAN_OF_CARE_CSN_ID NUMERIC No
The unique contact serial number of the hospice plan of care that generated the order. This is used to identify the version of the plan that was sent with the order.
23 RECORD_STATUS_2_C_NAME VARCHAR No
Record status flag. Used in conjunction with record archived flag for encounter archiving.
May contain organization-specific values: No
Category Entries:
Soft Deleted
Hidden
Hidden and Soft Deleted