v_training_instructor

v_training_instructor

Purpose

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

    • Referenced through instructor_id


Table



Column

Type

Description

id

integer

Primary key

client_code

varchar(28)

Organization ID

training_class_id

integer

Class reference

instructor_type_id

integer

Type reference

instructor_id

integer

Instructor reference

instructor_name

varchar(255)

Instructor name

instructor_external_id

integer

External reference

instructor_external_name

varchar(100)

External name

instructor_type

varchar(100)

Instructor type

class_name

varchar(255)

Class name

is_external

boolean

External flag




    • Related Articles

    • 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 Module Setup: Adding an Instructor Type

      Purpose To explain how to add an Instructor Type within the Instructor Type Section of the Training Module Setup. TIP: Examples of Instructor Types include: Lead Instructor Co-Instructor Evaluator Safety Officer Observer Assessor Coordinator Related ...

    • v_training_class_attendee

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

    • v_training_certification_user

      Purpose User training certification records. Relationships v_training_certification: Many-to-One (N:1) Many user certs link to one certification type Referenced through training_certification_id v_personnel: Many-to-One (N:1) Many certifications held ...

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