RSH_INVITATIONS
Description:
This table contains details about every research study invitation that was sent for a patient-study association.

Primary Key
Column Name Ordinal Position
ENROLL_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 ENROLL_ID NUMERIC No
The unique identifier (.1 item) for the enrollment record.
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 INVITATION_USER_ID VARCHAR No
The unique ID of the user that sent the research study invitation.
4 INVITATION_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
5 INVITATION_LAST_MOD_SOURCE_C_NAME VARCHAR No
The modification source category ID for the research study invitation.
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
6 INVITATION_UTC_DTTM DATETIME (UTC) No
The UTC instant at which the research study invitation was sent.
7 INVITATION_DTTM DATETIME (Attached) No
The local instant at which the research study invitation was sent.
8 INVITATION_SENT_YN VARCHAR No
Indicates whether the research study invitation was successfully sent to one or more recipients. 'Y' indicates that the invitation was successfully sent. 'N' or NULL indicates that the invitation was not successfully sent.
May contain organization-specific values: No
Category Entries:
No
Yes
9 INVITATION_TICKLER_SENT_YN VARCHAR No
Indicates whether any ticklers were sent for this research study invitation. 'Y' indicates that one or more ticklers were sent for the invitation. 'N' or NULL indicate that no ticklers were sent for the invitation.
The category values for this column were already listed for column: INVITATION_SENT_YN
10 INVITATION_MYC_RESPONSE_TYPE_C_NAME VARCHAR No
The response type to the research study invitation.
May contain organization-specific values: No
Category Entries:
Positive
Negative
Unknown
11 INVITATION_RESPONSE_UTC_DTTM DATETIME (UTC) No
The UTC instant that the research study invitation was responded to.
12 INVITATION_RESPONSE_MYPT_ID VARCHAR No
The unique ID of the MyChart user that responded to the research study invitation.
13 INVITE_RETRACT_UTC_DTTM DATETIME (UTC) No
The UTC instant at which the research study invitation was retracted.
14 INVITATION_OUTREACH_CSN_ID NUMERIC No
The unique contact serial number of the outreach contact that is associated with the invitation.