| clie_id* |
INT |
Identifier of the customer requesting the service |
| comp_id |
INT |
Identifier of the company requesting the service |
| serv_id* |
INT |
Identifier of the requested service |
| stat_id* |
INT |
Work Order Status ID |
| survey_id |
NVARCHAR (200) |
Account token sent to the client |
| tent_id* |
INT |
Application tenant ID |
| ticket_id |
NVARCHAR (100) |
Ticket number assigned to the work order |
| work_addl_address_info* |
NVARCHAR (1000) |
Additional address information of the place where the service will be performed |
| work_address* |
NVARCHAR (1000) |
Address of the place where the service will be performed |
| work_assignment_type |
INT |
Work order assignment type ID, value (0: Automatic, 1: Manual) |
| work_attendant |
INT |
Identifier of the specialist who will attend the work order |
| work_attention_end_date |
DATETIME |
Work Order End Date |
| work_attention_start_date |
DATETIME |
Start Date of Work Order Care |
| work_change_date |
DATETIME |
Date of last modification made to the work order |
| work_ci |
NVARCHAR (256) |
Configuration item ID related to the work order |
| work_ci_name |
NVARCHAR (512) |
Name of the configuration item related to the work order |
| work_client_cancelded |
BIT |
Identifies if a work order has been canceled by the customer |
| work_contact_email |
NVARCHAR (510) |
Email of the customer requesting the service |
| work_contact_name* |
NVARCHAR (200) |
Name of the customer requesting the service |
| work_contact_phone |
NVARCHAR (64) |
Contact telephone number of the customer requesting the service |
| work_created_by* |
INT |
Identifier of the user who creates the work order |
| work_created_date* |
DATETIME |
Work order creation date |
| work_description* |
NVARCHAR (MAX) |
Work Order Description |
| work_emergency* |
BIT |
Identify if a work order is an emergency |
| work_end_addl_address_info |
NVARCHAR (1000) |
additional information of the final address of the place where the displacement type service will be carried out |
| work_end_address |
NVARCHAR (1000) |
Final address of the place where the displacement service will be carried out |
| work_end_latitude |
DECIMAL |
Final latitude of the place where the displacement service will be performed |
| work_end_longitude |
DECIMAL |
Final length of the place where the displacement type service will be performed |
| work_id* |
INT |
Unique Work Order Identifier is a primary key |
| work_is_imported* |
BIT |
Identifies if the order was created through import bulk uploads |
| work_latitude* |
DECIMAL |
Latitude of the place where the service will be performed |
| work_longitude* |
DECIMAL |
Length of the place where the service will be performed |
| work_max_attention_time |
DATETIME |
Deadline to start work order service |
| work_max_solution_time |
DATETIME |
Deadline to end the work order |
| work_order_expired* |
BIT |
Identifies if the work order’s SLA has already expired |
| work_priority |
INT |
Work order priority type identifier, value (1: Normal, 2: Emergency, 3:Priority) |
| work_provider_id |
INT |
Vendor ID assigned to work order |
| work_restriction_assignment_start_date |
DATETIME |
Constraint assignment setup start date |
| work_restriction_info |
NVARCHAR (MAX) |
Configuring Assignment by Constraint |
| work_scheduler_attention_end_date |
DATETIME |
Work order care end schedule date |
| work_scheduler_attention_start_date |
DATETIME |
Work order service start schedule date |
| work_sla_id* |
INT |
Service level agreement ID assigned to work order |
| work_sub_state_id |
INT |
Work order sub-status ID |
| work_subject* |
NVARCHAR (200) |
Work Order Subject |
| work_tentative_attention_end_date |
DATETIME |
Tentative End Date of Work Order Care |
| work_tentative_attention_start_date |
DATETIME |
Tentative Start Date of Work Order Care |
| work_tentative_travel_start_date |
DATETIME |
Tentative start date of the specialist’s travel |
| work_token_assistme |
NVARCHAR (100) |
Token for displaying work order in AssistMe end-user console |
| work_travel_start_date |
DATETIME |
Start date of the specialist’s travel |
| work_version* |
INT |
Number of modifications made to the work order |
| work_zone_id |
INT |
Identifier of the zone assigned to the work order |
