Skip to content

Fracttal ETL Hub Documentation

List Work Orders Tasks By Document

List Work Orders Tasks By Document

Consult work orders and obtain information on assets, resources and associated tasks.

General information:

Module	Category
`Work Order`	`Read`

Molecule details

Input schema:

Field	Type	Required	Description	Default value	Examples
`description`	Optional[str]	❌	Description.	`None`	-
`id_work_order`	Optional[int]	❌	OT ID.	`None`	-
`id_work_orders_tasks`	Optional[int]	❌	OT task ID.	`None`	-
`id_task`	Optional[int]	❌	Task ID.	`None`	-
`id_item`	Optional[int]	❌	Item/asset ID.	`None`	-
`id_status_work_order`	Optional[int]	❌	OT status ID.	`None`	-
`wo_folio`	Optional[str]	❌	Folio of the OT.	`None`	-
`creation_date`	Optional[str]	❌	Creation date.	`None`	-
`duration`	Optional[int]	❌	Estimated duration.	`None`	-
`initial_date`	Optional[str]	❌	Initial date.	`None`	-
`id_priorities`	Optional[int]	❌	Priority ID.	`None`	-
`priorities_description`	Optional[str]	❌	Priority description.	`None`	-
`final_date`	Optional[str]	❌	End date.	`None`	-
`completed_percentage`	Optional[int]	❌	Percentage completed.	`None`	-
`created_by`	Optional[str]	❌	Created by.	`None`	-
`signature`	Optional[str]	❌	Signature.	`None`	-
`personnel_description`	Optional[str]	❌	Staff description.	`None`	-
`personnel_path_image`	Optional[str]	❌	Staff image path.	`None`	-
`items_log_description`	Optional[str]	❌	Description of the item log.	`None`	-
`done`	Optional[str]	❌	Indicates if it is completed.	`None`	-
`id_request`	Optional[str]	❌	Request ID.	`None`	-
`stop_assets`	Optional[str]	❌	Asset stoppage.	`None`	-
`stop_assets_sec`	Optional[str]	❌	Stop seconds.	`None`	-
`tasks_log_task_type_main`	Optional[str]	❌	Main type of log task.	`None`	-
`parent_description`	Optional[str]	❌	Description of the father.	`None`	-
`trigger_description`	Optional[str]	❌	Trigger description.	`None`	-
`resources_hours`	Optional[str]	❌	Hour resources.	`None`	-
`resources_inventory`	Optional[str]	❌	Inventory resources.	`None`	-
`resources_human_resources`	Optional[str]	❌	Human resources.	`None`	-
`resources_services`	Optional[str]	❌	Service resources.	`None`	-
`cal_date_maintenance`	Optional[str]	❌	Calculated maintenance date.	`None`	-
`real_duration`	Optional[int]	❌	Actual duration.	`None`	-
`date_maintenance`	Optional[str]	❌	Maintenance date.	`None`	-
`user_assigned`	Optional[str]	❌	Assigned user.	`None`	-
`note`	Optional[str]	❌	Note.	`None`	-
`details_signature`	Optional[str]	❌	Signature details.	`None`	-
`responsible_path_signature`	Optional[str]	❌	Route signature of the person in charge.	`None`	-
`validator_path_signature`	Optional[str]	❌	Validator signature path.	`None`	-
`first_date_task`	Optional[str]	❌	First task date.	`None`	-
`costs_center_description`	Optional[str]	❌	Description of the cost center.	`None`	-
`tasks_duration`	Optional[int]	❌	Duration of tasks.	`None`	-
`total_cost_task`	Optional[int]	❌	Total task cost.	`None`	-
`requested_by`	Optional[str]	❌	Requested by.	`None`	-
`groups_description`	Optional[str]	❌	Group description.	`None`	-
`groups_1_description`	Optional[str]	❌	Group description 1.	`None`	-
`groups_2_description`	Optional[str]	❌	Group description 2.	`None`	-
`task_note`	Optional[str]	❌	Homework note.	`None`	-
`id_parent_wo`	Optional[str]	❌	Parent OT ID.	`None`	-
`has_children`	Optional[str]	❌	He has children.	`None`	-
`real_stop_assets_sec`	Optional[str]	❌	Actual stop seconds.	`None`	-
`wo_final_date`	Optional[str]	❌	OT end date.	`None`	-
`is_offline`	Optional[str]	❌	It's offline.	`None`	-
`tasks_log_types_description`	Optional[str]	❌	Description of log types.	`None`	-
`tasks_log_types_2_description`	Optional[str]	❌	Description of log types 2.	`None`	-
`code_create_by`	Optional[str]	❌	Creator code.	`None`	-
`event_date`	Optional[str]	❌	Event date.	`None`	-
`rating`	Optional[int]	❌	Qualification.	`None`	-
`enable_budget`	Optional[str]	❌	Enable budget.	`None`	-
`work_orders_status_custom_description`	Optional[str]	❌	Custom status description.	`None`	-
`review_date`	Optional[str]	❌	Review date.	`None`	-
`code_responsible`	Optional[str]	❌	Responsible code.	`None`	-
`id_parent`	Optional[int]	❌	Father ID.	`None`	-
`id_failure_type`	Optional[str]	❌	Failure type ID.	`None`	-
`types_description`	Optional[str]	❌	Description of types.	`None`	-
`id_failure_cause`	Optional[str]	❌	Failure cause ID.	`None`	-
`causes_description`	Optional[str]	❌	Description of causes.	`None`	-
`id_failure_detection_method`	Optional[str]	❌	ID fault detection method.	`None`	-
`detection_method_description`	Optional[str]	❌	Description of the detection method.	`None`	-
`id_failure_severity`	Optional[str]	❌	Failure severity ID.	`None`	-
`severiry_description`	Optional[str]	❌	Description of severity.	`None`	-
`id_damage_type`	Optional[str]	❌	Damage type ID.	`None`	-
`damages_types_description`	Optional[str]	❌	Description of types of damage.	`None`	-
`caused_damage`	Optional[str]	❌	Damage caused.	`None`	-
`id_group_task`	Optional[str]	❌	Task group ID.	`None`	-
`id_items_availability`	Optional[str]	❌	Item availability ID.	`None`	-
`validated_by_description`	Optional[str]	❌	Description of the validator.	`None`	-
`id_personnel_log`	Optional[int]	❌	Personnel log ID.	`None`	-
`id_contacts_log`	Optional[str]	❌	Contact log ID.	`None`	-
`id_company`	Optional[int]	❌	Company ID.	`None`	-
`item`	Optional[dict]	❌	Object with detailed information of the item/asset.	`None`	-
`resources_inventory_code`	Optional[str]	❌	Inventory resource code.	`None`	-
`resources_human_resources_code`	Optional[str]	❌	Human resources code.	`None`	-
`resources_services_code`	Optional[str]	❌	Service resource code.	`None`	-
`code_wo_related`	Optional[str]	❌	Related OT code.	`None`	-
`id_wo_related`	Optional[str]	❌	Related OT ID.	`None`	-

Notes:

This model includes a nested item object with complete information about the asset associated with the task.