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:
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
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:
MyChart Study Finder
Pre-Login Interest Submission
28 | CREATION_COMM_ID | NUMERIC | No |
The unique ID of the CRM case that resulted in the creation of the study association record.