Person Personnel Certifications
Overview
The PersonnelCertification entity represents certifications held by personnel, ensuring that employees meet certain
qualifications or standards for their roles. This table is linked to individual personnel records, associating specific
certifications with individuals.
Table Structure
The following table outlines the SQL columns for the person_personnel_certifications table, providing a brief description of
each, along with sample data where applicable.
| Column | Type | Description | Example |
|---|---|---|---|
person_id | String (ULID) | References the Person this entry is associated with. See personnel. | 01JAP8RJBN-8ZTPXSGY-J9GSDPE1 |
certification_id | String (ULID) | References the specific PersonnelCertification within the group. See personnel_certifications. | 01JAP8R5RT-3FPXQABY-7KQZT6VF |
Field Details
name
The name field is required and unique for each certification. Examples include "Safety Training" or "Forklift
Operation." This allows certifications to be consistently referenced across personnel records.
description
An optional field for providing additional details about the certification, such as the scope, level, or expiration requirements.