Element451Integrations Guide

el_job_enrollments_raw

Updated Article

el_job_enrollments_raw Columns#

JSON Keys for Job Enrollments Object#

Sample JSON Object for Job Enrollments#

Job Enrollments

json
{
  "__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
el_job_enrollments_raw
ColumnData TypeDescription
el_job_enrollments_raw Columns
6 rows
el_job_enrollments_raw Columns
ColumnSQL Data TypeDescription
subdomVARCHARPartner school instance identifier
updated_atTIMESTAMP_NTZDocument update timestamp
created_atTIMESTAMP_NTZDocument created timestamp
_idVARCHARUnique identifier for each document.
srcVARIANTJSON object of job enrollments document properties.
etl_loaded_atTIMESTAMP_NTZDocument loaded to Snowflake timestamp
JSON Keys for Job Enrollments Object
73 rows
JSON Keys for Job Enrollments Object
DescriptionData TypeKey
Scheduled send or execution time for the action content.STRINGassessments[].content.scheduled_at
Type of creator for the assessment note. Distinct values: assistant.STRINGassessments[].notes[].creator_type
MongoDB identifier for an individual assessment action.STRINGassessments[]._id
Timestamp when the history event was created.STRINGhistory[].created_at
Client instance subdomain embedded in the source document.STRING_subdom
Timestamp when the assessment note was created.STRINGassessments[].notes[].created_at
Source metadata describing how the contact was enrolled in the workflow.OBJECTsource
Assessment action identifier associated with the error.STRINGerror[].assessmentId
Selected email template or variant for the action.STRINGassessments[].content.selected_email
Staff user or setting GUID that rejected the assessment action.STRINGassessments[].rejected_by
Top-level errors encountered during workflow enrollment processing.ARRAYerror
Timestamp when the history event was last updated.STRINGhistory[].updated_at
Note text attached to the assessment action.STRINGassessments[].notes[].note
Staff user who manually enrolled the contact in the workflow.STRINGsource.added_by_user_id
Context objects referenced by the history event.OBJECThistory[].context
User identifier associated with the error entry.STRINGerror[].userId
Workflow action node identifier for the assessment.STRINGassessments[].actionId
GUID of the AI workflow (job) the contact is enrolled in.STRINGworkflow_guid
Email subject line for the proposed action.STRINGassessments[].content.subject
Human-readable message describing the history event.STRINGhistory[].message
Enrollment GUID associated with the error entry.STRINGerror[].enrollmentGuid
Plain text message content for the proposed action.STRINGassessments[].content.text
Array of AI-generated workflow actions proposed or executed for this enrollment.ARRAYassessments
Scheduled time when the workflow should resume processing the enrollment.STRINGwake_time
Staff user or conversation setting GUID that approved the action.STRINGassessments[].approved_by
Human approval status for the proposed assessment action. Distinct values: pending, approved, irrelevant, feedback_sent, rejected.STRINGassessments[].approval_status
Workflow GUID referenced by the enrollment source.STRINGsource.workflow_guid
Conversation identifier associated with the action content.STRINGassessments[].content.conversation_id
Timestamp when the job enrollment was created in Element451.STRINGcreated_at
Timestamp when the assessment action was last updated.STRINGassessments[].updated_at
GUID of the resource created or updated by execution.STRINGassessments[].execution.resource_guid
Errors encountered while building or executing the assessment action.ARRAYassessments[].error
Conversation GUID for the executed SMS action.STRINGassessments[].execution.sms_conversation_guid
Segment GUID that triggered the enrollment.STRINGsource.segment_guid
Application GUID referenced in the history event context.STRINGhistory[].context.application_guid
Timestamp when the enrollment error was recorded.STRINGerror[].created_at
Timestamp when the assessment action was executed.STRINGassessments[].execution.executed_at
Workflow GUID referenced by the action content.STRINGassessments[].content.workflowGuid
Conversation GUID referenced in the history event context.STRINGhistory[].context.conversation_guid
Generated action content including message text and delivery channels.OBJECTassessments[].content
Generated email body content for the action.STRINGassessments[].content.email
Element451 person identifier for the enrolled contact.STRINGuser_id
Element451 GUID for the job enrollment record.STRINGguid
Execution metadata after the assessment action was carried out.OBJECTassessments[].execution
AI reasoning text explaining the proposed action.STRINGassessments[].content.reasoning
Trigger identifier that initiated the enrollment.STRINGsource.trigger_id
Enrollment source type (manual, segment, trigger, or queue). Distinct values: manual_segment, trigger, manual, sqs.STRINGsource.type
MongoDB identifier for an assessment note.STRINGassessments[].notes[]._id
Timestamp when the assessment note was last updated.STRINGassessments[].notes[].updated_at
Staff or assistant notes attached to the assessment action.ARRAYassessments[].notes
User or assistant identifier that created the note.STRINGassessments[].notes[].created_by
Segment GUID referenced in the history event context.STRINGhistory[].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.STRINGstatus
Generated phone call script or content for the action.STRINGassessments[].content.phone
Timestamp when the assessment action was created.STRINGassessments[].created_at
Template-based content used to generate the action.STRINGassessments[].content.template_content
Generated SMS message content for the action.STRINGassessments[].content.sms
Type of resource produced by action execution. Distinct values: conversation, workflow.STRINGassessments[].execution.resource_type
Scheduled execution time for the assessment action.STRINGassessments[].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.STRINGsource.trigger_key
Enhanced or formatted email content variant.STRINGassessments[].content.enhanced_email
Conversation GUID for the executed phone call action.STRINGassessments[].execution.phone_conversation_guid
History event type classification. Distinct values: skipped, abandoned, goal_completed.STRINGhistory[].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.STRINGerror[].node
MongoDB identifier for a history event entry.STRINGhistory[]._id
Event GUID referenced in the history event context.STRINGhistory[].context.event_guid
History of workflow state transitions and events for the enrollment.ARRAYhistory
Error message text.STRINGerror[].error
Unique identifier for the Job Enrollment document.STRING_id
Communication channels selected for the proposed action. Distinct values: email, sms, phone_call.ARRAYassessments[].content.channels
Workflow GUID associated with the error entry.STRINGerror[].workflowGuid
Conversation GUID for the executed email action.STRINGassessments[].execution.email_conversation_guid