Wiki·ontology·ontology/shopworkorder.md

ShopWorkOrder

A shop work order — the repair order for a component that's been removed from an aircraft. Each SWO tracks the component through disassembly, inspection, repair, reassembly, test, and certification. SWOs are the backbone of the component repair business for MROs.

Canonical table: swo_swoh_shop_wo_hdr · Key column: swoh_swo_no

Example record

  • swoh_swo_no: AWO-000001-2011
  • swoh_swo_type: AWO
  • swoh_ouinstance: 2
  • swoh_swo_desc: DND Replenishment (ANC-003 Take 2)
  • swoh_status: CL
  • swoh_job_type: mi
  • swoh_primary_wc_code: NULL
  • swoh_wc_ou: 2

Outgoing relationships (19)

  • SWO_HAS_ADDITIONAL_HDR → SWOAdditionalHeader
    • via swo_swoh_shop_wo_hdr.swoh_unique_id = swo_swoah_shop_wo_addl_hdr.swoad_unique_id
    • SWO has additional header info
  • SWO_HAS_COST_SUMMARY → CostSummary
    • via swo_swoh_shop_wo_hdr.swoh_swo_no = swo_swocst_cost_summary.swocst_swo_no
    • SWO has cost summary
  • FOR_AIRCRAFT → Aircraft
    • via swo_swoh_shop_wo_hdr.swoh_rem_aircraft_reg_no = AC_ACI_AIRCRAFT_INFO.ACI_AIRCRAFT_REG_NO
    • SWO is for aircraft
  • FOR_COMPONENT → ComponentID
    • via swo_swoh_shop_wo_hdr.swoh_component_id = AC_CMPID_COMPONENT_ID_INFO.CMPID_COMPONENT_ID
    • SWO is for component
  • AT_WORK_CENTER → LogicalWorkCenter (no automatic join)
    • SWO executed at work center
  • AT_FACILITY → Facility
    • via swo_swoh_shop_wo_hdr.swoh_primary_wc_code = BAS_WC_FAC_FACILITY.FAC_CODE
    • SWO at facility
  • HAS_PRIORITY → Priority
    • via swo_swoh_shop_wo_hdr.swoh_swo_priority_no = BAS_CM_PRI_PRIORITY_NUMBER.PRI_PRIORITY_NO
    • SWO has priority level
  • FOR_PART → Part
    • via swo_swoh_shop_wo_hdr.swoh_part_desc = PRT_PRCRL_CENTRALREFLIST_INFO.PRCRL_PART_DESC
    • SWO is for a part
  • SWO_HAS_CERTIFICATE → SWOCertificate
    • via swo_swoh_shop_wo_hdr.swoh_swo_no = swo_swoccm_com_certificate_dtl.swoccm_swo_no
    • SWO has certificate of maintenance
  • SWO_HAS_CONFORMITY_CERT → SWOConformityCert
    • via swo_swoh_shop_wo_hdr.swoh_swo_no = swo_swococ_conformity_cert_list.swococ_swo_no
    • SWO has conformity certificate
  • SWO_HAS_CALIBRATION_CERT → CalibrationCert
    • via swo_swoh_shop_wo_hdr.swoh_swo_no = swo_swocol_calibration_cert_list.swocol_swo_no
    • SWO has calibration certificate
  • SWO_HAS_MFG_CERT → MfgCertificate (no automatic join)
    • SWO has manufacturing certificate
  • SWO_HAS_ROUTING → RoutingDetail
    • via swo_swoh_shop_wo_hdr.swoh_ro_no = swo_swortng_routing_dtl.swortng_ro_no
    • SWO has routing details
  • SWO_HAS_KIT → KitRefDetail
    • via swo_swoh_shop_wo_hdr.swoh_poscode = swo_Kit_Ref_Dtl.KRD_poscode
    • SWO has kit reference
  • SWO_HAS_COMLIST → COMList
    • via swo_swoh_shop_wo_hdr.swoh_swo_no = swo_swocom_com_list.swocom_swo_no
    • SWO has COM list
  • SWO_HAS_CORE_DISASSY → CoreDisassembly
    • via swo_swoh_shop_wo_hdr.swoh_swo_no = swo_swocds_core_disassm_assemble_det.swocds_swo_no
    • SWO has core disassembly
  • SWO_HAS_MILESTONE → JobMilestone
    • via swo_swoh_shop_wo_hdr.swoh_createdby = swo_job_lvl_mile_stones.swomls_createdby
    • SWO has job milestone
  • SWO_HAS_CONFIG_REVIEW → ConfigReview
    • via swo_swoh_shop_wo_hdr.swoh_swo_no = SWO_Config_review_record.SCR_SWO_No
    • SWO has config review
  • SWO_CONTAINS_TASK → SWOTask
    • via swo_swoh_shop_wo_hdr.swoh_swo_no = swo_swostk_sub_task_details.swostk_swo_no
    • Shop work order contains tasks

Incoming relationships (1)

  • VisitPackage → VISIT_FOR_SWO
    • via SWO_Visit_Lvl_Info.visit_id = swo_swoh_shop_wo_hdr.swoh_eventid

See also