HOLOGRAM_DETAILS
Description:
This table stores workflow-level information about documentation pieces that have been queued up and suspended during an outpatient visit.

Primary Key
Column Name Ordinal Position
HOLOGRAM_ID 1

Column Information
Name Type Discontinued?
1 HOLOGRAM_ID NUMERIC No
The unique identifier (.1 item) for the hologram record.
2 PAT_ID VARCHAR No
The unique ID of the patient record for this hologram. This column is frequently used to link to the PATIENT table.
3 PAT_ENC_CSN_ID NUMERIC No
The unique contact serial number for this contact. This number is unique across all patient encounters in your system. If you use IntraConnect, this is the Unique Contact Identifier (UCI).
4 HOLOGRAM_STATUS_C_NAME VARCHAR No
The status category ID for selections in this hologram workflow.
May contain organization-specific values: Yes
Category Entries:
Pended
Restored
Discarded
5 WORKFLOW_USER_ID VARCHAR No
The unique ID associated with the user who performed this workflow. This column is frequently used to link to the CLARITY_EMP table.
6 WORKFLOW_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
7 WORKFLOW_PROV_ID_PROV_NAME VARCHAR No
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
8 WORKFLOW_INST_UTC_DTTM DATETIME (UTC) No
The date and time when this hologram's status was set, in UTC.