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 ...
    • Setting up the ePCR - Certification Levels

      Purpose To demonstrate how to set a user's EMS certification level in order to make the user available for ePCR documentation. Related Articles Personnel: NEMSIS Information Guide Video Directions 1. Navigate to Personnel -> Personnel List. 2. Use ...
    • 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 Assigning Certifications Video Instructions You will need to access the Personnel Module and not the Training ...
    • 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 ...