Skip to main content
GET
Work orders with every field of the records each row points at: asset, assigned team, assigned technician, assigned vendor, contract, department, location, maintenance plan, site, work request.

Headers

Range
string

Limiting and Pagination

Range-Unit
string
default:items

Limiting and Pagination

Prefer
enum<string>

Preference

Available options:
count=none

Query Parameters

id
string
work_order_number
string
title
string
description
string
remarks
string
work_order_type_id
string
work_order_type
string
work_order_type_name
string
is_planned
string
is_emergency
string
priority
string
priority_name
string
priority_rank
string
status
string
status_id
string
state_model_version_id
string
status_label
string
status_category
string
is_open
string
allows_technician_edit
string
allows_parts_consumption
string
allows_labour_entry
string
allows_sla_extension
string
origin
string
reported_by_user_id
string
reported_by_user_name
string
asset_id
string
asset_number
string
asset_name
string
asset_category_id
string
site_id
string
site_code
string
location_id
string
work_order_category_id
string
maintenance_occurrence_id
string
work_request_id
string
planned_start_at
string
planned_end_at
string
due_at
string
response_due_at
string
resolution_due_at
string
actual_start_at
string
actual_end_at
string
actual_duration_minutes
string
closed_at
string
readiness_score
string
is_ready
string
requires_permit
string
permit_required
string
safety_instructions
string
safety_briefing
string
problem_code
string
failure_code
string
work_order_resolution_code_id
string
resolution_code
string
resolution_code_name
string
resolution_notes
string
is_warranty_covered
string
contract_id
string
sla_breached
string
estimated_duration_minutes
string
total_cost
string
total_cost_currency_id
string
labour_cost
string
parts_cost
string
vendor_cost
string
status_is_terminal
string
assigned_vendor_id
string
assigned_vendor_name
string
assigned_team_id
string
assigned_team_name
string
vendor_technician
string
vendor_technician_phone
string
assignees
string
cc
string
task_count
string
mandatory_tasks_outstanding
string
primary_image_file_id
string
asset_image_file_id
string
custom_fields
string
is_unassigned
string
age_days
string
turnaround_minutes
string
turnaround_running
string
checked_in_minutes
string
checked_in_since
string
is_overdue
string
sla_breached_now
string
pending_approval_request_id
string
pending_sla_extension_request_id
string
row_version
string
created_at
string
created_by_id
string
created_by_name
string
created_source
string
updated_at
string
updated_by_id
string
updated_by_name
string
asset__asset_number
string
asset__name
string
asset__serial_number
string
asset__asset_category_code
string
asset__asset_category
string
asset__asset_category_ancestor_ids
string
asset__asset_category_path
string
asset__asset_category_root_code
string
asset__asset_category_root
string
asset__asset_class_code
string
asset__asset_class
string
asset__asset_class_is_default
string
asset__status
string
asset__status_label
string
asset__status_category
string
asset__criticality
string
asset__criticality_rank
string
asset__criticality_response_minutes
string
asset__site_code
string
asset__site_name
string
asset__location_name
string
asset__latitude
string
asset__longitude
string
asset__parent_asset_number
string
asset__manufacturer
string
asset__model_code
string
asset__model_name
string
asset__purchase_date
string
asset__installation_date
string
asset__commissioning_date
string
asset__warranty_expires_on
string
asset__health_score
string
asset__is_retired
string
asset__custodian
string
asset__custodian_email
string
asset__custody_since
string
asset__custom_fields
string
asset__created_at
string
asset__created_by_name
string
asset__updated_at
string
asset__updated_by_name
string
assigned_team__code
string
assigned_team__name
string
assigned_team__description
string
assigned_team__lead_names
string
assigned_team__default_assignee_name
string
assigned_team__is_active
string
assigned_team__member_count
string
assigned_team__members
string
assigned_team__category_ids
string
assigned_team__category_names
string
assigned_team__site_ids
string
assigned_team__site_names
string
assigned_team__work_order_type_ids
string
assigned_team__work_order_type_names
string
assigned_team__role_ids
string
assigned_team__role_names
string
assigned_vendor__vendor_number
string
assigned_vendor__name
string
assigned_vendor__vendor_type
string
assigned_vendor__is_oem
string
assigned_vendor__status
string
assigned_vendor__status_label
string
assigned_vendor__status_category
string
assigned_vendor__email
string
assigned_vendor__phone
string
assigned_vendor__website
string
assigned_vendor__payment_terms_days
string
assigned_vendor__onboarded_on
string
assigned_vendor__approved_on
string
assigned_vendor__performance_score
string
assigned_vendor__usable
string
assigned_vendor__categories
string
assigned_vendor__site_count
string
assigned_vendor__active_contracts
string
assigned_vendor__best_response_minutes
string
assigned_vendor__average_rating
string
assigned_vendor__rating_count
string
assigned_vendor__open_work_orders
string
assigned_vendor__warranty_work_orders
string
assigned_vendor__open_claims
string
assigned_vendor__is_assignable
string
assigned_vendor__compliance_expiring
string
assigned_vendor__warranty_authorisations
string
assigned_vendor__custom_fields
string
assigned_vendor__created_at
string
assigned_vendor__created_by_name
string
assigned_vendor__updated_at
string
assigned_vendor__updated_by_name
string
assigned_worker__worker_number
string
assigned_worker__name
string
assigned_worker__worker_type
string
assigned_worker__max_concurrent_work_orders
string
assigned_worker__is_active
string
assigned_worker__open_work_orders
string
assigned_worker__active_work_orders
string
assigned_worker__overdue_work_orders
string
assigned_worker__planned_minutes_outstanding
string
assigned_worker__skills
string
assigned_worker__email
string
assigned_worker__phone
string
assigned_worker__user_email
string
assigned_worker__user_status
string
assigned_worker__employment_status
string
assigned_worker__employment_start_date
string
assigned_worker__can_travel
string
assigned_worker__travel_radius_km
string
assigned_worker__track_location
string
assigned_worker__site_code
string
assigned_worker__site_name
string
assigned_worker__department_name
string
assigned_worker__team_name
string
assigned_worker__is_team_lead
string
assigned_worker__availability
string
assigned_worker__valid_certifications
string
assigned_worker__certifications_expiring
string
assigned_worker__certifications_lapsed
string
assigned_worker__next_certification_expiry
string
assigned_worker__performance_period_start
string
assigned_worker__performance_period_end
string
assigned_worker__utilisation_rate
string
assigned_worker__first_time_fix_rate
string
assigned_worker__sla_compliance_rate
string
assigned_worker__completed_in_period
string
assigned_worker__custom_fields
string
assigned_worker__created_at
string
assigned_worker__created_by_name
string
assigned_worker__updated_at
string
assigned_worker__updated_by_name
string
contract__contract_number
string
contract__name
string
contract__contract_type
string
contract__contract_type_name
string
contract__contract_category
string
contract__status
string
contract__status_label
string
contract__status_category
string
contract__vendor_number
string
contract__vendor_name
string
contract__site_code
string
contract__site_name
string
contract__start_date
string
contract__end_date
string
contract__signed_on
string
contract__auto_renew
string
contract__renewal_notice_days
string
contract__contract_value
string
contract__covers_parts
string
contract__covers_labour
string
contract__covers_travel
string
contract__requires_authorized_vendor
string
contract__scope
string
contract__exclusions_summary
string
contract__owner_name
string
contract__external_reference
string
contract__notes
string
contract__is_live
string
contract__has_expired
string
contract__days_remaining
string
contract__in_renewal_window
string
contract__named_assets
string
contract__covered_asset_categories
string
contract__visits_included
string
contract__visits_used
string
contract__claims
string
contract__custom_fields
string
contract__created_at
string
contract__created_by_name
string
contract__updated_at
string
contract__updated_by_name
string
department__code
string
department__name
string
department__business_unit_name
string
department__cost_centre_name
string
department__manager_name
string
department__maintenance_manager_name
string
department__is_active
string
department__workers
string
department__assets
string
location__site_code
string
location__parent_name
string
location__location_type
string
location__level_hint
string
location__code
string
location__name
string
location__path
string
location__depth
string
location__latitude
string
location__longitude
string
location__is_active
string
location__allows_direct_filing
string
location__takes_filing
string
location__primary_location_head_name
string
location__alternate_location_heads
string
location__children
string
location__assets
string
location__assets_in_branch
string
maintenance_plan__inspection_template_code
string
maintenance_plan__inspection_template_name
string
maintenance_plan__raises_inspection
string
maintenance_plan__plan_number
string
maintenance_plan__name
string
maintenance_plan__description
string
maintenance_plan__maintenance_type
string
maintenance_plan__maintenance_type_name
string
maintenance_plan__status
string
maintenance_plan__status_label
string
maintenance_plan__status_category
string
maintenance_plan__site_code
string
maintenance_plan__priority_code
string
maintenance_plan__priority_name
string
maintenance_plan__criticality
string
maintenance_plan__trigger_combination
string
maintenance_plan__estimated_duration_minutes
string
maintenance_plan__lead_time_days
string
maintenance_plan__tolerance_days
string
maintenance_plan__sla_response_minutes
string
maintenance_plan__sla_resolution_minutes
string
maintenance_plan__assigned_team_name
string
maintenance_plan__preferred_worker_name
string
maintenance_plan__preferred_vendor_name
string
maintenance_plan__assigned_to_user_name
string
maintenance_plan__end_date
string
maintenance_plan__reminder_days
string
maintenance_plan__use_contract_visits
string
maintenance_plan__requires_permit
string
maintenance_plan__requires_shutdown
string
maintenance_plan__safety_instructions
string
maintenance_plan__instructions
string
maintenance_plan__auto_generate_work_order
string
maintenance_plan__current_version_number
string
maintenance_plan__last_generated_at
string
maintenance_plan__is_active
string
maintenance_plan__asset_count
string
maintenance_plan__asset_category_count
string
maintenance_plan__place_count
string
maintenance_plan__scope_names
string
maintenance_plan__asset_category_codes
string
maintenance_plan__asset_category_names
string
maintenance_plan__asset_names
string
maintenance_plan__place_names
string
maintenance_plan__task_count
string
maintenance_plan__requirement_count
string
maintenance_plan__trigger_count
string
maintenance_plan__frequency
string
maintenance_plan__next_due_at
string
maintenance_plan__work_orders_generated
string
maintenance_plan__custom_fields
string
maintenance_plan__created_at
string
maintenance_plan__created_by_name
string
maintenance_plan__updated_at
string
maintenance_plan__updated_by_name
string
site__code
string
site__name
string
site__timezone
string
site__is_active
string
site__company_name
string
site__business_unit_name
string
site__business_unit_parent_name
string
site__asset_count
string
work_request__request_number
string
work_request__summary
string
work_request__description
string
work_request__status
string
work_request__status_label
string
work_request__status_category
string
work_request__source
string
work_request__category
string
work_request__category_name
string
work_request__reported_severity
string
work_request__severity_rank
string
work_request__suggested_priority_code
string
work_request__suggested_priority_name
string
work_request__asset_number
string
work_request__asset_name
string
work_request__requester_name
string
work_request__discovered_at
string
work_request__triaged_at
string
work_request__rejection_reason
string
work_request__assigned_worker_name
string
work_request__assigned_team_name
string
work_request__assigned_vendor_name
string
work_request__cc
string
work_request__work_order_number
string
work_request__custom_fields
string
work_request__created_at
string
work_request__created_by_name
string
work_request__updated_at
string
work_request__updated_by_name
string
reference_records
string
select
string

Filtering Columns

order
string

Ordering

offset
string

Limiting and Pagination

limit
string

Limiting and Pagination

Response

OK

actual_duration_minutes
integer<integer>
actual_end_at
string<timestamp with time zone>
actual_start_at
string<timestamp with time zone>
age_days
integer<integer>
allows_labour_entry
boolean<boolean>
allows_parts_consumption
boolean<boolean>
allows_sla_extension
boolean<boolean>
allows_technician_edit
boolean<boolean>
asset__asset_category
string<character varying>
Maximum string length: 200
asset__asset_category_ancestor_ids
string[]
asset__asset_category_code
string<character varying>
Maximum string length: 60
asset__asset_category_path
string<text>
asset__asset_category_root
string<character varying>
Maximum string length: 200
asset__asset_category_root_code
string<character varying>
Maximum string length: 60
asset__asset_class
string<character varying>
asset__asset_class_code
string<character varying>
asset__asset_class_is_default
boolean<boolean>
asset__asset_number
string<character varying>
Maximum string length: 80
asset__commissioning_date
string<date>
asset__created_at
string<timestamp with time zone>
asset__created_by_name
string<character varying>
Maximum string length: 200
asset__criticality
string<character varying>
Maximum string length: 40
asset__criticality_rank
integer<smallint>
asset__criticality_response_minutes
integer<integer>
asset__custodian
string<character varying>
asset__custodian_email
string<public.citext>
asset__custody_since
string<date>
asset__custom_fields
string<jsonb>
asset__health_score
number<numeric>
asset__installation_date
string<date>
asset__is_retired
boolean<boolean>
asset__latitude
number<numeric>
asset__location_name
string<character varying>
Maximum string length: 200
asset__longitude
number<numeric>
asset__manufacturer
string<character varying>
Maximum string length: 200
asset__model_code
string<character varying>
Maximum string length: 80
asset__model_name
string<character varying>
Maximum string length: 200
asset__name
string<character varying>
Maximum string length: 250
asset__parent_asset_number
string<character varying>
Maximum string length: 80
asset__purchase_date
string<date>
asset__serial_number
string<character varying>
Maximum string length: 120
asset__site_code
string<character varying>
Maximum string length: 50
asset__site_name
string<character varying>
Maximum string length: 200
asset__status
string<character varying>
Maximum string length: 60
asset__status_category
string<character varying>
Maximum string length: 20
asset__status_label
string<text>
asset__updated_at
string<timestamp with time zone>
asset__updated_by_name
string<character varying>
Maximum string length: 200
asset__warranty_expires_on
string<date>
asset_category_id
string<uuid>

Note: This is a Foreign Key to asset_categories.id.

asset_id
string<uuid>

Note: This is a Foreign Key to asset_contracts.asset_id.

asset_image_file_id
string<uuid>
asset_name
string<character varying>
Maximum string length: 250
asset_number
string<character varying>
Maximum string length: 80
assigned_team__category_ids
string[]
assigned_team__category_names
string[]
assigned_team__code
string<character varying>
Maximum string length: 60
assigned_team__default_assignee_name
string<character varying>
Maximum string length: 200
assigned_team__description
string<text>
assigned_team__is_active
boolean<boolean>
assigned_team__lead_names
string<text>
assigned_team__member_count
integer<bigint>
assigned_team__members
string<jsonb>
assigned_team__name
string<character varying>
Maximum string length: 200
assigned_team__role_ids
string[]
assigned_team__role_names
string[]
assigned_team__site_ids
string[]
assigned_team__site_names
string[]
assigned_team__work_order_type_ids
string[]
assigned_team__work_order_type_names
string[]
assigned_team_id
string<uuid>

Note: This is a Foreign Key to teams.id.

assigned_team_name
string<character varying>
Maximum string length: 200
assigned_vendor__active_contracts
integer<bigint>
assigned_vendor__approved_on
string<date>
assigned_vendor__average_rating
number<numeric>
assigned_vendor__best_response_minutes
integer<integer>
assigned_vendor__categories
string<jsonb>
assigned_vendor__compliance_expiring
integer<bigint>
assigned_vendor__created_at
string<timestamp with time zone>
assigned_vendor__created_by_name
string<character varying>
Maximum string length: 200
assigned_vendor__custom_fields
string<jsonb>
assigned_vendor__email
string<public.citext>
assigned_vendor__is_assignable
boolean<boolean>
assigned_vendor__is_oem
boolean<boolean>
Maximum string length: 250
assigned_vendor__name
string<character varying>
Maximum string length: 200
assigned_vendor__onboarded_on
string<date>
assigned_vendor__open_claims
integer<bigint>
assigned_vendor__open_work_orders
integer<bigint>
assigned_vendor__payment_terms_days
integer<integer>
assigned_vendor__performance_score
number<numeric>
assigned_vendor__phone
string<character varying>
Maximum string length: 40
assigned_vendor__rating_count
integer<bigint>
assigned_vendor__site_count
integer<bigint>
assigned_vendor__status
string<character varying>
Maximum string length: 60
assigned_vendor__status_category
string<character varying>
Maximum string length: 20
assigned_vendor__status_label
string<text>
assigned_vendor__updated_at
string<timestamp with time zone>
assigned_vendor__updated_by_name
string<character varying>
Maximum string length: 200
assigned_vendor__usable
boolean<boolean>
assigned_vendor__vendor_number
string<character varying>
Maximum string length: 60
assigned_vendor__vendor_type
string<character varying>
Maximum string length: 40
assigned_vendor__warranty_authorisations
integer<bigint>
assigned_vendor__warranty_work_orders
integer<bigint>
assigned_vendor__website
string<character varying>
Maximum string length: 250
assigned_vendor_id
string<uuid>

Note: This is a Foreign Key to assignable_vendors.id.

assigned_vendor_name
string<character varying>
Maximum string length: 200
assigned_worker__active_work_orders
integer<bigint>
assigned_worker__availability
string<text>
assigned_worker__can_travel
boolean<boolean>
assigned_worker__certifications_expiring
integer<bigint>
assigned_worker__certifications_lapsed
integer<bigint>
assigned_worker__completed_in_period
integer<integer>
assigned_worker__created_at
string<timestamp with time zone>
assigned_worker__created_by_name
string<character varying>
Maximum string length: 200
assigned_worker__custom_fields
string<jsonb>
assigned_worker__department_name
string<character varying>
Maximum string length: 200
assigned_worker__email
string<public.citext>
assigned_worker__employment_start_date
string<date>
assigned_worker__employment_status
string<character varying>
Maximum string length: 30
assigned_worker__first_time_fix_rate
number<numeric>
assigned_worker__is_active
boolean<boolean>
assigned_worker__is_team_lead
boolean<boolean>
assigned_worker__max_concurrent_work_orders
integer<smallint>
assigned_worker__name
string<character varying>
Maximum string length: 200
assigned_worker__next_certification_expiry
string<date>
assigned_worker__open_work_orders
integer<bigint>
assigned_worker__overdue_work_orders
integer<bigint>
assigned_worker__performance_period_end
string<date>
assigned_worker__performance_period_start
string<date>
assigned_worker__phone
string<character varying>
Maximum string length: 40
assigned_worker__planned_minutes_outstanding
integer<integer>
assigned_worker__site_code
string<character varying>
Maximum string length: 50
assigned_worker__site_name
string<character varying>
Maximum string length: 200
assigned_worker__skills
string<jsonb>
assigned_worker__sla_compliance_rate
number<numeric>
assigned_worker__team_name
string<character varying>
Maximum string length: 200
assigned_worker__track_location
boolean<boolean>
assigned_worker__travel_radius_km
integer<integer>
assigned_worker__updated_at
string<timestamp with time zone>
assigned_worker__updated_by_name
string<character varying>
Maximum string length: 200
assigned_worker__user_email
string<text>
assigned_worker__user_status
string<character varying>
Maximum string length: 30
assigned_worker__utilisation_rate
number<numeric>
assigned_worker__valid_certifications
integer<bigint>
assigned_worker__worker_number
string<character varying>
Maximum string length: 60
assigned_worker__worker_type
string<character varying>
Maximum string length: 40
assignees
string<jsonb>
cc
string<jsonb>
checked_in_minutes
integer<integer>
checked_in_since
string<timestamp with time zone>
closed_at
string<timestamp with time zone>
contract__auto_renew
boolean<boolean>
contract__claims
integer<bigint>
contract__contract_category
string<character varying>
Maximum string length: 30
contract__contract_number
string<character varying>
Maximum string length: 60
contract__contract_type
string<character varying>
Maximum string length: 40
contract__contract_type_name
string<character varying>
Maximum string length: 150
contract__contract_value
number<numeric>
contract__covered_asset_categories
integer<bigint>
contract__covers_labour
boolean<boolean>
contract__covers_parts
boolean<boolean>
contract__covers_travel
boolean<boolean>
contract__created_at
string<timestamp with time zone>
contract__created_by_name
string<character varying>
Maximum string length: 200
contract__custom_fields
string<jsonb>
contract__days_remaining
integer<integer>
contract__end_date
string<date>
contract__exclusions_summary
string<text>
contract__external_reference
string<character varying>
Maximum string length: 120
contract__has_expired
boolean<boolean>
contract__in_renewal_window
boolean<boolean>
contract__is_live
boolean<boolean>
contract__name
string<character varying>
Maximum string length: 200
contract__named_assets
integer<bigint>
contract__notes
string<text>
contract__owner_name
string<character varying>
Maximum string length: 200
contract__renewal_notice_days
integer<integer>
contract__requires_authorized_vendor
boolean<boolean>
contract__scope
string<text>
contract__signed_on
string<date>
contract__site_code
string<character varying>
Maximum string length: 50
contract__site_name
string<character varying>
Maximum string length: 200
contract__start_date
string<date>
contract__status
string<character varying>
Maximum string length: 60
contract__status_category
string<character varying>
Maximum string length: 20
contract__status_label
string<text>
contract__updated_at
string<timestamp with time zone>
contract__updated_by_name
string<character varying>
Maximum string length: 200
contract__vendor_name
string<character varying>
Maximum string length: 200
contract__vendor_number
string<character varying>
Maximum string length: 60
contract__visits_included
integer<bigint>
contract__visits_used
integer<bigint>
contract_id
string<uuid>

Note: This is a Foreign Key to contract_cover.contract_id.

created_at
string<timestamp with time zone>
created_by_id
string<uuid>

Note: This is a Foreign Key to capex_invite_candidates.id.

created_by_name
string<character varying>
Maximum string length: 200
created_source
string<text>
custom_fields
string<jsonb>
department__assets
integer<bigint>
department__business_unit_name
string<character varying>
Maximum string length: 200
department__code
string<character varying>
Maximum string length: 50
department__cost_centre_name
string<character varying>
Maximum string length: 200
department__is_active
boolean<boolean>
department__maintenance_manager_name
string<character varying>
Maximum string length: 200
department__manager_name
string<character varying>
Maximum string length: 200
department__name
string<character varying>
Maximum string length: 200
department__workers
integer<bigint>
description
string<text>
due_at
string<timestamp with time zone>
estimated_duration_minutes
integer<integer>
failure_code
string<character varying>
Maximum string length: 80
id
string<uuid>

Note: This is a Primary Key.

is_emergency
boolean<boolean>
is_open
boolean<boolean>
is_overdue
boolean<boolean>
is_planned
boolean<boolean>
is_ready
boolean<boolean>
is_unassigned
boolean<boolean>
is_warranty_covered
boolean<boolean>
labour_cost
number<numeric>
location__allows_direct_filing
boolean<boolean>
location__alternate_location_heads
string<jsonb>
location__assets
integer<bigint>
location__assets_in_branch
integer<bigint>
location__children
integer<bigint>
location__code
string<character varying>
Maximum string length: 80
location__depth
integer<smallint>
location__is_active
boolean<boolean>
location__latitude
number<numeric>
location__level_hint
integer<smallint>
location__location_type
string<character varying>
Maximum string length: 150
location__longitude
number<numeric>
location__name
string<character varying>
Maximum string length: 200
location__parent_name
string<character varying>
Maximum string length: 200
location__path
string<text>
location__primary_location_head_name
string<character varying>
Maximum string length: 200
location__site_code
string<character varying>
Maximum string length: 50
location__takes_filing
boolean<boolean>
location_id
string<uuid>

Note: This is a Foreign Key to location_settings.id.

maintenance_occurrence_id
string<uuid>

Note: This is a Foreign Key to asset_maintenance_plans.next_occurrence_id.

maintenance_plan__asset_category_codes
string[]
maintenance_plan__asset_category_count
integer<bigint>
maintenance_plan__asset_category_names
string<text>
maintenance_plan__asset_count
integer<bigint>
maintenance_plan__asset_names
string<text>
maintenance_plan__assigned_team_name
string<character varying>
Maximum string length: 200
maintenance_plan__assigned_to_user_name
string<character varying>
Maximum string length: 200
maintenance_plan__auto_generate_work_order
boolean<boolean>
maintenance_plan__created_at
string<timestamp with time zone>
maintenance_plan__created_by_name
string<character varying>
Maximum string length: 200
maintenance_plan__criticality
string<character varying>
Maximum string length: 40
maintenance_plan__current_version_number
integer<integer>
maintenance_plan__custom_fields
string<jsonb>
maintenance_plan__description
string<text>
maintenance_plan__end_date
string<date>
maintenance_plan__estimated_duration_minutes
integer<integer>
maintenance_plan__frequency
string<text>
maintenance_plan__inspection_template_code
string<character varying>
Maximum string length: 60
maintenance_plan__inspection_template_name
string<character varying>
Maximum string length: 250
maintenance_plan__instructions
string<text>
maintenance_plan__is_active
boolean<boolean>
maintenance_plan__last_generated_at
string<timestamp with time zone>
maintenance_plan__lead_time_days
integer<integer>
maintenance_plan__maintenance_type
string<character varying>
Maximum string length: 40
maintenance_plan__maintenance_type_name
string<character varying>
Maximum string length: 150
maintenance_plan__name
string<character varying>
Maximum string length: 250
maintenance_plan__next_due_at
string<timestamp with time zone>
maintenance_plan__place_count
integer<bigint>
maintenance_plan__place_names
string<text>
maintenance_plan__plan_number
string<character varying>
Maximum string length: 60
maintenance_plan__preferred_vendor_name
string<character varying>
Maximum string length: 200
maintenance_plan__preferred_worker_name
string<character varying>
Maximum string length: 200
maintenance_plan__priority_code
string<character varying>
Maximum string length: 40
maintenance_plan__priority_name
string<character varying>
Maximum string length: 150
maintenance_plan__raises_inspection
boolean<boolean>
maintenance_plan__reminder_days
integer<integer>
maintenance_plan__requirement_count
integer<bigint>
maintenance_plan__requires_permit
boolean<boolean>
maintenance_plan__requires_shutdown
boolean<boolean>
maintenance_plan__safety_instructions
string<text>
maintenance_plan__scope_names
string[]
maintenance_plan__site_code
string<character varying>
Maximum string length: 50
maintenance_plan__sla_resolution_minutes
integer<integer>
maintenance_plan__sla_response_minutes
integer<integer>
maintenance_plan__status
string<character varying>
Maximum string length: 60
maintenance_plan__status_category
string<character varying>
Maximum string length: 20
maintenance_plan__status_label
string<text>
maintenance_plan__task_count
integer<bigint>
maintenance_plan__tolerance_days
integer<integer>
maintenance_plan__trigger_combination
string<character varying>
Maximum string length: 10
maintenance_plan__trigger_count
integer<bigint>
maintenance_plan__updated_at
string<timestamp with time zone>
maintenance_plan__updated_by_name
string<character varying>
Maximum string length: 200
maintenance_plan__use_contract_visits
boolean<boolean>
maintenance_plan__work_orders_generated
integer<bigint>
mandatory_tasks_outstanding
integer<bigint>
origin
string<character varying>
Maximum string length: 30
parts_cost
number<numeric>
pending_approval_request_id
string<uuid>
pending_sla_extension_request_id
string<uuid>
permit_required
boolean<boolean>
planned_end_at
string<timestamp with time zone>
planned_start_at
string<timestamp with time zone>
primary_image_file_id
string<uuid>
priority
string<character varying>
Maximum string length: 40
priority_name
string<character varying>
Maximum string length: 150
priority_rank
integer<smallint>
problem_code
string<character varying>
Maximum string length: 80
readiness_score
number<numeric>
reference_records
string<jsonb>
remarks
string<text>
reported_by_user_id
string<uuid>

Note: This is a Foreign Key to capex_invite_candidates.id.

reported_by_user_name
string<character varying>
Maximum string length: 200
requires_permit
boolean<boolean>
resolution_code
string<character varying>
Maximum string length: 60
resolution_code_name
string<character varying>
Maximum string length: 200
resolution_due_at
string<timestamp with time zone>
resolution_notes
string<text>
response_due_at
string<timestamp with time zone>
row_version
integer<bigint>
safety_briefing
string<text>
safety_instructions
string<text>
site__asset_count
integer<bigint>
site__business_unit_name
string<character varying>
Maximum string length: 200
site__business_unit_parent_name
string<character varying>
Maximum string length: 200
site__code
string<character varying>
Maximum string length: 50
site__company_name
string<character varying>
Maximum string length: 200
site__is_active
boolean<boolean>
site__name
string<character varying>
Maximum string length: 200
site__timezone
string<character varying>
Maximum string length: 100
site_code
string<character varying>
Maximum string length: 50
site_id
string<uuid>

Note: This is a Foreign Key to entry_currencies.for_site_id.

sla_breached
boolean<boolean>
sla_breached_now
boolean<boolean>
state_model_version_id
string<uuid>

Note: This is a Foreign Key to state_models.version_id.

status
string<character varying>
Maximum string length: 60
status_category
string<character varying>
Maximum string length: 20
status_id
string<uuid>

Note: This is a Primary Key.

status_is_terminal
boolean<boolean>
status_label
string<text>
task_count
integer<bigint>
title
string<character varying>
Maximum string length: 250
total_cost
number<numeric>
total_cost_currency_id
string<uuid>

Note: This is a Foreign Key to asset_cost_to_keep.currency_id.

turnaround_minutes
integer<integer>
turnaround_running
boolean<boolean>
updated_at
string<timestamp with time zone>
updated_by_id
string<uuid>

Note: This is a Foreign Key to capex_invite_candidates.id.

updated_by_name
string<character varying>
Maximum string length: 200
vendor_cost
number<numeric>
vendor_technician
string<character varying>
Maximum string length: 120
vendor_technician_phone
string<character varying>
Maximum string length: 40
work_order_category_id
string<uuid>

Note: This is a Foreign Key to asset_categories.id.

work_order_number
string<character varying>
Maximum string length: 60
work_order_resolution_code_id
string<uuid>

Note: This is a Foreign Key to work_order_resolution_codes.id.

work_order_type
string<character varying>
Maximum string length: 40
work_order_type_id
string<uuid>

Note: This is a Foreign Key to work_order_types.id.

work_order_type_name
string<character varying>
Maximum string length: 150
work_request__asset_name
string<character varying>
Maximum string length: 250
work_request__asset_number
string<character varying>
Maximum string length: 80
work_request__assigned_team_name
string<character varying>
Maximum string length: 200
work_request__assigned_vendor_name
string<character varying>
Maximum string length: 200
work_request__assigned_worker_name
string<character varying>
Maximum string length: 200
work_request__category
string<character varying>
Maximum string length: 60
work_request__category_name
string<character varying>
Maximum string length: 200
work_request__cc
string<jsonb>
work_request__created_at
string<timestamp with time zone>
work_request__created_by_name
string<character varying>
Maximum string length: 200
work_request__custom_fields
string<jsonb>
work_request__description
string<text>
work_request__discovered_at
string<timestamp with time zone>
work_request__rejection_reason
string<text>
work_request__reported_severity
string<character varying>
Maximum string length: 20
work_request__request_number
string<character varying>
Maximum string length: 60
work_request__requester_name
string<character varying>
Maximum string length: 200
work_request__severity_rank
integer<integer>
work_request__source
string<character varying>
Maximum string length: 40
work_request__status
string<character varying>
Maximum string length: 60
work_request__status_category
string<character varying>
Maximum string length: 20
work_request__status_label
string<text>
work_request__suggested_priority_code
string<character varying>
Maximum string length: 40
work_request__suggested_priority_name
string<character varying>
Maximum string length: 150
work_request__summary
string<character varying>
Maximum string length: 250
work_request__triaged_at
string<timestamp with time zone>
work_request__updated_at
string<timestamp with time zone>
work_request__updated_by_name
string<character varying>
Maximum string length: 200
work_request__work_order_number
string<character varying>
Maximum string length: 60
work_request_id
string<uuid>

Note: This is a Foreign Key to work_requests.id.