v_training_class_attendee

v_training_class_attendee

Purpose

  1. Training class attendance records.

Relationships

  • v_training_class: Many-to-One (N:1)

    • Many attendees link to one class

    • Referenced through training_class_id

  • v_personnel: Many-to-One (N:1)

    • Many attendance records link to one personnel

    • Referenced through user_id

  • v_training_class_attendee_objective: One-to-Many (1:N)

    • One attendance record can have many objectives

    • Referenced through training_class_attendee_id



Table



Column

Type

Description

id

integer

Primary key

client_code

varchar(28)

Organization ID

training_class_id

integer

Class reference

user_id

integer

User reference

attendee_name

text

Attendee name

objective_names

text

Objectives met

created_by

integer

Creator reference

created_at

timestamp

Creation time

training_completed_hours

numeric

Hours completed




    • Related Articles

    • v_training_class_attendee_objective

      Purpose Training objective completion records. Relationships v_training_class_attendee: Many-to-One (N:1) Many objectives link to one attendance record Referenced through training_class_attendee_id v_training_class: Many-to-One (N:1) Many objectives ...

    • v_training_class

      Purpose Training class records. Relationships v_training_class_attendee: One-to-Many (1:N) One class can have many attendees Referenced through training_class_id v_training_class_instructor: One-to-Many (1:N) One class can have many instructors ...

    • Training Set-Up: Courses vs Classes

      Understanding Courses vs. Classes in the Training Module Purpose Statement The Training Module distinguishes between "Courses" and "Classes" to streamline training management across your department. Courses serve as reusable templates that establish ...

    • Training: Use Course vs Assign Course

      Purpose Statement The Training module in First Due provides two distinct options for adding courses to your training program: Use Course and Assign Course. Understanding the difference between these options ensures you select the appropriate method ...

    • Training Setup: Class Import

      Purpose Statement The Class Import section within the Training Module Setup allows administrators to efficiently bulk import multiple training classes using a standardized spreadsheet format. This feature streamlines the process of adding numerous ...