el_courses_raw

Updated Sep 23, 2026Article

el_courses_raw Columns#

JSON Keys for Course Type Object#

JSON Keys for Section Type Object#

JSON Keys for Enrollment Type Object#

Sample JSON Object for Courses by Type#

Note: the lms_syllabus_body field below is truncated — the original contains a full HTML-formatted syllabus.

Course

json

{
  "_id": "67cf2ff8badaa828fe00cbe9",
  "_subdom": "instance",
  "code": "BIO 1101",
  "created_at": "2025-03-10T18:31:20.850000",
  "credits": "2.0",
  "departments": [
    {
      "institution_id": 567,
      "name": "Sciences",
      "sis_account_id": "SCI"
    }
  ],
  "description": "",
  "grading": "A-F",
  "guid": "instance.courses.98656",
  "imported_at": "2025-04-13T15:02:00.765000",
  "imported_from": "canvas",
  "institution_id": 12345,
  "lms_account_id": 123,
  "lms_enrollment_term_id": 321,
  "lms_grading_standard_id": null,
  "lms_syllabus_body": "<p>Course Outline...(truncated)</p>",
  "lms_uuid": "Dpz1X8enB0cI5C2OZviRzAEMB6RZKozM1rDeoOKI",
  "name": "Biology 1011",
  "number": null,
  "semesters": [
    "_442_1",
    "_443_1"
  ],
  "status": "available",
  "subject": null,
  "term": "instance.terms.34473",
  "timezone": "America/New_York",
  "total_students": 19,
  "type": "online",
  "updated_at": "2025-04-13T15:02:00.765000",
  "version": null
}

Section

json

{
  "_id": "681af7bd3e480bb018f43",
  "_subdom": "instance",
  "campus": "Main Campus",
  "code": "WDDRFT-6131-003",
  "course_guid": "instance.courses.110065",
  "created_at": "2025-05-07T06:03:41.338000",
  "end_date": "2024-10-24T00:00:00",
  "etl_run_id": "62f24737-39b6-b3d6-3ec940239e7b",
  "etl_url": "https://element451.io/prod/runs/62f24737-39b6-4ff4-b3d6-3ec940239e7b",
  "guid": "instance.courses_sections.69234",
  "imported_at": "2025-05-21T06:27:53.071000",
  "imported_from": "ethos",
  "institution_id": "1ee39d03-3c3f-4c0a-b697-472da0621746",
  "instruction_mode": "In-Person",
  "lms_course_id": "22358ba6-3db2-4a07-666f50e62f79",
  "lms_instructor_id": "67762713-8924-b04f-ee3983e1e481",
  "lms_uuid": "1ee39d03-3c3f-4c097-472da0621746",
  "max_enrollment": 20,
  "number": "003",
  "school": "Humanities",
  "section_type": null,
  "sis_term": {
    "code": "WD2025",
    "id": "97caee92-af38-4f8d-a23e-44dab37afa24",
    "name": "Fall 2025"
  },
  "start_date": "2024-09-24T00:00:00",
  "status": "Active",
  "status_category": "active",
  "term": "instance.terms.37846",
  "times": [
    {
      "building": "Center for Humanities",
      "day": "tuesday",
      "end_date": "2024-10-24",
      "end_time": "21:00:00",
      "id": "4f56e977-99ac-88a3-5aea00c9d2d7",
      "room": "211",
      "start_date": "2024-09-24",
      "start_time": "18:00:00"
    },
    {
      "building": "Center for Humanities",
      "day": "thursday",
      "end_date": "2024-10-24",
      "end_time": "21:00:00",
      "id": "4f56e977-99ac-88a3-5aea00c9d2d7",
      "room": "211",
      "start_date": "2024-09-24",
      "start_time": "18:00:00"
    }
  ],
  "updated_at": "2025-05-21T07:03:37.456000"
}

Enrollment

json

{
  "_id": "69316bd3babff5008da84",
  "_subdom": "instance",
  "calculated": {
    "hash": "3204f2c99ee7b2fe98591ae682",
    "latest_metrics": {
      "days_since_first": 0,
      "delta": 0,
      "drop_from_peak_pct": 0,
      "history_count": 2,
      "is_below_passing": false,
      "latest_value": 100,
      "net_change": 0,
      "peak_value": 100,
      "streak_down": 0,
      "velocity": 0
    },
    "risk_codes": [],
    "risk_level": "none",
    "risk_updated_at": "2025-12-06T12:35:26.881000"
  },
  "course_code": "ABC-101",
  "course_credits": 3,
  "course_grading": "06dd7d0b-82eb-a51547f569b7",
  "course_guid": "ccbcmd.courses.207182",
  "course_institution_id": "12a0b051-833c-b3efdda8aa4a",
  "course_name": "Intro to Interior Design",
  "course_status": "261a3de9-26f3-9594-b3b17b8b1d26",
  "course_subject": "9bf354ef-1a93-a300-502059ff8496",
  "created_at": "2025-12-04T11:09:07.429000",
  "current_grade_date": null,
  "current_grade_lms_id": "24281797-5ae8-bfd9-5beac8e0b1a4",
  "current_grade_number": null,
  "current_grade_text": "C",
  "enrollment_credits": 3,
  "enrollment_credits_measure": "hour",
  "enrollment_status": "registered",
  "etl_run_id": "2f5e9fe8-d41c-4007-9bdb-21a349839502",
  "etl_url": "https://element451.io/prod/runs/2f5e9fe8-d41c-9bdb-21a349839502",
  "final_grade_date": "2024-12-18T05:00:00",
  "final_grade_lms_id": "7a2f447b-5ceb-86bd-69cfdeaf9c67",
  "final_grade_number": null,
  "final_grade_text": "C",
  "grade_history": [
    {
      "at": "2024-08-26T04:00:00",
      "value": 74
    },
    {
      "at": "2024-12-18T05:00:00",
      "value": 74
    }
  ],
  "grades": [
    {
      "date": null,
      "lms_id": "24281797-5ae8-464f-bfd9-5beac8e0b1a4",
      "type": "Final",
      "value": "C"
    },
    {
      "date": null,
      "lms_id": "24281797-5ae8-464f-bfd9-5beac8e0b1a4",
      "type": "Midterm",
      "value": "B"
    },
    {
      "date": "2024-12-18T05:00:00",
      "lms_id": "7a2f447b-5ceb-48cc-86bd-69cfdeaf9c67",
      "type": "literal",
      "value": "C"
    }
  ],
  "guid": "instance.courses_enrollments.2180733",
  "imported_at": "2026-05-07T01:07:27.832000",
  "imported_from": "ethos",
  "institution_id": "ecd3b217-b0ac-8d60-62d325f7e955",
  "last_attended_date": null,
  "last_run_id": "T40B5OZB",
  "original_registered_on": "2024-05-08T04:00:00",
  "progress": {
    "completed_at": "2026-05-27T21:47:16Z",
    "next_requirement_url": null,
    "requirement_completed_count": 1,
    "requirement_count": 1
  },
  "progress_updated_at": "2026-05-27T21:52:02.042000",
  "section_campus": "a46bde29-52e6-ad51-03e9b4a81cd6",
  "section_code": "90728",
  "section_end_date": "2024-12-15T05:00:00",
  "section_guid": "instance.courses_sections.284726",
  "section_institution_id": "cf9be998-4416-9d36-4f05ac45981f",
  "section_instruction_mode": "7b117395-0982-840e-4e6b927b6ef4",
  "section_instructor": "Faculty Name",
  "section_instructor_email": "faculty@instance.edu",
  "section_instructor_institution_id": "f5e21248-debb-a6d2-971c7c4243c5",
  "section_instructors": [
    "f5e21248-debb-a6d2-971c7c4243c5"
  ],
  "section_lms_term_code": "FA26",
  "section_school": "School Name",
  "section_start_date": "2024-08-26T04:00:00",
  "section_status": "3418968d-a627-a445-5d6f190efb85",
  "section_term": "instance.terms.35607",
  "section_term_id": "514a8bad-6bfa-93ed-ffb6381710dd",
  "total_active_time": null,
  "updated_at": "2026-05-07T17:33:27.704000",
  "user_id": "661e8324b81a1f00b8715",
  "user_institution_id": "97cf3e72-5917-b599-fda9daa533f1",
  "user_school_id": "901405"
}

el_courses_raw Columns

7 rows

el_courses_raw Columns
Column	SQL Data Type	Description
etl_loaded_at	TIMESTAMP_NTZ	Document loaded to Snowflake timestamp
type	VARCHAR	Category for the type of document per row: course, section, or enrollment.
src	VARIANT	JSON object of course document properties.
created_at	TIMESTAMP_NTZ	Document created timestamp
subdom	VARCHAR	Partner school instance identifier
updated_at	TIMESTAMP_NTZ	Document update timestamp
_id	VARCHAR	Unique identifier for each document.

JSON Keys for Course Type Object

47 rows

JSON Keys for Course Type Object
Description	Data Type	Key
Department identifier within the departments array.	STRING	departments[].id
LMS grade column identifier for the overall course grade.	STRING	lms_overall_grade_column_id
Departments or colleges associated with the course. Array of objects.	ARRAY	departments
Department type classification. Distinct values: college, department.	STRING	departments[].type
Institution identifier for the department.	INTEGER	departments[].institution_id
Client instance subdomain embedded in the source document.	STRING	_subdom
Number of credits awarded upon completion of the course.	STRING	credits
High-level status category for the course.	STRING	status_category
Default LMS term identifier associated with the course.	INTEGER	lms_enrollment_term_id
Total students associated with the course across sections.	INTEGER	total_students
Timezone for course scheduling defaults.	STRING	timezone
Identifier for the most recent sync or enrichment run.	STRING	last_run_id
Dagster ETL run identifier for the record load.	STRING	etl_run_id
Grading scheme or standard configured for the course.	STRING	grading
Unit of measure for course credits. Distinct values: hour, credit, ceu.	STRING	credit_measurement
Scheduling end date for the course offering window.	STRING	scheduling_end_date
Element451 GUID for the course catalog record.	STRING	guid
Course delivery type defined by the client (hybrid, clinical, online, etc.). Distinct values: on_campus, online, blended, lecture, lab, practicum, independent study, distance learning.	STRING	type
Course number within the subject.	STRING	number
Scheduling start date for the course offering window.	STRING	scheduling_start_date
LMS UUID for the course catalog entry.	STRING	lms_uuid
Delivery or registration method configured for the course.	STRING	method
Course catalog status from the source system. Distinct values: Client-configured course status codes.	STRING	status
Department code within the departments array.	STRING	departments[].code
Timestamp when the course catalog record was created.	STRING	created_at
URL to the Dagster ETL run that loaded the record.	STRING	etl_url
Semester associations for the course.	ARRAY	semesters
LMS account identifier for the course.	INTEGER	lms_account_id
Whether the course is active in the catalog. Distinct values: true, false.	BOOLEAN	active
SIS account identifier for the department.	STRING	departments[].sis_account_id
Timestamp when the course catalog record was last updated.	STRING (TIMESTAMP)	updated_at
Timestamp when the course was imported from an external system.	STRING	imported_at
Course category label from the institution or LMS.	STRING	category
Subject code for the course (e.g. MATH, ENGL).	STRING	subject
External system the course was imported from. Distinct values: canvas, ethos, brightspace, blackboard.	STRING	imported_from
LMS grading standard identifier for the course.	STRING	lms_grading_standard_id
Default term GUID associated with the course.	STRING	term
Syllabus body text synced from the LMS.	STRING	lms_syllabus_body
Percentage ownership of the course by the department.	INTEGER	departments[].ownership_percentage
Course display name in the catalog.	STRING	name
Department name.	STRING	departments[].name
Course description text.	STRING	description
Default instruction mode for the course (online, on campus, blended).	STRING	instruction_mode
Unique identifier for the Course.	STRING	_id
Institution identifier from the source or LMS system.	INTEGER	institution_id
Course code from the institution or third-party SIS/LMS.	STRING	code
LMS identifier for the department.	STRING	departments[].lms_id

JSON Keys for Section Type Object

70 rows

JSON Keys for Section Type Object
Description	Data Type	Key
Timestamp when the section was imported from an external system.	STRING	imported_at
LMS UUID for the course section.	STRING	lms_uuid
Status of the section import from an external system. Distinct values: course_link_pending.	STRING	import_status
Campus GUID where the course section is offered.	STRING	campus
Institution identifier for the parent course.	STRING	course_institution_id
Dagster ETL run identifier for the record load.	STRING	etl_run_id
Primary instructor email for the section.	STRING	instructor_email
Section number within the course.	STRING	number
GUID of the parent course this section belongs to.	STRING	course_guid
Instruction mode for the section (online, on campus, blended). Distinct values: on_campus, online, blended (also client-configured GUID codes).	STRING	instruction_mode
End date for the course section.	STRING	end_date
Institution identifier for the SIS term.	STRING	sis_term.institution_id
End date for the section meeting recurrence.	STRING	times[].end_date
LMS section identifier.	STRING	lms_section_id
Part-of-term code for the section within the academic term. Distinct values: Client-configured part-of-term GUID codes.	STRING	part_of_term
SIS term code.	STRING	sis_term.code
Name of the parent course copied onto the section record.	STRING	course_name
LMS identifier for the primary instructor.	INTEGER	lms_instructor_id
Parent term identifier in the SIS hierarchy.	STRING	sis_term.parent
Term GUID in which the course section is offered.	STRING	term
External system the section was imported from. Distinct values: ethos, canvas, brightspace, blackboard.	STRING	imported_from
Timezone for the course section schedule. Format like: "America/New_York".	STRING	timezone
Timestamp when the course section was last updated.	STRING (TIMESTAMP)	updated_at
Unique identifier for the Section.	STRING	_id
Recurrence interval for the section meeting.	INTEGER	times[].recurrence.interval
Meeting times for the course section.	ARRAY	times
Section code from the institution or LMS.	STRING	code
End date for the meeting recurrence pattern.	STRING	times[].recurrence.ends.date
Start time for the section meeting.	STRING	times[].start_time
Section status (active, inactive, available, unpublished, etc.). Distinct values: active, inactive, available, unpublished, Yes, No (also client-configured GUID status codes).	STRING	status
Start date for the course section.	STRING (TIMESTAMP)	start_date
Institution identifier for the primary instructor.	STRING	instructor_institution_id
Element451 GUID for the course section record.	STRING	guid
Total number of meetings for the section duration.	INTEGER	total_meetings
LMS term code for the section.	STRING	lms_term_code
SIS term name.	STRING	sis_term.name
SIS term object for the course section.	OBJECT	sis_term
Semester associations for the section.	ARRAY	semesters
Document version number for the section record.	STRING	version
End time for the section meeting.	STRING	times[].end_time
Current number of students enrolled in the section.	INTEGER	current_enrollments
Instructor identifier from the source system.	STRING	instructor_id
Recurrence pattern for the section meeting.	OBJECT	times[].recurrence
Room where the section meeting occurs.	STRING	times[].room
Client instance subdomain embedded in the source document.	STRING	_subdom
Start date for the section meeting recurrence.	STRING	times[].start_date
Institution identifier for the section.	STRING	section_institution_id
High-level status category for the section.	STRING	status_category
URL to the Dagster ETL run that loaded the record.	STRING	etl_url
Institution identifier for the meeting time entry.	STRING	times[].institution_id
SIS term identifier.	STRING	sis_term.id
Timestamp when the course section was created.	STRING	created_at
LMS course offering code.	STRING	lms_course_offering_code
End condition for the meeting recurrence pattern.	OBJECT	times[].recurrence.ends
Section type (seminar, lab, lecture, etc.). Distinct values: seminar, lecture (also client-configured GUID or category labels).	STRING	section_type
Institution identifier from the source or LMS system.	STRING	institution_id
Day of week for the section meeting. Distinct values: monday, tuesday, wednesday, thursday, friday, saturday, sunday (also numeric 0–6).	STRING	times[].day
LMS course identifier for the section.	STRING	lms_course_id
Sync or enrichment run identifier.	STRING	run_id
Institution identifier for the term.	STRING	term_institution_id
School or college offering the section.	STRING	school
Array of instructors assigned to the section.	ARRAY	instructors
Identifier for the section meeting time entry.	STRING	times[].id
Recurrence type for the section meeting. Distinct values: weekly, daily, monthly.	STRING	times[].recurrence.type
LMS course offering identifier.	STRING	lms_course_offering_id
Identifier for the most recent sync or enrichment run.	STRING	last_run_id
Primary instructor name for the section.	STRING	instructor
Building where the section meeting occurs.	STRING	times[].building
Maximum number of students allowed in the section.	INTEGER	max_enrollment
LMS section code.	STRING	lms_section_code

JSON Keys for Enrollment Type Object

104 rows

JSON Keys for Enrollment Type Object
Description	Data Type	Key
Timestamp when course progress was completed.	STRING	progress.completed_at
Institution identifier for the enrolled section.	STRING	section_institution_id
Consecutive downward grade metric changes.	INTEGER	calculated.latest_metrics.streak_down
LMS grade column identifier for overall grade.	STRING	lms_overall_grade_column_id
Migration marker from a legacy data import.	STRING	migration
Timestamp when the enrollment was completed.	STRING (TIMESTAMP)	completed_at
URL to the course or enrollment in the LMS.	STRING	lms_url
Instructors for the enrolled section.	ARRAY	section_instructors
LMS course identifier for the enrollment.	STRING	lms_course_id
LMS section identifier for the enrollment.	STRING	lms_section_id
Rate of grade change across recent metric snapshots.	INTEGER	calculated.latest_metrics.velocity
Numeric final grade for the enrollment.	INTEGER	final_grade_number
Text representation of the current grade.	STRING	current_grade_text
Date the student last attended the course section.	STRING	last_attended_date
Timestamp when grade data was last updated.	STRING	grade_updated_at
Campus GUID for the enrolled section.	STRING	section_campus
Latest computed grade trend and risk metrics.	ARRAY	calculated.latest_metrics
Status of the parent course catalog entry.	STRING	course_status
Text representation of the final grade.	STRING	final_grade_text
Client instance subdomain embedded in the source document.	STRING	_subdom
Dagster ETL run identifier for the record load.	STRING	etl_run_id
Start date of the enrolled section.	STRING	section_start_date
Grade value at the grade history snapshot.	INTEGER	grade_history[].value
Days since the first grade metric was recorded.	INTEGER	calculated.latest_metrics.days_since_first
Timestamp when the enrollment record was created.	STRING	created_at
GUID of the parent course for this enrollment.	STRING	course_guid
Timestamp when a grade history entry was recorded.	STRING	grade_history[].at
End date of the enrolled section.	STRING	section_end_date
Source system or process that enriched the enrollment record. Distinct values: openlms.	STRING	enriched_from
Institution identifier for the enrolled course.	STRING	course_institution_id
Total active time spent in the course by the student.	INTEGER	total_active_time
LMS identifier for an individual grade entry.	STRING	grades[].lms_id
Section code for the enrolled section.	STRING	section_code
Whether the enrollment has been marked completed.	BOOLEAN	completed
Instructor identifier for the enrolled section.	STRING	section_instructor_id
Highest grade metric value observed in history.	INTEGER	calculated.latest_metrics.peak_value
Institution identifier for the section instructor.	STRING	section_instructor_institution_id
Date the final grade was recorded.	STRING	final_grade_date
End date of student involvement in the enrollment.	STRING	involvement_end_date
Timestamp of the student last LMS course access.	STRING	last_course_access
Section type for the enrolled section (seminar, lab, lecture, etc.).	STRING	section_type
Most recent grade metric value.	INTEGER	calculated.latest_metrics.latest_value
Date of an individual LMS grade entry.	STRING (DATE)	grades[].date
Start date of student involvement in the enrollment.	STRING	involvement_start_date
URL to the Dagster ETL run that loaded the record.	STRING	etl_url
Timestamp when calculated risk metrics were last updated.	STRING	calculated.risk_updated_at
Institution identifier for the enrolled student.	STRING	user_institution_id
Unit of measure for enrollment credits.	STRING	enrollment_credits_measure
Grade type from the LMS (Final, Midterm, etc.). Distinct values: Final, Final Grade, Midterm, Midterm Grade 1, literal.	STRING	grades[].type
Timestamp when progress data was last updated.	STRING	progress_updated_at
System-calculated enrollment risk and grade trend metrics.	OBJECT	calculated
URL to the next incomplete course requirement.	STRING	progress.next_requirement_url
Percent drop from the peak grade value observed.	INTEGER	calculated.latest_metrics.drop_from_peak_pct
Grade value from the LMS.	STRING	grades[].value
Name of the enrolled course.	STRING	course_name
Risk indicator codes assigned to the enrollment.	ARRAY	calculated.risk_codes
Subject code for the enrolled course.	STRING	course_subject
Total absences recorded for the enrollment.	STRING	total_absences
Identifier for the most recent sync or enrichment run.	STRING	last_run_id
Change in grade value since the previous metric snapshot.	INTEGER	calculated.latest_metrics.delta
Date the current grade was recorded.	STRING	current_grade_date
Timestamp of the student last LMS activity.	STRING	last_lms_activity
Historical grade value changes for the enrollment.	ARRAY	grade_history
Institution identifier from the source or LMS system.	STRING	institution_id
Term identifier for the enrolled section.	STRING	section_term_id
Grading scheme for the enrolled course.	STRING	course_grading
Whether the latest grade is below the passing threshold.	BOOLEAN	calculated.latest_metrics.is_below_passing
Status of the enrolled section.	STRING	section_status
Number of completed course requirements.	INTEGER	progress.requirement_completed_count
Numeric current grade for the enrollment.	INTEGER	current_grade_number
Element451 GUID for the course enrollment record.	STRING	guid
Element451 person identifier for the enrolled student.	STRING	user_id
Total number of course requirements.	INTEGER	progress.requirement_count
Credits associated with this enrollment.	INTEGER	enrollment_credits
Instructor name for the enrolled section.	STRING	section_instructor
Course completion progress for the enrollment.	OBJECT	progress
LMS identifier for the final grade entry.	STRING	final_grade_lms_id
Overall calculated risk level for the enrollment. Distinct values: none, watch, critical, at_risk.	STRING	calculated.risk_level
Instructor email for the enrolled section.	STRING	section_instructor_email
Grade entries synced from the LMS.	ARRAY	grades
Term for the enrolled section.	STRING	section_term
Enrollment status (registered, active, dropped, withdrawn, etc.). Distinct values: registered, active, dropped, withdrawn, completed, inactive, invited, deleted, canceled.	STRING	enrollment_status
GUID of the course section for this enrollment.	STRING	section_guid
Timestamp when the enrollment was imported from an external system.	STRING	imported_at
Number of historical grade metric snapshots available.	INTEGER	calculated.latest_metrics.history_count
School for the enrolled section.	STRING	section_school
Net grade change from first to latest metric snapshot.	INTEGER	calculated.latest_metrics.net_change
Original registration date from the source system.	STRING	original_registered_on
Timestamp when section data on the enrollment was last updated.	STRING	section_updated_at
LMS UUID for the course enrollment.	STRING	lms_uuid
LMS identifier for the current grade entry.	STRING	current_grade_lms_id
Credit value for the enrolled course.	INTEGER	course_credits
Timestamp when the enrollment record was last updated.	STRING	updated_at
Enrollment state in the LMS. Distinct values: active, inactive, completed, invited, deleted, rejected, creation_pending.	STRING	lms_enrollment_state
LMS course offering identifier for the enrollment.	STRING	lms_course_offering_id
Category label for the enrolled course.	STRING	course_category
School identifier for the enrolled student.	STRING	user_school_id
Instruction mode for the enrolled section.	STRING	section_instruction_mode
LMS term code for the enrolled section.	STRING	section_lms_term_code
External system the enrollment was imported from. Distinct values: ethos, canvas, brightspace, blackboard.	STRING	imported_from
Course code copied from the parent course.	STRING	course_code
Hash of calculated metrics used to detect changes.	STRING	calculated.hash
LMS user identifier for the enrolled student.	STRING	lms_user_id
Unique identifier for the Enrollment.	STRING	_id