ENROLL_INFO
Description:
The ENROLL_INFO table contains information about patient enrollments in research studies, including status, alias, start and end dates, and last modified user and instant.

Primary Key
Column Name Ordinal Position
ENROLL_ID 1

Column Information
Name Type Discontinued?
1 ENROLL_ID NUMERIC No
The unique ID of the patient-study association record for this row. This column is frequently used to link to the ENROLL_INFO table.
2 RECORD_STATUS_C_NAME VARCHAR No
The record status, such as hidden or soft-deleted.
May contain organization-specific values: No
Category Entries:
Soft Deleted
Hidden
Hidden and Soft Deleted
3 RESEARCH_STUDY_ID_RESEARCH_STUDY_NAME VARCHAR No
The name of the research study record.
4 PAT_ID VARCHAR No
Unique ID of the associated Patient record.
5 ENROLL_STATUS_C_NAME VARCHAR No
Status category number of the patient's enrollment in the study.
May contain organization-specific values: Yes
Category Entries:
Identified
In Review
In Screening
Enrolled
Active Participant
In Follow-Up
In Long-Term Follow-Up
Completed
Withdrawn
Ineligible
Declined
Lost to Follow-Up
Recruitment Recalled
Bio-repository Specimen Collected
Enrolled on Registry
6 STUDY_ALIAS VARCHAR No
Patient's alias for the study enrollment.
7 ENROLL_START_DT DATETIME No
Start date of the patient's enrollment in the study.
8 ENROLL_END_DT DATETIME No
End date of the patient's enrollment in the study.
9 ENROLL_CMT_NOTE_ID VARCHAR No
The ID number for comments/notes associated with the enrollment.
10 LAST_MOD_DTTM DATETIME (Attached) No
Instant the enrollment information was last modified.
11 LAST_MOD_USER_ID VARCHAR No
User who modified the enrollment information last.
12 LAST_MOD_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
13 STUDY_BRANCH_ID VARCHAR No
For a patient enrolled in a research study that has multiple branches (or arms), this item stores the ID of the specific branch of that study to which the patient is assigned.
14 MYC_APPROVING_EMP_ID VARCHAR No
Either the user who was asked to approve this MyChart recruitment request if it is still awaiting approval, or the one who did approve or decline the request.
15 MYC_APPROVING_EMP_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
16 ADVERSE_EVENT_REVIEW_UTC_DTTM DATETIME (UTC) No
The date and time of last review for the adverse events for this study association.
17 ADVERSE_EVENT_REVIEW_USER_ID VARCHAR No
The unique ID of the last reviewing user for the adverse events for this study association.
18 ADVERSE_EVENT_REVIEW_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
19 RECRUITMENT_QUESR_ANSWER_ID VARCHAR No
The unique identifier of the recruitment questionnaire answers for this study association.
20 MYC_RESPONSE_TYPE_C_NAME VARCHAR No
The MyChart response type category ID for the enrollment.
May contain organization-specific values: No
Category Entries:
Positive
Negative
Unknown
21 FIRST_INVITATION_SENT_YN VARCHAR No
Indicates whether the patient has ever received a research study invitation for this patient-study association. 'Y' indicates that the patient has received a research study invitation for this patient-study association. 'N' or NULL indicate that the patient has not received a research study invitation for this patient-study association.
May contain organization-specific values: No
Category Entries:
No
Yes
22 FIRST_INVITE_LAST_MOD_SOURCE_C_NAME VARCHAR No
The modification source category ID of the source from which the first research study invitation was sent for this patient-study association.
May contain organization-specific values: No
Category Entries:
Action in Research Studies Activity
Action in Reporting Workbench
Datalink Action
Interface
Import
OurPractice Advisory
Programming Extension
User in MyChart
In Basket Action
Conversion
FHIR
Action in Research Study Maintenance
Cosmos Teleport
Unlink
Automated Utility
SlicerDicer Action
Recruitment Campaign
User in MyChart Study Finder
Patient Merge
CRM
Study Eligibility Analysis
CTMS Upgrade
23 FIRST_INVITATION_SENT_UTC_DTTM DATETIME (UTC) No
The UTC instant at which the first research study invitation was sent for this patient-study invitation.
24 LAST_DEMO_AUTH_TOKEN VARCHAR No
The last demographic authentication token that was generated for this patient-study association.
25 OPA_MANUAL_OUTREACH_UTC_DTTM DATETIME (UTC) No
The UTC instant at which the first manual OPA outreach was performed for this patient-study association.
26 OPA_AUTO_OUTREACH_UTC_DTTM DATETIME (UTC) No
The UTC instant at which the first automatic OPA outreach was performed for this patient-study association.
27 PAT_INITIATED_INTEREST_C_NAME VARCHAR No
The patient-initiated interest category ID for the enrollment.
May contain organization-specific values: No
Category Entries:
Post-Login MyChart Study Finder
Pre-Login MyChart Study Finder
28 CREATION_COMM_ID NUMERIC No
The unique ID of the CRM case that resulted in the creation of the study association record.
29 SCREENING_STATUS_C_NAME NUMERIC No
The screening status of the patient-study association.
May contain organization-specific values: No
Category Entries:
Ineligible
Prescreening Eligible
Eligible
Screen Fail
30 INTERESTED_C_NAME NUMERIC No
The interest status category ID for the patient-study association.
May contain organization-specific values: No
Category Entries:
Yes
Undecided
No
31 EXTERNAL_STUDY_SITE_ID_LOC_NAME VARCHAR No
The name of the revenue location.
32 ABBR_PROSPECT_ID NUMERIC No
The unique ID of the research study participant the study association is for.
33 PRE_ENROLL_CONSENT_STATUS_C_NAME NUMERIC No
Category ID indicating where a participant stands in the consenting process before enrollment on the research study.
May contain organization-specific values: No
Category Entries:
Not Consented
Consented for Initial Enrollment
Consented for Screening
Consent Waived
34 LAR_TREATMENT_STATUS_C_NAME NUMERIC No
Category ID indicating whether a participant is currently receiving, paused on, or finished with the study treatment within a research study.
May contain organization-specific values: No
Category Entries:
Not Started
On Treatment
Paused
Off Treatment
On Follow-Up Treatment
35 OFF_STUDY_REASON_C_NAME NUMERIC No
Category ID which captures why a participant is no longer enrolled in the research study.
May contain organization-specific values: No
Category Entries:
No Longer Eligible
Adverse Event
Protocol Deviation
Participant Decision
Deceased
Study Terminated
Added in Error
Investigator Decision
Survivorship