| Name | Description | Type | Additional information |
|---|---|---|---|
| id |
Primary Key |
globally unique identifier | |
| id2 |
Internal ID (numeric). Will be used if reference_back_office is empty |
integer | |
| reference_back_office |
The Id/Ref of the back office for this job |
string |
Max length: 50 |
| _parent_id |
Reference to a parent job (in case of Multi Job) |
globally unique identifier | |
| job_type_id |
Foreign key of job type for this job |
globally unique identifier | |
| job_type_name |
Type of the job (jobs.job_type_id=>job_type.name) |
string |
Max length: 50 |
| job_priority_id |
Foreign key of job priority for this job |
globally unique identifier | |
| job_priority_name |
Priority of the job (jobs.job_priority_id=>job_priority.name) |
string |
Max length: 50 |
| job_status_id |
Foreign key of job status for this job |
globally unique identifier | |
| job_status_name |
Status of the job (jobs.job_status_id=>job_status.name) |
string |
Max length: 50 |
| name |
Name of the job |
string |
Max length: 50 |
| nb_notes | integer | ||
| description |
Description of the job |
string |
Max length: 50 |
| date_closed |
Date+time job goes to completed |
date | |
| date_create |
Date create |
date | |
| date_update |
Date update |
date | |
| db_address_id |
Foreign key of db_address if the address of the job is different than the one of the project (or the main company) |
globally unique identifier | |
| contact_id |
Foreign key of contact if the main contact of the job is different than the one of the project |
globally unique identifier | |
| requested_by_contact_id |
Foreign key of contact to specify why contact of the requested_company_id makes the request |
globally unique identifier | |
| earliest_date_plannable |
If there is a minimum date for the planning (Not Before) |
date | |
| due_date |
Deadline of Max date for the planning (Not After) |
date | |
| project_shutdown_consequence |
Consequence of the installation is shut down (CEO has no air cooling anymore,..) |
string |
Max length: 50 |
| suggested_date_start |
Suggested date+time start (used for planning) |
date | |
| source_db_table_id |
Source Table of the entity that generate this jobs (like a task) |
globally unique identifier | |
| source_db_table_name |
Source Table of the entity that generate this jobs (like a task) in a string field |
string | |
| source_id_in_table |
Source ID of the entity that generate this jobs (like a task.id) |
globally unique identifier | |
| created_by_user_firstname |
User.firstname that created the job |
string |
Max length: 50 |
| created_by_user_lastname |
User.lastname that created the job |
string |
Max length: 50 |
| updated_by_user_firstname |
User.firstname that last updated the job |
string |
Max length: 50 |
| updated_by_user_lastname |
User.lastname that last updated the job |
string |
Max length: 50 |
| project_id |
Foreign key of project that owns this job |
globally unique identifier | |
| project_id2 |
Project Internal ID (numeric). Will be used if reference_back_office is empty |
integer | |
| project_parent_id |
Project Parent in case of project hierachy (child/parent) |
globally unique identifier | |
| project_location |
Additional text to describe the location |
string |
Max length: 50 |
| project_reference_back_office |
The Project Id/Ref of the back office for this project/installation |
string |
Max length: 50 |
| project_name |
Project name |
string |
Max length: 50 |
| project_serial_number |
Project Serial Number |
string |
Max length: 50 |
| project_contact_firstname |
Project main contact firstname |
string |
Max length: 50 |
| project_contact_lastname |
Project main contact lastname |
string |
Max length: 50 |
| equipment_model_id |
Foreign key of equipment model of the project |
globally unique identifier | |
| equipment_model_name |
Equipment model name (translated) of the project (jobs.equipment_model_id=>equipment_model.name) |
string |
Max length: 50 |
| equipment_family_id |
Foreign key of equipment family of the project |
globally unique identifier | |
| equipment_family_name |
Equipment family name (translated) of the project (jobs.equipment_family_id=>equipment_family.name) |
string |
Max length: 50 |
| equipment_brand_id | globally unique identifier | ||
| equipment_brand_name |
Equipment brand name (translated) of the project (equipment_model.equipment_brand_id=>equipment_brand.name) |
string |
Max length: 50 |
| company_code |
Company code that owns the project (jobs.project_id=>project.company_id=>company.code) |
string |
Max length: 50 |
| company_name |
Company name of the company that owns the project (jobs.project_id=>project.company_id=>company.name) |
string |
Max length: 50 |
| db_address_street |
Address Street of the job |
string |
Max length: 50 |
| db_address_street_number |
Address Street Number of the job |
string |
Max length: 50 |
| db_address_zip |
Address Zip code of the job |
string |
Max length: 50 |
| db_address_city |
Address City of the job |
string |
Max length: 50 |
| db_address_country_name |
Address Country Name of the job |
string |
Max length: 50 |
| db_address_country_code |
Address Country code of the job |
string |
Max length: 50 |
| db_address_phone |
Address Phone number of the job |
string |
Max length: 50 |
| db_address_email |
Address Email of the job |
string |
Max length: 50 |
| first_planning_userfullname |
Technician fullanme of the first planning |
string | |
| root_parent_id | globally unique identifier | ||
| has_child | boolean | ||
| first_planning_date |
Date+Time of the first planning |
date | |
| date_reported_by_company |
Date+time when company reported the problem |
date | |
| customer_reference |
Reference of this job for the customer |
string |
Max length: 50 |
| contact_fullname |
Contact fullname of the job |
string |
Max length: 50 |
| contact_phone |
Contact Phone number of the job |
string |
Max length: 50 |
| contact_mobile |
Contact Cellphone number of the job |
string |
Max length: 50 |
| contact_email |
Contact Email of the job |
string |
Max length: 50 |
| modified_dateutc |
Readonly system field managed by database, filled with GetUtcDate when adding,updating |
date | |
| dateutc_create |
auto filled when task is created |
date | |
| dateutc_max_sla_resolution |
dateutc_max_sla_resolution |
date | |
| dateutc_max_sla_hands_on_machine |
dateutc_max_sla_hands_on_machine |
date | |
| dateutc_max_sla_contact |
dateutc_max_sla_contact |
date | |
| dateutc_in_progress |
auto filled as soon as the jobs receive the status "in progress |
date | |
| job_reference |
The job reference, if reference_back_office is not null, then it is used else using id2 |
string | |
| dateutc_closed |
auto filled when jobs is closed or cancelled (based on job_approval.date_generated converted in utc |
date |
