COMM_PREF_ADDL_ITEMS
Description:
This table contains items related to Patient Communication Preferences.

Primary Key
Column Name Ordinal Position
PREFERENCES_ID 1

Column Information
Name Type Discontinued?
1 PREFERENCES_ID NUMERIC No
The unique identifier (.1 item) for the subject name record.
2 APPT_REMDR_OFFSET_C_NAME VARCHAR No
This column stores the offset of time prior to the appointment time when the system should send out a quick reminder.
May contain organization-specific values: No
Category Entries:
1 hour
2 hours
3 hours
4 hours
5 hours
6 hours
7 hours
8 hours
9 hours
10 hours
11 hours
0.5 days
1 day
2 days
3 APPT_NOTIF_SCHEDULED_YN VARCHAR No
This item stores a Yes No category value indicating whether the patient accepts Cadence Scheduled Appointment Notifications.
May contain organization-specific values: No
Category Entries:
Yes
No
4 APPT_NOTIF_CHANGED_YN VARCHAR No
This item stores a Yes No category value indicating whether the patient accepts Cadence Changed Appointment Notifications.
The category values for this column were already listed for column: APPT_NOTIF_SCHEDULED_YN
5 APPT_NOTIF_CANCELED_YN VARCHAR No
This item stores a Yes No category value indicating whether the patient accepts Cadence Cancelled Appointment Notifications.
The category values for this column were already listed for column: APPT_NOTIF_SCHEDULED_YN
6 APPT_NOTIF_MISSED_YN VARCHAR No
This item stores a Yes No category value indicating whether or not a patient accepts Cadence Missed Appointment Notifications.
The category values for this column were already listed for column: APPT_NOTIF_SCHEDULED_YN
7 USE_DAILY_DIGEST_YN VARCHAR No
Indicates whether a user wants to receive To Do task notifications only once daily.
May contain organization-specific values: No
Category Entries:
No
Yes
8 DAILY_DIGEST_TM DATETIME (UTC) No
The time at which the user wants to receive once daily To Do task reminder notifications.
9 AUTO_ADD_TO_WAITLIST_YN VARCHAR No
Indicates whether an appointment will be automatically added to the Wait List upon scheduling based on the patient preference. 'Y' indicates that the appointment is auto-added when scheduling if the DEP/SDF settings allow for it. 'N' or NULL indicate that the appointment will not be auto-added.
The category values for this column were already listed for column: APPT_NOTIF_SCHEDULED_YN
10 RSLT_DAILY_DIGEST_YN VARCHAR No
This item stores whether the user has signed up to receive a Daily Digest tickler for test results.
The category values for this column were already listed for column: APPT_NOTIF_SCHEDULED_YN