Training Requirements

Training Requirements

FieldTypeDescription
id 🔑INTEGERUnique identifier for this training requirement.
agency_id 🔗INTEGERThe ID of the agency this training requirement belongs to (from application).
agency_human_id 🔗INTEGERThe ID of the agency human (person) this training requirement is for.
application_id 🔗INTEGERThe ID of the application this training requirement is associated with.
training_curriculum_id 🔗INTEGERThe ID of the training curriculum this requirement is for, if applicable.
statusSTRINGThe status of the training requirement (e.g., Complete, Incomplete, Waived, Expired).
due_dateDATEThe date when the training requirement is due, calculated from max_expiration_date or due_at.
training_typeSTRINGThe training type from the curriculum (e.g., initial, renewal, has_expiration_date, events).
training_type_detailedSTRINGThe detailed, human-readable type of training.
training_nameSTRINGThe name of the training requirement, from curriculum name or training name.
created_atTIMESTAMPThe timestamp when the training requirement was created.
updated_atTIMESTAMPThe 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.