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.