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 Setup: Class Import

      Video Purpose Statement The Class Imports feature allows administrators and training officers to bulk upload training classes using a standardized spreadsheet format. This process streamlines the creation of multiple training classes at once, saving ...

    • Training Module: Adding a Class

      Purpose To explain how to add a class to the Training Module. Related Articles Creating a Training Class from a Template Completing Training Classes Self Completing Training Objectives Video Instructions 1. Navigate to the Training Module and click ...

    • v_training_instructor

      Purpose Training class instructor records. Relationships v_training_class: Many-to-One (N:1) Many instructors link to one class Referenced through training_class_id v_personnel: Many-to-One (N:1) Many instruction records link to one personnel ...