> ## Documentation Index > Fetch the complete documentation index at: https://docs.assetinfinity.ai/llms.txt > Use this file to discover all available pages before exploring further. # Maintenance plans with every field of the records each row points at: assigned team, preferred technician, preferred vendor, site. > Choose this source when one report needs columns from more than one register. Every list, export and dashboard reads the base view instead, which costs none of these joins — and the planner does not remove them when the columns go unnamed, so the two are separate sources on purpose. ## OpenAPI ````yaml /api-reference/openapi.json get /maintenance_plans_expanded openapi: 3.0.0 info: description: '' title: >- The only schema PostgREST exposes. Reads are security_invoker views; writes are SECURITY DEFINER functions. Rebuilt wholesale on every deploy — it holds no data. version: 12.2.3 servers: - url: https://app.assetinfinity.ai/api security: [] tags: - name: Signing in - name: Profile - name: Assets - name: Asset lifecycle - name: Work lifecycle - name: Maintenance - name: Inventory - name: Inventory detail - name: Procurement - name: Contracts - name: Workforce - name: Capacity - name: Dispatch - name: Tools - name: Inspections - name: Verification - name: Reliability - name: Parts demand - name: Sensors and meters - name: Map - name: Floor plans - name: Labels - name: Lost and found - name: Root cause analysis - name: Reports - name: Audit center - name: Activity - name: Notifications - name: Channels - name: Search - name: Copilot - name: Import - name: Files - name: Sync - name: Support - name: Admin - name: Access - name: Lookups - name: Read models - name: Branding - name: Custom fields - name: Form studio - name: Workflows - name: Workflow studio - name: Rules - name: Statuses and transitions - name: Currencies and locales - name: Work configuration - name: Asset configuration - name: Inventory configuration - name: Tool configuration - name: Workforce configuration - name: Vendor and contract configuration - name: Document configuration - name: Inspection configuration - name: Sites, locations and the organisation - name: Platform - name: Amendments - name: Asset clone - name: Asset components - name: Asset register - name: Asset transfer - name: Audit feed - name: Billing - name: Bookings - name: Budgets - name: Bulk jobs - name: Calibration history - name: Capex plans - name: Conversations - name: Costing - name: Currency - name: Dashboards - name: Directory sync - name: Document control - name: Document folders - name: Document tree - name: Documents - name: Energy - name: Extracts - name: Features - name: Feeds - name: File exchange - name: Filing exceptions - name: Finance - name: Inbound mail - name: Keys - name: Knowledge - name: Licence - name: List views - name: Locations - name: Mapping - name: Mcp - name: Mcp oauth - name: Mfa - name: Numbering - name: Permits - name: Readers - name: Reference - name: Reference columns - name: Reference entry - name: Release - name: Scim - name: Security streams - name: Self verification - name: Setup - name: Shutdown - name: Sso - name: Telegram - name: Tenant switch - name: The caller's own work - name: The checklist library - name: Tools on a job, and who has them out - name: Tray - name: Vendor spend forecast - name: Vendors and contracts - name: Visitors - name: Work order execution - name: Work sequencing - name: Workforce detail externalDocs: description: PostgREST Documentation url: https://postgrest.org/en/v12/references/api.html paths: /maintenance_plans_expanded: get: tags: - maintenance_plans_expanded summary: >- Maintenance plans with every field of the records each row points at: assigned team, preferred technician, preferred vendor, site. description: >- Choose this source when one report needs columns from more than one register. Every list, export and dashboard reads the base view instead, which costs none of these joins — and the planner does not remove them when the columns go unnamed, so the two are separate sources on purpose. parameters: - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.inspection_template_id - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.inspection_template_code - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.inspection_template_name - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.raises_inspection - $ref: '#/components/parameters/rowFilter.maintenance_plans_expanded.id' - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.plan_number - $ref: '#/components/parameters/rowFilter.maintenance_plans_expanded.name' - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.description - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.work_order_type_id - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.maintenance_type - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.maintenance_type_name - $ref: '#/components/parameters/rowFilter.maintenance_plans_expanded.status' - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.status_label - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.status_category - $ref: '#/components/parameters/rowFilter.maintenance_plans_expanded.site_id' - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.site_code - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.work_order_priority_id - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.priority_code - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.priority_name - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.criticality - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.trigger_combination - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.estimated_duration_minutes - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.lead_time_days - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.tolerance_days - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.sla_response_minutes - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.sla_resolution_minutes - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.assigned_team_id - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.assigned_team_name - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.preferred_worker_id - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.preferred_worker_name - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.preferred_vendor_id - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.preferred_vendor_name - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.assigned_to_user_id - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.assigned_to_user_name - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.end_date - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.reminder_days - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.use_contract_visits - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.requires_permit - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.requires_shutdown - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.safety_instructions - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.instructions - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.auto_generate_work_order - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.current_version_number - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.last_generated_at - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.is_active - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.asset_count - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.asset_category_count - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.place_count - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.scope_names - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.asset_category_codes - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.asset_category_names - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.asset_names - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.place_names - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.task_count - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.requirement_count - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.trigger_count - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.frequency - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.next_due_at - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.work_orders_generated - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.custom_fields - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.row_version - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.created_at - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.created_by_id - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.created_by_name - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.created_source - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.updated_at - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.updated_by_id - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.updated_by_name - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.assigned_team__code - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.assigned_team__name - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.assigned_team__description - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.assigned_team__lead_names - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.assigned_team__default_assignee_name - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.assigned_team__is_active - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.assigned_team__member_count - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.assigned_team__members - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.assigned_team__category_ids - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.assigned_team__category_names - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.assigned_team__site_ids - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.assigned_team__site_names - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.assigned_team__work_order_type_ids - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.assigned_team__work_order_type_names - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.assigned_team__role_ids - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.assigned_team__role_names - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.preferred_vendor__vendor_number - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.preferred_vendor__name - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.preferred_vendor__legal_name - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.preferred_vendor__vendor_type - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.preferred_vendor__is_oem - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.preferred_vendor__status - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.preferred_vendor__status_label - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.preferred_vendor__status_category - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.preferred_vendor__email - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.preferred_vendor__phone - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.preferred_vendor__website - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.preferred_vendor__payment_terms_days - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.preferred_vendor__onboarded_on - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.preferred_vendor__approved_on - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.preferred_vendor__performance_score - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.preferred_vendor__usable - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.preferred_vendor__categories - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.preferred_vendor__site_count - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.preferred_vendor__active_contracts - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.preferred_vendor__best_response_minutes - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.preferred_vendor__average_rating - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.preferred_vendor__rating_count - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.preferred_vendor__open_work_orders - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.preferred_vendor__warranty_work_orders - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.preferred_vendor__open_claims - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.preferred_vendor__is_assignable - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.preferred_vendor__compliance_expiring - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.preferred_vendor__warranty_authorisations - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.preferred_vendor__custom_fields - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.preferred_vendor__created_at - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.preferred_vendor__created_by_name - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.preferred_vendor__updated_at - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.preferred_vendor__updated_by_name - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.preferred_worker__worker_number - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.preferred_worker__name - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.preferred_worker__worker_type - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.preferred_worker__max_concurrent_work_orders - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.preferred_worker__is_active - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.preferred_worker__open_work_orders - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.preferred_worker__active_work_orders - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.preferred_worker__overdue_work_orders - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.preferred_worker__planned_minutes_outstanding - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.preferred_worker__skills - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.preferred_worker__email - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.preferred_worker__phone - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.preferred_worker__user_email - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.preferred_worker__user_status - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.preferred_worker__employment_status - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.preferred_worker__employment_start_date - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.preferred_worker__can_travel - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.preferred_worker__travel_radius_km - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.preferred_worker__track_location - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.preferred_worker__site_code - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.preferred_worker__site_name - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.preferred_worker__department_name - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.preferred_worker__team_name - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.preferred_worker__is_team_lead - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.preferred_worker__availability - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.preferred_worker__valid_certifications - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.preferred_worker__certifications_expiring - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.preferred_worker__certifications_lapsed - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.preferred_worker__next_certification_expiry - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.preferred_worker__performance_period_start - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.preferred_worker__performance_period_end - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.preferred_worker__utilisation_rate - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.preferred_worker__first_time_fix_rate - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.preferred_worker__sla_compliance_rate - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.preferred_worker__completed_in_period - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.preferred_worker__custom_fields - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.preferred_worker__created_at - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.preferred_worker__created_by_name - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.preferred_worker__updated_at - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.preferred_worker__updated_by_name - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.site__code - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.site__name - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.site__timezone - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.site__is_active - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.site__company_name - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.site__business_unit_name - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.site__business_unit_parent_name - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.site__asset_count - $ref: >- #/components/parameters/rowFilter.maintenance_plans_expanded.reference_records - $ref: '#/components/parameters/select' - $ref: '#/components/parameters/order' - $ref: '#/components/parameters/range' - $ref: '#/components/parameters/rangeUnit' - $ref: '#/components/parameters/offset' - $ref: '#/components/parameters/limit' - $ref: '#/components/parameters/preferCount' responses: '200': content: application/json: schema: items: $ref: '#/components/schemas/maintenance_plans_expanded' type: array application/vnd.pgrst.object+json: schema: items: $ref: '#/components/schemas/maintenance_plans_expanded' type: array application/vnd.pgrst.object+json;nulls=stripped: schema: items: $ref: '#/components/schemas/maintenance_plans_expanded' type: array text/csv: schema: items: $ref: '#/components/schemas/maintenance_plans_expanded' type: array description: OK '206': description: Partial Content components: parameters: rowFilter.maintenance_plans_expanded.inspection_template_id: in: query name: inspection_template_id required: false schema: type: string rowFilter.maintenance_plans_expanded.inspection_template_code: in: query name: inspection_template_code required: false schema: type: string rowFilter.maintenance_plans_expanded.inspection_template_name: in: query name: inspection_template_name required: false schema: type: string rowFilter.maintenance_plans_expanded.raises_inspection: in: query name: raises_inspection required: false schema: type: string rowFilter.maintenance_plans_expanded.id: in: query name: id required: false schema: type: string rowFilter.maintenance_plans_expanded.plan_number: in: query name: plan_number required: false schema: type: string rowFilter.maintenance_plans_expanded.name: in: query name: name required: false schema: type: string rowFilter.maintenance_plans_expanded.description: in: query name: description required: false schema: type: string rowFilter.maintenance_plans_expanded.work_order_type_id: in: query name: work_order_type_id required: false schema: type: string rowFilter.maintenance_plans_expanded.maintenance_type: in: query name: maintenance_type required: false schema: type: string rowFilter.maintenance_plans_expanded.maintenance_type_name: in: query name: maintenance_type_name required: false schema: type: string rowFilter.maintenance_plans_expanded.status: in: query name: status required: false schema: type: string rowFilter.maintenance_plans_expanded.status_label: in: query name: status_label required: false schema: type: string rowFilter.maintenance_plans_expanded.status_category: in: query name: status_category required: false schema: type: string rowFilter.maintenance_plans_expanded.site_id: in: query name: site_id required: false schema: type: string rowFilter.maintenance_plans_expanded.site_code: in: query name: site_code required: false schema: type: string rowFilter.maintenance_plans_expanded.work_order_priority_id: in: query name: work_order_priority_id required: false schema: type: string rowFilter.maintenance_plans_expanded.priority_code: in: query name: priority_code required: false schema: type: string rowFilter.maintenance_plans_expanded.priority_name: in: query name: priority_name required: false schema: type: string rowFilter.maintenance_plans_expanded.criticality: in: query name: criticality required: false schema: type: string rowFilter.maintenance_plans_expanded.trigger_combination: in: query name: trigger_combination required: false schema: type: string rowFilter.maintenance_plans_expanded.estimated_duration_minutes: in: query name: estimated_duration_minutes required: false schema: type: string rowFilter.maintenance_plans_expanded.lead_time_days: in: query name: lead_time_days required: false schema: type: string rowFilter.maintenance_plans_expanded.tolerance_days: in: query name: tolerance_days required: false schema: type: string rowFilter.maintenance_plans_expanded.sla_response_minutes: in: query name: sla_response_minutes required: false schema: type: string rowFilter.maintenance_plans_expanded.sla_resolution_minutes: in: query name: sla_resolution_minutes required: false schema: type: string rowFilter.maintenance_plans_expanded.assigned_team_id: in: query name: assigned_team_id required: false schema: type: string rowFilter.maintenance_plans_expanded.assigned_team_name: in: query name: assigned_team_name required: false schema: type: string rowFilter.maintenance_plans_expanded.preferred_worker_id: in: query name: preferred_worker_id required: false schema: type: string rowFilter.maintenance_plans_expanded.preferred_worker_name: in: query name: preferred_worker_name required: false schema: type: string rowFilter.maintenance_plans_expanded.preferred_vendor_id: in: query name: preferred_vendor_id required: false schema: type: string rowFilter.maintenance_plans_expanded.preferred_vendor_name: in: query name: preferred_vendor_name required: false schema: type: string rowFilter.maintenance_plans_expanded.assigned_to_user_id: in: query name: assigned_to_user_id required: false schema: type: string rowFilter.maintenance_plans_expanded.assigned_to_user_name: in: query name: assigned_to_user_name required: false schema: type: string rowFilter.maintenance_plans_expanded.end_date: in: query name: end_date required: false schema: type: string rowFilter.maintenance_plans_expanded.reminder_days: in: query name: reminder_days required: false schema: type: string rowFilter.maintenance_plans_expanded.use_contract_visits: in: query name: use_contract_visits required: false schema: type: string rowFilter.maintenance_plans_expanded.requires_permit: in: query name: requires_permit required: false schema: type: string rowFilter.maintenance_plans_expanded.requires_shutdown: in: query name: requires_shutdown required: false schema: type: string rowFilter.maintenance_plans_expanded.safety_instructions: in: query name: safety_instructions required: false schema: type: string rowFilter.maintenance_plans_expanded.instructions: in: query name: instructions required: false schema: type: string rowFilter.maintenance_plans_expanded.auto_generate_work_order: in: query name: auto_generate_work_order required: false schema: type: string rowFilter.maintenance_plans_expanded.current_version_number: in: query name: current_version_number required: false schema: type: string rowFilter.maintenance_plans_expanded.last_generated_at: in: query name: last_generated_at required: false schema: type: string rowFilter.maintenance_plans_expanded.is_active: in: query name: is_active required: false schema: type: string rowFilter.maintenance_plans_expanded.asset_count: in: query name: asset_count required: false schema: type: string rowFilter.maintenance_plans_expanded.asset_category_count: in: query name: asset_category_count required: false schema: type: string rowFilter.maintenance_plans_expanded.place_count: in: query name: place_count required: false schema: type: string rowFilter.maintenance_plans_expanded.scope_names: in: query name: scope_names required: false schema: type: string rowFilter.maintenance_plans_expanded.asset_category_codes: in: query name: asset_category_codes required: false schema: type: string rowFilter.maintenance_plans_expanded.asset_category_names: in: query name: asset_category_names required: false schema: type: string rowFilter.maintenance_plans_expanded.asset_names: in: query name: asset_names required: false schema: type: string rowFilter.maintenance_plans_expanded.place_names: in: query name: place_names required: false schema: type: string rowFilter.maintenance_plans_expanded.task_count: in: query name: task_count required: false schema: type: string rowFilter.maintenance_plans_expanded.requirement_count: in: query name: requirement_count required: false schema: type: string rowFilter.maintenance_plans_expanded.trigger_count: in: query name: trigger_count required: false schema: type: string rowFilter.maintenance_plans_expanded.frequency: in: query name: frequency required: false schema: type: string rowFilter.maintenance_plans_expanded.next_due_at: in: query name: next_due_at required: false schema: type: string rowFilter.maintenance_plans_expanded.work_orders_generated: in: query name: work_orders_generated required: false schema: type: string rowFilter.maintenance_plans_expanded.custom_fields: in: query name: custom_fields required: false schema: type: string rowFilter.maintenance_plans_expanded.row_version: in: query name: row_version required: false schema: type: string rowFilter.maintenance_plans_expanded.created_at: in: query name: created_at required: false schema: type: string rowFilter.maintenance_plans_expanded.created_by_id: in: query name: created_by_id required: false schema: type: string rowFilter.maintenance_plans_expanded.created_by_name: in: query name: created_by_name required: false schema: type: string rowFilter.maintenance_plans_expanded.created_source: in: query name: created_source required: false schema: type: string rowFilter.maintenance_plans_expanded.updated_at: in: query name: updated_at required: false schema: type: string rowFilter.maintenance_plans_expanded.updated_by_id: in: query name: updated_by_id required: false schema: type: string rowFilter.maintenance_plans_expanded.updated_by_name: in: query name: updated_by_name required: false schema: type: string rowFilter.maintenance_plans_expanded.assigned_team__code: in: query name: assigned_team__code required: false schema: type: string rowFilter.maintenance_plans_expanded.assigned_team__name: in: query name: assigned_team__name required: false schema: type: string rowFilter.maintenance_plans_expanded.assigned_team__description: in: query name: assigned_team__description required: false schema: type: string rowFilter.maintenance_plans_expanded.assigned_team__lead_names: in: query name: assigned_team__lead_names required: false schema: type: string rowFilter.maintenance_plans_expanded.assigned_team__default_assignee_name: in: query name: assigned_team__default_assignee_name required: false schema: type: string rowFilter.maintenance_plans_expanded.assigned_team__is_active: in: query name: assigned_team__is_active required: false schema: type: string rowFilter.maintenance_plans_expanded.assigned_team__member_count: in: query name: assigned_team__member_count required: false schema: type: string rowFilter.maintenance_plans_expanded.assigned_team__members: in: query name: assigned_team__members required: false schema: type: string rowFilter.maintenance_plans_expanded.assigned_team__category_ids: in: query name: assigned_team__category_ids required: false schema: type: string rowFilter.maintenance_plans_expanded.assigned_team__category_names: in: query name: assigned_team__category_names required: false schema: type: string rowFilter.maintenance_plans_expanded.assigned_team__site_ids: in: query name: assigned_team__site_ids required: false schema: type: string rowFilter.maintenance_plans_expanded.assigned_team__site_names: in: query name: assigned_team__site_names required: false schema: type: string rowFilter.maintenance_plans_expanded.assigned_team__work_order_type_ids: in: query name: assigned_team__work_order_type_ids required: false schema: type: string rowFilter.maintenance_plans_expanded.assigned_team__work_order_type_names: in: query name: assigned_team__work_order_type_names required: false schema: type: string rowFilter.maintenance_plans_expanded.assigned_team__role_ids: in: query name: assigned_team__role_ids required: false schema: type: string rowFilter.maintenance_plans_expanded.assigned_team__role_names: in: query name: assigned_team__role_names required: false schema: type: string rowFilter.maintenance_plans_expanded.preferred_vendor__vendor_number: in: query name: preferred_vendor__vendor_number required: false schema: type: string rowFilter.maintenance_plans_expanded.preferred_vendor__name: in: query name: preferred_vendor__name required: false schema: type: string rowFilter.maintenance_plans_expanded.preferred_vendor__legal_name: in: query name: preferred_vendor__legal_name required: false schema: type: string rowFilter.maintenance_plans_expanded.preferred_vendor__vendor_type: in: query name: preferred_vendor__vendor_type required: false schema: type: string rowFilter.maintenance_plans_expanded.preferred_vendor__is_oem: in: query name: preferred_vendor__is_oem required: false schema: type: string rowFilter.maintenance_plans_expanded.preferred_vendor__status: in: query name: preferred_vendor__status required: false schema: type: string rowFilter.maintenance_plans_expanded.preferred_vendor__status_label: in: query name: preferred_vendor__status_label required: false schema: type: string rowFilter.maintenance_plans_expanded.preferred_vendor__status_category: in: query name: preferred_vendor__status_category required: false schema: type: string rowFilter.maintenance_plans_expanded.preferred_vendor__email: in: query name: preferred_vendor__email required: false schema: type: string rowFilter.maintenance_plans_expanded.preferred_vendor__phone: in: query name: preferred_vendor__phone required: false schema: type: string rowFilter.maintenance_plans_expanded.preferred_vendor__website: in: query name: preferred_vendor__website required: false schema: type: string rowFilter.maintenance_plans_expanded.preferred_vendor__payment_terms_days: in: query name: preferred_vendor__payment_terms_days required: false schema: type: string rowFilter.maintenance_plans_expanded.preferred_vendor__onboarded_on: in: query name: preferred_vendor__onboarded_on required: false schema: type: string rowFilter.maintenance_plans_expanded.preferred_vendor__approved_on: in: query name: preferred_vendor__approved_on required: false schema: type: string rowFilter.maintenance_plans_expanded.preferred_vendor__performance_score: in: query name: preferred_vendor__performance_score required: false schema: type: string rowFilter.maintenance_plans_expanded.preferred_vendor__usable: in: query name: preferred_vendor__usable required: false schema: type: string rowFilter.maintenance_plans_expanded.preferred_vendor__categories: in: query name: preferred_vendor__categories required: false schema: type: string rowFilter.maintenance_plans_expanded.preferred_vendor__site_count: in: query name: preferred_vendor__site_count required: false schema: type: string rowFilter.maintenance_plans_expanded.preferred_vendor__active_contracts: in: query name: preferred_vendor__active_contracts required: false schema: type: string rowFilter.maintenance_plans_expanded.preferred_vendor__best_response_minutes: in: query name: preferred_vendor__best_response_minutes required: false schema: type: string rowFilter.maintenance_plans_expanded.preferred_vendor__average_rating: in: query name: preferred_vendor__average_rating required: false schema: type: string rowFilter.maintenance_plans_expanded.preferred_vendor__rating_count: in: query name: preferred_vendor__rating_count required: false schema: type: string rowFilter.maintenance_plans_expanded.preferred_vendor__open_work_orders: in: query name: preferred_vendor__open_work_orders required: false schema: type: string rowFilter.maintenance_plans_expanded.preferred_vendor__warranty_work_orders: in: query name: preferred_vendor__warranty_work_orders required: false schema: type: string rowFilter.maintenance_plans_expanded.preferred_vendor__open_claims: in: query name: preferred_vendor__open_claims required: false schema: type: string rowFilter.maintenance_plans_expanded.preferred_vendor__is_assignable: in: query name: preferred_vendor__is_assignable required: false schema: type: string rowFilter.maintenance_plans_expanded.preferred_vendor__compliance_expiring: in: query name: preferred_vendor__compliance_expiring required: false schema: type: string rowFilter.maintenance_plans_expanded.preferred_vendor__warranty_authorisations: in: query name: preferred_vendor__warranty_authorisations required: false schema: type: string rowFilter.maintenance_plans_expanded.preferred_vendor__custom_fields: in: query name: preferred_vendor__custom_fields required: false schema: type: string rowFilter.maintenance_plans_expanded.preferred_vendor__created_at: in: query name: preferred_vendor__created_at required: false schema: type: string rowFilter.maintenance_plans_expanded.preferred_vendor__created_by_name: in: query name: preferred_vendor__created_by_name required: false schema: type: string rowFilter.maintenance_plans_expanded.preferred_vendor__updated_at: in: query name: preferred_vendor__updated_at required: false schema: type: string rowFilter.maintenance_plans_expanded.preferred_vendor__updated_by_name: in: query name: preferred_vendor__updated_by_name required: false schema: type: string rowFilter.maintenance_plans_expanded.preferred_worker__worker_number: in: query name: preferred_worker__worker_number required: false schema: type: string rowFilter.maintenance_plans_expanded.preferred_worker__name: in: query name: preferred_worker__name required: false schema: type: string rowFilter.maintenance_plans_expanded.preferred_worker__worker_type: in: query name: preferred_worker__worker_type required: false schema: type: string rowFilter.maintenance_plans_expanded.preferred_worker__max_concurrent_work_orders: in: query name: preferred_worker__max_concurrent_work_orders required: false schema: type: string rowFilter.maintenance_plans_expanded.preferred_worker__is_active: in: query name: preferred_worker__is_active required: false schema: type: string rowFilter.maintenance_plans_expanded.preferred_worker__open_work_orders: in: query name: preferred_worker__open_work_orders required: false schema: type: string rowFilter.maintenance_plans_expanded.preferred_worker__active_work_orders: in: query name: preferred_worker__active_work_orders required: false schema: type: string rowFilter.maintenance_plans_expanded.preferred_worker__overdue_work_orders: in: query name: preferred_worker__overdue_work_orders required: false schema: type: string rowFilter.maintenance_plans_expanded.preferred_worker__planned_minutes_outstanding: in: query name: preferred_worker__planned_minutes_outstanding required: false schema: type: string rowFilter.maintenance_plans_expanded.preferred_worker__skills: in: query name: preferred_worker__skills required: false schema: type: string rowFilter.maintenance_plans_expanded.preferred_worker__email: in: query name: preferred_worker__email required: false schema: type: string rowFilter.maintenance_plans_expanded.preferred_worker__phone: in: query name: preferred_worker__phone required: false schema: type: string rowFilter.maintenance_plans_expanded.preferred_worker__user_email: in: query name: preferred_worker__user_email required: false schema: type: string rowFilter.maintenance_plans_expanded.preferred_worker__user_status: in: query name: preferred_worker__user_status required: false schema: type: string rowFilter.maintenance_plans_expanded.preferred_worker__employment_status: in: query name: preferred_worker__employment_status required: false schema: type: string rowFilter.maintenance_plans_expanded.preferred_worker__employment_start_date: in: query name: preferred_worker__employment_start_date required: false schema: type: string rowFilter.maintenance_plans_expanded.preferred_worker__can_travel: in: query name: preferred_worker__can_travel required: false schema: type: string rowFilter.maintenance_plans_expanded.preferred_worker__travel_radius_km: in: query name: preferred_worker__travel_radius_km required: false schema: type: string rowFilter.maintenance_plans_expanded.preferred_worker__track_location: in: query name: preferred_worker__track_location required: false schema: type: string rowFilter.maintenance_plans_expanded.preferred_worker__site_code: in: query name: preferred_worker__site_code required: false schema: type: string rowFilter.maintenance_plans_expanded.preferred_worker__site_name: in: query name: preferred_worker__site_name required: false schema: type: string rowFilter.maintenance_plans_expanded.preferred_worker__department_name: in: query name: preferred_worker__department_name required: false schema: type: string rowFilter.maintenance_plans_expanded.preferred_worker__team_name: in: query name: preferred_worker__team_name required: false schema: type: string rowFilter.maintenance_plans_expanded.preferred_worker__is_team_lead: in: query name: preferred_worker__is_team_lead required: false schema: type: string rowFilter.maintenance_plans_expanded.preferred_worker__availability: in: query name: preferred_worker__availability required: false schema: type: string rowFilter.maintenance_plans_expanded.preferred_worker__valid_certifications: in: query name: preferred_worker__valid_certifications required: false schema: type: string rowFilter.maintenance_plans_expanded.preferred_worker__certifications_expiring: in: query name: preferred_worker__certifications_expiring required: false schema: type: string rowFilter.maintenance_plans_expanded.preferred_worker__certifications_lapsed: in: query name: preferred_worker__certifications_lapsed required: false schema: type: string rowFilter.maintenance_plans_expanded.preferred_worker__next_certification_expiry: in: query name: preferred_worker__next_certification_expiry required: false schema: type: string rowFilter.maintenance_plans_expanded.preferred_worker__performance_period_start: in: query name: preferred_worker__performance_period_start required: false schema: type: string rowFilter.maintenance_plans_expanded.preferred_worker__performance_period_end: in: query name: preferred_worker__performance_period_end required: false schema: type: string rowFilter.maintenance_plans_expanded.preferred_worker__utilisation_rate: in: query name: preferred_worker__utilisation_rate required: false schema: type: string rowFilter.maintenance_plans_expanded.preferred_worker__first_time_fix_rate: in: query name: preferred_worker__first_time_fix_rate required: false schema: type: string rowFilter.maintenance_plans_expanded.preferred_worker__sla_compliance_rate: in: query name: preferred_worker__sla_compliance_rate required: false schema: type: string rowFilter.maintenance_plans_expanded.preferred_worker__completed_in_period: in: query name: preferred_worker__completed_in_period required: false schema: type: string rowFilter.maintenance_plans_expanded.preferred_worker__custom_fields: in: query name: preferred_worker__custom_fields required: false schema: type: string rowFilter.maintenance_plans_expanded.preferred_worker__created_at: in: query name: preferred_worker__created_at required: false schema: type: string rowFilter.maintenance_plans_expanded.preferred_worker__created_by_name: in: query name: preferred_worker__created_by_name required: false schema: type: string rowFilter.maintenance_plans_expanded.preferred_worker__updated_at: in: query name: preferred_worker__updated_at required: false schema: type: string rowFilter.maintenance_plans_expanded.preferred_worker__updated_by_name: in: query name: preferred_worker__updated_by_name required: false schema: type: string rowFilter.maintenance_plans_expanded.site__code: in: query name: site__code required: false schema: type: string rowFilter.maintenance_plans_expanded.site__name: in: query name: site__name required: false schema: type: string rowFilter.maintenance_plans_expanded.site__timezone: in: query name: site__timezone required: false schema: type: string rowFilter.maintenance_plans_expanded.site__is_active: in: query name: site__is_active required: false schema: type: string rowFilter.maintenance_plans_expanded.site__company_name: in: query name: site__company_name required: false schema: type: string rowFilter.maintenance_plans_expanded.site__business_unit_name: in: query name: site__business_unit_name required: false schema: type: string rowFilter.maintenance_plans_expanded.site__business_unit_parent_name: in: query name: site__business_unit_parent_name required: false schema: type: string rowFilter.maintenance_plans_expanded.site__asset_count: in: query name: site__asset_count required: false schema: type: string rowFilter.maintenance_plans_expanded.reference_records: in: query name: reference_records required: false schema: type: string select: description: Filtering Columns in: query name: select required: false schema: type: string order: description: Ordering in: query name: order required: false schema: type: string range: description: Limiting and Pagination in: header name: Range required: false schema: type: string rangeUnit: description: Limiting and Pagination in: header name: Range-Unit required: false schema: default: items type: string offset: description: Limiting and Pagination in: query name: offset required: false schema: type: string limit: description: Limiting and Pagination in: query name: limit required: false schema: type: string preferCount: description: Preference in: header name: Prefer required: false schema: enum: - count=none type: string schemas: maintenance_plans_expanded: description: >- Maintenance plans with every field of the records each row points at: assigned team, preferred technician, preferred vendor, site. Choose this source when one report needs columns from more than one register. Every list, export and dashboard reads the base view instead, which costs none of these joins — and the planner does not remove them when the columns go unnamed, so the two are separate sources on purpose. properties: asset_category_codes: format: text[] items: type: string type: array asset_category_count: format: bigint type: integer asset_category_names: format: text type: string asset_count: format: bigint type: integer asset_names: format: text type: string assigned_team__category_ids: format: uuid[] items: type: string type: array assigned_team__category_names: format: character varying[] items: type: string type: array assigned_team__code: format: character varying maxLength: 60 type: string assigned_team__default_assignee_name: format: character varying maxLength: 200 type: string assigned_team__description: format: text type: string assigned_team__is_active: format: boolean type: boolean assigned_team__lead_names: format: text type: string assigned_team__member_count: format: bigint type: integer assigned_team__members: format: jsonb assigned_team__name: format: character varying maxLength: 200 type: string assigned_team__role_ids: format: uuid[] items: type: string type: array assigned_team__role_names: format: character varying[] items: type: string type: array assigned_team__site_ids: format: uuid[] items: type: string type: array assigned_team__site_names: format: character varying[] items: type: string type: array assigned_team__work_order_type_ids: format: uuid[] items: type: string type: array assigned_team__work_order_type_names: format: character varying[] items: type: string type: array assigned_team_id: description: |- Note: This is a Foreign Key to `teams.id`. format: uuid type: string assigned_team_name: format: character varying maxLength: 200 type: string assigned_to_user_id: description: >- Note: This is a Foreign Key to `capex_invite_candidates.id`. format: uuid type: string assigned_to_user_name: format: character varying maxLength: 200 type: string auto_generate_work_order: format: boolean type: boolean created_at: format: timestamp with time zone type: string created_by_id: description: >- Note: This is a Foreign Key to `capex_invite_candidates.id`. format: uuid type: string created_by_name: format: character varying maxLength: 200 type: string created_source: format: text type: string criticality: format: character varying maxLength: 40 type: string current_version_number: format: integer type: integer custom_fields: format: jsonb description: format: text type: string end_date: format: date type: string estimated_duration_minutes: format: integer type: integer frequency: format: text type: string id: description: |- Note: This is a Primary Key. format: uuid type: string inspection_template_code: format: character varying maxLength: 60 type: string inspection_template_id: description: >- Note: This is a Foreign Key to `inspection_template_settings.id`. format: uuid type: string inspection_template_name: format: character varying maxLength: 250 type: string instructions: format: text type: string is_active: format: boolean type: boolean last_generated_at: format: timestamp with time zone type: string lead_time_days: format: integer type: integer maintenance_type: format: character varying maxLength: 40 type: string maintenance_type_name: format: character varying maxLength: 150 type: string name: format: character varying maxLength: 250 type: string next_due_at: format: timestamp with time zone type: string place_count: format: bigint type: integer place_names: format: text type: string plan_number: format: character varying maxLength: 60 type: string preferred_vendor__active_contracts: format: bigint type: integer preferred_vendor__approved_on: format: date type: string preferred_vendor__average_rating: format: numeric type: number preferred_vendor__best_response_minutes: format: integer type: integer preferred_vendor__categories: format: jsonb preferred_vendor__compliance_expiring: format: bigint type: integer preferred_vendor__created_at: format: timestamp with time zone type: string preferred_vendor__created_by_name: format: character varying maxLength: 200 type: string preferred_vendor__custom_fields: format: jsonb preferred_vendor__email: format: public.citext type: string preferred_vendor__is_assignable: format: boolean type: boolean preferred_vendor__is_oem: format: boolean type: boolean preferred_vendor__legal_name: format: character varying maxLength: 250 type: string preferred_vendor__name: format: character varying maxLength: 200 type: string preferred_vendor__onboarded_on: format: date type: string preferred_vendor__open_claims: format: bigint type: integer preferred_vendor__open_work_orders: format: bigint type: integer preferred_vendor__payment_terms_days: format: integer type: integer preferred_vendor__performance_score: format: numeric type: number preferred_vendor__phone: format: character varying maxLength: 40 type: string preferred_vendor__rating_count: format: bigint type: integer preferred_vendor__site_count: format: bigint type: integer preferred_vendor__status: format: character varying maxLength: 60 type: string preferred_vendor__status_category: format: character varying maxLength: 20 type: string preferred_vendor__status_label: format: text type: string preferred_vendor__updated_at: format: timestamp with time zone type: string preferred_vendor__updated_by_name: format: character varying maxLength: 200 type: string preferred_vendor__usable: format: boolean type: boolean preferred_vendor__vendor_number: format: character varying maxLength: 60 type: string preferred_vendor__vendor_type: format: character varying maxLength: 40 type: string preferred_vendor__warranty_authorisations: format: bigint type: integer preferred_vendor__warranty_work_orders: format: bigint type: integer preferred_vendor__website: format: character varying maxLength: 250 type: string preferred_vendor_id: description: >- Note: This is a Foreign Key to `assignable_vendors.id`. format: uuid type: string preferred_vendor_name: format: character varying maxLength: 200 type: string preferred_worker__active_work_orders: format: bigint type: integer preferred_worker__availability: format: text type: string preferred_worker__can_travel: format: boolean type: boolean preferred_worker__certifications_expiring: format: bigint type: integer preferred_worker__certifications_lapsed: format: bigint type: integer preferred_worker__completed_in_period: format: integer type: integer preferred_worker__created_at: format: timestamp with time zone type: string preferred_worker__created_by_name: format: character varying maxLength: 200 type: string preferred_worker__custom_fields: format: jsonb preferred_worker__department_name: format: character varying maxLength: 200 type: string preferred_worker__email: format: public.citext type: string preferred_worker__employment_start_date: format: date type: string preferred_worker__employment_status: format: character varying maxLength: 30 type: string preferred_worker__first_time_fix_rate: format: numeric type: number preferred_worker__is_active: format: boolean type: boolean preferred_worker__is_team_lead: format: boolean type: boolean preferred_worker__max_concurrent_work_orders: format: smallint type: integer preferred_worker__name: format: character varying maxLength: 200 type: string preferred_worker__next_certification_expiry: format: date type: string preferred_worker__open_work_orders: format: bigint type: integer preferred_worker__overdue_work_orders: format: bigint type: integer preferred_worker__performance_period_end: format: date type: string preferred_worker__performance_period_start: format: date type: string preferred_worker__phone: format: character varying maxLength: 40 type: string preferred_worker__planned_minutes_outstanding: format: integer type: integer preferred_worker__site_code: format: character varying maxLength: 50 type: string preferred_worker__site_name: format: character varying maxLength: 200 type: string preferred_worker__skills: format: jsonb preferred_worker__sla_compliance_rate: format: numeric type: number preferred_worker__team_name: format: character varying maxLength: 200 type: string preferred_worker__track_location: format: boolean type: boolean preferred_worker__travel_radius_km: format: integer type: integer preferred_worker__updated_at: format: timestamp with time zone type: string preferred_worker__updated_by_name: format: character varying maxLength: 200 type: string preferred_worker__user_email: format: text type: string preferred_worker__user_status: format: character varying maxLength: 30 type: string preferred_worker__utilisation_rate: format: numeric type: number preferred_worker__valid_certifications: format: bigint type: integer preferred_worker__worker_number: format: character varying maxLength: 60 type: string preferred_worker__worker_type: format: character varying maxLength: 40 type: string preferred_worker_id: description: >- Note: This is a Foreign Key to `assignable_workers.id`. format: uuid type: string preferred_worker_name: format: character varying maxLength: 200 type: string priority_code: format: character varying maxLength: 40 type: string priority_name: format: character varying maxLength: 150 type: string raises_inspection: format: boolean type: boolean reference_records: format: jsonb reminder_days: format: integer type: integer requirement_count: format: bigint type: integer requires_permit: format: boolean type: boolean requires_shutdown: format: boolean type: boolean row_version: format: bigint type: integer safety_instructions: format: text type: string scope_names: format: text[] items: type: string type: array site__asset_count: format: bigint type: integer site__business_unit_name: format: character varying maxLength: 200 type: string site__business_unit_parent_name: format: character varying maxLength: 200 type: string site__code: format: character varying maxLength: 50 type: string site__company_name: format: character varying maxLength: 200 type: string site__is_active: format: boolean type: boolean site__name: format: character varying maxLength: 200 type: string site__timezone: format: character varying maxLength: 100 type: string site_code: format: character varying maxLength: 50 type: string site_id: description: >- Note: This is a Foreign Key to `entry_currencies.for_site_id`. format: uuid type: string sla_resolution_minutes: format: integer type: integer sla_response_minutes: format: integer type: integer status: format: character varying maxLength: 60 type: string status_category: format: character varying maxLength: 20 type: string status_label: format: text type: string task_count: format: bigint type: integer tolerance_days: format: integer type: integer trigger_combination: format: character varying maxLength: 10 type: string trigger_count: format: bigint type: integer updated_at: format: timestamp with time zone type: string updated_by_id: description: >- Note: This is a Foreign Key to `capex_invite_candidates.id`. format: uuid type: string updated_by_name: format: character varying maxLength: 200 type: string use_contract_visits: format: boolean type: boolean work_order_priority_id: description: >- Note: This is a Foreign Key to `request_severity_priorities.work_order_priority_id`. format: uuid type: string work_order_type_id: description: >- Note: This is a Foreign Key to `work_order_types.id`. format: uuid type: string work_orders_generated: format: bigint type: integer type: object ````