job_constraints_v1
Job constraints refer to specific requirements or limitations to be considered when allocating resources or vehicles to a job. Constraints help ensure that the correct resources or vehicles are assigned to tasks by considering qualifications, availability, skills, attributes, and compliance regulations.
| Column | Data type | Description |
|---|---|---|
| id | VARCHAR(32) | The unique identifier for the job constraint. |
| job_reference | VARCHAR(88) | The reference of the job that is inputted as free text. |
| constraint_type | VARCHAR(72) | Defines a specific type of constraint associated with a job. This field helps in categorising and understanding the different types of constraints. Possible values: 'Job requires resource', 'Job requires resource group', 'Job requires resource skill', 'Job requires vehicle', 'Job requires vehicle group', 'Job requires vehicle attribute'. |
| resource | VARCHAR(150) | The name of the individual who is constrained to perform the job based on their qualification, skill, availability or any other relevant criteria. |
| resource_group | VARCHAR(150) | The resource group that is constrained to perform the job. |
| resource_skill | VARCHAR(150) | Specific attribute or characteristic associated with a resource. It could include qualifications, skills, certifications, or any other relevant information that needs to be considered when assigning resources to a job. |
| vehicle | VARCHAR(150) | The name of the vehicle that is constrained to perform the job based on factors such as capacity, capabilities, or any other relevant criteria. |
| vehicle_group | VARCHAR(150) | The vehicle group that is constrained to perform the job. |
| vehicle_attribute | VARCHAR(150) | Specific attribute or characteristic associated with a vehicle. It could include capacity, capabilities, or any other relevant information that needs to be considered when assigning vehicles to a job. |
| _resource_id | NUMBER(38,0) | The identifier of the resource that is constrained to perform the job. |
| _resource_group_id | NUMBER(38,0) | The identifier of the resource group that is constrained to perform the job. |
| _vehicle_id | NUMBER(38,0) | The identifier of the vehicle that is constrained to perform the job. |
| _vehicle_group_id | NUMBER(38,0) | The identifier of the vehicle group that is constrained to perform the job. |
| _job_id | NUMBER(38,0) | The identifier of the job that the job constraint is associated with. |
| _last_sync_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset of when the job constraint record was last refreshed. |