|
Name |
Type |
Discontinued? |
|
1 |
ENROLL_ID |
NUMERIC |
No |
|
|
|
The unique ID of the patient enrollment record for this row. This column is frequently used to link to the ENROLL_INFO table. |
|
|
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 |
PAT_CSN |
NUMERIC |
No |
|
|
|
The unique contact serial number (CSN) for patient encounters linked to this enrollment. These numbers are unique across all patient encounters in your system. If you use IntraConnect this is the Unique Contact Identifier (UCI). |
|
|
4 |
PROTOCOL_CSN |
NUMERIC |
No |
|
|
|
The unique contact serial number (CSN) for protocols linked to this encounter. These numbers are unique across all protocol contacts in your system. If you use IntraConnect this is the Unique Contact Identifier (UCI). |
|
|
5 |
LINKED_UNIQ_DAY_NUM |
INTEGER |
No |
|
|
|
The timeline day ID for the timeline instantiation of a protocol. Once a protocol is assigned to a patient, any repeating cycles and treatment days defined in the protocol are expanded out into individual cycles and cycles in the timeline. This day ID is a unique value for the protocol contact serial number (CSN) assigned to the timeline and can be linked back to the original protocol through the CL_PRL_DAY_MAP table. |
|
|
6 |
TREATMENT_PLAN_CSN |
NUMERIC |
No |
|
|
|
The clinical treatment plan linked to the encounter. |
|
|
7 |
TREATMENT_DAY_CSN |
NUMERIC |
No |
|
|
|
The clinical treatment day linked to the encounter. This column may be linked to TRG_UPDATE_INFO.CONTACT_SERIAL_NUM. |
|
|
8 |
LINK_ENCOUNTER_USER_ID |
VARCHAR |
No |
|
|
|
The user who linked or unlinked an encounter to a study. |
|
|
9 |
LINK_ENCOUNTER_USER_ID_NAME |
VARCHAR |
No |
|
|
|
The name of the user record. This name may be hidden. |
|
|
10 |
LINK_ENCOUNTER_DTTM |
DATETIME (UTC) |
No |
|
|
|
UTC formatted instant when user links or unlinks an encounter to a study. |
|
|
11 |
TREATMENT_DAY_LINE |
INTEGER |
No |
|
|
|
The line number of the treatment day in the treatment plan that this encounter is linked to. |
|
|