v_training_class

v_training_class

Purpose

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

    • Referenced through training_class_id

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

    • One class can have many objectives

    • Referenced through training_class_id

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

    • Many classes created by one personnel

    • Referenced through created_by




Table



Column

Type

Description

id

integer

Primary key

client_code

varchar(28)

Organization ID

place_name

varchar(255)

Location name

name

varchar(255)

Class name

internal_course_xref_id

varchar(255)

Internal reference

duration_hours

numeric(8,2)

Duration

start_date

date

Start date

end_date

date

End date

start_time

time

Start time

end_time

time

End time

training_category_id

integer

Category reference

description

text

Class description

class_status_code

varchar(16)

Status code

completed_at

timestamp

Completion time

water_usage

numeric(9,1)

Water used

category_name

varchar(100)

Category name

topic_names

text

Topics covered

created_at

timestamp

Creation time

created_by

integer

Creator reference

training_type_ids

integer[]

Type references




    • Related Articles

    • 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_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_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 ...
    • 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 ...
    • Self-Completing a Training Class

      Purpose To explain how to self-complete training objectives. Related Articles Adding a Training Class Creating Training Class from a Template Completing Training Classes Video Directions 1. Click on Admin 2. Click on Roles & Permissions 3. Select a ...