v_training_certification_user
Purpose
- User training certification records.
Relationships
v_training_certification: Many-to-One (N:1)
v_personnel: Many-to-One (N:1)
v_personnel: Many-to-One (N:1)
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 ...
Training Setup: List Configuration
Video Purpose Statement The List Configuration area in Training Setup allows administrators to define and manage reusable lists that appear when creating or editing training classes. These lists ensure consistency, improve efficiency, and reduce ...
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 ...
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 ...