Instructor-Led and Virtual-Instructor-Led Training

Entity summary

Name	data_object	Description
Course Offerings	course_offerings	Scheduled instances of a course, with date range, location, capacity, language, and delivery mode.
Course Resources	course_resources	Handouts, supplementary materials, and pre-reads attached to a course offering or session.
Course Sessions	course_sessions	Individual sessions within a multi-day offering, with per-session attendance and instructor assignment.
Instructor Assignments	instructor_assignments	Assignments of an instructor to a session or offering, with role such as primary, assistant, or observer.
Instructors	instructors	Instructor records covering internal trainers, contracted experts, and external vendor instructors, kept separate from employees.
Session Attendances	session_attendances	Per-session attendance roster rows for each learner, serving as evidence of completed required workplace training.
Session Cancellations	session_cancellations	Cancellation or no-show records for an instructor-led session, used to drive waitlist promotion.
Session Rosters	session_rosters	Pre-session enrollment snapshots for an instructor-led session, used as the basis for attendance proof.
Training Room Bookings	training_room_bookings	Reservations of a physical or virtual room and its resources for an instructor-led session.
Virtual Classroom Meetings	virtual_classroom_meetings	Links to external video meetings for a virtual session, carrying the join URL and recording reference.
Waitlist Entries	waitlist_entries	Capacity overflow queue for a course offering, with priority order and a notify-on-seat-open policy.
Course Enrollments	course_enrollments	Per-learner per-course records tracking assigned and due dates, attempts, status, and score.
Courses	courses	Learning units such as e-learning modules, videos, live sessions, or blended programs, with format, duration, and prerequisites.
Employees	employees	Canonical records of people currently or formerly employed, carrying identity, employment metadata, and links to position, manager, and org unit.
Locations	locations	Physical or organizational locations referenced across the system, used to place and group other records.
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.

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;
  course_offerings["Course Offerings"]
  course_sessions["Course Sessions"]
  instructors["Instructors"]
  instructor_assignments["Instructor Assignments"]
  session_attendances["Session Attendances"]
  waitlist_entries["Waitlist Entries"]
  virtual_classroom_meetings["Virtual Classroom Meetings"]
  course_resources["Course Resources"]
  locations["Locations"]
  courses["Courses"]
  course_enrollments["Course Enrollments"]
  employees["Employees"]
  org_units["Org Units"]
  training_room_bookings["Training Room Bookings"]
  session_rosters["Session Rosters"]
  session_cancellations["Session Cancellations"]
  users["Users"]
  courses -->|"scheduled_as"| course_offerings
  course_offerings -->|"comprises"| course_sessions
  course_sessions -->|"staffed_by"| instructor_assignments
  instructors -->|"fulfills"| instructor_assignments
  course_sessions -->|"records"| session_attendances
  course_offerings -->|"queues"| waitlist_entries
  course_sessions -->|"delivered_via"| virtual_classroom_meetings
  course_sessions -->|"provides"| course_resources
  org_units -->|"groups"| employees
  employees -->|"enrolls_in"| course_enrollments
  courses -->|"enrolled_via"| course_enrollments
  employees -->|"learns_via"| course_enrollments
  org_units -->|"rolls_up_to"| org_units
  locations -->|"rolls_up_to"| locations
  users -->|"owns"| courses
  users -->|"instructs_as"| instructors
  users -->|"fulfills_assignment"| instructor_assignments
  users -->|"attends"| session_attendances
  users -->|"waitlisted_for"| waitlist_entries
  employees -->|"is_linked_to"| users
  users -->|"leads"| org_units
  users -->|"authors"| courses
  users -->|"enrolls in"| course_enrollments
  users -->|"assigns"| course_enrollments
  org_units -->|"has members"| users
  locations -->|"houses"| users
  class course_offerings master;
  class course_sessions master;
  class instructors master;
  class instructor_assignments master;
  class session_attendances master;
  class waitlist_entries master;
  class virtual_classroom_meetings master;
  class course_resources master;
  class locations embedded_master;
  class courses embedded_master;
  class course_enrollments embedded_master;
  class employees embedded_master;
  class org_units embedded_master;
  class training_room_bookings master;
  class session_rosters master;
  class session_cancellations master;
  class users platform_builtin;
  style locations stroke-dasharray:5 5;
  style org_units stroke-dasharray:5 5;
  style training_room_bookings stroke-dasharray:5 5;
  style session_rosters stroke-dasharray:5 5;
  style session_cancellations stroke-dasharray:5 5;