ENROLL_LINKED_CSN2

Description: |
The ENROLL_LINKED_CSN2 table identifies encounters, using Contact Serial Numbers (CSN), linked to a patient's enrollment in a research study. Unlike ENROLL_LINKED_REPL, this table includes any associated protocols, day numbers, treatment plans, and treatment days with the CSN as well.
The ENROLL_LINKED_CSN view should be used instead of directly linking to this table. The actual data used by this view may be split between the ENROLL_LINKED_REPL or the ENROLL_LINKED_CSN2 tables. The ENROLL_LINKED_CSN view combines the data from both tables regardless of how the underlying data may be shifting between the two tables.

Primary Key

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

Column Information

| 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.
12 | LINK_ENC_SOURCE_C_NAME | VARCHAR | No |
Contains how this encounter got linked to this enrollment. Blank is an unspecified process (before the data was collected)
May contain organization-specific values: No
Category Entries:
Manual Action
Automatic Action
Signing Order
Releasing Child Order
Data Conversion