PAT_EPISODE

Description: |
The PAT_EPISODE table links patient ID numbers to Episodes of Care records. This is especially helpful for connecting patients to episodes of care when there are no linked encounters on an episode record. When this is the case, the PAT_ID column in the EPISODE table may be null.

Primary Key

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

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | PAT_ID | VARCHAR | No |
The unique ID assigned to the patient record. This ID may be encrypted if you have elected to use enterprise reporting’s encryption utility.
2 | LINE | INTEGER | No |
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 | EPISODE_ID | NUMERIC | No |
The unique ID number associated with an Episode of Care.