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 ...

    • Frequently Asked Questions - Training

      Certificate Management How do I upload a training certificate to a personnel record? For those with the proper permissions to edit personnel should navigate to the personnel module and from the personnel list filter to the person to edit. Select the ...

    • 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 ...