swo_wobsl_baseline_wo_hdr

SWO Workscoping -Baselined WO Header Data

Process: COMPMAINTENANCE · Component: BasSWO · Table type: Transaction Table Category: Contains header-level information for baseline work orders, defining the initial reference or standard plan against which modifications and execution are tracked

Primary key

Wobsl_wsunique_id

Columns (155)

#	Column	Type	Description
1	`Wobsl_action_rev`	datetime	Indicates type of change applied to workscoping task
2	`Wobsl_act_end_datetime`	datetime	Records actual end date of the task
3	`Wobsl_act_start_datetime`	Datetime	Tracks actual start date of the task
4	`Wobsl_act_wo_cmptn_datetime`	varchar	Records actual completion date of the Shop Work Order
5	`Wobsl_ac_effective_code`	int	Tracks customer order effectivity code
6	`Wobsl_ac_eff_line_no`	varchar	Records customer order effectivity line number
7	`Wobsl_adjust_PDD_chk`	varchar	Indicates flag for PDD check adjustment
8	`Wobsl_assoc_cr_linkid`	varchar	Used to link associate or assemble-disassemble table
9	`Wobsl_ber_flag`	varchar	Indicates whether a Built-in Error Report is applicable
10	`Wobsl_capex_proposal_no`	datetime	Tracks CAPEX proposal number associated with Shop Work Order
11	`Wobsl_cls_date`	varchar	Records Shop Work Order closure date
12	`Wobsl_component_id`	varchar	Identifies main core component
13	`Wobsl_comptype`	int	Tracks component type
14	`Wobsl_comp_ou`	varchar	Records organization unit instance for component
15	`Wobsl_com_reqd`	varchar	Indicates whether Certification of Maintenance is required
16	`Wobsl_com_status`	varchar	Tracks status of Certification of Maintenance
17	`Wobsl_contract_eff_code`	int	Records contract effectivity code
18	`Wobsl_contract_eff_line_no`	varchar	Tracks contract effectivity line number
19	`Wobsl_contract_no`	int	Records contract number
20	`Wobsl_contract_rev_no`	varchar	Tracks contract revision number
21	`Wobsl_core_lot_no`	numeric	Records main core lot number
22	`Wobsl_core_quantity`	varchar	Tracks main core quantity
23	`Wobsl_core_status`	varchar	Indicates main core status
24	`Wobsl_createdby`	datetime	Identifies user who created the record
25	`Wobsl_created_date`	bigint	Records creation date
26	`Wobsl_cr_task_trackid`	varchar	Tracks task track identifier for child Shop Work Orders
27	`Wobsl_current_location`	varchar	Indicates current location of component
28	`Wobsl_current_loc_option`	varchar	Records option for current location
29	`Wobsl_curr_parent_swo`	varchar	Tracks current parent Shop Work Order
30	`Wobsl_curr_root_swo`	varchar	Tracks current root Shop Work Order
31	`Wobsl_cust_no`	datetime	Records customer number
32	`Wobsl_cust_reg_date`	varchar	Tracks customer request date
33	`Wobsl_cust_warr_req_flag`	varchar	Indicates if warranty is requested
34	`Wobsl_cust_warr_res_flag`	varchar	Tracks resolution of warranty request
35	`Wobsl_cus_order_no`	int	Records customer order number
36	`Wobsl_cus_order_ou`	varchar	Records organizational unit of customer component
37	`Wobsl_cus_order_revno`	varchar	Tracks customer order revision number
38	`Wobsl_dlink_flag`	varchar	Indicates D-link flag for exchange transaction
39	`Wobsl_est_flag`	varchar	Indicates estimation flag for cost and effort
40	`Wobsl_eventid`	Char	Tracks Shop Work Order event number
41	`Wobsl_execsrc_desc`	Char	Reserved for execution source description
42	`Wobsl_execsrc_ref`	varchar	Reserved for reference to execution source
43	`Wobsl_exec_document_no`	varchar	Records execution document number
44	`Wobsl_exec_wc_code`	varchar	Tracks execution work center code
45	`Wobsl_exe_doc_type`	varchar	Records type of execution document
46	`Wobsl_expense_type`	varchar	Indicates type of expense
47	`Wobsl_fac_desc`	varchar	Tracks facility description
48	`Wobsl_fac_No`	varchar	Records facility number
49	`Wobsl_fac_obj`	varchar	Tracks facility object number
50	`Wobsl_fac_type`	varchar	Indicates type of facility
51	`Wobsl_fb_no`	varchar	Captures feedback identifiers
52	`Wobsl_final_disposition`	varchar	Final repair disposition indicating the outcome of the repair
53	`Wobsl_final_move_option`	varchar	Final movement option specifying whether the component is returned to the customer, a warehouse, or another location
54	`Wobsl_final_move_to`	varchar	Location where the main core component must be returned after repair completion
55	`Wobsl_hierarchy_id`	datetime	Identifier to maintain parent-child relationships within the shop work order
56	`Wobsl_induction_date`	varchar	Date when the component was inducted into the shop work order process
57	`Wobsl_initial_disposition`	varchar	Initial repair disposition at the start of the process
58	`Wobsl_job_type`	varchar	Type of shop work order job; valid values include: Miscellaneous, Project, Engine, Piece Part, Facility, Component, Make
59	`Wobsl_mfg_lot_no`	numeric	Manufacturing lot number; applicable for jobs with type “Make”
60	`Wobsl_mfg_qty`	varchar	Manufacturing quantity; applicable for jobs with type “Make”
61	`Wobsl_mfg_serialno`	varchar	Manufacturing serial number; applicable for jobs with type “Make”
62	`Wobsl_mfr_no`	varchar	Manufacturer code identifying the main core part
63	`Wobsl_mfr_partno`	varchar	Manufacturer-issued part number for the main core
64	`Wobsl_mkdata_pflg`	varchar	Marshalling or kitting flag indicating whether the component is grouped for assembly
65	`Wobsl_modified_by`	datetime	User who last modified the record
66	`Wobsl_modified_date`	varchar	Date when the record was last modified
67	`Wobsl_mod_core_lot_no`	varchar	Modified lot number for the component
68	`Wobsl_mod_mfrno`	varchar	Modified manufacturer number
69	`Wobsl_mod_mfr_partno`	varchar	Modified manufacturer part number
70	`Wobsl_mod_partno`	varchar	Modified part number
71	`Wobsl_mod_part_serialno`	varchar	Modified serial number; updated during repair receipt or part serial change transactions
72	`Wobsl_msn`	varchar	Manufacturing serial number
73	`Wobsl_multi_core_flag`	varchar	Flag indicating whether multiple cores are associated with the same work order
74	`Wobsl_NewMfr_no`	varchar	New manufacturer number assigned to the component
75	`Wobsl_NewMfr_partno`	varchar	New manufacturer part number
76	`Wobsl_Newpartno`	varchar	New part number
77	`Wobsl_next_move_option`	varchar	Next movement option specifying the upcoming location for the component
78	`Wobsl_next_move_to`	varchar	Next movement location details for the component
79	`Wobsl_nff_flag`	varchar	Non-functional flag indicating component status
80	`Wobsl_operator_code`	varchar	Operator code mapped to the component ID
81	`Wobsl_order_class`	numeric	Order classification indicating whether the shop work order is internal or external
82	`Wobsl_Org_CoreQty`	int	Original quantity of the main core component
83	`Wobsl_ouinstance`	varchar	Organization unit instance for the shop work order
84	`Wobsl_override_cmnts`	varchar	Override comments used during capability checks
85	`Wobsl_parent_swo_no`	varchar	Parent shop work order number
86	`Wobsl_partno`	varchar	Code identifying the main core part
87	`Wobsl_part_desc`	int	Description of the part
88	`Wobsl_part_ou`	varchar	Administrative organization unit for the part
89	`Wobsl_part_serialno`	numeric	Serial number of the main core part
90	`Wobsl_per_comp`	Bigint	Percentage of task completion
91	`Wobsl_planid`	datetime	Plan identifier from scheduling
92	`Wobsl_plan_endate`	datetime	Planned end date and time for the task
93	`Wobsl_plan_startdate`	varchar	Planned start date and time for the task
94	`Wobsl_poscode`	Bigint	Position code identifies the position of the task or component
95	`Wobsl_prdstr_reftrackid`	varchar	Product structure tracking identifier tracks the identifier of the product structure
96	`Wobsl_primary_wc_code`	datetime	Primary work center responsible for shop work order execution identifies the main work center handling execution
97	`Wobsl_proj_comp_date`	datetime	Projected completion date records the expected completion date
98	`Wobsl_promised_cmp_date`	datetime	Promised completion date captures the date promised to the customer
99	`Wobsl_prom_del_date`	Bigint	Promised delivery date indicates the promised delivery date of the work or component
100	`Wobsl_propln_reftrackid`	varchar	Process plan tracking identifier tracks the process plan
101	`Wobsl_reasonforchge`	varchar	Reason for change provides the reason for changes in target, promised completion, or projected completion
102	`Wobsl_ref_doc_typ`	varchar	Column identifying the parent transaction type indicates the origin of the transaction; Aircraft Maintenance Execution or Shop Work Order
103	`Wobsl_rem_aircraft_reg_no`	datetime	Aircraft registration number removed from captures the aircraft registration number removed from
104	`Wobsl_rem_date`	varchar	Date of component removal records when the component was removed
105	`Wobsl_rem_part`	varchar	Removed part number identifies the part number that was removed
106	`Wobsl_rem_reason`	varchar	Reason for removal indicates the reason the component was removed
107	`Wobsl_rem_serial_no`	varchar	Removed serial number captures the serial number of the removed component
108	`Wobsl_repair_class`	varchar	Repair classification records the type of repair
109	`Wobsl_repair_proc_code`	datetime	Repair process code identifies the repair process used
110	`Wobsl_resch_from`	varchar	Rescheduled from date captures the previous schedule date
111	`Wobsl_rm_modeltyp`	varchar	Removed model type indicates the type of model removed
112	`Wobsl_root_swo_no`	Varchar	Root shop work order number identifies the root Shop Work Order
113	`Wobsl_rostergroup`	int	Roster group for scheduling tracks the group used for scheduling
114	`Wobsl_rout_id`	varchar	Identifier used to track the latest routing details captures routing information
115	`Wobsl_ro_no`	varchar	Main core repair order number records the main repair order number
116	`Wobsl_sch_opt`	varchar	Flag indicating whether scheduling is applicable identifies if scheduling applies
117	`Wobsl_source_flag`	varchar	Source from which the work order was created indicates origin of the work order, e.g., Strip, Split, Plan Work Order, RS, CO
118	`Wobsl_src_cust_ord`	varchar	Source customer order number tracks the originating customer order
119	`Wobsl_stationcode`	varchar	Station code mapped to the primary work center identifies the station code
120	`Wobsl_status`	varchar	Shop work order status indicates current Shop Work Order status; Draft, Planned, Closed, Pre-Closed, Completed, Fresh, In Progress, Cancelled
121	`Wobsl_stock_status`	varchar	Stock status of the component records stock condition
122	`Wobsl_supp_warr_flag`	Bigint	Indicates whether the component is under warranty tracks warranty status
123	`Wobsl_sup_refid`	numeric	Supplier reference identifier identifies the supplier reference
124	`Wobsl_Surplus_Shortage`	varchar	Indicates shortage or surplus of parts records part shortages or surplus
125	`Wobsl_swo_category`	varchar	Category of the shop work order identifies the type of Shop Work Order
126	`Wobsl_swo_desc`	varchar	Description of the shop work order provides details about the Shop Work Order
127	`Wobsl_swo_no`	int	Shop work order number tracks the unique Shop Work Order
128	`Wobsl_swo_priority_no`	varchar	Order priority for the shop work order indicates the priority level
129	`Wobsl_swo_slot`	varchar	Slot number assigned to the work order records the scheduling slot
130	`Wobsl_swo_type`	varchar	Type of shop work order identifies the Shop Work Order type
131	`Wobsl_swo_ud_status`	datetime	User status for the shop work order records user-defined status
132	`Wobsl_target_date`	datetime	Target date for completion tracks the target completion date
133	`Wobsl_TAT_Startdate`	int	Turnaround time start date records when the work order turnaround time begins
134	`Wobsl_timestamp`	varchar	Timestamp of record creation or update captures creation or update time
135	`Wobsl_transient_status`	bigint	Transient status of the work order identifies temporary status
136	`Wobsl_unique_id`	varchar	Unique identifier for the work order stores a unique ID
137	`Wobsl_user_defined1`	varchar	User-defined field 1 for scheduling purposes captures scheduling-specific information
138	`Wobsl_user_defined2`	datetime	User-defined field 2 for scheduling purposes captures additional scheduling information
139	`Wobsl_user_defined3`	varchar	User-defined field 3 for scheduling purposes tracks extra scheduling details
140	`Wobsl_usr_status`	datetime	User status records current user-defined status
141	`Wobsl_utc_act_end_datetime`	datetime	Actual UTC end date captures the actual end date in UTC
142	`Wobsl_utc_act_start_datetime`	datetime	Actual UTC start date captures the actual start date in UTC
143	`Wobsl_utc_rep_date`	varchar	Reported date of the work order records when the work order was reported
144	`Wobsl_visitdoc_no`	int	Indicates if scheduling application is used identifies if scheduling software is used
145	`Wobsl_wc_ou`	varchar	Work center organization unit instance tracks organizational instance of the work center
146	`Wobsl_workscope_task`	int	Timesheet task code for work scope identifies the timesheet code
147	`Wobsl_wrk_scp_revno`	varchar	Revision number of the work order incremented when changes occur
148	`Wobsl_wrk_scp_status`	varchar	Status indicating the current state of the work scope shows current work status
149	`Wobsl_wsclass`	varchar	Workscoping class identifies the class of workscoping
150	`Wobsl_wscomments`	int	Comments related to workscoping stores notes on workscoping
151	`Wobsl_wscusrevno`	int	Customer revision number for workscoping tracks customer revision
152	`Wobsl_wsrevno`	varchar	Workscoping revision number identifies the current workscoping revision
153	`Wobsl_wsrevstatus`	varchar	Workscoping revision status shows the status of the workscoping revision
154	`Wobsl_wsstage`	bigint	Current stage of workscoping identifies the active stage
155	`Wobsl_wsunique_id` 🔑	datetime	Unique identifier for workscoping stores workscoping unique ID

Sample rows (from live DB)

`Wobsl_action_rev`	`Wobsl_act_end_datetime`	`Wobsl_act_start_datetime`	`Wobsl_act_wo_cmptn_datetime`	`Wobsl_ac_effective_code`	`Wobsl_ac_eff_line_no`
ADD	NULL	NULL	NULL	NULL	NULL
ADD	NULL	NULL	NULL	NULL	NULL
ADD	NULL	NULL	NULL	NULL	NULL

Showing 3 of 66 rows.

swo_wobsl_baseline_wo_hdr

Primary key

Columns (155)

Sample rows (from live DB)

See also