ED_IEV_PAT_INFO

Description: |
This table contains information that is useful for linking records (patient, department, etc.) to their appropriate events.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
EVENT_ID | 1 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | EVENT_ID | VARCHAR | No |
The unique ID of the event record. This column is frequently used to link to the ED_IEV_EVENT_INFO table.
2 | PAT_ID | VARCHAR | No |
The unique ID of the patient record for this line. This column is frequently used to link to the PATIENT table.
3 | ITEMS_EDITED_TIME | DATETIME | No |
The date and time when this event record was last edited.
4 | UPDATE_DATE | DATETIME (Local) | No |
The last date and time the event record was extracted.
5 | PAT_DATE_REAL | FLOAT | No |
A unique, internal contact date in decimal format. The integer portion of the number indicates the date of the contact. The digits after the decimal distinguish different contacts on the same date and are unique for each contact on that date. For example, .00 is the first/only contact, .01 is the second contact, etc.
6 | DTE_EXTERNAL | DATETIME | No |
The date of this contact in calendar format.
7 | PAT_ENC_CSN_ID | NUMERIC | No |
The unique contact serial number for this contact. This number is unique across patients and encounters in your system. If you use IntraConnect this is the Unique Contact Identifier (UCI).
8 | PAT_ENC_DATE_REAL | FLOAT | No |
A unique, internal patient contact date in decimal format. The integer portion of the number indicates the date of the contact. The digits after the decimal distinguish different contacts on the same date and are unique for each contact on that date. For example, .00 is the first/only contact, .01 is the second contact, etc.
9 | CONTACT_DATE | DATETIME | No |
The date of this contact in calendar format.
10 | DEPT_EVENT_DEP_ID_EXTERNAL_NAME | VARCHAR | No |
The external name of the department record. This is often used in patient correspondence such as reminder letters.
11 | RECORD_STATE_C_NAME | VARCHAR | No |
The record state category number for the event record. Link this column to the ZC_PBA_REC_STAT table to look up the corresponding record state values.
May contain organization-specific values: No
Category Entries:
Active
Inactive
Deleted
Inactive and Deleted
Hidden
Inactive and Hidden
Deleted and Hidden
Inactive Deleted and Hidden
12 | TRANSFER_STATUS_C_NAME | VARCHAR | No |
The transfer status category number for medication reconciliation events.
May contain organization-specific values: No
Category Entries:
Active
Canceled
Completed
13 | CREATE_DTTM | DATETIME (Local) | No |
The instant when the event record was created.
14 | CREATE_USER_ID | VARCHAR | No |
The unique ID of the user who created the event record.
15 | CREATE_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
16 | EVENT_DATE | DATETIME | No |
The date the event record was created.
17 | PAT_CSN | NUMERIC | No |
The unique contact serial number for this contact. This number is unique across patients and encounters in your system. If you use IntraConnect this is the Unique Contact Identifier (UCI).
18 | ADT_TRANSFER_LINK | INTEGER | No |
Virtual item for the Admission, Transfer, Discharge, or Leave of Absence (ADT) event link for a medication reconciliation transfer.
19 | REG_CLIP_FREETEXT | VARCHAR | No |
User-entered patient name for patient added to clipboard. User-entered text is necessary for users without security to select real patients or for new patients.
20 | REG_CLIP_COMMENTS | VARCHAR | No |
Comments for the patient added to the Patients Waiting Registration Clipboard
21 | IP_ORDREC_SORT_DTTM | DATETIME (Local) | No |
This is the instant that all the orders in the event should be sorted by, instead of using their individual ordering session keys or ordering instants.
22 | REG_WAIT_STATE_C_NAME | VARCHAR | No |
Holds the state of the record that holds Registration wait list info.
May contain organization-specific values: No
Category Entries:
Unidentified Patient
Identified Patient
Identified Encounter
Removed
23 | REG_WAIT_PAT_NAME | VARCHAR | No |
Holds the user-entered patient name for a patient who is waiting but has not yet been identified.
24 | REG_WAIT_IS_PRI_YN | VARCHAR | No |
Holds the priority value for a patient who is waiting to be registered.
May contain organization-specific values: No
Category Entries:
Yes
No
25 | REG_WAIT_ARRV_DTTM | DATETIME (Local) | No |
Holds the earliest event instant, which will indicate the time the patient arrived for the encounter this event list is associated with.
26 | AVS_COPY_FORWARD_DTTM | DATETIME (UTC) | No |
The date and time that a user copied After Visit Summary documentation from another encounter into this one.
27 | AVS_COPY_FORWARD_USER_ID | VARCHAR | No |
The unique ID of the user who copied After Visit Summary documentation from another encounter into this one.
28 | AVS_COPY_FORWARD_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.