UPC_CHANNEL_PREFERENCE

This table stores information related to channel preferences created by the user to link to a global preference.

Field Type Length Null? Description
Id (Primary Key) INT 64 False Unique ID of the regional preference.
channel_preference_name VARCHAR 64 False A name for the channel preference.
business_days CLOB False

Stores the selected working days and working hour.

For example, 1-1000:1400|2-1000:1800.

The example states that the Marketer, or Customer, has set business days and working hours as:

  • Monday (10:00 am to 2:00 pm)
  • Tuesday (10:00 am to 6:00 pm)
excluded_days CLOB True

Excluded days.

For example, 1640419470-1;Christmas

Here 1640419470 is epoch second value for 25 Dec 2021.

The example states that the Marketer, or Customer, has chosen following days are non-working days:
  • 25 Dec 2021 – Holiday – Christmas
createdDateEpoch INT 64 False Created date epoch.
lastModifiedDateEpoch INT 64 False Last modified date epoch.
createdby INT 20 False Platform ID of the user who created the entry.
modifiedby INT 20 False Platform ID of the user modifying the entry
version INT 20 False Version information for optimistic locking.