Course Delivery

Entity summary

Name	data_object	Description
Assessment Attempts	assessment_attempts	Per-learner, per-attempt records of an assessment: start time, score, pass or fail, and time on task, retained as compliance evidence.
Assessment Questions	assessment_questions	Item-bank questions with their stem, answer choices, scoring, and metadata for randomization.
cmi5 Assignable Units	cmi5_assignable_units	Assignable units in the cmi5 standard, launched against a learning record store as the modern successor to SCORM.
Course Assessments	course_assessments	Quiz or exam definitions tied to a course or lesson, with passing score and attempt policy.
Course Catalogs	course_catalogs	Scoped catalog views surfacing a subset of courses to a specific audience, branch, or domain.
Course Categories	course_categories	Hierarchical taxonomy for browsing and reporting on the course catalog.
Course Completions	course_completions	Terminal completion records per learner per course version, marking the course as finished.
Course Discussions	course_discussions	Forum-style discussion threads attached to a course or lesson, supporting collaborative learning.
Course Enrollments	course_enrollments	Per-learner per-course records tracking assigned and due dates, attempts, status, and score.
Course Modules	course_modules	Units within a course that group related lessons, supporting completion tracking below course level.
Course Ratings	course_ratings	Numeric ratings per learner per course, feeding aggregate analytics.
Course Reviews	course_reviews	Learner-authored qualitative reviews of a course written after completion.
Course Tags	course_tags	Free-form tags alongside categories that support faceted search of courses.
Course Versions	course_versions	Versioned snapshots of a course's content, required to record which version each learner completed for compliance.
Courses	courses	Learning units such as e-learning modules, videos, live sessions, or blended programs, with format, duration, and prerequisites.
Learning Content Assets	learning_content_assets	Reusable content assets (video, PDF, image, audio) referenced by lessons and modules.
Learning Records	learning_records	Granular completion events for a course or activity (actor, verb, object, result, timestamp) feeding skill profiles and certifications.
Lessons	lessons	Individual lessons inside a course module: a video, document, SCORM block, or live activity.
LRS Statement Endpoints	lrs_statement_endpoints	External Learning Record Store endpoints that xAPI learning statements are routed to.
Observation Checklist Results	observation_checklist_results	Scored learner results against observation checklists, with observer signoff.
Observation Checklists	observation_checklists	On-the-job competency checklists that an observer scores against for field-skill assessment.
Question Banks	question_banks	Reusable pools of assessment questions independent of any single test, drawn from for randomized quizzes and recertification exams.
Quiz Responses	quiz_responses	Item-level learner responses to quiz questions, captured for per-question review and psychometric analysis.
SCORM Packages	scorm_packages	Imported e-learning content packages in standard formats, carrying the content manifest and runtime tracking state.
xAPI Statements	xapi_statements	Experience-API event log entries capturing actor-verb-object learning activity inside or outside the learning system.
Cost Centers	cost_centers	Organizational units for cost allocation, with code, manager, hierarchy, and currency, driving variance and departmental reporting.
Employees	employees	Canonical records of people currently or formerly employed, carrying identity, employment metadata, and links to position, manager, and org unit.
Org Units	org_units	Nodes in the organizational hierarchy such as divisions, departments, and teams, with manager, cost center alignment, geographic scope, and parent-child links.
Positions	hcm_positions	Approved org slots with role definition, cost center, reporting line, location, and FTE allocation. Each can be open, filled, or eliminated.

flowchart TD
  classDef master fill:#d4f4dd,stroke:#27ae60,color:#0b3d20;
  classDef embedded_master fill:#fff4cc,stroke:#c79100,color:#5b4500;
  classDef platform_builtin fill:#e0e0e0,stroke:#424242,color:#1a1a1a;
  org_units["Org Units"]
  courses["Courses"]
  course_enrollments["Course Enrollments"]
  learning_records["Learning Records"]
  employees["Employees"]
  hcm_positions["Positions"]
  cost_centers["Cost Centers"]
  course_versions["Course Versions"]
  course_modules["Course Modules"]
  lessons["Lessons"]
  learning_content_assets["Learning Content Assets"]
  scorm_packages["SCORM Packages"]
  xapi_statements["xAPI Statements"]
  course_completions["Course Completions"]
  course_assessments["Course Assessments"]
  assessment_questions["Assessment Questions"]
  assessment_attempts["Assessment Attempts"]
  quiz_responses["Quiz Responses"]
  course_categories["Course Categories"]
  course_tags["Course Tags"]
  course_catalogs["Course Catalogs"]
  course_discussions["Course Discussions"]
  course_reviews["Course Reviews"]
  course_ratings["Course Ratings"]
  question_banks["Question Banks"]
  cmi5_assignable_units["cmi5 Assignable Units"]
  lrs_statement_endpoints["LRS Statement Endpoints"]
  observation_checklists["Observation Checklists"]
  observation_checklist_results["Observation Checklist Results"]
  users["Users"]
  courses -->|"has_version"| course_versions
  course_versions -->|"contains"| course_modules
  course_modules -->|"contains"| lessons
  lessons -->|"uses"| learning_content_assets
  course_versions -->|"imports"| scorm_packages
  course_completions -->|"records_completion_of"| course_versions
  course_enrollments -->|"yields"| course_completions
  course_assessments -->|"contains"| assessment_questions
  course_assessments -->|"attempted_by"| assessment_attempts
  assessment_attempts -->|"produces"| quiz_responses
  courses -->|"classified_as"| course_categories
  courses -->|"tagged_with"| course_tags
  course_catalogs -->|"lists"| courses
  courses -->|"reviewed_via"| course_reviews
  courses -->|"rated_via"| course_ratings
  courses -->|"discussed_in"| course_discussions
  org_units -->|"groups"| employees
  org_units -->|"contains"| hcm_positions
  hcm_positions -->|"is_filled_by"| employees
  cost_centers -->|"funds"| org_units
  employees -->|"enrolls_in"| course_enrollments
  org_units -->|"maps_to"| cost_centers
  courses -->|"enrolled_via"| course_enrollments
  course_enrollments -->|"produces"| learning_records
  cost_centers -->|"funds"| course_enrollments
  employees -->|"reflects"| learning_records
  employees -->|"fills"| hcm_positions
  employees -->|"learns_via"| course_enrollments
  org_units -->|"rolls_up_to"| org_units
  users -->|"owns"| courses
  users -->|"attempts"| assessment_attempts
  users -->|"answers"| quiz_responses
  users -->|"completes"| course_completions
  users -->|"posts_in"| course_discussions
  users -->|"authors"| course_reviews
  users -->|"rates_via"| course_ratings
  employees -->|"is_linked_to"| users
  users -->|"manages"| hcm_positions
  users -->|"leads"| org_units
  users -->|"owns"| cost_centers
  users -->|"authors"| courses
  users -->|"enrolls in"| course_enrollments
  users -->|"assigns"| course_enrollments
  users -->|"earns"| learning_records
  org_units -->|"has members"| users
  class org_units embedded_master;
  class courses master;
  class course_enrollments master;
  class learning_records master;
  class employees embedded_master;
  class hcm_positions embedded_master;
  class cost_centers embedded_master;
  class course_versions master;
  class course_modules master;
  class lessons master;
  class learning_content_assets master;
  class scorm_packages master;
  class xapi_statements master;
  class course_completions master;
  class course_assessments master;
  class assessment_questions master;
  class assessment_attempts master;
  class quiz_responses master;
  class course_categories master;
  class course_tags master;
  class course_catalogs master;
  class course_discussions master;
  class course_reviews master;
  class course_ratings master;
  class question_banks master;
  class cmi5_assignable_units master;
  class lrs_statement_endpoints master;
  class observation_checklists master;
  class observation_checklist_results master;
  class users platform_builtin;
  style org_units stroke-dasharray:5 5;
  style hcm_positions stroke-dasharray:5 5;
  style cost_centers stroke-dasharray:5 5;
  style question_banks stroke-dasharray:5 5;
  style cmi5_assignable_units stroke-dasharray:5 5;
  style lrs_statement_endpoints stroke-dasharray:5 5;
  style observation_checklists stroke-dasharray:5 5;
  style observation_checklist_results stroke-dasharray:5 5;