ENROLL_TIMELINE

Description: |
The ENROLL_TIMELINE table extracts the patient's assigned protocols, cycle, days, and date ranges. The dates are used to capture the patient's progress through the research protocol.

Primary Key

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

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | ENROLL_ID | NUMERIC | No |
This column stores the unique identifier for the patient enrollment record. 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 | PROTOCOL_CSN | NUMERIC | No |
The unique contact serial number 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).
4 | UNIQ_CYCLE_NUM | INTEGER | No |
This column stores the unique cycle number that is generated after applying a protocol to a patient timeline and expanding all of the repeating cycles and days within the protocol. This number can be mapped back to the original protocol source cycle by linking to CL_PRL_DAY_MAP. In order to determine the appropriate contact to use, ENROLL_TIMELINE.PROTOCOL_contact serial number (CSN) should be used to link to CL_PRL_SS_OT.CONTACT_SERIAL_NUM.
5 | UNIQ_DAY_NUM | INTEGER | No |
This column stores the unique cycle number that is generated after applying a protocol to a patient timeline and expanding all of the repeating cycles and days within the protocol. This number can be mapped back to the original protocol source day by linking to CL_PRL_DAY_MAP. In order to determine the appropriate contact to use, ENROLL_TIMELINE.PROTOCOL_contact serial number (CSN) should be used to link to CL_PRL_SS_OT.CONTACT_SERIAL_NUM.
6 | EXPECT_FROM_DATE | DATETIME | No |
For the timeline treatment day, this is start of the date range of when the day is expected to take place.
7 | EXPECT_TO_DATE | DATETIME | No |
For the timeline treatment day, this is end of the date range of when the day is expected to take place.