Training Requirements
Training Requirements
| Field | Type | Description |
|---|---|---|
id đ | INTEGER | Unique identifier for this training requirement. |
agency_id đ | INTEGER | The ID of the agency this training requirement belongs to (from application). |
agency_human_id đ | INTEGER | The ID of the agency human (person) 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- Unique identifier for this training requirement.
Foreign Keys
agency_id- The ID of the agency this training requirement belongs to (from application).agency_human_id- The ID of the agency human (person) 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 2 months ago
