v_training_class_attendee_objective

v_training_class_attendee_objective

Purpose

  1. 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 link to one class

    • Referenced through training_class_id



Table



Column

Type

Description

id

integer

Primary key

client_code

varchar(28)

Organization ID

hours

numeric(8,2)

Hours spent

training_objective_id

integer

Objective reference

training_class_attendee_id

integer

Attendee reference

training_class_id

integer

Class reference

attendee_name

text

Attendee name

objective_name

varchar(255)

Objective name

description

text

Description

class_name

varchar(255)

Class name

standards

text

Standards met

certifications

text

Related certs

is_enabled

boolean

Active status

is_completed

boolean

Completion status

completed_at

timestamp

Completion time




    • 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

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

    • Training Module: Release Notes (July 2025)

      ? Video Video will be coming soon ✨ New Features Course-Based Certification Requirements What: Training admins can now create certifications based on course completion instead of individual objectives. Why: Offers greater flexibility and clarity in ...