swo_swoh_shop_wo_hdr

Holds metadata for error messages used in routing operations. This table contains error message templates, routing rules, and system notification details to manage workflow routing and error handling within the SWO system.

Process: COMPMAINTENANCE · Component: BasSWO · Table type: Transaction Table Category: Routing information, metadata and message details

This table is the canonical store for the ShopWorkOrder entity.

Primary key

swoh_unique_id

Columns (155)

#	Column	Type	Description
1	`swoh_amemr_covflg`	varchar	Capex proposal number.
2	`swoh_assoc_cr_linkid`	varchar	Work order closure date.
3	`swoh_ber_flag`	varchar	Code identifying the main core component.
4	`swoh_ber_sourceflag`	varchar	Component type.
5	`swoh_capex_proposal_no`	varchar	Component organizational unit instance.
6	`swoh_cls_date`	datetime	Indicates if Certification of Maintenance (CoM) is required.
7	`swoh_component_id`	varchar	Completion status of CoM.
8	`swoh_comptype`	varchar	Contract effectivity code.
9	`swoh_comp_ou`	int	Contract effectivity line number.
10	`swoh_com_reqd`	varchar	Customer order number (defaulted from order).
11	`swoh_com_status`	varchar	Customer order revision number.
12	`swoh_contract_eff_code`	varchar	Main core lot number for the shop work order.
13	`swoh_contract_eff_line_no`	int	Contract effectivity line no
14	`swoh_contract_no`	varchar	Contract No-Defaulted from Customer order
15	`swoh_contract_rev_no`	int	Contract revision No
16	`swoh_core_lot_no`	varchar	Shop Work Order (SWO ) Main Core Lot No
17	`swoh_core_quantity`	numeric	Shop Work Order (SWO Main Core Quantity
18	`swoh_core_status`	varchar	Main Core status-holds the following values R - returned NA -Not applicable ER -External routed PR-pending request EBER-Ext. routed BER I -Issued
19	`swoh_createdby`	varchar	Created by
20	`swoh_created_date`	datetime	created date
21	`swoh_cr_task_trackid`	bigint	Task track id for task used to remove and create the child swo
22	`swoh_current_location`	varchar	Current location of the component.
23	`swoh_current_loc_option`	varchar	Current location option.
24	`swoh_curr_parent_swo`	varchar	Current parent SWO.
25	`swoh_curr_root_swo`	varchar	Current root SWO.
26	`swoh_cust_no`	varchar	Customer number.
27	`swoh_cust_reg_date`	datetime	Customer request date (defaulted from order).
28	`swoh_cust_warr_req_flag`	varchar	Warranty requested flag.
29	`swoh_cust_warr_res_flag`	varchar	Warranty resolution flag.
30	`swoh_cus_order_no`	varchar	Customer order number.
31	`swoh_cus_order_ou`	int	Customer component organizational unit.
32	`swoh_cus_order_revno`	varchar	Customer order revision number.
33	`swoh_dlink_flag`	varchar	D-link flag for exchange transaction type.
34	`swoh_est_flag`	varchar	Estimation flag.
35	`swoh_eventid`	varchar	Shop WO event ID linking parent and child work orders.
36	`swoh_execsrc_desc`	Char	Unused column.
37	`swoh_execsrc_ref`	Char	Unused column (not used in SP).
38	`swoh_exec_document_no`	varchar	Execution document number.
39	`swoh_exec_wc_code`	varchar	Execution work center code.
40	`swoh_exe_doc_type`	varchar	Execution document type.
41	`swoh_expense_type`	varchar	Expense type (Revenue/Capital).
42	`swoh_fac_desc`	varchar	Facility description.
43	`swoh_fac_No`	varchar	Facility number.
44	`swoh_fac_obj`	varchar	Facility object number.
45	`swoh_fac_type`	varchar	Facility type.
46	`swoh_fb_no`	varchar	FB identifier.
47	`swoh_final_disposition`	varchar	Final repair disposition.
48	`swoh_final_move_option`	varchar	Final movement options (e.g., return to customer, warehouse).
49	`swoh_final_move_to`	varchar	Final movement location.
50	`swoh_hierarchy_id`	varchar	Hierarchy ID for parent/child relationship in SWO.
51	`swoh_induction_date`	datetime	Component induction date.
52	`swoh_initial_disposition`	varchar	Initial repair disposition.
53	`swoh_jobclass`	varchar	Quickcode value for SWO job class.
54	`swoh_job_type`	varchar	Shop WO job type (e.g., Miscellaneous, Project, Engine, Piece Part, Facility, Component, Make).
55	`swoh_mfg_date`	datetime	Manufacturing date.
56	`swoh_mfg_lot_no`	varchar	Manufacturing lot number (for Make job type).
57	`swoh_mfg_qty`	numeric	Manufacturing quantity (for Make job type).
58	`swoh_mfg_serialno`	varchar	Manufacturing serial number (for Make job type).
59	`swoh_mfr_no`	varchar	Manufacturer code for main core part.
60	`swoh_mfr_partno`	varchar	Manufacturer part number for main core part.
61	`swoh_mkdata_pflg`	varchar	Marshalling/Kitting data flag.
62	`swoh_modified_by`	varchar	User who modified the record.
63	`swoh_modified_date`	datetime	Modified lot number.
64	`swoh_mod_core_lot_no`	varchar	Modified manufacturer number.
65	`swoh_mod_mfrno`	varchar	Modified manufacturer part number.
66	`swoh_mod_mfr_partno`	varchar	Modified part number.
67	`swoh_mod_partno`	varchar	Modified serial number (Repair receipt or part serial change).
68	`swoh_mod_part_serialno`	varchar	Coverage quantity.
69	`swoh_mrcovqty`	numeric	MR line number.
70	`swoh_mrlineno`	int	MR number.
71	`swoh_mrno`	varchar	Required quantity.
72	`swoh_mrreqqty`	numeric	Manufacture serial number for the aircraft.
73	`swoh_msn`	varchar	Flag indicating multiple cores associated with same work order.
74	`swoh_multi_core_flag`	varchar	New manufacturer number.
75	`swoh_NewMfr_no`	varchar	New manufacturer part number.
76	`swoh_NewMfr_partno`	varchar	New part number.
77	`swoh_Newpartno`	varchar	Next movement option for core.
78	`swoh_next_move_option`	varchar	Next movement location for core.
79	`swoh_next_move_to`	varchar	NFF flag.
80	`swoh_nff_flag`	varchar	Operator code mapped to component ID.
81	`swoh_operator_code`	varchar	Order class (Internal/External).
82	`swoh_order_class`	varchar	Original core quantity of work order.
83	`Swoh_Org_CoreQty`	numeric	Shop WO organizational unit instance.
84	`swoh_ouinstance`	int	Override comments (Capability check).
85	`swoh_override_cmnts`	varchar	Parent shop WO number.
86	`swoh_parent_swo_no`	varchar	Code identifying the main core part.
87	`swoh_partno`	varchar	Part description.
88	`swoh_part_desc`	varchar	Part administrative organizational unit.
89	`swoh_part_ou`	int	Serial number of main core part.
90	`swoh_part_serialno`	varchar	Percentage of completion.
91	`swoh_per_comp`	numeric	Scheduling plan ID.
92	`swoh_planid`	Bigint	Plan end date and time.
93	`swoh_plan_endate`	datetime	Plan start date and time.
94	`swoh_plan_startdate`	datetime	Position code.
95	`swoh_poscode`	varchar	Product structure track ID.
96	`swoh_prdstr_reftrackid`	bigint	Revision number.
97	`swoh_prdstr_revno`	int	Primary work center responsible for SWO execution.
98	`swoh_primary_wc_code`	varchar	Projected completion date.
99	`swoh_proj_comp_date`	datetime	Promised completion date.
100	`swoh_promised_cmp_date`	datetime	Promised delivery date.
101	`swoh_prom_del_date`	datetime	Process plan track ID.
102	`swoh_propln_reftrackid`	bigint	Reason for change (target date, PCD, PDD, projected completion date).
103	`swoh_reasonforchge`	varchar	Reference document type (AME/SWO).
104	`swoh_ref_doc_typ`	varchar	Removed aircraft registration number.
105	`swoh_rem_aircraft_reg_no`	varchar	Removal date.
106	`swoh_rem_date`	datetime	Removed part number.
107	`swoh_rem_part`	varchar	Reason for removal.
108	`swoh_rem_reason`	varchar	Removed serial number.
109	`swoh_rem_serial_no`	varchar	Repair classification.
110	`swoh_repair_class`	varchar	Repair process code.
111	`swoh_repair_proc_code`	varchar	Reschedule from date.
112	`swoh_resch_from`	datetime	Root shop WO number.
113	`swoh_root_swo_no`	varchar	Roster group for scheduling.
114	`swoh_rostergroup`	varchar	Routing identifier for latest routing details.
115	`swoh_rout_id`	int	Main repair order number.
116	`swoh_ro_no`	varchar	Scheduling application flag.
117	`swoh_sch_opt`	varchar	Source of the SWO (manual, customer order, strip, split).
118	`swoh_source_flag`	varchar	Source customer order number.
119	`swoh_src_cust_ord`	varchar	Station code mapped to primary work center.
120	`swoh_stationcode`	varchar	Shop WO status (e.g., Draft, Planned, Closed, Pre-Closed, Completed, Fresh, In Progress, Cancelled).
121	`swoh_status`	varchar	Stock status.
122	`swoh_stock_status`	varchar	Under warranty flag.
123	`swoh_supp_warr_flag`	varchar	Demand supplier reference ID.
124	`swoh_sup_refid`	Bigint	Shortage/Surplus indicator.
125	`swoh_Surplus_Shortage`	numeric	Category of SWO.
126	`swoh_swo_category`	varchar	Shop WO description.
127	`swoh_swo_desc`	varchar	Shop WO number.
128	`swoh_swo_no`	varchar	Order priority.
129	`swoh_swo_priority_no`	int	Work center slot.
130	`swoh_swo_slot`	varchar	Shop WO type.
131	`swoh_swo_type`	varchar	User-defined status.
132	`swoh_swo_ud_status`	varchar	Target date.
133	`swoh_target_date`	datetime	TAT start date.
134	`swoh_TAT_Startdate`	datetime	Timestamp of the record.
135	`swoh_timestamp`	int	Transient status.
136	`swoh_transient_status`	varchar	Unique sequence number (Primary Key).
137	`swoh_unique_id` 🔑	bigint	User-defined field 1 (scheduling).
138	`swoh_user_defined1`	varchar	User-defined field 2 (scheduling).
139	`swoh_user_defined2`	varchar	User-defined field 3 (scheduling).
140	`swoh_user_defined3`	datetime	User status.
141	`swoh_usr_status`	varchar	Actual UTC end date.
142	`swoh_utc_act_end_datetime`	datetime	Actual UTC start date.
143	`swoh_utc_act_start_datetime`	datetime	Reported date.
144	`swoh_utc_rep_date`	datetime	Visit document number.
145	`swoh_visitdoc_no`	varchar	Work center organizational unit instance.
146	`swoh_wc_ou`	int	Timesheet task code for work scope.
147	`swoh_workscope_task`	varchar	Revision number of the work order after release.
148	`swoh_wrk_scp_revno`	int	Work scope status.
149	`swoh_wrk_scp_status`	varchar	Workscoping class.
150	`swoh_wsclass`	varchar	Workscoping comments.
151	`swoh_wscomments`	varchar	Workscoping customer revision number.
152	`swoh_wscusrevno`	int	Workscoping revision number.
153	`swoh_wsrevno`	int	Workscoping revision status.
154	`swoh_wsrevstatus`	varchar	Workscoping stage.
155	`swoh_wsstage`	varchar	Adjusted actual cost.

Relationships (20)

SWO_HAS_ADDITIONAL_HDR → SWOAdditionalHeader (swo_swoah_shop_wo_addl_hdr)
- Join: 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 (swo_swocst_cost_summary)
- Join: swo_swoh_shop_wo_hdr.swoh_swo_no = swo_swocst_cost_summary.swocst_swo_no
- SWO has cost summary
FOR_AIRCRAFT → Aircraft (AC_ACI_AIRCRAFT_INFO)
- Join: 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 (AC_CMPID_COMPONENT_ID_INFO)
- Join: swo_swoh_shop_wo_hdr.swoh_component_id = AC_CMPID_COMPONENT_ID_INFO.CMPID_COMPONENT_ID
- SWO is for component
AT_WORK_CENTER → LogicalWorkCenter (BAS_WCLOG_WC_LOGICAL_WC_DTL) (no automatic join)
- SWO executed at work center
AT_FACILITY → Facility (BAS_WC_FAC_FACILITY)
- Join: swo_swoh_shop_wo_hdr.swoh_primary_wc_code = BAS_WC_FAC_FACILITY.FAC_CODE
- SWO at facility
HAS_PRIORITY → Priority (BAS_CM_PRI_PRIORITY_NUMBER)
- Join: swo_swoh_shop_wo_hdr.swoh_swo_priority_no = BAS_CM_PRI_PRIORITY_NUMBER.PRI_PRIORITY_NO
- SWO has priority level
FOR_PART → Part (PRT_PRCRL_CENTRALREFLIST_INFO)
- Join: swo_swoh_shop_wo_hdr.swoh_part_desc = PRT_PRCRL_CENTRALREFLIST_INFO.PRCRL_PART_DESC
- SWO is for a part
SWO_HAS_CERTIFICATE → SWOCertificate (swo_swoccm_com_certificate_dtl)
- Join: 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 (swo_swococ_conformity_cert_list)
- Join: 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 (swo_swocol_calibration_cert_list)
- Join: 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 (swo_prtmfg_certificate_dtl) (no automatic join)
- SWO has manufacturing certificate
SWO_HAS_ROUTING → RoutingDetail (swo_swortng_routing_dtl)
- Join: swo_swoh_shop_wo_hdr.swoh_ro_no = swo_swortng_routing_dtl.swortng_ro_no
- SWO has routing details
SWO_HAS_KIT → KitRefDetail (swo_Kit_Ref_Dtl)
- Join: swo_swoh_shop_wo_hdr.swoh_poscode = swo_Kit_Ref_Dtl.KRD_poscode
- SWO has kit reference
SWO_HAS_COMLIST → COMList (swo_swocom_com_list)
- Join: swo_swoh_shop_wo_hdr.swoh_swo_no = swo_swocom_com_list.swocom_swo_no
- SWO has COM list
SWO_HAS_CORE_DISASSY → CoreDisassembly (swo_swocds_core_disassm_assemble_det)
- Join: 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 (swo_job_lvl_mile_stones)
- Join: swo_swoh_shop_wo_hdr.swoh_createdby = swo_job_lvl_mile_stones.swomls_createdby
- SWO has job milestone
SWO_HAS_CONFIG_REVIEW → ConfigReview (SWO_Config_review_record)
- Join: swo_swoh_shop_wo_hdr.swoh_swo_no = SWO_Config_review_record.SCR_SWO_No
- SWO has config review
VisitPackage (SWO_Visit_Lvl_Info) → VISIT_FOR_SWO (this table is target)
- Join: SWO_Visit_Lvl_Info.visit_id = swo_swoh_shop_wo_hdr.swoh_eventid
- Visit package for shop work order
SWO_CONTAINS_TASK → SWOTask (swo_swostk_sub_task_details)
- Join: swo_swoh_shop_wo_hdr.swoh_swo_no = swo_swostk_sub_task_details.swostk_swo_no
- Shop work order contains tasks

Sample rows (from live DB)

`swoh_amemr_covflg`	`swoh_assoc_cr_linkid`	`swoh_ber_flag`	`swoh_ber_sourceflag`	`swoh_capex_proposal_no`	`swoh_cls_date`
NULL	NULL	NULL	NULL	NULL	NULL
NULL	NULL	NULL	NULL	NULL	NULL
NULL	NULL	NULL	NULL	NULL	NULL

Showing 3 of 25,147 rows.

swo_swoh_shop_wo_hdr

Primary key

Columns (155)

Relationships (20)

Sample rows (from live DB)

See also