el_notifications_raw Columns

Column SQL Data Type Description
_id VARCHAR Unique identifier for each document.
subdom VARCHAR Partner school instance identifier
src VARIANT JSON object of Notification document properties.
updated_at TIMESTAMP_NTZ Document update timestamp
created_at TIMESTAMP_NTZ Document created timestamp
etl_loaded_at TIMESTAMP_NTZ Document loaded to Snowflake timestamp

JSON Keys for Notifications Object

Key Data Type Description
_id String Unique identifier for the Notifications Object.
_subdom String Client instance subdomain embedded in the source document.
active Boolean Whether the notification template is active.
created_at String (Timestamp) Timestamp when the notification record was created in Element451.
delivery Array Delivery channels enabled for the notification. Distinct values: email, sms, alert.
direct Boolean Whether the notification is sent directly without a campaign wrapper.
from_source Object Source module and namespace that owns the notification template.
from_source.module String Element451 module that created the notification (campaigns, events, etc.). Distinct values: campaigns, events, applications, documents.
from_source.namespace String Namespace within the module (communications, messages, autoresponders). Distinct values: communications, messages, autoresponders.
guid String Element451 GUID for the notification record.
id String Legacy or alternate identifier for the notification record.
is_template Boolean Whether the record is a reusable notification template.
message Object Message content configuration for each delivery channel.
message.alert String In-app alert message text for system notifications.
message.email String Email conversation or template GUID for the notification.
message.sms String SMS message configuration for the notification.
message.sms_from_number String Sender phone number for SMS (top-level alias on message object).
message.sms.content String SMS message body text.
message.sms.from_number String Sender phone number for the SMS notification.
message.sms.media String Media attachments included in the SMS message.
message.sms.media[].type String Media attachment type for SMS. Distinct values: file.
message.sms.media[].value String Media attachment URL or file reference for SMS.
message.sms.opt_out_text String Opt-out disclaimer text appended to SMS messages.
message.sms.sms String Nested SMS content object with body and file attachments.
message.sms.sms.content String SMS body text in the nested SMS content object.
message.sms.sms.file String File attachment reference for the nested SMS content.
name String Display name for the notification template.
schedule Object Delivery timing configuration per channel.
schedule.email String Email delivery timing mode (synchronous or asynchronous). Distinct values: asynch, async, sync.
schedule.push String Push notification delivery timing mode. Distinct values: asynch.
schedule.sms String SMS delivery timing mode (synchronous or asynchronous). Distinct values: asynch, sync.
sender String Sender type for the notification (typically client). Distinct values: client.
source String Origin of the notification (autoresponder or system). Distinct values: autoresponder, system.
subdom String Client subdomain duplicated inside the SRC document.
target String Recipient target type for the notification (user or anonymous). Distinct values: user, anon.
type String Notification type classification. Distinct values: info, sms, email.
updated_at String Timestamp when the notification record was last updated.
used_in Array GUIDs of campaigns, events, or workflows that reference this notification.

Sample JSON Object for Notifications

Notifications

el_notifications_raw

el_notifications_raw Columns

JSON Keys for Notifications Object