el_job_enrollments_raw
el_job_enrollments_raw Columns#
JSON Keys for Job Enrollments Object#
Sample JSON Object for Job Enrollments#
Job Enrollments
{
"__v": 0,
"_id": "6940918e9e39ef57d8fcc",
"_subdom": "instance",
"assessments": [
{
"_id": "69666c92e64e5b69d494",
"actionId": "69407ae3f3def47c5367",
"approval_status": null,
"approved_by": "instance.conversation_settings.322894",
"content": {
"channels": [
"email"
],
"conversation_id": "uvU.conversations_v2.5135122",
"email": "<p>Hi Student,</p><br><br><p>I'm excited to invite you to a special Open House just for adult learners and international students on <strong>January 15, 2026 at 5:30 PM</strong>. We'll share practical steps for balancing work, family, and school, answer visa and international-admissions questions, and help you see how your past choices can open up new opportunities.</p><p>At the event you'll be able to meet faculty and advisors, get on-the-spot help with applications, financial aid, and scholarships, and explore degree options that fit your goals.</p><p>If you'd like to save your spot, please <a href=\"https://instance.event451.sites.451.io/event/instance.events.1371564\" target=\"_blank\">Register for the Jan 15 Open House</a> soon — seats are limited and we'd love to make time to meet you.</p><p>If you have any questions or need help registering, reply to this email and I'll personally help you get set up.</p><br><br><p>Sara<br>AI Undergraduate Admissions Specialist<br>Example University</p>",
"phone": null,
"reasoning": "I created a personalized event invitation email scheduled for January 14, 2026 at 9:00 AM.",
"scheduled_at": "2026-01-14T16:00:00",
"selected_email": "example@gmail.com",
"sms": null,
"subject": "Hello! — Explore Your Future at our Jan 15 Open House",
"text": ""
},
"created_at": "2026-01-13T16:02:27.174000",
"error": [],
"execution": {
"email_conversation_guid": "instance.conversations_v2.5170469",
"executed_at": "2026-01-13T16:02:35.641000",
"phone_conversation_guid": null,
"resource_guid": "instnace.conversations_v2.5170469",
"resource_type": "conversation",
"scheduled_at": "2026-01-14T16:00:00",
"sms_conversation_guid": null
},
"notes": [
{
"_id": "69666c8be64e5b69ca52",
"created_at": "2026-01-13T16:02:27.174000",
"created_by": "instance.conversation_settings.322894",
"creator_type": "assistant",
"note": "The event is in 2 days (Jan 15 at 5:30 PM) and the last outreach email was sent 3 days ago (Jan 10). The user prefers email and morning contact (America/New York). SMS is not reliable (hard bounce). Given the approaching deadline and the user's prior email engagement, it's appropriate to send a reminder email now to maximize conversions.",
"updated_at": "2026-01-13T16:02:27.174000"
},
{
"_id": "69666c8be64e5b69ca51",
"created_at": "2026-01-13T16:02:27.174000",
"created_by": "instance.conversation_settings.322894",
"creator_type": "assistant",
"note": "I created a personalized event invitation email scheduled for January 14, 2026 at 9:00 AM.",
"updated_at": "2026-01-13T16:02:27.174000"
}
],
"updated_at": "2026-01-13T16:02:35.642000"
}
],
"created_at": "2025-12-15T22:54:06.989000",
"error": [],
"guid": "instance.ai_workflow_enrollments.2027054",
"history": [
{
"_id": "694433669b42aa965152",
"created_at": "2025-12-18T17:01:26.737000",
"message": "The user was contacted recently via the scheduled email invitation to the Open House and has opened previous emails. We should not send another message now; schedule the next wake time in 4 days.",
"type": "skipped",
"updated_at": "2025-12-18T17:01:26.737000"
},
{
"_id": "6968907cec4285a98c6f",
"created_at": "2026-01-15T07:00:12.538000",
"message": "Enrollment abandoned due to deadline",
"type": "abandoned",
"updated_at": "2026-01-15T07:00:12.538000"
}
],
"source": {
"added_by_user_id": "670708e66af6b50cd6d2",
"segment_guid": "instance.segments.189096",
"type": "manual_segment"
},
"status": "abandoned",
"updated_at": "2026-01-15T07:00:12.538000",
"user_id": "67ec08f5ccc6520d82f4",
"wake_time": "2026-01-15T16:00:00",
"workflow_guid": "instance.ai_workflows.2181"
}Note: the history array in this sample is trimmed to two representative entries; the original source record includes additional intermediate entries.
el_job_enrollments_raw
0 rows
| Column | Data Type | Description |
|---|
el_job_enrollments_raw Columns
6 rows
| Column | SQL Data Type | Description |
|---|---|---|
| subdom | VARCHAR | Partner school instance identifier |
| updated_at | TIMESTAMP_NTZ | Document update timestamp |
| created_at | TIMESTAMP_NTZ | Document created timestamp |
| _id | VARCHAR | Unique identifier for each document. |
| src | VARIANT | JSON object of job enrollments document properties. |
| etl_loaded_at | TIMESTAMP_NTZ | Document loaded to Snowflake timestamp |
JSON Keys for Job Enrollments Object
73 rows
| Description | Data Type | Key |
|---|---|---|
| Scheduled send or execution time for the action content. | STRING | assessments[].content.scheduled_at |
| Type of creator for the assessment note. Distinct values: assistant. | STRING | assessments[].notes[].creator_type |
| MongoDB identifier for an individual assessment action. | STRING | assessments[]._id |
| Timestamp when the history event was created. | STRING | history[].created_at |
| Client instance subdomain embedded in the source document. | STRING | _subdom |
| Timestamp when the assessment note was created. | STRING | assessments[].notes[].created_at |
| Source metadata describing how the contact was enrolled in the workflow. | OBJECT | source |
| Assessment action identifier associated with the error. | STRING | error[].assessmentId |
| Selected email template or variant for the action. | STRING | assessments[].content.selected_email |
| Staff user or setting GUID that rejected the assessment action. | STRING | assessments[].rejected_by |
| Top-level errors encountered during workflow enrollment processing. | ARRAY | error |
| Timestamp when the history event was last updated. | STRING | history[].updated_at |
| Note text attached to the assessment action. | STRING | assessments[].notes[].note |
| Staff user who manually enrolled the contact in the workflow. | STRING | source.added_by_user_id |
| Context objects referenced by the history event. | OBJECT | history[].context |
| User identifier associated with the error entry. | STRING | error[].userId |
| Workflow action node identifier for the assessment. | STRING | assessments[].actionId |
| GUID of the AI workflow (job) the contact is enrolled in. | STRING | workflow_guid |
| Email subject line for the proposed action. | STRING | assessments[].content.subject |
| Human-readable message describing the history event. | STRING | history[].message |
| Enrollment GUID associated with the error entry. | STRING | error[].enrollmentGuid |
| Plain text message content for the proposed action. | STRING | assessments[].content.text |
| Array of AI-generated workflow actions proposed or executed for this enrollment. | ARRAY | assessments |
| Scheduled time when the workflow should resume processing the enrollment. | STRING | wake_time |
| Staff user or conversation setting GUID that approved the action. | STRING | assessments[].approved_by |
| Human approval status for the proposed assessment action. Distinct values: pending, approved, irrelevant, feedback_sent, rejected. | STRING | assessments[].approval_status |
| Workflow GUID referenced by the enrollment source. | STRING | source.workflow_guid |
| Conversation identifier associated with the action content. | STRING | assessments[].content.conversation_id |
| Timestamp when the job enrollment was created in Element451. | STRING | created_at |
| Timestamp when the assessment action was last updated. | STRING | assessments[].updated_at |
| GUID of the resource created or updated by execution. | STRING | assessments[].execution.resource_guid |
| Errors encountered while building or executing the assessment action. | ARRAY | assessments[].error |
| Conversation GUID for the executed SMS action. | STRING | assessments[].execution.sms_conversation_guid |
| Segment GUID that triggered the enrollment. | STRING | source.segment_guid |
| Application GUID referenced in the history event context. | STRING | history[].context.application_guid |
| Timestamp when the enrollment error was recorded. | STRING | error[].created_at |
| Timestamp when the assessment action was executed. | STRING | assessments[].execution.executed_at |
| Workflow GUID referenced by the action content. | STRING | assessments[].content.workflowGuid |
| Conversation GUID referenced in the history event context. | STRING | history[].context.conversation_guid |
| Generated action content including message text and delivery channels. | OBJECT | assessments[].content |
| Generated email body content for the action. | STRING | assessments[].content.email |
| Element451 person identifier for the enrolled contact. | STRING | user_id |
| Element451 GUID for the job enrollment record. | STRING | guid |
| Execution metadata after the assessment action was carried out. | OBJECT | assessments[].execution |
| AI reasoning text explaining the proposed action. | STRING | assessments[].content.reasoning |
| Trigger identifier that initiated the enrollment. | STRING | source.trigger_id |
| Enrollment source type (manual, segment, trigger, or queue). Distinct values: manual_segment, trigger, manual, sqs. | STRING | source.type |
| MongoDB identifier for an assessment note. | STRING | assessments[].notes[]._id |
| Timestamp when the assessment note was last updated. | STRING | assessments[].notes[].updated_at |
| Staff or assistant notes attached to the assessment action. | ARRAY | assessments[].notes |
| User or assistant identifier that created the note. | STRING | assessments[].notes[].created_by |
| Segment GUID referenced in the history event context. | STRING | history[].context.segment_guid |
| Current status of the job enrollment in the AI workflow. Distinct values: cancelled, abandoned, idle, completed, pending, waiting_for_approval, no_action_needed, errored, scheduled, taking_action, thinking. | STRING | status |
| Generated phone call script or content for the action. | STRING | assessments[].content.phone |
| Timestamp when the assessment action was created. | STRING | assessments[].created_at |
| Template-based content used to generate the action. | STRING | assessments[].content.template_content |
| Generated SMS message content for the action. | STRING | assessments[].content.sms |
| Type of resource produced by action execution. Distinct values: conversation, workflow. | STRING | assessments[].execution.resource_type |
| Scheduled execution time for the assessment action. | STRING | assessments[].execution.scheduled_at |
| Trigger event key that initiated the enrollment. Distinct values: entered_segment, user_label_added, application_started, entered_exited_segment, form_submitted, grade_risk_changed, appointments_attended, decision_status_changed, appointments_no_show, decision_released, application_submitted, event_signup, appointments_canceled, alert_created, exited_segment. | STRING | source.trigger_key |
| Enhanced or formatted email content variant. | STRING | assessments[].content.enhanced_email |
| Conversation GUID for the executed phone call action. | STRING | assessments[].execution.phone_conversation_guid |
| History event type classification. Distinct values: skipped, abandoned, goal_completed. | STRING | history[].type |
| Timestamp when the job enrollment was last updated. | STRING (TIMESTAMP) | updated_at |
| Workflow node where the error occurred. Distinct values: build_action, graph, decide_next_action, human_approval, execute_action. | STRING | error[].node |
| MongoDB identifier for a history event entry. | STRING | history[]._id |
| Event GUID referenced in the history event context. | STRING | history[].context.event_guid |
| History of workflow state transitions and events for the enrollment. | ARRAY | history |
| Error message text. | STRING | error[].error |
| Unique identifier for the Job Enrollment document. | STRING | _id |
| Communication channels selected for the proposed action. Distinct values: email, sms, phone_call. | ARRAY | assessments[].content.channels |
| Workflow GUID associated with the error entry. | STRING | error[].workflowGuid |
| Conversation GUID for the executed email action. | STRING | assessments[].execution.email_conversation_guid |
Was this page helpful?