v_trade_certification

v_trade_certification

Purpose

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

    • Referenced through created_by


Table



Column

Type

Description

id

integer

Primary key

name

varchar(100)

Certification name

created_by

integer

Creator reference

created_at

timestamp

Creation time

public_name

varchar(255)

Creator name

client_code

varchar(28)

Organization ID

xref_id

varchar(100)

Cross reference





    • Related Articles

    • v_trade

      Purpose Shift trade records. Relationships v_personnel: Many-to-One (N:1) Many trades requested by one personnel Referenced through user_id v_personnel: Many-to-One (N:1) Many trades accepted by one personnel Referenced through accepting_user_id ...

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

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

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

    • v_time_off

      Purpose Personnel time off records. Relationships v_personnel: Many-to-One (N:1) Many time off records link to one personnel Referenced through user_id v_personnel: Many-to-One (N:1) Many time off records approved by one personnel Referenced through ...