|
Name |
Type |
Discontinued? |
|
1 |
PAT_RELATIONSHIP_ID |
NUMERIC |
No |
|
|
|
The unique identifier for the patient contact record. |
|
|
2 |
GROUP_LINE |
INTEGER |
No |
|
|
|
The line number of the episode information in the patient contact. Together with PAT_RELATIONSHIP_ID, this forms the foreign key to the PAT_REL_INFO_EPSD and the PAT_REL_NOTES_EPSD tables. |
|
|
3 |
VALUE_LINE |
INTEGER |
No |
|
|
|
The line number of one of multiple notes associated with the patient contact and episode from the PAT_REL_INFO_EPSD table. |
|
|
4 |
EPSD_NOTE_ID |
VARCHAR |
No |
|
|
|
The unique ID of episode-level note for a patient contact. |
|
|