v_training_certification_user

v_training_certification_user

Purpose

  1. 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 by one personnel

    • Referenced through user_id

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

    • Many certifications issued by one personnel

    • Referenced through issued_by



Table



Column

Type

Description

id

integer

Primary key

client_code

varchar(28)

Organization ID

training_certification_id

integer

Certification reference

issue_date

date

Issue date

expiration_date

date

Expiry date

is_end_date_required

boolean

End date required

certification_name

varchar(100)

Cert name

user_id

integer

User reference

certification_user

varchar(255)

User name

issued_by

integer

Issuer reference

issuer_name

varchar(255)

Issuer name

attachments_count

bigint

Attachment count

is_latest

boolean

Current flag




    • Related Articles

    • EMS Setup - Certification Levels

      Purpose Statement This article demonstrates how to set a user's EMS certification level in order to make the user available for ePCR documentation and ensure NEMSIS compliance requirements are met. Background Information EMS certification levels are ...

    • v_trade_certification

      Purpose Training certification records. Relationships v_training_certification_user: One-to-Many (1:N) One certification type can have many user certifications Referenced through training_certification_id v_personnel: Many-to-One (N:1) Many ...

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

    • Training Module: Release Notes (July 2025)

      Video 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 tracking overall certification ...

    • Editing or Deleting a Certification

      Purpose To demonstrate how to edit or delete a Certification in a Personnel File. Related Articles Tracking and Managing Certifications Video Instructions You will need to access the Personnel Module and not the Training Module for this task. 1. ...