Skip to main content
GET
Maintenance plans with every field of the records each row points at: assigned team, preferred technician, preferred vendor, site.

Headers

Range
string

Limiting and Pagination

Range-Unit
string
default:items

Limiting and Pagination

Prefer
enum<string>

Preference

Available options:
count=none

Query Parameters

inspection_template_id
string
inspection_template_code
string
inspection_template_name
string
raises_inspection
string
id
string
plan_number
string
name
string
description
string
work_order_type_id
string
maintenance_type
string
maintenance_type_name
string
status
string
status_label
string
status_category
string
site_id
string
site_code
string
work_order_priority_id
string
priority_code
string
priority_name
string
criticality
string
trigger_combination
string
estimated_duration_minutes
string
lead_time_days
string
tolerance_days
string
sla_response_minutes
string
sla_resolution_minutes
string
assigned_team_id
string
assigned_team_name
string
preferred_worker_id
string
preferred_worker_name
string
preferred_vendor_id
string
preferred_vendor_name
string
assigned_to_user_id
string
assigned_to_user_name
string
end_date
string
reminder_days
string
use_contract_visits
string
requires_permit
string
requires_shutdown
string
safety_instructions
string
instructions
string
auto_generate_work_order
string
current_version_number
string
last_generated_at
string
is_active
string
asset_count
string
asset_category_count
string
place_count
string
scope_names
string
asset_category_codes
string
asset_category_names
string
asset_names
string
place_names
string
task_count
string
requirement_count
string
trigger_count
string
frequency
string
next_due_at
string
work_orders_generated
string
custom_fields
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
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
preferred_vendor__vendor_number
string
preferred_vendor__name
string
preferred_vendor__vendor_type
string
preferred_vendor__is_oem
string
preferred_vendor__status
string
preferred_vendor__status_label
string
preferred_vendor__status_category
string
preferred_vendor__email
string
preferred_vendor__phone
string
preferred_vendor__website
string
preferred_vendor__payment_terms_days
string
preferred_vendor__onboarded_on
string
preferred_vendor__approved_on
string
preferred_vendor__performance_score
string
preferred_vendor__usable
string
preferred_vendor__categories
string
preferred_vendor__site_count
string
preferred_vendor__active_contracts
string
preferred_vendor__best_response_minutes
string
preferred_vendor__average_rating
string
preferred_vendor__rating_count
string
preferred_vendor__open_work_orders
string
preferred_vendor__warranty_work_orders
string
preferred_vendor__open_claims
string
preferred_vendor__is_assignable
string
preferred_vendor__compliance_expiring
string
preferred_vendor__warranty_authorisations
string
preferred_vendor__custom_fields
string
preferred_vendor__created_at
string
preferred_vendor__created_by_name
string
preferred_vendor__updated_at
string
preferred_vendor__updated_by_name
string
preferred_worker__worker_number
string
preferred_worker__name
string
preferred_worker__worker_type
string
preferred_worker__max_concurrent_work_orders
string
preferred_worker__is_active
string
preferred_worker__open_work_orders
string
preferred_worker__active_work_orders
string
preferred_worker__overdue_work_orders
string
preferred_worker__planned_minutes_outstanding
string
preferred_worker__skills
string
preferred_worker__email
string
preferred_worker__phone
string
preferred_worker__user_email
string
preferred_worker__user_status
string
preferred_worker__employment_status
string
preferred_worker__employment_start_date
string
preferred_worker__can_travel
string
preferred_worker__travel_radius_km
string
preferred_worker__track_location
string
preferred_worker__site_code
string
preferred_worker__site_name
string
preferred_worker__department_name
string
preferred_worker__team_name
string
preferred_worker__is_team_lead
string
preferred_worker__availability
string
preferred_worker__valid_certifications
string
preferred_worker__certifications_expiring
string
preferred_worker__certifications_lapsed
string
preferred_worker__next_certification_expiry
string
preferred_worker__performance_period_start
string
preferred_worker__performance_period_end
string
preferred_worker__utilisation_rate
string
preferred_worker__first_time_fix_rate
string
preferred_worker__sla_compliance_rate
string
preferred_worker__completed_in_period
string
preferred_worker__custom_fields
string
preferred_worker__created_at
string
preferred_worker__created_by_name
string
preferred_worker__updated_at
string
preferred_worker__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
reference_records
string
select
string

Filtering Columns

order
string

Ordering

offset
string

Limiting and Pagination

limit
string

Limiting and Pagination

Response

OK

asset_category_codes
string[]
asset_category_count
integer<bigint>
asset_category_names
string<text>
asset_count
integer<bigint>
asset_names
string<text>
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_to_user_id
string<uuid>

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

assigned_to_user_name
string<character varying>
Maximum string length: 200
auto_generate_work_order
boolean<boolean>
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>
criticality
string<character varying>
Maximum string length: 40
current_version_number
integer<integer>
custom_fields
string<jsonb>
description
string<text>
end_date
string<date>
estimated_duration_minutes
integer<integer>
frequency
string<text>
id
string<uuid>

Note: This is a Primary Key.

inspection_template_code
string<character varying>
Maximum string length: 60
inspection_template_id
string<uuid>

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

inspection_template_name
string<character varying>
Maximum string length: 250
instructions
string<text>
is_active
boolean<boolean>
last_generated_at
string<timestamp with time zone>
lead_time_days
integer<integer>
maintenance_type
string<character varying>
Maximum string length: 40
maintenance_type_name
string<character varying>
Maximum string length: 150
name
string<character varying>
Maximum string length: 250
next_due_at
string<timestamp with time zone>
place_count
integer<bigint>
place_names
string<text>
plan_number
string<character varying>
Maximum string length: 60
preferred_vendor__active_contracts
integer<bigint>
preferred_vendor__approved_on
string<date>
preferred_vendor__average_rating
number<numeric>
preferred_vendor__best_response_minutes
integer<integer>
preferred_vendor__categories
string<jsonb>
preferred_vendor__compliance_expiring
integer<bigint>
preferred_vendor__created_at
string<timestamp with time zone>
preferred_vendor__created_by_name
string<character varying>
Maximum string length: 200
preferred_vendor__custom_fields
string<jsonb>
preferred_vendor__email
string<public.citext>
preferred_vendor__is_assignable
boolean<boolean>
preferred_vendor__is_oem
boolean<boolean>
Maximum string length: 250
preferred_vendor__name
string<character varying>
Maximum string length: 200
preferred_vendor__onboarded_on
string<date>
preferred_vendor__open_claims
integer<bigint>
preferred_vendor__open_work_orders
integer<bigint>
preferred_vendor__payment_terms_days
integer<integer>
preferred_vendor__performance_score
number<numeric>
preferred_vendor__phone
string<character varying>
Maximum string length: 40
preferred_vendor__rating_count
integer<bigint>
preferred_vendor__site_count
integer<bigint>
preferred_vendor__status
string<character varying>
Maximum string length: 60
preferred_vendor__status_category
string<character varying>
Maximum string length: 20
preferred_vendor__status_label
string<text>
preferred_vendor__updated_at
string<timestamp with time zone>
preferred_vendor__updated_by_name
string<character varying>
Maximum string length: 200
preferred_vendor__usable
boolean<boolean>
preferred_vendor__vendor_number
string<character varying>
Maximum string length: 60
preferred_vendor__vendor_type
string<character varying>
Maximum string length: 40
preferred_vendor__warranty_authorisations
integer<bigint>
preferred_vendor__warranty_work_orders
integer<bigint>
preferred_vendor__website
string<character varying>
Maximum string length: 250
preferred_vendor_id
string<uuid>

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

preferred_vendor_name
string<character varying>
Maximum string length: 200
preferred_worker__active_work_orders
integer<bigint>
preferred_worker__availability
string<text>
preferred_worker__can_travel
boolean<boolean>
preferred_worker__certifications_expiring
integer<bigint>
preferred_worker__certifications_lapsed
integer<bigint>
preferred_worker__completed_in_period
integer<integer>
preferred_worker__created_at
string<timestamp with time zone>
preferred_worker__created_by_name
string<character varying>
Maximum string length: 200
preferred_worker__custom_fields
string<jsonb>
preferred_worker__department_name
string<character varying>
Maximum string length: 200
preferred_worker__email
string<public.citext>
preferred_worker__employment_start_date
string<date>
preferred_worker__employment_status
string<character varying>
Maximum string length: 30
preferred_worker__first_time_fix_rate
number<numeric>
preferred_worker__is_active
boolean<boolean>
preferred_worker__is_team_lead
boolean<boolean>
preferred_worker__max_concurrent_work_orders
integer<smallint>
preferred_worker__name
string<character varying>
Maximum string length: 200
preferred_worker__next_certification_expiry
string<date>
preferred_worker__open_work_orders
integer<bigint>
preferred_worker__overdue_work_orders
integer<bigint>
preferred_worker__performance_period_end
string<date>
preferred_worker__performance_period_start
string<date>
preferred_worker__phone
string<character varying>
Maximum string length: 40
preferred_worker__planned_minutes_outstanding
integer<integer>
preferred_worker__site_code
string<character varying>
Maximum string length: 50
preferred_worker__site_name
string<character varying>
Maximum string length: 200
preferred_worker__skills
string<jsonb>
preferred_worker__sla_compliance_rate
number<numeric>
preferred_worker__team_name
string<character varying>
Maximum string length: 200
preferred_worker__track_location
boolean<boolean>
preferred_worker__travel_radius_km
integer<integer>
preferred_worker__updated_at
string<timestamp with time zone>
preferred_worker__updated_by_name
string<character varying>
Maximum string length: 200
preferred_worker__user_email
string<text>
preferred_worker__user_status
string<character varying>
Maximum string length: 30
preferred_worker__utilisation_rate
number<numeric>
preferred_worker__valid_certifications
integer<bigint>
preferred_worker__worker_number
string<character varying>
Maximum string length: 60
preferred_worker__worker_type
string<character varying>
Maximum string length: 40
preferred_worker_id
string<uuid>

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

preferred_worker_name
string<character varying>
Maximum string length: 200
priority_code
string<character varying>
Maximum string length: 40
priority_name
string<character varying>
Maximum string length: 150
raises_inspection
boolean<boolean>
reference_records
string<jsonb>
reminder_days
integer<integer>
requirement_count
integer<bigint>
requires_permit
boolean<boolean>
requires_shutdown
boolean<boolean>
row_version
integer<bigint>
safety_instructions
string<text>
scope_names
string[]
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_resolution_minutes
integer<integer>
sla_response_minutes
integer<integer>
status
string<character varying>
Maximum string length: 60
status_category
string<character varying>
Maximum string length: 20
status_label
string<text>
task_count
integer<bigint>
tolerance_days
integer<integer>
trigger_combination
string<character varying>
Maximum string length: 10
trigger_count
integer<bigint>
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
use_contract_visits
boolean<boolean>
work_order_priority_id
string<uuid>

Note: This is a Foreign Key to request_severity_priorities.work_order_priority_id.

work_order_type_id
string<uuid>

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

work_orders_generated
integer<bigint>