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

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

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

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

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

    • Deletion of Personnel and User Records

      New Guidelines for Deleting Personnel and Users in First Due We have implemented new guidelines regarding the deletion of personnel and users within the First Due platform. Deletion of Personnel and User Accounts Clients can now delete personnel ...