el_notifications_raw
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 (opens in a new tab) | 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 (opens in a new tab) | String | Media attachments included in the SMS message. |
| message.sms.media (opens in a new tab)[].type | String | Media attachment type for SMS. Distinct values: file. |
| message.sms.media (opens in a new tab)[].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 (opens in a new tab) | 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
{
"_id": "55bb7c5b200c78c63e641f57",
"_subdom": "instance",
"active": true,
"delivery": [
"email",
"sms"
],
"event": "RecommendationRequestEmailSend",
"from_source": {
"module": "documents",
"namespace": "autoresponders"
},
"guid": "instance.notifications.withwaiver",
"message": {
"email": "emails.instance.5",
"sms": "Just a reminder...",
"sms_from_number": "+1234567890"
},
"name": "Information Request with Waiver",
"schedule": {
"email": "async"
},
"sender": "client",
"source": "autoresponder",
"target": "anon",
"type": "info",
"updated_at": "2016-06-13T16:20:11.924000",
"used_in": [
"instance.communications.281204"
]
}el_notifications_raw
0 rows
| Column | Data Type | Description |
|---|
el_notifications_raw Columns
6 rows
| Column | SQL Data Type | Description |
|---|---|---|
| src | VARIANT | JSON object of Notification document properties. |
| _id | VARCHAR | Unique identifier for each document. |
| etl_loaded_at | TIMESTAMP_NTZ | Document loaded to Snowflake timestamp |
| subdom | VARCHAR | Partner school instance identifier |
| updated_at | TIMESTAMP_NTZ | Document update timestamp |
| created_at | TIMESTAMP_NTZ | Document created timestamp |
JSON Keys for Notifications Object
25 rows
| Description | Data Type | Key |
|---|---|---|
| Email conversation or template GUID for the notification. | STRING | [message.email](http://message.email) |
| Timestamp when the notification record was created in Element451. | STRING (TIMESTAMP) | created_at |
| Namespace within the module (communications, messages, autoresponders). Distinct values: communications, messages, autoresponders. | STRING | from_source.namespace |
| Source module and namespace that owns the notification template. | OBJECT | from_source |
| Media attachment type for SMS. Distinct values: file. | STRING | [message.sms.media](http://message.sms.media)[].type |
| SMS message body text. | STRING | message.sms.content |
| Whether the notification is sent directly without a campaign wrapper. | BOOLEAN | direct |
| Delivery channels enabled for the notification. Distinct values: email, sms, alert. | ARRAY | delivery |
| Element451 module that created the notification (campaigns, events, etc.). Distinct values: campaigns, events, applications, documents. | STRING | from_source.module |
| Opt-out disclaimer text appended to SMS messages. | STRING | message.sms.opt_out_text |
| Nested SMS content object with body and file attachments. | STRING | message.sms.sms |
| Whether the notification template is active. | BOOLEAN | active |
| In-app alert message text for system notifications. | STRING | message.alert |
| SMS message configuration for the notification. | STRING | message.sms |
| Sender phone number for the SMS notification. | STRING | message.sms.from_number |
| Legacy or alternate identifier for the notification record. | STRING | id |
| Client instance subdomain embedded in the source document. | STRING | _subdom |
| Whether the record is a reusable notification template. | BOOLEAN | is_template |
| Media attachments included in the SMS message. | STRING | [message.sms.media](http://message.sms.media) |
| Message content configuration for each delivery channel. | OBJECT | message |
| Element451 GUID for the notification record. | STRING | guid |
| Sender phone number for SMS (top-level alias on message object). | STRING | message.sms_from_number |
| Unique identifier for the Notifications Object. | STRING | _id |
| Media attachment URL or file reference for SMS. | STRING | [message.sms.media](http://message.sms.media)[].value |
| SMS body text in the nested SMS content object. | STRING | message.sms.sms.content |
Was this page helpful?