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 (Local) No
The time at which the user wants to receive once daily To Do task reminder notifications. If the time zone column is populated, then the time is in that time zone. Otherwise, it is in UTC.
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
11 DAILY_DIGEST_TIME_ZONE_C_NAME VARCHAR No
The time zone of the time which the user wants to receive once daily To Do task reminder notifications.
May contain organization-specific values: No
Category Entries:
Africa/Johannesburg
America/Anchorage
America/Halifax
America/Puerto_Rico
America/Chicago
America/Regina
America/New_York
AMERICA/EASTERN_NO_DST
Pacific/Honolulu
America/Denver
America/Phoenix
America/Los_Angeles
ETC/UNIVERSAL
Europe/Amsterdam
AMERICA/PACIFIC_NO_DST
America/St_Johns
Europe/London
Europe/Lisbon
Europe/Athens
Europe/Kaliningrad
Australia/Sydney
Australia/Brisbane
Australia/Lord_Howe
America/Sao_Paulo
America/Fortaleza
Africa/Cairo
Asia/Dubai
Africa/Abidjan
Africa/Accra
Africa/Addis_Ababa
Africa/Algiers
Africa/Asmara
Africa/Bamako
Africa/Bangui
Africa/Banjul
Africa/Blantyre
Africa/Brazzaville
Africa/Bujumbura
Africa/Casablanca
Africa/Conakry
Africa/Dakar
Africa/Dar_es_Salaam
Africa/Djibouti
Africa/Douala
Africa/Freetown
Africa/Gaborone
Africa/Harare
Africa/Juba
Africa/Kampala
Africa/Khartoum
Africa/Kigali
Africa/Kinshasa
Africa/Lagos
Africa/Libreville
Africa/Lome
Africa/Luanda
Africa/Lusaka
Africa/Maputo
Africa/Maseru
Africa/Mbabane
Africa/Nairobi
Africa/Ndjamena
Africa/Niamey
Africa/Nouakchott
Africa/Ouagadougou
Africa/Porto-Novo
Africa/Tripoli
Africa/Tunis
Africa/Windhoek
America/Argentina/Buenos_Aires
America/Asuncion
America/Barbados
America/Belize
America/Bogota
America/Caracas
America/Chihuahua
America/Costa_Rica
America/El_Salvador
America/Guatemala
America/Guayaquil
America/Guyana
America/Havana
America/Hermosillo
America/Jamaica
America/La_Paz
America/Lima
America/Managua
America/Mexico_City
America/Montevideo
America/Montreal
America/Nassau
America/Panama
America/Paramaribo
America/Port_of_Spain
America/Port-au-Prince
America/Recife
America/Santiago
America/Santo_Domingo
America/Tegucigalpa
America/Tijuana
Asia/Aden
Asia/Almaty
Asia/Amman
Asia/Ashgabat
Asia/Baghdad
Asia/Bahrain
Asia/Baku
Asia/Bangkok
Asia/Beirut
Asia/Bishkek
Asia/Chongqing
Asia/Colombo
Asia/Damascus
Asia/Dhaka
Asia/Dili
Asia/Dushanbe
Asia/Ho_Chi_Minh
Asia/Hong_Kong
Asia/Jakarta
Asia/Jerusalem
Asia/Kabul
Asia/Karachi
Asia/Kathmandu
Asia/Kolkata
Asia/Kuala_Lumpur
Asia/Kuwait
Asia/Manila
Asia/Muscat
Asia/Nicosia
Asia/Phnom_Penh
Asia/Qatar
Asia/Rangoon
Asia/Riyadh
Asia/Seoul
Asia/Shanghai
Asia/Singapore
Asia/Taipei
Asia/Tashkent
Asia/Tbilisi
Asia/Tokyo
Asia/Ulaanbaatar
Asia/Vientiane
Asia/Vladivostok
Asia/Yekaterinburg
Asia/Yerevan
Atlantic/Cape_Verde
Europe/Belgrade
Europe/Berlin
Europe/Brussels
Europe/Bucharest
Europe/Budapest
Europe/Chisinau
Europe/Copenhagen
Europe/Dublin
Europe/Helsinki
Europe/Istanbul
Europe/Kiev
Europe/Madrid
Europe/Malta
Europe/Minsk
Europe/Moscow
Europe/Oslo
Europe/Paris
Europe/Prague
Europe/Riga
Europe/Rome
Europe/Sofia
Europe/Stockholm
Europe/Tallinn
Europe/Tirane
Europe/Vienna
Europe/Vilnius
Europe/Warsaw
Europe/Zurich
Indian/Antananarivo
Indian/Mauritius
Pacific/Fiji
Pacific/Pohnpei
Africa/Monrovia
America/North_Dakota/Beulah
America/Bahia_Banderas
America/Goose_Bay
America/Araguaina
Atlantic/Reykjavik
Africa/Malabo
Europe/Sarajevo
Europe/Zagreb
Europe/Skopje
Europe/Podgorica
Europe/Bratislava
Europe/Ljubljana
Pacific/Auckland
America/Belem
Australia/Adelaide
Australia/Broken_Hill
Australia/Currie
Australia/Darwin
Australia/Eucla
Australia/Hobart
Australia/Lindeman
Australia/Melbourne
Australia/Perth
Pacific/Guam
(DEMO USE ONLY TIME ZONE)