swo_wotskbsl_baseline_task_detail
SWO : Workscoping : Baselined Task details
Process: COMPMAINTENANCE 路 Component: BasSWO 路 Table type: Transaction Table Category: Maintains detailed records of baseline tasks associated with a shop work order, including predefined tasks, dependencies, and requirements before amendments or changes are applied
Primary key
wotskbsl_unique_id
Columns (172)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | wotskbsl_act_end_datetime | datetime | Actual end date and time records actual task end |
| 2 | wotskbsl_act_start_datetime | Datetime | Actual start date and time records actual task start |
| 3 | wotskbsl_act_tsk_cmptn_datetime | datetime | Actual task completion date and time captures task completion |
| 4 | wotskbsl_act_tsk_cmptn_utcdatetime | datetime | Actual Universal Time Coordinated task completion date and time records UTC completion |
| 5 | wotskbsl_act_utc_end_datetime | datetime | Actual Universal Time Coordinated end date and time captures UTC end |
| 6 | wotskbsl_act_utc_start_datetime | varchar | Actual Universal Time Coordinated start date and time captures UTC start |
| 7 | wotskbsl_addn_report_by | varchar | Additional reported by identifies extra reporting users |
| 8 | wotskbsl_ALT_EFFECTIVE | varchar | Alternate effective date records the alternate effective date |
| 9 | wotskbsl_amendno | varchar | Amendment number tracks the amendment number |
| 10 | wotskbsl_ata_no | varchar | ATA number identifies the ATA chapter or section |
| 11 | wotskbsl_billable_flag | int | Billable flag indicates if the task or work is billable |
| 12 | wotskbsl_bslrevno | varchar | Baselined workscoping revision number records baselined revision |
| 13 | wotskbsl_buyback_flag | varchar | Buyback flag indicates if buyback applies |
| 14 | wotskbsl_capex_proposal_no | varchar | CAPEX proposal number tracks associated CAPEX proposal |
| 15 | wotskbsl_charge_est_flag | datetime | Charge estimated flag indicates if estimated charges exist |
| 16 | wotskbsl_cls_date | varchar | Task closure date records when the task was closed |
| 17 | wotskbsl_coa_flag | datetime | COA flag indicates Certificate of Authorization requirements |
| 18 | wotskbsl_compl_datetime | varchar | Compliance date and time tracks compliance |
| 19 | wotskbsl_compl_flag | varchar | Compliance operations flag identifies operations compliance |
| 20 | wotskbsl_component_id | datetime | Component identifier records the component ID |
| 21 | wotskbsl_ConstDate | varchar | Constraint date used in scheduling indicates scheduling constraint date |
| 22 | wotskbsl_ConstType | varchar | Constraint type used in scheduling identifies type of constraint |
| 23 | wotskbsl_created_by | datetime | User who created the record identifies the creator |
| 24 | wotskbsl_created_date | int | Date the record was created records creation date |
| 25 | wotskbsl_curr_wrk_scp_revno | Char | Current work scope revision number tracks current revision |
| 26 | wotskbsl_cust_req_wksc_flg | numeric | Customer requested work scope flag indicates customer-requested work |
| 27 | wotskbsl_display_est_elap_Time | varchar | Displayed elapsed time shows elapsed time |
| 28 | wotskbsl_display_time_uom | varchar | Elapsed time unit of measure identifies unit for elapsed time |
| 29 | wotskbsl_disposition_code | varchar | Disposition code records disposition of the task or component |
| 30 | wotskbsl_dlink_flag | varchar | Delink flag identifies if delinking occurred |
| 31 | wotskbsl_dtchange_flag | varchar | Date change flag used in scheduling records changes to dates |
| 32 | wotskbsl_emploading_flag | numeric | Employee loading flag indicates employee loading |
| 33 | wotskbsl_equipment_cost | varchar | Equipment cost records cost of equipment |
| 34 | wotskbsl_est_act_flag | numeric | Estimation actual flag identifies whether estimation is actual |
| 35 | wotskbsl_est_elapsed_time_mins | numeric | Elapsed time in minutes records time in minutes |
| 36 | wotskbsl_est_equipment_cost | varchar | Estimated equipment cost records estimated equipment cost |
| 37 | wotskbsl_est_inst_id | numeric | Estimate instance identifier tracks estimate instance |
| 38 | wotskbsl_est_labour_cost | numeric | Estimated labour cost records labour cost estimate |
| 39 | wotskbsl_est_man_hrs | numeric | Estimated man hours tracks estimated work hours |
| 40 | wotskbsl_est_material_cost | numeric | Estimated material cost records material cost |
| 41 | wotskbsl_est_others_cost | varchar | Estimated other costs records other estimated costs |
| 42 | wotskbsl_est_purpose | varchar | Purpose of the estimate explains why estimate is calculated |
| 43 | wotskbsl_est_req_for | numeric | Estimation required for identifies what estimation applies to |
| 44 | wotskbsl_est_skill_cost | varchar | Estimated skill cost records skill cost estimate |
| 45 | wotskbsl_est_status | numeric | Estimation status identifies status of estimation |
| 46 | wotskbsl_est_tools_cost | varchar | Estimated tools cost records estimated tools cost |
| 47 | wotskbsl_eventid | varchar | Event identifier tracks event |
| 48 | wotskbsl_exec_action | varchar | Execution action records execution action |
| 49 | wotskbsl_exec_category | varchar | Execution category identifies execution category |
| 50 | wotskbsl_exec_opr_flag | varchar | Execution operations flag indicates execution operations |
| 51 | wotskbsl_exec_phase | int | Execution phase tracks execution phase |
| 52 | wotskbsl_exec_priority_no | varchar | Execution priority number records priority |
| 53 | wotskbsl_expense_type | varchar | Expense type identifies type of expense |
| 54 | wotskbsl_ext_facility_flag | varchar | Execution facility flag indicates facility used for execution |
| 55 | wotskbsl_filename | datetime | File name records file name |
| 56 | wotskbsl_FlaggDate | varchar | Highlighted date used in scheduling UI tracks highlighted date |
| 57 | wotskbsl_FlaggEmp | varchar | Highlighted by in scheduling UI identifies who highlighted |
| 58 | wotskbsl_FlaggRemarks | int | Highlighted remarks unused in UI records remarks |
| 59 | wotskbsl_forecast_instid | varchar | Forecast instance identifier tracks forecast instance |
| 60 | wotskbsl_forecast_no | varchar | Forecast number records forecast number |
| 61 | wotskbsl_hierarchy_id | numeric | Task hierarchy identifier identifies task hierarchy |
| 62 | wotskbsl_labour_cost | varchar | Labour cost tracks labour cost |
| 63 | wotskbsl_levelcode | varchar | Level code records level |
| 64 | wotskbsl_MaintManualRef | datetime | Maintain manual reference tracks manual reference |
| 65 | wotskbsl_MaintManualRef_Date | varchar | Maintain manual reference date records reference date |
| 66 | wotskbsl_MaintManualRef_Rev | varchar | Maintain manual reference revision tracks reference revision |
| 67 | wotskbsl_mandatory_flag | numeric | Mandatory flag indicates if mandatory |
| 68 | wotskbsl_man_hours | numeric | Man hours records hours required |
| 69 | wotskbsl_material_cost | varchar | Material cost tracks material cost |
| 70 | wotskbsl_mfr_no | varchar | Manufacturer number records manufacturer number |
| 71 | wotskbsl_mfr_partno | numeric | Manufacturer part number tracks manufacturer part number |
| 72 | wotskbsl_misc_cost | varchar | Miscellaneous cost records other costs |
| 73 | wotskbsl_modified_by | datetime | User who modified the record identifies last modifier |
| 74 | wotskbsl_modified_date | varchar | Date modified records last modified date |
| 75 | wotskbsl_nhamfrno | varchar | NHA manufacturer number tracks NHA manufacturer number |
| 76 | wotskbsl_nhamfrpartno | varchar | NHA manufacturer part number tracks NHA manufacturer part number |
| 77 | wotskbsl_nhapartno | varchar | NHA part number records NHA part number |
| 78 | wotskbsl_nhaserialno | varchar | NHA serial number records NHA serial number |
| 79 | wotskbsl_onwing_flag | int | Onwing flag indicates if component is on-wing |
| 80 | wotskbsl_org_seqno | int | Original repair sequence number tracks original repair sequence |
| 81 | wotskbsl_org_wrk_scp_revno | numeric | Original work scope revision identifies original work scope revision |
| 82 | wotskbsl_others_cost | varchar | Other costs records other associated costs |
| 83 | wotskbsl_other_est_flag | int | Others estimated flag indicates if others are estimated |
| 84 | wotskbsl_ouinstance | varchar | Organization unit instance tracks organization instance |
| 85 | wotskbsl_parent_ref_id | varchar | Parent reference identifier tracks parent reference |
| 86 | wotskbsl_parent_taskcode | Bigint | Parent task code records parent task |
| 87 | wotskbsl_parent_task_trackid | varchar | Parent task track identifier identifies parent task track |
| 88 | wotskbsl_partno | varchar | Part number records part number |
| 89 | wotskbsl_part_desc | varchar | Part description records part description |
| 90 | wotskbsl_part_est_flag | varchar | Part estimated flag indicates if part is estimated |
| 91 | wotskbsl_part_type | varchar | Part type identifies part type |
| 92 | wotskbsl_perpectual_flag | numeric | Perpetual flag indicates if perpetual |
| 93 | wotskbsl_per_comp | Bigint | Percentage completion tracks completion percentage |
| 94 | wotskbsl_planid | datetime | Scheduling plan identifier records scheduling plan |
| 95 | wotskbsl_plan_endate | datetime | Planned end date tracks planned end |
| 96 | wotskbsl_plan_startdate | varchar | Planned start date tracks planned start |
| 97 | wotskbsl_position_code | varchar | Position code identifies position |
| 98 | wotskbsl_proplan_tskflag | Bigint | Process plan flag indicates process plan usage |
| 99 | wotskbsl_proplan_tsktrackid | varchar | Process plan track identifier tracks process plan |
| 100 | wotskbsl_qty_type | varchar | Output quantity type identifies output quantity type |
| 101 | wotskbsl_quote_rel_id | Int | Quote release identifier tracks quote release |
| 102 | wotskbsl_reference_task | Bigint | Reference task tracks reference task |
| 103 | wotskbsl_reference_Tasktrackid | varchar | Reference task track identifier tracks reference task track |
| 104 | wotskbsl_ref_doc_revno | varchar | Reference document revision tracks document revision |
| 105 | wotskbsl_ref_src_docno | varchar | Reference source document number records source document number |
| 106 | wotskbsl_ref_src_doctype | varchar | Reference source document type tracks source document type |
| 107 | wotskbsl_repair_agency | varchar | Repair agency identifies repair agency |
| 108 | wotskbsl_repair_class | varchar | Repair class records repair class |
| 109 | wotskbsl_repair_proc_code | varchar | Repair process code records repair process |
| 110 | wotskbsl_rep_basis | int | Repair basis tracks repair basis |
| 111 | wotskbsl_rep_seqno | numeric | Repair sequence number identifies repair sequence |
| 112 | wotskbsl_res_equip_hrs | varchar | Resource equipment hours tracks equipment hours |
| 113 | wotskbsl_res_est_flag | numeric | Resource estimated flag identifies estimated resource |
| 114 | wotskbsl_res_other_hrs | numeric | Resource other hours tracks other resource hours |
| 115 | wotskbsl_res_skill_hrs | numeric | Resource skill hours tracks skill hours |
| 116 | wotskbsl_res_tools_hrs | varchar | Resource tool hours tracks tool hours |
| 117 | wotskbsl_revision_no | varchar | Task revision number records revision number |
| 118 | wotskbsl_revstatus | varchar | Workscoping baselined revision status tracks baselined status |
| 119 | wotskbsl_rii_report_by | varchar | RII reported by identifies reporter |
| 120 | wotskbsl_rii_report_req | varchar | RII required flag indicates if RII is required |
| 121 | wotskbsl_rii_skill | varchar | RII skill tracks required skill |
| 122 | wotskbsl_rii_type | varchar | RII type identifies type of RII |
| 123 | wotskbsl_root_task_code | varchar | Root task code tracks root task |
| 124 | wotskbsl_routing_reg | varchar | Routing required flag indicates if routing is required |
| 125 | wotskbsl_ro_no | varchar | Repair order number records repair order |
| 126 | wotskbsl_Rpr_schm_flag | varchar | Repair scheme flag indicates repair scheme |
| 127 | wotskbsl_rson_nonexec | varchar | Reason for non-execution tracks reason |
| 128 | wotskbsl_sch_appl | varchar | Schedule applicability identifies schedule applicability |
| 129 | wotskbsl_seperated_flag | varchar | Separated flag indicates separated status |
| 130 | wotskbsl_seperation_rule | int | Separation rule tracks separation rule |
| 131 | wotskbsl_seq_cntrl_no | varchar | Sequence control number tracks sequence |
| 132 | wotskbsl_serial_no | varchar | Serial number records serial number |
| 133 | wotskbsl_sign_off_info | numeric | Sign-off information captures sign-off |
| 134 | wotskbsl_skill_cost | varchar | Skill cost tracks skill cost |
| 135 | wotskbsl_station | varchar | Station records station |
| 136 | wotskbsl_status | numeric | Task status identifies task status |
| 137 | wotskbsl_std_elap_time | varchar | Standard elapsed time tracks standard elapsed time |
| 138 | wotskbsl_swo_no | varchar | Work order number records work order number |
| 139 | wotskbsl_taskcode | varchar | Task number tracks task number |
| 140 | wotskbsl_task_desc | int | Task description records task description |
| 141 | wotskbsl_task_ou | varchar | Task organization unit identifies organizational unit for task |
| 142 | wotskbsl_task_plan_type | varchar | Task plan type identifies planned or unplanned |
| 143 | wotskbsl_task_rel_flag | bigint | Task relationship flag tracks task relationship |
| 144 | wotskbsl_task_track_id | varchar | Task track identifier records task track |
| 145 | wotskbsl_task_type | int | Task type identifies type of task |
| 146 | wotskbsl_timestamp | numeric | Timestamp records timestamp |
| 147 | wotskbsl_tools_cost | varchar | Tools cost tracks tools cost |
| 148 | wotskbsl_transient_status | bigint | Transient status indicates temporary status |
| 149 | wotskbsl_unique_id 馃攽 | Bigint | Unique identifier stores unique ID |
| 150 | wotskbsl_upgraded_prnttrackid | varchar | Upgraded parent task track identifier tracks parent of upgraded task |
| 151 | wotskbsl_upgraded_task | Bigint | Upgraded task records upgraded task |
| 152 | wotskbsl_upgraded_tasktrackid | Bigint | Upgraded task track identifier tracks upgraded task track |
| 153 | wotskbsl_upgraded_wstasktrackid | varchar | Upgraded workscoping task track identifier tracks upgraded workscoping task |
| 154 | wotskbsl_upgrade_flag | varchar | Upgrade flag indicates if upgraded |
| 155 | wotskbsl_user_defined1 | varchar | User defined field 1 for scheduling UI tracks user-defined info |
| 156 | wotskbsl_user_defined2 | datetime | User defined field 2 for scheduling UI tracks additional user-defined info |
| 157 | wotskbsl_user_defined3 | varchar | User defined field 3 for scheduling UI tracks additional user-defined info |
| 158 | wotskbsl_user_status | varchar | User status records current user status |
| 159 | wotskbsl_warranty | varchar | Warranty indicates warranty status |
| 160 | wotskbsl_wbs_code | varchar | Work breakdown structure code tracks WBS code |
| 161 | wotskbsl_wbs_flg | varchar | Work Breakdown Structure ( WBS ) flag indicates WBS applicability |
| 162 | wotskbsl_wbs_level | varchar | Work Breakdown Structure ( WBS ) level tracks WBS level |
| 163 | wotskbsl_wc_code | numeric | Work center code records work center |
| 164 | wotskbsl_wrenchtime_min | varchar | Wrench time in minutes tracks task master wrench time |
| 165 | wotskbsl_wrk_scp_flag | varchar | Workscoping flag indicates workscoping applicability |
| 166 | wotskbsl_wsappreq | varchar | Workscoping approval required indicates if approval is needed |
| 167 | wotskbsl_wsclass | varchar | Workscoping class identifies workscoping class |
| 168 | wotskbsl_wscomments | int | Workscoping comments stores workscoping remarks |
| 169 | wotskbsl_wscusrevno | int | Workscoping customer revision number tracks customer revision |
| 170 | wotskbsl_wsrevno | varchar | Workscoping revision number tracks workscoping revision |
| 171 | wotskbsl_wsrevstatus | varchar | Workscoping revision status tracks revision status |
| 172 | wotskbsl_wsstage | varchar | Workscoping stage indicating the current stage of work scoping |
Sample rows (from live DB)
wotskbsl_act_end_datetime | wotskbsl_act_start_datetime | wotskbsl_act_tsk_cmptn_datetime | wotskbsl_act_tsk_cmptn_utcdatetime | wotskbsl_act_utc_end_datetime | wotskbsl_act_utc_start_datetime |
|---|---|---|---|---|---|
| NULL | NULL | NULL | NULL | NULL | NULL |
| NULL | NULL | NULL | NULL | NULL | NULL |
| NULL | NULL | NULL | NULL | NULL | NULL |
Showing 3 of 924 rows.