|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| swoh_unique_id | udd_unique_id | bigint(8) | No | An Unique Id, Primary Key- Identity Column - Clustered Index Column | Yes |
| swoh_swo_no | udd_documentno | varchar(40) | No | Shop WO | Yes |
| swoh_swo_type | udd_quickcodes | varchar(25) | No | Shop WO Type | No |
| swoh_ouinstance | udd_ctxt_ouinstance | int(4) | No | Shop WO OU | No |
| swoh_swo_desc | udd_txt2000 | varchar(2000) | Yes | Shop WO Description | No |
| swoh_status | udd_designparamcode | varchar(5) | No | Shop WO status holds the following valuesDR - DraftPN - PlannedCL - ClosedPCL - Pre-ClosedCM - CompletedFR - FreshIP - In ProgressCN - cancelled | No |
| swoh_job_type | udd_designparamcode | varchar(5) | No | Shop WO job Type-Valid values will be MI - MiscellaneousPJT - project ENG - Enginepp - piece partF - Facilityc - ComponentM - make | No |
| swoh_primary_wc_code | udd_wccode | varchar(30) | Yes | Shop WO Primary Work center-work center that is responsible for SWO execution | No |
| swoh_wc_ou | udd_ctxt_ouinstance | int(4) | Yes | Work center ouinstance | No |
| swoh_eventid | udd_txt255 | varchar(255) | Yes | Shop WO Event ID-The event number indicating the visit of the main core and identified for grouping the shop work order. The event number is a linkage between the parent work order and the child work order(s). When one or more child work orders are c | No |
| swoh_partno | udd_partno | varchar(40) | Yes | The code identifying the main core part | No |
| swoh_part_serialno | udd_partserialnumber | varchar(40) | Yes | The serial number of the main core part. | No |
| swoh_part_desc | udd_txt150 | varchar(150) | Yes | Part Description | No |
| swoh_part_ou | udd_ctxt_ouinstance | int(4) | Yes | Part Admin OU | No |
| swoh_mfr_partno | udd_partno | varchar(40) | Yes | The number issued by the manufacturer of the main core part | No |
| swoh_mfr_no | udd_vendorcode | varchar(45) | Yes | The code identifying the manufacturer of the main core part | No |
| swoh_core_lot_no | udd_lotno | varchar(18) | Yes | Shop WO Main Core Lot No | No |
| swoh_core_quantity | udd_quantity | numeric(13) | Yes | Shop WO Main Core Quantity | No |
| swoh_mfg_serialno | udd_partno | varchar(40) | Yes | Manufacturing Serial no.For Job type Make will have a value in this column | No |
| swoh_mfg_lot_no | udd_lotno | varchar(18) | Yes | Manufacturing Lot No.For Job type Make will have a value in this column | No |
| swoh_mfg_qty | udd_quantity | numeric(13) | Yes | Manufacturing Quantity.For Job type Make will have a value in this column | No |
| swoh_fac_obj | udd_resourcecode | varchar(40) | Yes | Facility Object No | No |
| swoh_fac_type | udd_type | varchar(25) | Yes | Facility Type | No |
| swoh_fac_No | udd_resourcecode | varchar(40) | Yes | Facility No | No |
| swoh_fac_desc | udd_txt150 | varchar(150) | Yes | Facility Description | No |
| swoh_component_id | udd_componentid | varchar(90) | Yes | The code identifying the main core component | No |
| swoh_comp_ou | udd_ctxt_ouinstance | int(4) | Yes | Component Ouinstance | No |
| swoh_multi_core_flag | udd_chkflag | varchar(1) | Yes | Multiple core?(Y/N)-Indicates whether multiple cores are associated to the same work order | No |
| swoh_core_status | udd_designparamcode | varchar(5) | Yes | Main Core status-holds the following valuesR - returnedNA -Not applicableER -External routedPR-pending requestEBER-Ext. routed BERI -Issued | No |
| swoh_wrk_scp_status | udd_chkflag | varchar(1) | Yes | Used to indicate the work scope status | No |
| swoh_wrk_scp_revno | udd_numrevno | int(4) | Yes | The revision number of the work order after release. When a work order is released the Revision # will have the value "0". If any changes are made in the multiline due to task addition/modification/cancellation, the Revision # is updated with +1 ever | No |
| swoh_action_rev | udd_designparamcode | varchar(5) | Yes | holds the following values ADD-Addition(to add more workscoping tasks to the already existing workscoping tasks in order to perform a repair),UP-Upgrade(upgrade the existing task to a higher level workscoping task, to perform additional work) | No |
| swoh_swo_category | udd_quickcodes | varchar(25) | Yes | Category | No |
| swoh_swo_priority_no | udd_priorityno | int(4) | Yes | Order Priority | No |
| swoh_swo_ud_status | udd_quickcodes | varchar(25) | Yes | User status | No |
| swoh_com_reqd | udd_chkflag | varchar(1) | Yes | Com Required(Y/N)-to specify whether Certification of Maintenance (CoM) is required for the shop work order | No |
| swoh_plan_startdate | udd_datetime1 | datetime(8) | Yes | Plan Start Date / Time | No |
| swoh_plan_endate | udd_datetime1 | datetime(8) | Yes | Plan End Date / Time | No |
| swoh_repair_proc_code | udd_quickcodes | varchar(25) | Yes | Repair process code | No |
| swoh_order_class | udd_designparamcode | varchar(5) | Yes | Order Class - Indicates whether the SWO is Internal or External | No |
| swoh_repair_class | udd_quickcodes | varchar(25) | Yes | Repair Classification | No |
| swoh_expense_type | udd_designparamcode | varchar(5) | Yes | Expense type-revenue/capital | No |
| swoh_capex_proposal_no | udd_documentno | varchar(40) | Yes | Capex Proposal No | No |
| swoh_initial_disposition | udd_quickcodes | varchar(25) | Yes | Initial Repair disposition | No |
| swoh_final_disposition | udd_quickcodes | varchar(25) | Yes | Final Repair disposition | No |
| swoh_final_move_option | udd_documentno | varchar(40) | Yes | Final Movement Options will hold return to customer ,return to specific warehouse etc | No |
| swoh_final_move_to | udd_wccode | varchar(30) | Yes | column hold the values for the final movment.The location where the main core must be returned after the entire work is completed. | No |
| swoh_cus_order_no | UDD_CustomerorderNo | varchar(40) | Yes | Customer Order No | No |
| swoh_cus_order_ou | udd_ctxt_ouinstance | int(4) | Yes | Customer component OU | No |
| swoh_cus_order_revno | udd_revisionno | varchar(40) | Yes | Customer order Revision No | No |
| swoh_cust_no | udd_customer_id | varchar(18) | Yes | Customer No | No |
| swoh_operator_code | udd_vendorcode | varchar(45) | Yes | Operater code mapped to the component ID | No |
| swoh_src_cust_ord | UDD_CustomerorderNo | varchar(40) | Yes | Source Customer Order No | No |
| swoh_cust_reg_date | udd_datetime1 | datetime(8) | Yes | Customer Request Date-Defaulted from Customer order | No |
| swoh_prom_del_date | udd_datetime1 | datetime(8) | Yes | Promised Delivery Date | No |
| swoh_target_date | udd_datetime1 | datetime(8) | Yes | Target Date | No |
| swoh_promised_cmp_date | udd_datetime1 | datetime(8) | Yes | promised Completion Date | No |
| swoh_contract_no | udd_documentno | varchar(40) | Yes | Contract No-Defaulted from Customer order | No |
| swoh_exec_document_no | udd_documentno | varchar(40) | Yes | Execution document No | No |
| swoh_exe_doc_type | udd_documentno | varchar(40) | Yes | Execution Document Type | No |
| swoh_rem_aircraft_reg_no | udd_documentno | varchar(40) | Yes | Aircraft Registration No-Removed from | No |
| swoh_exec_wc_code | udd_wccode | varchar(30) | Yes | Execution Work Center | No |
| swoh_hierarchy_id | _hierarchyid_0 | hierarchyid(0) | Yes | Hierarchy id used to maintain parent / child relationship within the SWO | No |
| swoh_parent_swo_no | udd_documentno | varchar(40) | Yes | Parent Shop WO | No |
| swoh_root_swo_no | udd_documentno | varchar(40) | Yes | Root Shop WO | No |
| swoh_rem_part | udd_partno | varchar(40) | Yes | Removed from Part No | No |
| swoh_rem_serial_no | udd_partserialnumber | varchar(40) | Yes | Removed from Serial No | No |
| swoh_rem_reason | udd_txt2000 | varchar(2000) | Yes | Reason for Removal | No |
| swoh_rem_date | udd_datetime1 | datetime(8) | Yes | Removal Date | No |
| swoh_supp_warr_flag | udd_chkflag | varchar(1) | Yes | Under Warranty ? | No |
| swoh_cust_warr_req_flag | udd_chkflag | varchar(1) | Yes | Warranty Requested? | No |
| swoh_cust_warr_res_flag | udd_designparamcode | varchar(5) | Yes | Warranty Resolution | No |
| swoh_utc_rep_date | udd_datetime1 | datetime(8) | Yes | Reported date | No |
| swoh_act_start_datetime | udd_datetime1 | datetime(8) | Yes | Actual start Date | No |
| swoh_act_end_datetime | udd_datetime1 | datetime(8) | Yes | Actual End date | No |
| swoh_utc_act_start_datetime | udd_datetime1 | datetime(8) | Yes | Actual UTC start date | No |
| swoh_utc_act_end_datetime | udd_datetime1 | datetime(8) | Yes | Actual UTC end date | No |
| swoh_workscope_task | udd_workunitcode | varchar(30) | Yes | Timesheet taskcode for Wokscope | No |
| swoh_fb_no | udd_wccode | varchar(30) | Yes | FB Id | No |
| swoh_est_flag | udd_designparamcode | varchar(5) | Yes | Estimation flag | No |
| swoh_source_flag | udd_designparamcode | varchar(5) | Yes | manual,Customer order,strip,split | No |
| swoh_createdby | udd_ctxt_user | varchar(30) | Yes | Created by | No |
| swoh_modified_by | udd_ctxt_user | varchar(30) | Yes | modified by | No |
| swoh_created_date | udd_datetime1 | datetime(8) | Yes | created date | No |
| swoh_modified_date | udd_datetime1 | datetime(8) | Yes | Modified Date | No |
| swoh_timestamp | udd_timestamp | int(4) | Yes | Timestamp | No |
| swoh_stock_status | udd_documentno | varchar(40) | Yes | Stock status | No |
| swoh_msn | udd_partserialnumber | varchar(40) | Yes | Manufacture serial no for the aircraft | No |
| swoh_contract_rev_no | udd_seqno | int(4) | Yes | Contract revision No | No |
| swoh_contract_eff_code | udd_documentno | varchar(40) | Yes | Contract effectivity code | No |
| swoh_contract_eff_line_no | udd_seqno | int(4) | Yes | Contract effectivity line no | No |
| swoh_next_move_option | udd_documentno | varchar(40) | Yes | next movement option holds the next location option for the core | No |
| swoh_next_move_to | udd_wccode | varchar(30) | Yes | next movement option holds the next location details for the core | No |
| swoh_mod_partno | udd_partno | varchar(40) | Yes | Modified part no | No |
| swoh_mod_mfr_partno | udd_partno | varchar(40) | Yes | Modified manufacture part no | No |
| swoh_mod_part_serialno | udd_partserialnumber | varchar(40) | Yes | Modified serial no-Repair Receipt or part Serial change transaction will update the modified serial in this column | No |
| swoh_current_location | udd_documentno | varchar(40) | Yes | Current location | No |
| swoh_current_loc_option | udd_documentno | varchar(40) | Yes | current location option | No |
| swoh_proj_comp_date | udd_datetime1 | datetime(8) | Yes | projected completion date | No |
| swoh_curr_parent_swo | udd_documentno | varchar(40) | Yes | Current parent Swo | No |
| swoh_curr_root_swo | udd_documentno | varchar(40) | Yes | Current root swo | No |
| swoh_dlink_flag | udd_flag | varchar(25) | Yes | D-link flag-Exchange transaction will update the type of exchange in this column | No |
| swoh_cr_task_trackid | udd_unique_id | bigint(8) | Yes | Task track id for task used to remove and create the child swo | No |
| swoh_usr_status | udd_quickcodes | varchar(25) | Yes | User status | No |
| swoh_stationcode | udd_flag | varchar(25) | Yes | station code mapped to the primary work center | No |
| swoh_ro_no | udd_documentno | varchar(40) | Yes | Main code repair order no | No |
| swoh_assoc_cr_linkid | udd_documentno | varchar(40) | Yes | used to link the associate / assemble-dissassemble table | No |
| swoh_rout_id | udd_count | int(4) | Yes | used to identify the latest routing details | No |
| swoh_mod_mfrno | udd_vendorcode | varchar(45) | Yes | Modified manufacture part no | No |
| swoh_act_wo_cmptn_datetime | _datetime_8 | datetime(8) | Yes | Actual SWO completion date | No |
| swoh_mod_core_lot_no | udd_lotno | varchar(18) | Yes | modified lot no | No |
| swoh_ac_effective_code | udd_documentno | varchar(40) | Yes | Customer order effectivity code | No |
| swoh_ac_eff_line_no | udd_seqno | int(4) | Yes | Customer order effectivity line no | No |
| swoh_ref_doc_typ | udd_designparamcode | varchar(5) | Yes | column used to identify the parent transaction type-if the SWO is created from Aircraft maintenance execution then system will update the value as -AME,if the SWO is created from a Shop woro order the column holds the value as swo | No |
| swoh_per_comp | udd_duration | numeric(13) | Yes | used to hold the Percentage of completion | No |
| swoh_com_status | udd_designparamcode | varchar(5) | Yes | Completion Status | No |
| swoh_nff_flag | udd_chkflag | varchar(1) | Yes | Nff Flag | No |
| swoh_ber_flag | udd_chkflag | varchar(1) | Yes | Ber Flag | No |
| swoh_transient_status | udd_designparamcode | varchar(5) | Yes | Transient Status | No |
| swoh_Newpartno | udd_partno | varchar(40) | Yes | New Part number | No |
| swoh_NewMfr_partno | udd_partno | varchar(40) | Yes | New Manufacturer part number | No |
| swoh_NewMfr_no | udd_vendorcode | varchar(45) | Yes | New Manufacturer number | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| swoisu_uniqueid | udd_unique_id | bigint(8) | No | An Unique Id, Primary Key- Identity Column - Clustered Index Column | Yes |
| swoisu_part_seq_no | udd_unique_id | bigint(8) | No | Unique identified the Part requirment/Estimation record | No |
| swoisu_task_track_id | udd_unique_id | bigint(8) | No | task track id for which material issue has created | No |
| swoisu_ouinstance | udd_ctxt_ouinstance | int(4) | Yes | SWO Ouinstance | No |
| swoisu_mr_ou | udd_ctxt_ouinstance | int(4) | Yes | Material request component Ouinstance | No |
| swoisu_mr_no | udd_documentno | varchar(40) | Yes | Material request transaction No | No |
| swoisu_mr_line_no | udd_seqno | int(4) | Yes | Material request transaction Line no | No |
| swoisu_request_part_no | udd_partno | varchar(40) | Yes | Request part No | No |
| swoisu_reqmfr_part_no | udd_partno | varchar(40) | Yes | request manufacturer part no | No |
| swoisu_reqmfr_no | udd_manufacturernofilter | varchar(45) | Yes | manufacturer for the request part no | No |
| swoisu_reqpart_desc | udd_txt150 | varchar(150) | Yes | request part description | No |
| swoisu_issue_no | udd_documentno | varchar(40) | Yes | Material Issue No | No |
| swoisu_issue_lineno | udd_seqno | int(4) | Yes | Material Issue Line No | No |
| swoisu_issued_part_no | udd_partno | varchar(40) | Yes | Issue Part No | No |
| swoisu_issmfr_part_no | udd_partno | varchar(40) | Yes | Issue manufacturer part no | No |
| swoisu_issmfr_no | udd_manufacturernofilter | varchar(45) | Yes | Manufacturer for the issue part No | No |
| swoisu_isspart_desc | udd_txt150 | varchar(150) | Yes | Issue part Description | No |
| swoisu_serial_no | udd_partserialnumber | varchar(40) | Yes | Issued Serial No | No |
| swoisu_lot_no | udd_lotno | varchar(18) | Yes | Issued Lot No | No |
| swoisu_issued_uom | udd_uom | varchar(15) | Yes | issued UOM | No |
| swoisu_issued_wh | udd_warehouse | varchar(10) | Yes | Issued Warehouse | No |
| swoisu_issue_basis | udd_designparamcode | varchar(5) | Yes | Issue basis | No |
| swoisu_return_basis | udd_designparamcode | varchar(5) | Yes | Return Basis | No |
| swoisu_part_type | udd_designparamcode | varchar(5) | Yes | Part Type | No |
| swoisu_issued_qty | udd_quantity | numeric(13) | Yes | Issued Qty | No |
| swoisu_used_qty | udd_quantity | numeric(13) | Yes | Used Qty | No |
| swoisu_pend_ret_excess_qty | udd_quantity | numeric(13) | Yes | Pending Return Qty-Excess | No |
| swoisu_pend_ret_core_qty | udd_quantity | numeric(13) | Yes | pending Return Qty-Core | No |
| swoisu_ret_excess_qty | udd_quantity | numeric(13) | Yes | Retuned Qty-Excess | No |
| swoisu_ret_core_qty | udd_quantity | numeric(13) | Yes | Returned Qty-Core | No |
| swoisu_recon_excess_qty | udd_quantity | numeric(13) | Yes | Reconcillation Qty-Excess | No |
| swoisu_recon_core_qty | udd_quantity | numeric(13) | Yes | Reconcillation Qty-Core | No |
| swoisu_pend_ret_Mcore_qty | udd_quantity | numeric(13) | Yes | pending Return Qty-Main Core | No |
| swoisu_ret_Mcore_qty | udd_quantity | numeric(13) | Yes | Returned Qty-Main Core | No |
| swoisu_mat_type | udd_designparamcode | varchar(5) | Yes | Material Type-RG-Regular,MC-Main Core | No |
| swoisu_latest_return_no | udd_documentno | varchar(40) | Yes | latest Return document No | No |
| swoisu_latest_return_ou | udd_ctxt_ouinstance | int(4) | Yes | Return component Ouinstance | No |
| swoisu_recon_remarks | udd_txt2000 | varchar(2000) | Yes | Reconcillation remarks | No |
| swoisu_created_by | udd_ctxt_user | varchar(30) | Yes | Created by | No |
| swoisu_created_date | udd_datetime1 | datetime(8) | Yes | Created Date | No |
| swoisu_modified_by | udd_ctxt_user | varchar(30) | Yes | Modified By | No |
| swoisu_modified_date | udd_datetime1 | datetime(8) | Yes | Modified Date | No |
| swoisu_timestamp | udd_seqno | int(4) | Yes | Time Stamp | No |
| swoisu_service | udd_ctxt_service | varchar(32) | Yes | Service Name of the transaction updated the record | No |
| swoisu_issued_cost | udd_cost | numeric(13) | Yes | issue cost | No |
| swoisu_issue_stockstatus | udd_partstatus | varchar(40) | Yes | issued Stock status | No |
| swoisu_request_part_ou | udd_ctxt_ouinstance | int(4) | Yes | request part Ouinstance | No |
| swoisu_issued_part_ou | udd_ctxt_ouinstance | int(4) | Yes | Issued part ouuinstance | No |
| swoisu_return_remarks | udd_txt2000 | varchar(2000) | Yes | Return remarks | No |
| swoisu_return_wh | udd_warehouse | varchar(10) | Yes | Return Warehouse | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| swomr_unique_id | udd_unique_id | bigint(8) | No | An Unique Id, Primary Key- Identity Column - Clustered Index Column | Yes |
| swomr_part_seq_no | udd_unique_id | bigint(8) | No | Unique identified the Part requirment/Estimation record | No |
| swomr_task_track_id | udd_unique_id | bigint(8) | No | task track id for which material issue has created | No |
| swomr_ouinstance | udd_ctxt_ouinstance | int(4) | No | SWO Ouinstance | No |
| swomr_part_no | udd_partno | varchar(40) | No | Requested part No | No |
| swomr_mfr_no | udd_manufacturernofilter | varchar(45) | Yes | Requested manufacturer part no | No |
| swomr_mfrpart_no | udd_partno | varchar(40) | Yes | Manufacturer for the requested part no | No |
| swomr_mr_qty | udd_quantity | numeric(13) | Yes | MR Qty | No |
| swomr_mr_uom | udd_uom | varchar(15) | Yes | Requested UOM | No |
| swomr_wh_no | udd_warehouse | varchar(10) | Yes | Requested part in the warehouse stamped in this column | No |
| swomr_stock_status | udd_partstatus | varchar(40) | Yes | requested Stock status | No |
| swomr_newpart_flag | udd_designparamcode | varchar(5) | Yes | Flag identifies the request for existing or New part | No |
| swomr_part_desc | udd_txt150 | varchar(150) | Yes | part description | No |
| swomr_rep_class | udd_quickcodes | varchar(25) | Yes | Repair Classification | No |
| swomr_need_freq | udd_designparamcode | varchar(5) | Yes | Need frequency | No |
| swomr_request_mode | udd_designparamcode | varchar(5) | Yes | request Mode-Normal | No |
| swomr_required_cond | udd_designparamcode | varchar(5) | Yes | required condition | No |
| swomr_alternate_type | udd_designparamcode | varchar(5) | Yes | Alternate part type | No |
| swomr_alternate_part | udd_partno | varchar(40) | Yes | requested alternate part no | No |
| swomr_eff_notes | udd_txt2000 | varchar(2000) | Yes | Effectivity Notes | No |
| swomr_hold_code | udd_documentno | varchar(40) | Yes | hold code | No |
| swomr_hold_comments | udd_txt2000 | varchar(2000) | Yes | Hold comments | No |
| swomr_mr_no | udd_documentno | varchar(40) | Yes | material Request No | No |
| swomr_mr_lineno | udd_unique_id | bigint(8) | No | Material request line no | No |
| swomr_mr_ou | udd_ctxt_ouinstance | int(4) | Yes | Material request component Ouinstance | No |
| swomr_mat_type | udd_designparamcode | varchar(5) | Yes | Material Type-RG-Regular,MC-Main Core | No |
| swomr_created_by | udd_ctxt_user | varchar(30) | Yes | Created By | No |
| swomr_created_date | udd_datetime1 | datetime(8) | Yes | Created Date | No |
| swomr_modified_by | udd_ctxt_user | varchar(30) | Yes | Modified By | No |
| swomr_modified_date | udd_datetime1 | datetime(8) | Yes | Modified Date | No |
| swomr_service_name | udd_ctxt_service | varchar(32) | Yes | Service Name of the transaction updated the record | No |
| swomr_timestamp | udd_unique_id | bigint(8) | No | Time Stamp | No |
| swomr_mr_shcls_qty | udd_quantity | numeric(13) | Yes | MR shoort close Qty.Column value will get updated during MR short close tranaction | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| swomt_unique_id | udd_rowno | int(4) | No | An Unique Id, Primary Key- Identity Column - Clustered Index Column | Yes |
| swomt_service | udd_flag | varchar(25) | Yes | Routing Event | No |
| swomt_ack_receipt | udd_designparamcode | varchar(5) | Yes | Move parts / Acknoledge Receipt | No |
| swomt_allow_diff_wc_code | udd_designparamcode | varchar(5) | Yes | Metrics data used for validating the route / Acknoledge parts | No |
| swomt_current_loc | udd_designparamcode | varchar(5) | Yes | Metrics data used for validating the route / Acknoledge parts | No |
| swomt_exist_rout_sts | udd_designparamcode | varchar(5) | Yes | Metrics data used for validating the route / Acknoledge parts | No |
| swomt_new_rout_sts | udd_designparamcode | varchar(5) | Yes | Metrics data used for validating the route / Acknoledge parts | No |
| swomt_action | udd_designparamcode | varchar(5) | Yes | Metrics data used for validating the route / Acknoledge parts | No |
| swomt_final_result | udd_designparamcode | varchar(5) | Yes | Metrics data used for validating the route / Acknoledge parts | No |
| swomt_message_type | udd_designparamcode | varchar(5) | Yes | Metrics data used for validating the route / Acknoledge parts | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| swoobs_obs_id | udd_unique_id | bigint(8) | No | An Unique Id, Primary Key- Identity Column - Clustered Index Column | Yes |
| swoobs_swo_no | udd_documentno | varchar(40) | No | SWO No | No |
| swoobs_ouinstance | udd_ctxt_ouinstance | int(4) | Yes | SWO Ouinstance | No |
| swoobs_obs_desc | udd_txt2000 | varchar(2000) | Yes | Observation | No |
| swoobs_reported_by | udd_ctxt_user | varchar(30) | Yes | Reported By | No |
| swoobs_reported_datetime | _datetime_8 | datetime(8) | Yes | Reported date | No |
| swoobs_task_track_id | udd_seqno | int(4) | Yes | The Task trackid for the task code against which the discrepancy / observation is reported. | No |
| swoobs_task_code | udd_workunitcode | varchar(30) | Yes | The code identifying the task against which the discrepancy / observation is reported. | No |
| swoobs_created_by | udd_ctxt_user | varchar(30) | Yes | Created By | No |
| swoobs_created_date | _datetime_8 | datetime(8) | Yes | Created Date | No |
| swoobs_modified_by | udd_ctxt_user | varchar(30) | Yes | Modified by | No |
| swoobs_modified_date | _datetime_8 | datetime(8) | Yes | Modified date | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| swoprm_swo_no | udd_documentno | varchar(40) | Yes | SWO No | No |
| swoprm_ouinstance | udd_ctxt_ouinstance | int(4) | Yes | SWO Ouinstance | No |
| swoprm_task_track_id | udd_unique_id | bigint(8) | No | The Task trackid for the task code against which parameter values are reported | No |
| swoprm_subtsk_seq_no | udd_seqno | int(4) | Yes | Sub Task Seqno to identify the Sub task for which parameters values are reported | No |
| swoprm_param_ou | udd_ctxt_ouinstance | int(4) | Yes | Task component Ouinstance | No |
| swoprm_param_code | udd_parameter | varchar(40) | Yes | Parameter code | No |
| swoprm_sub_task_desc | udd_txt2000 | varchar(2000) | Yes | Sub Task Description | No |
| swoprm_param_type | udd_flag | varchar(25) | Yes | Parameter Type | No |
| swoprm_param_value | udd_charparamval | varchar(32) | Yes | Pameter Value | No |
| swoprm_updated_date | udd_datetime1 | datetime(8) | Yes | Updated Date | No |
| swoprm_updated_by | udd_ctxt_user | varchar(30) | Yes | Updated By | No |
| swoprm_param_mandatory | udd_designparamcode | varchar(5) | Yes | Flag to indentify the Mandatory check for parameter value reporting | No |
| swoprm_exe_remarks | udd_txt2000 | varchar(2000) | Yes | Remarks | No |
| swoprm_upd_mode | udd_flag | varchar(25) | Yes | Update Mode -new/delta | No |
| swoprm_created_by | udd_ctxt_user | varchar(30) | Yes | Created By | No |
| swoprm_created_datetime | udd_datetime1 | datetime(8) | Yes | Created Date | No |
| swoprm_modified_by | udd_ctxt_user | varchar(30) | Yes | Modified By | No |
| swoprm_modified_date | udd_datetime1 | datetime(8) | Yes | Modified date | No |
| swoprm_trigg_val_min | udd_numericparamval | numeric(13) | Yes | Min Triggering Values defined in task component for the parameter | No |
| swoprm_trigg_val_max | udd_numericparamval | numeric(13) | Yes | max Triggering Values defined in task component for the parameter | No |
| swoprm_followup_task | udd_workunitcode | varchar(30) | Yes | Folloup task defined in the task component for the parameter | No |
| swoprm_followup_action | udd_status | varchar(25) | Yes | Folloup Action defined in the task component for the parameter | No |
| swoprm_param_seq_no | udd_seqno | int(4) | No | An Unique Id, Primary Key- Identity Column - Clustered Index Column | Yes | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| swoprth_part_seq_no | udd_unique_id | bigint(8) | No | An Unique Id, Primary Key- Identity Column - Clustered Index Column | No |
| swoprth_task_track_id | udd_unique_id | bigint(8) | No | The Task trackid for the task code against which part requirments/estimation details are recorded | No |
| swoprth_part_no | udd_partno | varchar(40) | Yes | Part No | No |
| swoprth_part_desc | udd_txt150 | varchar(150) | Yes | part description | No |
| swoprth_ouinstance | udd_ctxt_ouinstance | int(4) | Yes | SWO Ouinstance | No |
| swoprth_mfr_part_no | udd_partno | varchar(40) | Yes | The number issued by the manufacturer of part | No |
| swoprth_mfr_no | udd_vendorcode | varchar(45) | Yes | The code identifying the manufacturer of the part | No |
| swoprth_uom | udd_uom | varchar(15) | Yes | UOM | No |
| swoprth_std_qty | udd_quantity | numeric(13) | Yes | When Task is added in SWO,Part requirment will get copied to SWO along with Standard Qty defined in Task Part requirments | No |
| swoprth_est_qty | udd_quantity | numeric(13) | Yes | Estimated Qty - During task addtion value in Standart Qty will get defaulted to this column | No |
| swoprth_confirmed_qty | udd_quantity | numeric(13) | Yes | During confirmation estimated Qty will get copied to Confirmed Qty | No |
| swoprth_req_qty | udd_quantity | numeric(13) | Yes | During confirmation if the option - Update Requirements is selected then Estimated Qty will get copied to this and visible to Exection for MR generation | No |
| swoprth_mr_qty | udd_quantity | numeric(13) | Yes | Total MR Qty | No |
| swoprth_iss_qty | udd_quantity | numeric(13) | Yes | Total Issue Qty | No |
| swoprth_ret_qty | udd_quantity | numeric(13) | Yes | Total Return Qty | No |
| swoprth_used_qty | udd_quantity | numeric(13) | Yes | Total Used Qty | No |
| swoprth_stock_status | udd_partstatus | varchar(40) | Yes | Stock Status | No |
| swoprth_part_condition | udd_condition | varchar(15) | Yes | Part Condition | No |
| swoprth_need_frequency | udd_designparamcode | varchar(5) | Yes | to specify if the part is mandatory for the execution of the task | No |
| swoprth_rep_class | udd_quickcodes | varchar(25) | Yes | specify the repair classification in order to differentiate the tasks which are over and above the contract (COA - Contract Over and Above) between the operator and the MRO | No |
| swoprth_probability | udd_seqno | int(4) | Yes | The probability of requirement of the part | No |
| swoprth_wh_no | udd_warehouse | varchar(10) | Yes | to specify the warehouse from which the part must be issued. | No |
| swoprth_PMA_flag | udd_chkflag | varchar(1) | Yes | Indicates that the part is a PMA part or Not(Y/N) | No |
| swoprth_billable_flag | udd_chkflag | varchar(1) | Yes | to specify whether warranty is recommended for the part. | No |
| swoprth_warranty_flag | udd_chkflag | varchar(1) | Yes | Estimation Remarks | No |
| swoprth_est_remarks | udd_txt2000 | varchar(2000) | Yes | After confirmation if the estimates are updated then system will incriment the current revision no by one | No |
| swoprth_baseline_rev_no | udd_seqno | int(4) | Yes | baseline revisionno is incremented by 1 every time estimations are updated and confirmed | No |
| swoepd_plan_unplan_flag | udd_chkflag | varchar(1) | Yes | tp identify whther thr Part Requirment added in Estimation phazse or Execution | No |
| swoprth_created_by | udd_ctxt_user | varchar(30) | Yes | Created By | No |
| swoprth_created_date | udd_datetime1 | datetime(8) | Yes | Created date | No |
| swoprth_modified_by | udd_ctxt_user | varchar(30) | Yes | Modified by | No |
| swoprth_modified_date | udd_datetime1 | datetime(8) | Yes | Modified date | No |
| swoprth_timestamp | udd_timestamp | int(4) | Yes | Timestamp | No |
| REPLICATION_KEY | _bigint_8 | Bigint(8) | No | Replication key | Yes |
| swoprth_coa_flag | udd_designparamcode | varchar(5) | No | Coa Flag | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| swoprt_part_seq_no | udd_unique_id | bigint(8) | No | An Unique Id, Primary Key- Identity Column - Clustered Index Column | Yes |
| swoprt_task_track_id | udd_unique_id | bigint(8) | No | The Task trackid for the task code against which part requirments/estimation details are recorded | Yes |
| swoprt_part_no | udd_partno | varchar(40) | No | Part No | No |
| swoprt_part_desc | udd_txt150 | varchar(150) | Yes | part description | No |
| swoprt_ouinstance | udd_ctxt_ouinstance | int(4) | Yes | SWO Ouinstance | No |
| swoprt_mfr_part_no | udd_partno | varchar(40) | Yes | The number issued by the manufacturer of part | No |
| swoprt_mfr_no | udd_vendorcode | varchar(45) | Yes | The code identifying the manufacturer of the part | No |
| swoprt_uom | udd_uom | varchar(15) | Yes | UOM | No |
| swoprt_std_qty | udd_quantity | numeric(13) | Yes | When Task is added in SWO,Part requirment will get copied to SWO along with Standard Qty defined in Task Part requirments | No |
| swoprt_est_qty | udd_quantity | numeric(13) | Yes | Estimated Qty - During task addtion value in Standart Qty will get defaulted to this column | No |
| swoprt_confirmed_qty | udd_quantity | numeric(13) | Yes | During confirmation estimated Qty will get copied to Confirmed Qty | No |
| swoprt_req_qty | udd_quantity | numeric(13) | Yes | During confirmation if the option - Update Requirements is selected then Estimated Qty will get copied to this and visible to Exection for MR generation | No |
| swoprt_mr_qty | udd_quantity | numeric(13) | Yes | Total MR Qty | No |
| swoprt_iss_qty | udd_quantity | numeric(13) | Yes | Total Issue Qty | No |
| swoprt_ret_qty | udd_quantity | numeric(13) | Yes | Total Return Qty | No |
| swoprt_used_qty | udd_quantity | numeric(13) | Yes | Total Used Qty | No |
| swoprt_stock_status | udd_partstatus | varchar(40) | Yes | Stock Status | No |
| swoprt_part_condition | udd_condition | varchar(15) | Yes | Part Condition | No |
| swoprt_need_frequency | udd_designparamcode | varchar(5) | Yes | to specify if the part is mandatory for the execution of the task | No |
| swoprt_rep_class | udd_quickcodes | varchar(25) | Yes | specify the repair classification in order to differentiate the tasks which are over and above the contract (COA - Contract Over and Above) between the operator and the MRO | No |
| swoprt_probability | udd_quantity | numeric(13) | Yes | The probability of requirement of the part | No |
| swoprt_wh_no | udd_warehouse | varchar(10) | Yes | to specify the warehouse from which the part must be issued. | No |
| swoprt_PMA_flag | udd_chkflag | varchar(1) | Yes | Indicates that the part is a PMA part or Not(Y/N) | No |
| swoprt_warranty_flag | udd_chkflag | varchar(1) | Yes | to specify whether warranty is recommended for the part. | No |
| swoprt_est_remarks | udd_txt2000 | varchar(2000) | Yes | Estimation Remarks | No |
| swoprt_curr_rev_no | udd_seqno | int(4) | Yes | After confirmation if the estimates are updated then system will incriment the current revision no by one | No |
| swoprt_baseline_rev_no | udd_seqno | int(4) | Yes | baseline revisionno is incremented by 1 every time estimations are updated and confirmed | No |
| swoepd_plan_unplan_flag | udd_chkflag | varchar(1) | Yes | tp identify whther thr Part Requirment added in Estimation phazse or Execution | No |
| swoprt_created_by | udd_ctxt_user | varchar(30) | Yes | Created By | No |
| swoprt_created_date | udd_datetime1 | datetime(8) | Yes | Created date | No |
| swoprt_modified_by | udd_ctxt_user | varchar(30) | Yes | Modified by | No |
| swoprt_modified_date | udd_datetime1 | datetime(8) | Yes | Modified date | No |
| swoprt_timestamp | udd_timestamp | int(4) | Yes | Timestamp | No |
| swoprt_mat_type | udd_designparamcode | varchar(5) | Yes | holds the following values RG-regulat,MC-Main core | No |
| swoprt_effect_flag | udd_designparamcode | varchar(5) | Yes | Effectivity flag | No |
| swoprt_effect_notes | udd_txt2000 | varchar(2000) | Yes | Effectivity Notes | No |
| swoprt_std_rate | udd_amount | numeric(13) | Yes | The standard cost of the part | No |
| swoprt_new_part_flag | udd_chkflag | varchar(1) | Yes | To identify the existing or new part request initiated in Execution | No |
| swoprt_req_mode | udd_designparamcode | varchar(5) | Yes | Requested Mode | No |
| swoprt_alt_type | udd_designparamcode | varchar(5) | Yes | Alternate part type | No |
| swoprt_alt_part_no | udd_partno | varchar(40) | Yes | alternate part no | No |
| swoprt_mod_part_no | udd_partno | varchar(40) | Yes | Modified part no | No |
| swoprt_ret_flag | udd_chkflag | varchar(1) | Yes | Flag used to identify pending return -based on the disposition code system will update the pending return flag | No |
| swoprt_Pend_qty | udd_quantity | numeric(13) | Yes | based on the disposition code system will update the pending return Qty | No |
| swoprt_Mcore_ret_remarks | udd_txt2000 | varchar(2000) | Yes | Return Remarks | No |
| swoprt_request_comments | udd_txt2000 | varchar(2000) | Yes | Comments | No |
| swoprt_latest_return_no | udd_documentno | varchar(40) | Yes | latest Return document No | No |
| swoprt_return_wh | udd_warehouse | varchar(10) | Yes | return warehouse | No |
| swoprt_core_cr_type | udd_quickcodes | varchar(25) | Yes | Flag used to indentify the core type -MC-Main core,AC-Additional Core | No |
| swoprt_core_cr_id | udd_unique_id | bigint(8) | Yes | Unique used to link the Associate core details table | No |
| swoprt_exchange_flag | udd_chkflag | varchar(1) | Yes | Flag to identify the exchange order has created for the part | No |
| swoprt_prtchng_flag | udd_chkflag | varchar(1) | Yes | flag to identify whether any Part serial change done | No |
| swoprt_ref_doc_type | udd_type | varchar(25) | Yes | for External Swo,column will be updated with the value CO | No |
| swoprt_ref_doc_no | udd_documentno | varchar(40) | Yes | for External Swo,column will be updated with the customer order No | No |
| swoprt_ref_doc_lineno | udd_lineno | int(4) | Yes | for External Swo,column will be updated with the customer order Line no | No |
| swoprt_est_done | udd_chkflag | varchar(1) | Yes | Flag to indentify the Estimation is done or not | No |
| swoprt_mod_mfrpart_no | udd_partno | varchar(40) | Yes | Modified manufacture part no | No |
| swoprt_mod_mfrno | udd_vendorcode | varchar(45) | Yes | Manufacture for the modified part no | No |
| swoprt_alt_mfrpart_no | udd_partno | varchar(40) | Yes | manufacture part no for the alternate | No |
| swoprt_alt_mfrno | udd_partno | varchar(40) | Yes | Manufacture for the alternate part no | No |
| swoprt_coa_flag | udd_designparamcode | varchar(5) | Yes | Coa Flag | No |
| swoprt_billable_flag | udd_chkflag | varchar(1) | Yes | Billable Flag | No |
| swoprt_est_cost | udd_amount | numeric(13) | Yes | Estimation Cost | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| swopsl_unique_id | udd_unique_id | bigint(8) | No | An Unique Id, Primary Key- Identity Column - Clustered Index Column | Yes |
| swopsl_part_seq_no | udd_unique_id | bigint(8) | No | Column used to link the part requirment/Estimation record | No |
| swopsl_task_track_id | udd_unique_id | bigint(8) | No | The Task trackid for the task code against which Serial /lot requirments are recorded | No |
| swopsl_ouinstance | udd_ctxt_ouinstance | int(4) | No | SWO Ouinstance | No |
| swopsl_seq_no | udd_unique_id | bigint(8) | No | Seqno | No |
| swopsl_part_no | udd_partno | varchar(40) | No | The code identifying the part for which the task must be executed | No |
| swopsl_mfr_no | udd_manufacturernofilter | varchar(45) | Yes | The number assigned to the part, by the manufacturer of the part | No |
| swopsl_mfrpart_no | udd_partno | varchar(40) | Yes | The code identifying the manufacturer of the part | No |
| swopsl_serial_no | udd_partserialnumber | varchar(40) | Yes | Serial No | No |
| swopsl_lot_no | udd_lotno | varchar(18) | Yes | Lot No | No |
| swopsl_quantity | udd_quantity | numeric(13) | Yes | Required Qty | No |
| swopsl_mr_quantity | udd_quantity | numeric(13) | Yes | Total MR qty | No |
| swopsl_ret_quantity | udd_quantity | numeric(13) | Yes | Column hold the pending return qty | No |
| swopsl_ret_flag | udd_designparamcode | varchar(5) | Yes | Flag to identify whether part needs to be returned or not(Y/N)-Flag is applicable for main core | No |
| swopsl_mat_type | udd_designparamcode | varchar(5) | Yes | MC-Main Core,RG-Regular | No |
| swopsl_created_by | udd_ctxt_user | varchar(30) | Yes | Created By | No |
| swopsl_created_date | udd_datetime1 | datetime(8) | Yes | Created Date | No |
| swopsl_modified_by | udd_ctxt_user | varchar(30) | Yes | Modified by | No |
| swopsl_modified_date | udd_datetime1 | datetime(8) | Yes | Modified Date | No |
| swopsl_latest_return_no | udd_documentno | varchar(40) | Yes | latest Return document No | No |
| swopsl_Mcore_ret_remarks | udd_txt2000 | varchar(2000) | Yes | Return Remarks | No |
| swopsl_return_wh | udd_warehouse | varchar(10) | Yes | return warehouse | No |
| swopsl_mfg_serial_no | udd_partserialnumber | varchar(40) | Yes | Manufacturing Serial no.For Job type Make will have a value in this column | No |
| swopsl_mfg_lot_no | udd_lotno | varchar(18) | Yes | Manufacturing lot no.For Job type Make will have a value in this column | No |
| swopsl_mod_part_no | udd_partno | varchar(40) | Yes | Modified part no | No |
| swopsl_mod_serial_no | udd_partserialnumber | varchar(40) | Yes | Modified serial no-Repair Receipt or part Serial change transaction will update the modified serial in this column | No |
| swopsl_mod_mfrpart_no | udd_partno | varchar(40) | Yes | Modified manufacture part no | No |
| swopsl_mod_mfrno | udd_vendorcode | varchar(45) | Yes | Modified manufacturer for the part no | No |
| swopsl_mod_lotno | udd_lotno | varchar(18) | Yes | modified lot no | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| swoptg_unique_no | udd_seqno | int(4) | No | An Unique Id, Primary Key- Identity Column - Clustered Index Column | Yes |
| sowptg_ouinstance | udd_ctxt_ouinstance | int(4) | Yes | Ou Instance | No |
| swoptg_tag_id | udd_documentno | varchar(40) | Yes | The code identifying the part tag to tag the component | No |
| sowptg_tag_status | udd_designparamcode | varchar(5) | Yes | Part Tag Status | No |
| sowptg_no_copies | udd_seqno | int(4) | Yes | Indicates the number of copies of certificates printed. | No |
| Sowptg_replaced_tag_id | udd_documentno | varchar(40) | Yes | The number identifying the part tag that was last approved | No |
| swoptg_swo_no | udd_documentno | varchar(40) | Yes | The number identifying the shop work order | No |
| swoptg_swo_part | udd_partno | varchar(40) | Yes | The code identifying the part pertaining to the shop work order | No |
| swoptg_swo_serial | udd_partserialnumber | varchar(40) | Yes | The serial number of the component against which the shop work order is raised | No |
| swoptg_swo_event_id | udd_event | varchar(40) | Yes | Event ID | No |
| swoptg_current_flag | udd_flag | varchar(25) | Yes | Current Flag | No |
| swoptg_work_performed | udd_taskcode | varchar(30) | Yes | All the execution level tasks. | No |
| swoptg_involved_in_rework | udd_flag | varchar(25) | Yes | Indicates if work performed on the part is other than what is in the work order, like for e.g. refurbishing, oil change etc. | No |
| swoptg_final_disposition | udd_quickcode | varchar(25) | Yes | The type of the work performed on the part during the final stage which could be repair, replace, exchange, etc. | No |
| swoptg_comments | udd_txt2000 | varchar(2000) | Yes | Any remarks associated with the part tag. | No |
| swoptg_sb_ad_ref | udd_txt2000 | varchar(2000) | Yes | SB/AD | No |
| swoptg_reason_for_rej | udd_txt2000 | varchar(2000) | Yes | Reason for Rejection | No |
| swoptg_auth_emp_code | udd_empcode | varchar(15) | Yes | Emp code | No |
| swoptg_auth_wc_code | udd_wccode | varchar(30) | Yes | Primary work center | No |
| swoptg_auth_license_no | udd_flag | varchar(25) | Yes | Licensene no | No |
| swoptg_auth_no | udd_documentno | varchar(40) | Yes | AuthorizationNo | No |
| swoptg_auth_ref_no | udd_documentno | varchar(40) | Yes | Authorized Ref No | No |
| swoptg_auth_skill_code | UDD_SKILLCODE | varchar(10) | Yes | Skill code | No |
| swoptg_issue_date | udd_datetime1 | datetime(8) | Yes | Issue Date | No |
| swoptg_created_by | udd_ctxt_user | varchar(30) | Yes | Created by | No |
| swoptg_created_date | udd_datetime1 | datetime(8) | Yes | Created Date | No |
| swoptg_modified_by | udd_ctxt_user | varchar(30) | Yes | Modified by | No |
| swoptg_modified_date | udd_datetime1 | datetime(8) | Yes | Modified date | No |
| swoptg_last_printed_on | udd_datetime1 | datetime(8) | Yes | Printed y/n | No |
| sowptg_Filename | udd_filename | varchar(50) | Yes | Document Attachment details | No |
| sowptg_approved_by | udd_ctxt_user | varchar(30) | Yes | Approved by | No |
| sowptg_approved_date | udd_datetime1 | datetime(8) | Yes | Approved Date | No |
| sowptg_timestamp | udd_timestamp | int(4) | Yes | Timestamp | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| swoqcd_ouinstance | udd_ctxt_ouinstance | int(4) | Yes | Ou Instance | No |
| swoqcd_qcd_category | udd_quickcodes | varchar(25) | Yes | Category | No |
| swoqcd_qcd_code | udd_flag | varchar(25) | Yes | Quick Code | No |
| swoqcd_status | udd_designparamcode | varchar(5) | Yes | Status for the Quick code | No |
| swoqcd_desc | udd_txt80 | varchar(80) | Yes | Description | No |
| swoqcd_createdby | udd_ctxt_user | varchar(30) | Yes | Created By | No |
| swoqcd_createddate | _datetime_8 | datetime(8) | Yes | Created Date | No |
| swoqcd_modifiedby | udd_ctxt_user | varchar(30) | Yes | Modified by | No |
| swoqcd_modifieddate | _datetime_8 | datetime(8) | Yes | Modified date | No |
| swoqcd_timestamp | udd_timestamp | int(4) | Yes | Timestamp | No |
| REPLICATION_KEY | _bigint_8 | Bigint(8) | No | Replication key | Yes |
| created_area_code | varchar | Char(10) | Yes | Area code creation | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| sworc_res_act_seq_no | udd_unique_id | bigint(8) | No | An Unique Id, Primary Key- Identity Column - Clustered Index Column | Yes |
| sworc_res_seq_no | udd_unique_id | bigint(8) | No | Column to Link Resource estimation Details | No |
| sworc_task_track_id | udd_unique_id | bigint(8) | No | The Task trackid for the task code against which the discrepancy / observation is reported. | No |
| sworc_res_ouinstance | udd_ctxt_ouinstance | int(4) | Yes | Ou Instance | No |
| sworc_res_code | udd_resourcecode | varchar(40) | Yes | Rescource Code | No |
| sworc_res_type | udd_designparamcode | varchar(5) | Yes | Resource Type | No |
| sworc_fac_obj_code | udd_resourcecode | varchar(40) | Yes | facilit Object code | No |
| sworc_from_date_time | udd_datetime1 | datetime(8) | Yes | From Date | No |
| sworc_to_date_time | udd_datetime1 | datetime(8) | Yes | To date | No |
| sworc_actual_hrs | udd_quantity | numeric(13) | Yes | Actual Hours | No |
| sworc_used_nos | udd_quantity | numeric(13) | Yes | user nos | No |
| sworc_used_uom | udd_uom | varchar(15) | Yes | Used Uom | No |
| sworc_res_cost | udd_amount | numeric(13) | Yes | Resource cost | No |
| sworc_comments | udd_txt2000 | varchar(2000) | Yes | Comments | No |
| sworc_created_by | udd_ctxt_user | varchar(30) | Yes | Created by | No |
| sworc_created_date | udd_datetime1 | datetime(8) | Yes | Created Date | No |
| sworc_modified_by | udd_ctxt_user | varchar(30) | Yes | Modified By | No |
| sworc_modified_date | udd_datetime1 | datetime(8) | Yes | Modified Date | No |
| sworc_timestamp | udd_timestamp | int(4) | Yes | Timestamp | No |
| sworc_rep_class | udd_quickcodes | varchar(25) | Yes | Repair Classification | No |
| sworc_cost_center | fin_maccost | varchar(32) | Yes | Cost center | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| sworesh_res_seq_no | udd_unique_id | bigint(8) | No | Column to Link Resource estimation Details | No |
| sworesh_task_track_id | udd_unique_id | bigint(8) | No | The Task trackid for the task code against which the discrepancy / observation is reported. | No |
| sworesh_ouinstance | udd_ctxt_ouinstance | int(4) | Yes | Ou Instance | No |
| sworesh_res_code | udd_resourcecode | varchar(40) | Yes | Rescource Code | No |
| sworesh_res_type | udd_designparamcode | varchar(5) | Yes | Resource Type | No |
| sworesh_std_nos | udd_quantity | numeric(13) | Yes | Standard Nos defaulted from task resource requirments | No |
| sworesh_std_time | udd_quantity | numeric(13) | Yes | Standard Time | No |
| sworesh_est_nos | udd_quantity | numeric(13) | Yes | Estimated Nos | No |
| sworesh_est_time | udd_quantity | numeric(13) | Yes | Estimated Time | No |
| sworesh_est_time_uom | udd_uom | varchar(15) | Yes | Estimated Time Uom | No |
| sworesh_confirmed_nos | udd_quantity | numeric(13) | Yes | Confirmed Nos | No |
| sworesh_confirmed_time | udd_quantity | numeric(13) | Yes | Confirmed time | No |
| sworesh_req_nos | udd_quantity | numeric(13) | Yes | Required No | No |
| sworesh_req_time | udd_quantity | numeric(13) | Yes | Required Time | No |
| sworesh_used_nos | udd_quantity | numeric(13) | Yes | used Nos | No |
| sworesh_used_time | udd_quantity | numeric(13) | Yes | used time | No |
| sworesh_rep_class | udd_quickcodes | varchar(25) | Yes | Repair Classification | No |
| sworesh_coa_flag | udd_designparamcode | varchar(5) | Yes | Coa Flag | No |
| sworesh_warranty_flag | udd_chkflag | varchar(1) | Yes | Warranty flag | No |
| sworesh_est_remarks | udd_txt2000 | varchar(2000) | Yes | Estimation Remarks | No |
| sworesh_baseline_rev_no | udd_seqno | int(4) | Yes | After confirmation if the estimates are updated then system will incriment the current revision no by one | No |
| sworesh_plan_unplan_flag | udd_chkflag | varchar(1) | Yes | baseline revisionno is incremented by 1 every time estimations are updated and confirmed | No |
| sworesh_created_by | udd_ctxt_user | varchar(30) | Yes | to identify whther thr Part Requirment added in Estimation phazse or Execution | No |
| sworesh_created_date | udd_datetime1 | datetime(8) | Yes | Created By | No |
| sworesh_modified_by | udd_ctxt_user | varchar(30) | Yes | Modified by | No |
| sworesh_modified_date | udd_datetime1 | datetime(8) | Yes | Modified date | No |
| sworesh_timestamp | udd_timestamp | int(4) | Yes | Timestamp | No |
| REPLICATION_KEY | _bigint_8 | Bigint(8) | No | Replication key | Yes | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| swores_res_seq_no | udd_unique_id | bigint(8) | No | An Unique Id, Primary Key- Identity Column - Clustered Index Column | Yes |
| swores_task_track_id | udd_unique_id | bigint(8) | No | The Task trackid for the task code against which the discrepancy / observation is reported. | Yes |
| swores_ouinstance | udd_ctxt_ouinstance | int(4) | Yes | Ou Instance | No |
| swores_res_code | udd_resourcecode | varchar(40) | No | Rescource Code | No |
| swores_res_type | udd_designparamcode | varchar(5) | No | Resource Type | No |
| swores_std_nos | udd_quantity | numeric(13) | Yes | Standard Nos defaulted from task resource requirments | No |
| swores_std_time | udd_quantity | numeric(13) | Yes | Standard Time | No |
| swores_est_nos | udd_quantity | numeric(13) | Yes | Estimated Nos | No |
| swores_est_time | udd_quantity | numeric(13) | Yes | Estimated Time | No |
| swores_est_time_uom | udd_uom | varchar(15) | Yes | Estimated Time Uom | No |
| swoprt_confirmed_nos | udd_quantity | numeric(13) | Yes | Confirmed Nos | No |
| swoprt_confirmed_time | udd_quantity | numeric(13) | Yes | Confirmed time | No |
| swoprt_req_nos | udd_quantity | numeric(13) | Yes | Required No | No |
| swoprt_req_time | udd_quantity | numeric(13) | Yes | Required Time | No |
| swores_used_nos | udd_quantity | numeric(13) | Yes | used Nos | No |
| swores_used_time | udd_quantity | numeric(13) | Yes | used time | No |
| swores_rep_class | udd_quickcodes | varchar(25) | Yes | Repair Classification | No |
| swores_coa_flag | udd_designparamcode | varchar(5) | Yes | Coa Flag | No |
| swores_warranty_flag | udd_chkflag | varchar(1) | Yes | Warranty flag | No |
| swores_est_remarks | udd_txt2000 | varchar(2000) | Yes | Estimation Remarks | No |
| swores_curr_rev_no | udd_seqno | int(4) | Yes | After confirmation if the estimates are updated then system will incriment the current revision no by one | No |
| swores_baseline_rev_no | udd_seqno | int(4) | Yes | baseline revisionno is incremented by 1 every time estimations are updated and confirmed | No |
| swores_plan_unplan_flag | udd_chkflag | varchar(1) | Yes | to identify whther thr Part Requirment added in Estimation phazse or Execution | No |
| swores_created_by | udd_ctxt_user | varchar(30) | Yes | Created By | No |
| swores_created_date | udd_datetime1 | datetime(8) | Yes | Created date | No |
| swores_modified_by | udd_ctxt_user | varchar(30) | Yes | Modified by | No |
| swores_modified_date | udd_datetime1 | datetime(8) | Yes | Modified date | No |
| swores_timestamp | udd_timestamp | int(4) | Yes | Timestamp | No |
| swores_est_rate | udd_amount | numeric(13) | Yes | Estimated rate | No |
| swores_est_cost | udd_amount | numeric(13) | Yes | Estimated Cost | No |
| swores_std_time_uom | udd_uom | varchar(15) | Yes | Standard Time UOM | No |
| swores_est_done | udd_chkflag | varchar(1) | Yes | Flag to indentify the Estimation is done or not | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| swortngh_ou_instance | udd_ctxt_ouinstance | int(4) | Yes | Ouinstance | No |
| swortngh_routing_id | udd_count | int(4) | Yes | Routing ID-Column to link the Routing Dtl table | No |
| swortngh_his_id | udd_count | int(4) | No | History id to log the changes for the routing details | Yes |
| swortngh_flag | udd_flag | varchar(25) | Yes | Flag used to identify the whether user has changed the routing details or System | No |
| swortngh_event | udd_flag | varchar(25) | Yes | Identify the source for the routing | No |
| swortngh_disposition | udd_flag | varchar(25) | Yes | Disposition code | No |
| swortngh_from_wc | udd_workunitcode | varchar(30) | Yes | From Work center | No |
| swortngh_to_wc | udd_workunitcode | varchar(30) | Yes | To Work Center | No |
| swortngh_rep_shop | udd_documentno | varchar(40) | Yes | Repai Agency | No |
| swortngh_req_date | udd_datetime1 | datetime(8) | Yes | Required date | No |
| swortngh_return_WH | udd_warehouse | varchar(10) | Yes | Return to Warhouse | No |
| swortngh_return_WC | udd_workunitcode | varchar(30) | Yes | Return Work Center | No |
| swortngh_created_date | udd_datetime1 | datetime(8) | Yes | Created Date | No |
| swortngh_created_by | udd_ctxt_user | varchar(30) | Yes | Created By | No |
| swortng_from_WH | udd_workunitcode | varchar(30) | Yes | From Warehouse | No |
| swortng_from_repagency | udd_workunitcode | varchar(30) | Yes | From repair agency | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| swortng_ou_instance | udd_ctxt_ouinstance | int(4) | Yes | Ouinstance | No |
| swortngh_routing_id | udd_count | int(4) | Yes | Column to Link the routing Dtl table | No |
| swortngh_hisId | udd_count | int(4) | No | History id to log the changes for the routing details | Yes |
| swortngh_frm_status | udd_flag | varchar(25) | Yes | from Routing status | No |
| swortngh_To_status | udd_flag | varchar(25) | Yes | To Routing Status | No |
| swortngh_created_date | udd_datetime1 | datetime(8) | Yes | Created Date | No |
| swortngh_created_by | udd_ctxt_user | varchar(30) | Yes | Created By | No |
| swortngh_modified_date | udd_datetime1 | datetime(8) | Yes | Modified date | No |
| swortngh_modified_by | udd_ctxt_user | varchar(30) | Yes | Modified by | No |
| swortngh_event | udd_flag | varchar(25) | Yes | Identify the source for the routing | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| swortng_ou_instance | udd_ctxt_ouinstance | int(4) | Yes | Ou Instance | No |
| swortng_routing_id | udd_count | int(4) | No | An Unique Id, Primary Key- Identity Column - Clustered Index Column | Yes |
| swortng_part_no | udd_partno | varchar(40) | Yes | part No | No |
| swortng_serial_no | udd_partserialnumber | varchar(40) | Yes | Serial No | No |
| swortng_mfrPrtNo | udd_partno | varchar(40) | Yes | The part number issued by the manufacturer of the part which you want to route | No |
| swortng_mfrNo | udd_vendorcode | varchar(45) | Yes | The manufacturer number of the Mfr. Part # which you wish to route | No |
| swortng_routing_qty | udd_sequence | numeric(9) | Yes | Routing Qty | No |
| swortng_Disposition | udd_flag | varchar(25) | Yes | Disposition code | No |
| swortng_from_wc | udd_workunitcode | varchar(30) | Yes | Routing From Work center | No |
| swortng_to_wc | udd_workunitcode | varchar(30) | Yes | Routing to Work center | No |
| swortng_rep_shopno | udd_documentno | varchar(40) | Yes | Repair Shop no-For external routing | No |
| swortng_wrk_req | udd_txt2000 | varchar(2000) | Yes | Work requested | No |
| swortng_ReqDate | udd_datetime1 | datetime(8) | Yes | required date | No |
| swortng_current_Loc | udd_txt2000 | varchar(2000) | Yes | Current location | No |
| swortng_Routing_dtl | udd_txt2000 | varchar(2000) | Yes | Any information relating to the routed parts | No |
| swortng_return_WC | udd_workunitcode | varchar(30) | Yes | The number identifying the work center to which the part is to be returned | No |
| swortng_return_WH | udd_warehouse | varchar(10) | Yes | The number identifying the warehouse to which the part is to be returned. | No |
| swortng_routing_status | udd_flag | varchar(25) | Yes | Routing status | No |
| swortng_genrtd_swo | udd_documentno | varchar(40) | Yes | The shop work order number of the part which is routed. | No |
| swortng_ro_no | udd_documentno | varchar(40) | Yes | The number identifying the repair order of the part which is  routed | No |
| swortng_cr_no | udd_documentno | varchar(40) | Yes | CR Number | No |
| swortng_refdoc_no | udd_documentno | varchar(40) | Yes | specify the reference document number against which you wish to retrieve the routing details | No |
| swortng_refdoc_typ | udd_flag | varchar(25) | Yes | Values could be AME-A/C Maint. Exec. Ref. #,SWO-SWO# | No |
| swortng_flag | udd_flag | varchar(25) | Yes | Flag to identify the latest Routing Deftails for the Part/Serial No | No |
| swortng_print_status | udd_flag | varchar(25) | Yes | Print status | No |
| swortng_timestamp | udd_timestamp | int(4) | Yes | Timestamp | No |
| swortng_rem_from_ac | udd_aircraftnumber | varchar(30) | Yes | part / aircraft from which the part is removed for which you wish to retrieve the routing details | No |
| swortng_parent_prtno | udd_partno | varchar(40) | Yes | NHA part No | No |
| swortng_parent_srlno | udd_partserialnumber | varchar(40) | Yes | NHA Serial No | No |
| swortng_created_date | udd_datetime1 | datetime(8) | Yes | Created Date | No |
| swortng_created_by | udd_ctxt_user | varchar(30) | Yes | Created By | No |
| swortng_modified_date | udd_datetime1 | datetime(8) | Yes | Modified Date | No |
| swortng_modified_by | udd_ctxt_user | varchar(30) | Yes | Modified By | No |
| swortng_event | udd_flag | varchar(25) | Yes | Event | No |
| swortng_task_track_id | udd_unique_id | bigint(8) | Yes | Task Track ID | No |
| swortng_from_WH | udd_workunitcode | varchar(30) | Yes | From Warehouse | No |
| swortng_from_repagency | udd_workunitcode | varchar(30) | Yes | From repair agency | No |
| swortng_ReasonFrRmvl | udd_txt2000 | varchar(2000) | Yes | Reason for Removal | No |
| swortng_core_lot_no | udd_lotno | varchar(18) | Yes | Lot No | No |
| swortng_MR_doc_no | udd_documentno | varchar(40) | Yes | MR Number | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| swosgh_swo_no | udd_documentno | varchar(40) | No | SWO no | No |
| swosgh_task_track_id | udd_seqno | int(4) | No | The Task trackid for the task code against which the sign comments are recorded | No |
| swosgh_ouinstance | udd_ctxt_ouinstance | int(4) | Yes | Ouinstance | No |
| swosgh_sub_task_desc | udd_txt2000 | varchar(2000) | Yes | Sub Task Description | No |
| swosgh_skill_code | udd_resourcecode | varchar(40) | Yes | Skill code | No |
| swosch_recorded_by | udd_ctxt_user | varchar(30) | Yes | Recorded by | No |
| swosgh_res_grp | udd_flag | varchar(25) | Yes | Resource group | No |
| swosgh_emp_code | udd_ctxt_user | varchar(30) | Yes | Emp code | No |
| swosgh_created_date | _datetime_8 | datetime(8) | Yes | Created Date | No |
| swosgh_sign_off_comments | udd_txt2000 | varchar(2000) | Yes | Sign off comments | No |
| swosgh_comments_type | udd_flag | varchar(25) | Yes | Comments Type | No |
| swosgh_sign_off_flag | udd_flag | varchar(25) | Yes | Sign off status | No |
| swosgh_seq_no | udd_seqno | int(4) | No | An Unique Id, Primary Key- Identity Column - Clustered Index Column | Yes | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| swostso_sub_task_seq_no | udd_unique_id | bigint(8) | No | An Unique Id, Primary Key- Identity Column - Clustered Index Column | Yes |
| swostk_task_track_id | udd_unique_id | bigint(8) | No | The Task trackid for the task code against which the Sub task / Sign off informaton is stored | No |
| swostk_swo_no | udd_documentno | varchar(40) | No | SWO no | No |
| swostk_seq_no | udd_seqno | int(4) | No | SUB task level running o | No |
| swostk_ouinstance | udd_ctxt_ouinstance | int(4) | Yes | Ouinstance | No |
| swostk_sub_task_desc | udd_txt2000 | varchar(2000) | Yes | Sub Task Description | No |
| swostk_resource_group | udd_designparamcode | varchar(5) | Yes | resource Group | No |
| swostk_recorded_by | udd_ctxt_user | varchar(30) | Yes | Recorded by | No |
| swostk_reported_by | udd_ctxt_user | varchar(30) | Yes | Reported By | No |
| swostk_reported_datetime | _datetime_8 | datetime(8) | Yes | Reported date | No |
| swostk_skill_code | udd_resourcecode | varchar(40) | Yes | Skill code | No |
| swostk_skill_ou | udd_ctxt_ouinstance | int(4) | Yes | HRMS Ouinstance | No |
| swostk_sign_off_status | udd_designparamcode | varchar(5) | Yes | Sign off Status | No |
| swostk_sign_off_date | _datetime_8 | datetime(8) | Yes | Sign Off Date | No |
| swostk_sign_off_comments | udd_txt2000 | varchar(2000) | Yes | Sign Of comments | No |
| swostk_emp_code | udd_ctxt_user | varchar(30) | Yes | Emp code | No |
| swostk_created_by | udd_ctxt_user | varchar(30) | Yes | Crated By | No |
| swostk_created_date | _datetime_8 | datetime(8) | Yes | Created Date | No |
| swostk_modified_by | udd_ctxt_user | varchar(30) | Yes | Modified By | No |
| swostk_modified_date | _datetime_8 | datetime(8) | Yes | Modified date | No |
| swostk_timestamp | udd_timestamp | int(4) | Yes | Timestamp | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| swosts_swo_no | udd_documentno | varchar(40) | No | SWO no | No |
| swosts_ouinstance | udd_ctxt_ouinstance | int(4) | Yes | Ouinstance | No |
| swosts_entity_chg | udd_designparamcode | varchar(5) | Yes | Work Order / Task Level Status change | No |
| swosts_task_track_id | _bigint_8 | Bigint(8) | Yes | The Task trackid for the task code against Status changes are recorded | No |
| swosts_task_code | udd_workunitcode | varchar(30) | Yes | task code | No |
| swosts_task_ou | udd_ctxt_ouinstance | int(4) | Yes | task ouinstance | No |
| swosts_from_status | udd_designparamcode | varchar(5) | Yes | From Status | No |
| swosts_to_status | udd_designparamcode | varchar(5) | Yes | To Status | No |
| swosts_station | udd_oucode | varchar(32) | Yes | Station | No |
| swosts_changed_by | udd_ctxt_user | varchar(30) | Yes | Changed by | No |
| swosts_changed_date | _datetime_8 | datetime(8) | Yes | Changed Date | No |
| swosts_wc_code | udd_wccode | varchar(30) | Yes | Work Center Code | No |
| REPLICATION_KEY | _bigint_8 | Bigint(8) | No | Replication Key | Yes | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| swosts_event_code | udd_status | varchar(25) | Yes | Meta Data for Append/Upgrade of Tasks in SWO | No |
| swosts_from_status | udd_status | varchar(25) | Yes | From status | No |
| swosts_from_action | udd_status | varchar(25) | Yes | Action select by user | No |
| swosts_to_status | udd_status | varchar(25) | Yes | To Status | No |
| swosts_to_action | udd_status | varchar(25) | Yes | To action | No |
| swosts_destination_status | udd_status | varchar(25) | Yes | Destination status | No |
| swosts_destination_action | udd_status | varchar(25) | Yes | Destination action | No |
| swosts_rule_comments | udd_txt2000 | varchar(2000) | Yes | Rule Comments | No |
| REPLICATION_KEY | _bigint_8 | Bigint(8) | No | Replication Key | Yes | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| swotad_task_track_id | udd_unique_id | bigint(8) | No | The Task trackid for the task code against which additional Comments are recorded | Yes |
| swotad_eng_instruction | udd_txt2000 | varchar(2000) | Yes | Engineering Instructon | No |
| swotad_wrk_scp_notes | udd_txt2000 | varchar(2000) | Yes | Work Scope Notes | No |
| swotad_exec_comments | udd_txt2000 | varchar(2000) | Yes | Execution Comments | No |
| swotad_est_remarks | udd_txt2000 | varchar(2000) | Yes | Estimation Remarks | No |
| swotad_ReEst_Remarks | udd_txt2000 | varchar(2000) | Yes | Re Estimation Remarks | No | |
| Table Name : | swo_swotct_teardown_comp_times |
| Comment : | Tear down screen detail table. This page allows you to generate a report containing the details of the maintenance activities carried out on a part, associated work order details, warranty details of the part, reason for repair / removal of part as specif |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| swotct_swo_no | udd_documentno | varchar(40) | Yes | SWO no | No |
| swotct_tdr_tracking_id | udd_documentno | varchar(40) | Yes | Tracking Id | No |
| swotct_tracking_rev | udd_seqno | int(4) | Yes | Revision No | No |
| swotct_ouinstance | udd_ctxt_ouinstance | int(4) | Yes | Ou Instance | No |
| swotct_param_code | udd_parameter | varchar(40) | Yes | Parameter details | No |
| swotct_since_overhaul | udd_numericparamval | numeric(13) | Yes | Overhaul value - Entered by User | No |
| swotct_since_shop_visit | udd_numericparamval | numeric(13) | Yes | Shop Visit - Entered by User | No |
| swotct_tot_time | udd_numericparamval | numeric(13) | Yes | Total Time | No |
| REPLICATION_KEY | _bigint_8 | Bigint(8) | No | Replication Key | Yes |
| swotct_UOM | udd_uom | varchar(15) | Yes | UOM correponding to the chosen Parameter | No |
| swotct_since_repair | udd_numericparamval | numeric(13) | Yes | Since Repair - Entered by User | No |
| swotct_since_inspection | udd_numericparamval | numeric(13) | Yes | Since Inspection - Entered by User | No |
| swotct_present_value | udd_txt20 | varchar(20) | Yes | Present Value - Entered by User | No | |
| Table Name : | swo_swotdr_teardown_report |
| Comment : | Tear down screen header table. This page allows you to generate a report containing the details of the maintenance activities carried out on a part, associated work order details, warranty details of the part, reason for repair / removal of part as specif |
|
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| swotdr_swo_no | udd_documentno | varchar(40) | Yes | SWO no | No |
| swotdr_unique_no | udd_seqno | int(4) | No | Unique No | Yes |
| swotdr_tdr_tracking_id | udd_documentno | varchar(40) | Yes | Tracking Id | No |
| swotdr_rev_no | udd_seqno | int(4) | Yes | Revision No | No |
| swotdr_ouinstance | udd_ctxt_ouinstance | int(4) | Yes | OU Instance | No |
| swotdr_latest_flag | udd_flag | varchar(25) | Yes | Latest flag to identify the latest document | No |
| swotdr_reference_no | udd_documentno | varchar(40) | Yes | Editable field - User Entry | No |
| swotdr_cust_rep_proc_code | udd_quickcode | varchar(25) | Yes | Customer Instruction - Repair Process Code | No |
| swotdr_cust_inspect_opt | udd_flag | varchar(25) | Yes | Customer Instruction - Inspection | No |
| swotdr_cust_repair_opt | udd_flag | varchar(25) | Yes | Customer Instruction - Repair | No |
| swotdr_cust_overhaul_opt | udd_flag | varchar(25) | Yes | Customer Instruction - Overhaul | No |
| swotdr_cust_modify_opt | udd_flag | varchar(25) | Yes | Customer Instruction - Indicates any maintenance changes the part was subjected to | No |
| swotdr_act_rep_proc_code | udd_quickcode | varchar(25) | Yes | Actual Repair Process Code | No |
| swotdr_act_inspect_done | udd_flag | varchar(25) | Yes | Inspection Done | No |
| swotdr_act_repair_done | udd_flag | varchar(25) | Yes | Repair Done | No |
| swotdr_act_overhaul_done | udd_flag | varchar(25) | Yes | Overhaul Done | No |
| swotdr_act_mod_done | udd_flag | varchar(25) | Yes | Modified Done | No |
| swotdr_cust_rfr_conf_flag | udd_flag | varchar(25) | Yes | Confirm Customer Reference Flag | No |
| swotdr_other_findgs_flag | udd_flag | varchar(25) | Yes | Other findings flag | No |
| swotdr_Warr_Seal | udd_quickcode | varchar(25) | Yes | Warranty Details - Seal Values Combo | No |
| swotdr_Warr_Claim | udd_quickcode | varchar(25) | Yes | Warranty Details - ClaimValues Combo | No |
| swotdr_Warr_Notes | udd_quickcode | varchar(25) | Yes | Warranty Details - Notes | No |
| swotdr_cust_rfr_code | udd_quickcode | varchar(25) | Yes | Customer Reference Code | No |
| swotdr_prior_test_flag | udd_quickcode | varchar(25) | Yes | Tested Prior to Tear Down - Combo | No |
| swotdr_failure_desc | udd_quickcode | varchar(25) | Yes | Failure Desc | No |
| swotdr_rfr_reason | udd_txt2000 | varchar(2000) | Yes | Reason | No |
| swotdr_other_findgs_pri | udd_quickcode | varchar(25) | Yes | Other findings Primary | No |
| swotdr_other_findgs_sec | udd_quickcode | varchar(25) | Yes | Other findings Secondary | No |
| swotdr_other_findgs_dtl | udd_txt2000 | varchar(2000) | Yes | Other findings Detail | No |
| swotdr_rep_cond_found | udd_txt2000 | varchar(2000) | Yes | Condition Found | No |
| swotdr_corr_action | udd_txt2000 | varchar(2000) | Yes | Corrective Action | No |
| swotdr_exec_facility | udd_documentno | varchar(40) | Yes | Exec Facility - Combo | No |
| swotdr_serviced_by | udd_ctxt_user | varchar(30) | Yes | Serviced By - Editable | No |
| swotdr_certificate | udd_documentno | varchar(40) | Yes | Certificate # | No |
| swotdr_test_eqp | udd_txt2000 | varchar(2000) | Yes | Test Equipment | No |
| swotdr_test_hrs | udd_numericparamval | numeric(13) | Yes | Test Hours | No |
| swotdr_mod_done | udd_txt2000 | varchar(2000) | Yes | Mod Details - Embodied | No |
| swotdr_iss_by | udd_ctxt_user | varchar(30) | Yes | Issued by | No |
| swotdr_iss_date | udd_datetime1 | datetime(8) | Yes | Issued Date | No |
| swotdr_new_warr_seal | udd_flag | varchar(25) | Yes | new Warranty Seal Check Box | No |
| swotdr_approval_no | udd_documentno | varchar(40) | Yes | Approval No | No |
| swotdr_created_by | udd_ctxt_user | varchar(30) | Yes | Crreated By | No |
| swotdr_created_date | udd_datetime1 | datetime(8) | Yes | Created Date | No |
| swotdr_modified_by | udd_ctxt_user | varchar(30) | Yes | Modified By | No |
| swotdr_modified_date | udd_datetime1 | datetime(8) | Yes | Modified Date | No |
| swotdr_Timestamp | udd_timestamp | int(4) | Yes | timestamp | No |
| swotdr_param_code | udd_parameter | varchar(40) | Yes | Parameter Codes | No |
| swotdr_since_overhaul | udd_numericparamval | numeric(13) | Yes | Overhaul - Editable | No |
| swotdr_since_shop_visit | udd_numericparamval | numeric(13) | Yes | Since Shop Visit - Editable | No |
| swotdr_tot_time | udd_numericparamval | numeric(13) | Yes | Total Time | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| swotsk_swo_no | udd_documentno | varchar(40) | No | Shop Work Order No | No |
| swotsk_ouinstance | udd_ctxt_ouinstance | int(4) | No | Basswo OU | No |
| swotsk_rep_seqno | udd_seqno | int(4) | Yes | current sequence no | No |
| swotsk_org_seqno | udd_seqno | int(4) | Yes | Orginal Repair sequence No-defaulted from repair scheme | No |
| swotsk_hierarchy_id | _hierarchyid_0 | hierarchyid(0) | No | Hierarchy id used to maintain parent / child relationship within the SWO | No |
| swotsk_seq_cntrl_no | udd_seqno | int(4) | Yes | Master sequence No | No |
| swotsk_taskcode | udd_workunitcode | varchar(30) | No | Task code | No |
| swotsk_revision_no | udd_revisionno | varchar(40) | No | Task Revision No | No |
| swotsk_task_desc | udd_txt150 | varchar(150) | Yes | Task Description | No |
| swotsk_task_ou | udd_ctxt_ouinstance | int(4) | Yes | Bastask OU | No |
| swotsk_org_wrk_scp_revno | udd_numrevno | int(4) | Yes | work scope revision No | No |
| swotsk_curr_wrk_scp_revno | udd_numrevno | int(4) | Yes | work scope current revision No | No |
| swotsk_wbs_code | udd_quickcodes | varchar(25) | Yes | The Work Breakdown Structure (WBS) code indicating the attributes that identify whether the task is executed for planning purpose or execution purpose | No |
| swotsk_wrk_scp_flag | udd_chkflag | varchar(1) | No | Work scope element y/n(defaulted from repair scheme) | No |
| swotsk_Rpr_schm_flag | udd_chkflag | varchar(1) | No | Repair Scheme defined or not-defaulted from repair scheme | No |
| swotsk_wbs_level | udd_chkflag | varchar(1) | No | WBS level-Root,intermediate,leaf | No |
| swotsk_exec_opr_flag | udd_chkflag | varchar(1) | No | Execution operation (Y/n)-defaulted from wbs | No |
| swotsk_compl_flag | udd_chkflag | varchar(1) | No | Auto /manual for Work scope element Task | No |
| swotsk_exec_action | udd_designparamcode | varchar(5) | Yes | Execution action used for Upgrade/Append work scope | No |
| swotsk_task_plan_type | udd_designparamcode | varchar(5) | Yes | Planning Type(Planned/Un Planned) | No |
| swotsk_task_type | udd_designparamcode | varchar(5) | Yes | T,NST | No |
| swotsk_parent_taskcode | udd_workunitcode | varchar(30) | Yes | Parent task code defauted from Repair scheme for Child tasks | No |
| swotsk_root_task_code | udd_workunitcode | varchar(30) | Yes | Root task code defauted from Repair scheme for Child tasks | No |
| swotsk_task_rel_flag | udd_designparamcode | varchar(5) | Yes | Task Relationship - defaulted from repair scheme | No |
| swotsk_perpectual_flag | udd_designparamcode | varchar(5) | Yes | Perpectual task or Not | No |
| swotsk_partno | udd_partno | varchar(40) | Yes | The code identifying the part against which the task is executed | No |
| swotsk_serial_no | udd_partserialnumber | varchar(40) | Yes | The serial number of the part | No |
| swotsk_part_desc | udd_txt150 | varchar(150) | Yes | Part desc | No |
| swotsk_component_id | udd_componentid | varchar(90) | Yes | Component ID for the Main core Part/Serial No | No |
| swotsk_mfr_partno | udd_partno | varchar(40) | Yes | The number issued to the part, by the manufacturer of the part | No |
| swotsk_mfr_no | udd_vendorcode | varchar(45) | Yes | The code identifying the manufacturer of the part | No |
| swotsk_mandatory_flag | udd_chkflag | varchar(1) | Yes | Task mandatory Flag-Defaulted from Repair Scheme | No |
| swotsk_seperated_flag | udd_chkflag | varchar(1) | Yes | to specify whether the tasks can be moved from the parent work order to the child work order or not | No |
| swotsk_ext_facility_flag | udd_chkflag | varchar(1) | Yes | Internal /External | No |
| swotsk_est_status | udd_designparamcode | varchar(5) | Yes | Estimation Status | No |
| swotsk_status | udd_designparamcode | varchar(5) | Yes | Task Status | No |
| swotsk_routing_reg | udd_chkflag | varchar(1) | Yes | Routing Required(Y/N)-Defaulted from Repair Scheme | No |
| swotsk_coa_flag | udd_designparamcode | varchar(5) | Yes | COA Flag | No |
| swotsk_repair_class | udd_quickcodes | varchar(25) | Yes | specify the repair classification in order to differentiate the tasks which are over and above the contract (COA - Contract Over and Above) between the operator and the MRO | No |
| swotsk_expense_type | udd_designparamcode | varchar(5) | Yes | Revenue - Select this option to indicate that the task in the work order is of expense type Revenue.Capital - Select this option to indicate that the task in the work order is of expense type Capital | No |
| swotsk_capex_proposal_no | udd_documentno | varchar(40) | Yes | The capital expense proposal number applicable to the work order. | No |
| swotsk_display_est_elap_Time | udd_duration | numeric(13) | Yes | The estimated elapsed time for execution of the task. | No |
| swotsk_display_time_uom | udd_chkflag | varchar(1) | Yes | Time UOM | No |
| swotsk_est_elapsed_time_mins | udd_duration | numeric(13) | Yes | Elapstime in Mins | No |
| swotsk_exec_category | udd_quickcodes | varchar(25) | Yes | to specify the execution category of the task | No |
| swotsk_exec_priority_no | udd_priorityno | int(4) | Yes | to specify the priority of execution of the task | No |
| swotsk_exec_phase | udd_quickcodes | varchar(25) | Yes | to specify the execution phase of the task | No |
| swotsk_wc_code | udd_wccode | varchar(30) | Yes | Tasks Work Center | No |
| swotsk_repair_agency | udd_documentno | varchar(40) | Yes | Repair Agency | No |
| swotsk_plan_startdate | udd_datetime1 | datetime(8) | Yes | Plan Start Date / Time | No |
| swotsk_plan_endate | udd_datetime1 | datetime(8) | Yes | Plan End Date / Time | No |
| swotsk_est_man_hrs | udd_duration | numeric(13) | Yes | Estimated man Hrs | No |
| swotsk_user_status | udd_quickcodes | varchar(25) | Yes | to specify the user status with respect to the work order | No |
| swotsk_warranty | udd_chkflag | varchar(1) | Yes | to specify whether the warranty is applicable for the task performed on the part # - serial #. | No |
| swotsk_rep_basis | udd_designparamcode | varchar(5) | Yes | OEM - Select this option to indicate that the repair scheme is given by the Original Equipment Manufacturer (OEM).MRO specific - Select this option to indicate that the repair scheme is given based on MRO need.Operator specific - Select this opt | No |
| swotsk_ro_no | udd_documentno | varchar(40) | Yes | The number identifying the repair order is displayed here, when the part sent to external agency for repair | No |
| swotsk_eventid | udd_txt255 | varchar(255) | Yes | The event number indicating the visit of the main core and identified for grouping the shop work order. | No |
| swotsk_repair_proc_code | udd_quickcodes | varchar(25) | Yes | to specify the repair process code that defines various repair processes that are performed on a component | No |
| swotsk_disposition_code | udd_quickcodes | varchar(25) | Yes | to specify the type of work performed on the part | No |
| swotsk_act_start_datetime | udd_datetime1 | datetime(8) | Yes | Actual start date | No |
| swotsk_act_end_datetime | udd_datetime1 | datetime(8) | Yes | Actual End date | No |
| swotsk_compl_datetime | udd_datetime1 | datetime(8) | Yes | Compliance date | No |
| swotsk_sign_off_info | udd_flag | varchar(25) | Yes | Sign Off Status | No |
| swotsk_station | udd_oucode | varchar(32) | Yes | Station Mapped to the Task work center | No |
| swotsk_rii_report_req | udd_designparamcode | varchar(5) | Yes | swotsk_rii_report_req | No |
| swotsk_rii_report_by | udd_ctxt_user | varchar(30) | Yes | swotsk_rii_report_by | No |
| swotsk_addn_report_by | udd_ctxt_user | varchar(30) | Yes | swotsk_addn_report_by | No |
| swotsk_est_act_flag | udd_designparamcode | varchar(5) | Yes | Flag used to check whether task got added in Plan sWo/Shop Execution | No |
| swotsk_onwing_flag | udd_designparamcode | varchar(5) | Yes | Off /CR Task | No |
| swotsk_ata_no | udd_atanumber | varchar(16) | Yes | ATA Number | No |
| swotsk_part_type | udd_designparamcode | varchar(5) | Yes | Part type | No |
| swotsk_position_code | udd_flag | varchar(25) | Yes | Position code | No |
| swotsk_forecast_no | udd_documentno | varchar(40) | Yes | Forecast No -Defaulted for Forecasted task | No |
| swotsk_forecast_instid | udd_seqno | int(4) | Yes | JOB Id from Forecast table | No |
| swotsk_per_comp | udd_duration | numeric(13) | Yes | Percentage of completion | No |
| swotsk_ref_src_docno | udd_documentno | varchar(40) | Yes | Source document No | No |
| swotsk_ref_doc_revno | udd_revisionno | varchar(40) | Yes | Source document revision | No |
| swotsk_ref_src_doctype | udd_designparamcode | varchar(5) | Yes | Source Doc type | No |
| swotsk_parent_ref_id | udd_txt150 | varchar(150) | Yes | Parent Ref ID | No |
| swotsk_parent_task_trackid | _bigint_8 | Bigint(8) | Yes | Parent Task track id-Task Which initiates the child task | No |
| swotsk_filename | udd_documentno | varchar(40) | Yes | File Name | No |
| swotsk_created_date | udd_datetime1 | datetime(8) | Yes | Created Date | No |
| swotsk_modified_date | udd_datetime1 | datetime(8) | Yes | Modified Date | No |
| swotsk_created_by | udd_ctxt_user | varchar(30) | Yes | Created By | No |
| swotsk_modified_by | udd_ctxt_user | varchar(30) | Yes | Modified by | No |
| swotsk_timestamp | udd_timestamp | int(4) | Yes | timestamp | No |
| swotsk_est_purpose | udd_txt150 | varchar(150) | Yes | Estimation Purpose | No |
| swotsk_est_inst_id | udd_txt150 | varchar(150) | Yes | Estimation Instace id | No |
| swotsk_quote_rel_id | udd_txt150 | varchar(150) | Yes | Release ID | No |
| swotsk_charge_est_flag | udd_chkflag | varchar(1) | Yes | Estimation completed for charges -0/1 | No |
| swotsk_other_est_flag | udd_chkflag | varchar(1) | Yes | Estimation completed for Others -0/1 | No |
| swotsk_part_est_flag | udd_chkflag | varchar(1) | Yes | Estimation completed for Part -0/1 | No |
| swotsk_res_est_flag | udd_chkflag | varchar(1) | Yes | Estimation completed for Resource -0/1 | No |
| swotsk_act_tsk_cmptn_datetime | _datetime_8 | datetime(8) | Yes | Actual task completion date | No |
| swotsk_nhapartno | udd_partno | varchar(40) | Yes | The NHA Part # of the sub-assembly | No |
| swotsk_nhamfrpartno | udd_partno | varchar(40) | Yes | The next higher assembly (NHA) Mfr. Part # of the sub-assembly | No |
| swotsk_nhamfrno | udd_vendorcode | varchar(45) | Yes | The manufacturer number of the NHA Part # of the sub-assembly | No |
| swotsk_nhaserialno | udd_partserialnumber | varchar(40) | Yes | The NHA Serial # of the sub-assembly | No |
| swotsk_seperation_rule | udd_designparamcode | varchar(5) | Yes | Seperation Rules | No |
| swotsk_levelcode | udd_txt150 | varchar(150) | Yes | The level code of the sub-assembly | No |
| swotsk_task_track_id | udd_unique_id | bigint(8) | No | An Unique Id, Primary Key- Identity Column - Clustered Index Column | Yes |
| swotsk_est_req_for | udd_txt150 | varchar(150) | Yes | Estimation Request | No |
| swotsk_billable_flag | udd_chkflag | varchar(1) | Yes | Billable Flag | No |
| swotsk_buyback_flag | udd_chkflag | varchar(1) | Yes | Buyback Flag | No |
| swotsk_transient_status | udd_designparamcode | varchar(5) | Yes | Transient Status | No |
| swotsk_est_labour_cost | udd_amount | numeric(13) | Yes | Estimated Labour cost | No |
| swotsk_est_material_cost | udd_amount | numeric(13) | Yes | Estimated Material Cost | No |
| swotsk_est_tools_cost | udd_amount | numeric(13) | Yes | Estimated tools cost | No |
| swotsk_est_equipment_cost | udd_amount | numeric(13) | Yes | Estimated equipment cost | No |
| swotsk_est_others_cost | udd_amount | numeric(13) | Yes | Estimated other cost | No |
| swotsk_est_skill_cost | udd_amount | numeric(13) | Yes | Estrimated skill cost | No |
| swotsk_res_tools_hrs | udd_value | numeric(13) | Yes | Tools hours | No |
| swotsk_res_equip_hrs | udd_value | numeric(13) | Yes | Equipment Hours | No |
| swotsk_res_other_hrs | udd_value | numeric(13) | Yes | Other hours | No |
| swotsk_res_skill_hrs | udd_value | numeric(13) | Yes | Skill hours | No |
| swotsk_man_hours | udd_value | numeric(13) | Yes | Man hours | No |
| swotsk_labour_cost | udd_amount | numeric(13) | Yes | Labour cost | No |
| swotsk_misc_cost | udd_amount | numeric(13) | Yes | Miscellaneous cost | No |
| swotsk_material_cost | udd_amount | numeric(13) | Yes | Material cost | No |
| swotsk_tools_cost | udd_amount | numeric(13) | Yes | Tools cost | No |
| swotsk_equipment_cost | udd_amount | numeric(13) | Yes | Equipment cost | No |
| swotsk_others_cost | udd_amount | numeric(13) | Yes | Other cost | No |
| swotsk_skill_cost | udd_amount | numeric(13) | Yes | Skill cost | No |
| swotsk_dlink_flag | udd_chkflag | varchar(1) | Yes | Dlink flag | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| swowka_seq_no | udd_unique_id | bigint(8) | No | An Unique Id, Primary Key- Identity Column - Clustered Index Column | Yes |
| swowka_task_track_id | udd_unique_id | bigint(8) | No | The Task trackid for the task code against which the Work Assignment is recorded | No |
| swowka_swo_no | udd_documentno | varchar(40) | No | SWO no | No |
| swowka_ouinstance | udd_ctxt_ouinstance | int(4) | No | OU Instance | No |
| swowka_task_code | udd_workunitcode | varchar(30) | No | Task code | No |
| swowka_wc_code | udd_wccode | varchar(30) | Yes | Work Center Code | No |
| swowka_emp_code | udd_ctxt_user | varchar(30) | No | Emp code assigned to Task | No |
| swowka_emp_ou | udd_ctxt_ouinstance | int(4) | Yes | HRMS Ouinstance | No |
| swowka_from_date | _datetime_8 | datetime(8) | No | Assigned From | No |
| swowka_to_date | _datetime_8 | datetime(8) | Yes | Assigned To | No |
| swowka_assign_hrs | udd_duration | numeric(13) | Yes | Assigned Hours | No |
| swowka_assign_comments | udd_txt2000 | varchar(2000) | Yes | Assign Comments | No |
| swowka_created_by | udd_ctxt_user | varchar(30) | Yes | Created By | No |
| swowka_created_date | _datetime_8 | datetime(8) | Yes | Created date | No |
| swowka_modified_by | udd_ctxt_user | varchar(30) | Yes | Modified By | No |
| swowka_modified_date | _datetime_8 | datetime(8) | Yes | Modified date | No |
| swowka_timestamp | udd_timestamp | int(4) | Yes | timestamp | No | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| swp_componentname | udd_txt80 | varchar(80) | Yes | Component Name-metadata used to record system predifined value | No |
| swp_paramcategory | _varchar_10 | varchar(10) | Yes | Category | No |
| swp_paramtype | udd_flag | varchar(25) | Yes | Parameter Type | No |
| swp_paramcode | udd_designparamcode | varchar(5) | Yes | Parameter Code | No |
| swp_paramdesc | udd_txt80 | varchar(80) | Yes | Param Desc | No |
| swp_displayorder | _int_0 | int(0) | Yes | Display order | No |
| swp_langid | _int_0 | int(0) | Yes | language ID | No |
| swp_creationdate | _datetime_8 | datetime(8) | Yes | Created Date | No |
| REPLICATION_KEY | _bigint_8 | Bigint(8) | No | Replication Key | Yes | |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| swotp_attribute_name | udd_documentno | varchar(40) | Yes | Work Level / Task level Status change | No |
| swotp_from_status | udd_designparamcode | varchar(5) | Yes | when status changes - From status | No |
| swotp_to_status | udd_designparamcode | varchar(5) | Yes | when status changes - To status status | No |
| swotp_comp_cond_upd | udd_designparamcode | varchar(5) | Yes | Meta Data used to identiy the activities to performed when status changes-Component codition to be called or not | No |
| swotp_param_upd | udd_designparamcode | varchar(5) | Yes | Meta Data used to identiy the activities to performed when status changes-Paramter values updates to be called or not | No |
| swotp_compl_upd | udd_designparamcode | varchar(5) | Yes | Meta Data used to identiy the activities to performed when status changes-Compliance to be called or not | No |
| swotp_mr_short_closure | udd_designparamcode | varchar(5) | Yes | Meta Data used to identiy the activities to performed when status changes-MR short close service to be called or not | No |
| swotp_part_change | udd_designparamcode | varchar(5) | Yes | Meta Data used to identiy the activities to performed when status changes-part changes | No |
| swotp_fin_posting | udd_designparamcode | varchar(5) | Yes | Meta Data used to identiy the activities to performed when status changes-Finance postings (Only for To status-Pre close,Close Service has to be called) | No |
| swotp_capex_posting | udd_designparamcode | varchar(5) | Yes | Meta Data used to identiy the activities to performed when status changes | No |
| swotp_comp_creation | udd_designparamcode | varchar(5) | Yes | Meta Data used to identiy the activities to performed when status changes | No |
| swotp_auto_return | udd_designparamcode | varchar(5) | Yes | Meta Data used to identiy the activities to performed when status changes-Auto return to be triggered or not | No |
| swotp_tskchg_allowed | udd_designparamcode | varchar(5) | Yes | Meta Data used to identiy the activities to performed when status changes | No |
| REPLICATION_KEY | _bigint_8 | Bigint(8) | No | Replication Key | Yes |
| swotp_est_service | udd_designparamcode | varchar(5) | Yes | Estimation service to be called or not | No |
| swotp_eo_service_scrap | udd_designparamcode | varchar(5) | Yes | EO Service | No |
| swotp_facility_object | udd_designparamcode | varchar(5) | Yes | facility obect | No |
| swotp_ownership_update | udd_designparamcode | varchar(5) | Yes | Meta Data used to identiy the activities to performed when status changes-Ownership service to be called or not | No |