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