Training Requirements
Training Requirements
| Field | Type | Description |
|---|---|---|
id 🔑 | INTEGER | Legacy row identifier (same value as training_requirement_id). |
training_requirement_id | INTEGER | Unique identifier for this training requirement. |
agency_id 🔗 | INTEGER | The ID of the agency this training requirement belongs to (from application). |
person_id 🔗 | INTEGER | The ID of the person (agency human) this training requirement is for. |
application_id 🔗 | INTEGER | The ID of the application this training requirement is associated with. |
training_curriculum_id 🔗 | INTEGER | The ID of the training curriculum this requirement is for, if applicable. |
status | STRING | The status of the training requirement (e.g., Complete, Incomplete, Waived, Expired). |
due_date | DATE | The date when the training requirement is due, calculated from max_expiration_date or due_at. |
training_type | STRING | The training type from the curriculum (e.g., initial, renewal, has_expiration_date, events). |
training_type_detailed | STRING | The detailed, human-readable type of training. |
training_name | STRING | The name of the training requirement, from curriculum name or training name. |
created_at | TIMESTAMP | The timestamp when the training requirement was created. |
updated_at | TIMESTAMP | The timestamp when the training requirement was last updated. |
Key Information
Primary Keys
id- Legacy row identifier (same value as training_requirement_id).
Foreign Keys
agency_id- The ID of the agency this training requirement belongs to (from application).person_id- The ID of the person (agency human) this training requirement is for.application_id- The ID of the application this training requirement is associated with.training_curriculum_id- The ID of the training curriculum this requirement is for, if applicable.
Updated about 1 month ago
