el_appointments_raw

Updated Sep 23, 2026Article

Appointments can be scheduled between a one contact and one Element451 user or "admin". Appointments can be grouped by Category and Type.

el_appointments_raw Columns#

Distinct Appointment Document Types#

Sample JSON Objects for Appointment Document Types#

appointment

json

{
  "_id": "66142dc56e73cf03c593",
  "_subdom": "instance",
  "admin_id": "653a84390c32ff27440b1316",
  "appointment_type": "instance.appointments_types.983",
  "availability_guid": "instance.appointments_availabilities.1281",
  "created_at": "2024-04-08T17:47:49.369000",
  "duration": 30,
  "etl_run_id": "5aa22153-94f16-a458-bc7b1ce326a7",
  "etl_url": "https://element451.dagster.cloud/prod/runs/5aa22153-94f16-a458-bc7b1ce326a7",
  "fields": [
    {
      "name": "first_name",
      "slug": "user-first-name",
      "value": "Jaime "
    },
    {
      "name": "last_name",
      "slug": "user-last-name",
      "value": "Kadu"
    },
    {
      "name": "email",
      "slug": "user-email-address",
      "value": "jkadu@gmail.com"
    },
    {
      "name": "user-phone",
      "slug": "user-phone-cell",
      "subfields": [
        {
          "name": "user-phone-type",
          "value": "cell"
        },
        {
          "name": "user-phone-country_alpha_2",
          "value": "CA"
        },
        {
          "name": "user-phone-country_code",
          "value": "1"
        },
        {
          "name": "user-phone-number",
          "value": "8888675309"
        }
      ]
    }
  ],
  "guid": "instance.scheduled_appointment.4028",
  "location": "Phone",
  "location_type": "virtual",
  "notification_status": "sent",
  "public_uuid": "5699d1e6-d4-92b774207ed4",
  "start_date": "2024-04-10T14:00:00",
  "status": "no_show",
  "updated_at": "2024-11-08T16:25:55.854000",
  "user_id": "65de539d4f8206b0ea"
}

appointment_type

json

{
  "_id": "66cf8d53087871919903",
  "_subdom": "instance",
  "category_guid": "instance.appointments_categories.936",
  "create_milestone": true,
  "created_at": "2024-08-28T20:49:23.677000",
  "description": "",
  "etl_run_id": "ba62b8fe-4b46-9ca7-9500f0e0de14",
  "etl_url": "https://element451.dagster.cloud/prod/runs/ba62b8fe-4b46-9ca7-9500f0e0de14",
  "field_guid": "instance.field.1473589",
  "guid": "instance.appointments_types.1458",
  "location": "Join Zoom Meeting\nhttps://us06web.zoom.us/j/80411161?pwd=KSJhERMbL77UWnWalXXq.1\n\nMeeting ID: 808 447 1111\nPasscode: gnpNJURg",
  "location_type": "virtual",
  "name": "Academic Counseling",
  "public": true,
  "updated_at": "2024-11-07T20:02:27.912000"
}

category

json

{
  "_id": "672d2439bcb66e03ca36",
  "_subdom": "instance",
  "created_at": "2024-11-07T20:34:01.492000",
  "etl_run_id": "1351946b-75c9-499b-9cd1-49361c1d8249",
  "etl_url": "https://element451.dagster.cloud/prod/runs/1351946b-499b-9cd1-49361c1d8249",
  "guid": "instance.appointments_categories.1019",
  "name": "Enrollment",
  "updated_at": "2024-11-07T20:34:01.492000"
}

el_appointments_raw Columns

8 rows

el_appointments_raw Columns
Column	SQL Data Type	Description
created_at	TIMESTAMP_NTZ	Task created timestamp
etl_loaded_at	TIMESTAMP_NTZ	Task loaded to Snowflake timestamp
src	VARIANT	JSON object of user properties
type	VARCHAR	Appointment document type, either appointment, appointment_type or appointment category.
subdom	VARCHAR	Partner school instance identifier
_id	VARCHAR	Unique document identifier.
deleted_at	TIMESTAMP_NTZ	Task deleted timestamp
updated_at	TIMESTAMP_NTZ	Task update timestamp

Distinct Appointment Document Types

3 rows

Distinct Appointment Document Types
Name	Description
appointment_type	Mid-level grouping that is tied to a specific location and registration fields. Can be used by multiple admins.
appointment	Individual appointment registration between one admin and one contact.
category	Top-level tag to organize appointments, such as by department.