IP_EPISODE_LINK

Description: |
The episode table for Inpatient episodes. This is used as a substitute for the EPISODE and EPISODE_LINK tables.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
EPISODE_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | EPISODE_ID | NUMERIC | No |
The unique ID of the episode of care record.
2 | LINE | INTEGER | No |
This identifies the encounter within the episode.
3 | SUM_BLK_TYPE_ID_EPISODE_DEF_NAME | VARCHAR | No |
This column displays the name of the episode / block definition record.
4 | PAT_ENC_CSN_ID | NUMERIC | No |
A unique serial number for this encounter. This number is unique across all patients and encounters in the system.
5 | INP_CSN | NUMERIC | No |
A unique serial number for this Inpatient Data (INP) record.
6 | INPATIENT_DATA_ID | VARCHAR | No |
A unique ID assigned to the Inpatient Data (INP) record
7 | START_DATE | DATETIME | No |
The date the episode was initiated in calendar format. This field is called Noted on the clinical system screen.
8 | END_DATE | DATETIME | No |
The date the episode was resolved in calendar format. This field is called Resolved on the clinical system screen.
9 | CARE_INTG_ID | VARCHAR | No |
The unique ID for the inpatient care integrator record.
10 | STATUS_C_NAME | VARCHAR | No |
The status of the episode record: i.e. Active, Resolved, or Deleted.
May contain organization-specific values: No
Category Entries:
Active
Resolved
Deleted
11 | EPISODE_NAME | VARCHAR | No |
The name of the episode.