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
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:
Research Studies Activity
Reporting Workbench
Datalink
Interface
Import
OurPractice Advisory
Programming Extension
MyChart
In Basket
Conversion
FHIR
Research Study Maintenance
Cosmos Teleport
Unlink
Automated Utility
SlicerDicer
Recruitment Campaign
Patient Merge
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.