FLOG_TLGWU_WORK_UNIT_DTL
Maintains a comprehensive list of tasks and work units defined within an Aircraft Maintenance Execution (AME) package. Supports task grouping, sequencing, and work tracking for efficient package execution.
Process: LINEMAINTENANCE · Component: BasFltLog · Table type: Transaction Table Category: Core system for Aircraft Maintenance Execution ( AME ) package tracking, task eliminations, work assignments, and maintenance operations. Manages detailed records of maintenance tasks, employee assignments, work centers, and scheduling for aircraft maintenance activities.
This table is the canonical store for the Task entity.
Primary key
TLGWU_TRACK_ID
Columns (199)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | TLGWU_SLFSRC_OUINSTANCE | #N/A | Specifies the organization unit in which the package is recorded |
| 2 | TLGWU_DOC_TYPE | varchar | Specifies the document type |
| 3 | TLGWU_DOC_NO | varchar | Specifies the maintenance report number or discrepancy number |
| 4 | TLGWU_CRT_OU | #N/A | Specifies the organization unit which recorded the package |
| 5 | TLGWU_SEQ_NO | #N/A | Specifies the sequence number which uniquely identifies the tasks in the package |
| 6 | TLGWU_WORK_UNIT_TYPE | varchar | Specifies the work unit type |
| 7 | TLGWU_WORK_UNIT_OU | #N/A | Specifies the organization unit in which the task is defined |
| 8 | TLGWU_WORK_UNIT_CODE | varchar | Specifies the task number |
| 9 | TLGWU_TASK_REVNO | varchar | Specifies the task revision number |
| 10 | TLGWU_EXEC_STATUS | varchar | Specifies the execution status |
| 11 | TLGWU_ATA_NO | varchar | Specifies the ATA number |
| 12 | TLGWU_EXEC_COMMENTS | varchar | Specifies the execution comments |
| 13 | TLGWU_LEVEL_CODE | varchar | Specifies the aircraft level code |
| 14 | TLGWU_POSITION_CODE | Varchar | Specifies the aircraft position code |
| 15 | TLGWU_PART_NO | varchar | Specifies the part number on which the task needs to be performed |
| 16 | TLGWU_SERIAL_NO | varchar | Specifies the serial number on which the task needs to be performed |
| 17 | TLGWU_COMPONENT_ID | varchar | Specifies the component on which the task needs to be performed |
| 18 | TLGWU_COMPONENT_OU | #N/A | Specifies the organization unit in which the component is defined |
| 19 | TLGWU_JOB_TYPE | varchar | Specifies the job type |
| 20 | TLGWU_SRC_DOC_TYP | Varchar | Specifies the type of source document from where the tasks were posted for execution |
| 21 | TLGWU_SRC_DOC_OU | #N/A | Specifies the organization unit in which the source document is defined |
| 22 | TLGWU_SOURCE_DOC_NO | varchar | Specifies the source document from where the tasks were posted for execution |
| 23 | TLGWU_SRC_DOC_REV_NO | varchar | Specifies the revision number of the source document |
| 24 | TLGWU_WU_SEQ_NO | #N/A | Specifies the work unit sequence number |
| 25 | TLGWU_MAINT_TYPE | varchar | Specifies the maintenance type |
| 26 | TLGWU_SIGN_OFF_INFO | varchar | Specifies the sign off status for the work unit |
| 27 | TLGWU_FILE_NAME | varchar | Specifies the file name |
| 28 | TLGWU_FORECAST_NO | varchar | Specifies the work unit forecast number |
| 29 | TLGWU_COMPLIANCE_DATETIME | datetime | Specifies the last compliance date for the work unit |
| 30 | TLGWU_SCHEDULE_DATE | datetime | Specifies the schedule date |
| 31 | TLGWU_PLAN_START_DATE | datetime | Specifies the planned start date |
| 32 | TLGWU_PLANNING_TYPE | varchar | Specifies the planning type |
| 33 | TLGWU_WORKUNIT_SOURCE | varchar | Specifies the source of the work unit |
| 34 | TLGWU_INCOMPLETE_FLAG | varchar | Specifies whether the work unit is incomplete |
| 35 | TLGWU_INCOMPLETE_DOCNO | varchar | Specifies the document number from which incomplete details are fetched |
| 36 | TLGWU_INCOMPLETE_DATE | datetime | Specifies the incomplete date |
| 37 | TLGWU_DISP_SEQ_NO | #N/A | Specifies the display sequence number |
| 38 | TLGWU_MATERIAL_COST | decimal | Specifies the material cost to perform the task |
| 39 | TLGWU_LABOUR_COST | decimal | Specifies the labour cost to perform the task |
| 40 | TLGWU_TOOLS_COST | decimal | Specifies the tools cost to perform the task |
| 41 | TLGWU_EQUIPMENT_COST | decimal | Specifies the equipment cost to perform the task |
| 42 | TLGWU_OTHERS_COST | decimal | Specifies any other cost to perform the task |
| 43 | TLGWU_SKILL_COST | decimal | Specifies the skill cost to perform the task |
| 44 | TLGWU_MAN_HOURS | decimal | Specifies the required man hours to perform the task |
| 45 | TLGWU_RES_TOOLS_HRS | decimal | Specifies the resource tool hours |
| 46 | TLGWU_RES_EQUIP_HRS | decimal | Specifies the resource equipment hours |
| 47 | TLGWU_RES_OTHER_HRS | decimal | Specifies the resource other hours |
| 48 | TLGWU_RES_SKILL_HRS | decimal | Specifies the resource skill hours |
| 49 | TLGWU_RECORDED_BY | varchar | Specifies the recorded by user |
| 50 | TLGWU_CORDER_SEQNO | int | Specifies the customer order sequence number |
| 51 | TLGWU_CORDER_UPDATE | varchar | Specifies whether the customer order is updated |
| 52 | TLGWU_TSK_TYPE | varchar | Specifies the type of task |
| 53 | TLGWU_PREV_EXEC_COMMENTS | varchar | Specifies previous execution comments |
| 54 | TLGWU_PRV_INCMP_TLOG_NO | varchar | Specifies the previous incomplete package number |
| 55 | TLGWU_SCHSTDT_DATETIME | datetime | Specifies the scheduled start datetime |
| 56 | TLGWU_SCHEDDT_DATETIME | datetime | Specifies the scheduled end datetime |
| 57 | TLGWU_ACTSTDT_DATETIME | datetime | Specifies the actual start datetime |
| 58 | TLGWU_ACTEDDT_DATETIME | datetime | Specifies the actual end datetime |
| 59 | TLGWU_ACTMAN_HRS | numeric | Specifies the actual man hours |
| 60 | TLGWU_RIIREPORT_BY | varchar | Specifies the RII reported by |
| 61 | TLGWU_ADDNREPORT_BY | varchar | Specifies the additional reported by |
| 62 | TLGWU_RIIREPORT_REQ | varchar | Specifies whether RII reporting is required |
| 63 | TLGWU_ADDNREPORT_REQ | varchar | Specifies whether additional reporting is required |
| 64 | TLGWU_RIIREPORT_SOFF | varchar | Specifies whether RII is signed off |
| 65 | TLGWU_REL_TASK | varchar | Specifies the related task |
| 66 | TLGWU_STD_PROC | varchar | Specifies standard procedure no longer used |
| 67 | TLGWU_WRK_PKG | varchar | Specifies work package no longer used |
| 68 | TLGWU_TSK_STATION | varchar | Specifies the station in which the task is performed |
| 69 | TLGWU_TSK_WCCODE | varchar | Specifies the work center in which the task is performed |
| 70 | TLGWU_TSK_EXEDATE | datetime | Specifies the task execution date and time |
| 71 | TLGWU_TSK_EXEPHAS | varchar | Specifies the task execution phase |
| 72 | TLGWU_TSK_ZONEWRK | varchar | Specifies the task work area |
| 73 | TLGWU_TSK_ADDSIGN | varchar | Specifies task additional sign off |
| 74 | TLGWU_EXPENSE_TYPE | varchar | Specifies the expense type |
| 75 | TLGWU_CAPEXPROPOSAL_NO | varchar | Specifies the CAPEX proposal number |
| 76 | TLGWU_PRIORITY_CODE | varchar | Specifies the priority code |
| 77 | TLGWU_REFNO | varchar | Specifies the reference number |
| 78 | TLGWU_FORECAST_INSTID | int | Specifies the forecast instance ID |
| 79 | TLGWU_ESTMATERIAL_COST | numeric | Specifies the estimated material cost |
| 80 | TLGWU_ESTLABOUR_COST | numeric | Specifies the estimated labour cost |
| 81 | TLGWU_ESTTOOLS_COST | numeric | Specifies the estimated tool cost |
| 82 | TLGWU_ESTEQUIPMENT_COST | numeric | Specifies the estimated equipment cost |
| 83 | TLGWU_ESTOTHERS_COST | numeric | Specifies the estimated other cost |
| 84 | TLGWU_ESTSKILL_COST | numeric | Specifies the estimated skill cost |
| 85 | TLGWU_EST_ELASPED_TIME_IN_MIN | numeric | Specifies the estimated elapsed time in minutes |
| 86 | TLGWU_ASSIGN_STATUS | varchar | Specifies the assignment status |
| 87 | TLGWU_MISC_COST | numeric | Specifies miscellaneous cost |
| 88 | TLGWU_EXEC_CATEGORY | varchar | Specifies execution category |
| 89 | TLGWU_PERCENT_COMPLETE | int | Specifies the percentage completed |
| 90 | TLGWU_ZONE | varchar | Specifies the zone |
| 91 | TLGWU_USER_DEF_STATUS | varchar | Specifies user defined status |
| 92 | TLGWU_ENG_DOCNO | varchar | Specifies the engineering document number |
| 93 | TLGWU_DOC_UNIQUEID | varchar | Specifies unique ID for document attribute page |
| 94 | TLgWu_Eng_DocRevNo | varchar | Specifies the revision number of engineering document |
| 95 | TLgWu_CusOrd_TskLineNo | int | Specifies the customer order task line number |
| 96 | Tlgwu_TimeStamp | int | Specifies the work unit timestamp |
| 97 | Tlgwu_ParaRef_Id | varchar | Specifies the work unit parent reference ID used for record parameter reading |
| 98 | Tlgwu_Maint_Event | varchar | Specifies the maintenance event |
| 99 | TLGWU_PSTMAT_COST | numeric | Specifies the material cost posted to finance function |
| 100 | TLGWU_PSTLABOUR_COST | numeric | Specifies the labour cost posted to finance function |
| 101 | TLGWU_PSTTOOLS_COST | numeric | Specifies the tools cost posted to finance function |
| 102 | TLGWU_PSTEQUIPMENT_COST | numeric | Specifies the equipment cost posted to finance function |
| 103 | TLGWU_PSTOTHERS_COST | numeric | Specifies other cost posted to finance function |
| 104 | TLGWU_PSTSKILL_COST | numeric | Specifies skill cost posted to finance function |
| 105 | TLGWU_PSTMISC_COST | numeric | Specifies miscellaneous cost posted to finance function |
| 106 | TLGWU_HOLD_ID | varchar | Specifies the hold code applied on the task |
| 107 | TLGWU_HOLD_COMMENT | varchar | Specifies the hold comments |
| 108 | TLGWU_TRANSIENT_STATUS | varchar | Specifies the transient status |
| 109 | Tlgwu_CreatedDt | datetime | Specifies the date and time at which the task is added to the package for execution |
| 110 | TLGWU_created_by | varchar | Specifies the user who added the task to the package for execution |
| 111 | TLGWU_modifiedDt | datetime | Specifies the date and time at which the task is last modified |
| 112 | TLGWU_modified_by | varchar | Specifies the user who last modified the task |
| 113 | TLGWU_task_Desc | varchar | Specifies the task description |
| 114 | TLGWU_part_desc | varchar | Specifies the part description |
| 115 | TLGWU_mfr_partno | varchar | Specifies the manufacturer part number |
| 116 | TLGWU_mfr_no | varchar | Specifies the manufacturer number |
| 117 | TLGWU_hierarchy_id | varchar | Specifies the hierarchy ID which helps to identify the task relationships |
| 118 | TLGWU_root_task | varchar | Specifies the root task |
| 119 | TLGWU_rep_seqno | int | Specifies the repair sequence number |
| 120 | TLGWU_org_seqno | int | Specifies the original sequence number |
| 121 | TLGWU_seq_cntrl_no | int | Specifies the sequence control number |
| 122 | TLGWU_wbs_code | varchar | Specifies the WBS code |
| 123 | TLGWU_wrk_scp_flag | varchar | Specifies the work scoping flag indicating if the task is a work scoping task |
| 124 | TLGWU_Rpr_schm_flag | varchar | Specifies the repair scheme flag |
| 125 | TLGWU_wbs_level | varchar | Specifies the WBS level |
| 126 | TLGWU_exec_opr_flag | varchar | Specifies the execution operation flag indicating if the task is operational |
| 127 | TLGWU_compl_flag | varchar | Specifies the compliance flag |
| 128 | TLGWU_exec_action | varchar | Specifies the execution action |
| 129 | TLGWU_task_rel_flag | varchar | Specifies the task relationship flag |
| 130 | TLGWU_mandatory_flag | varchar | Specifies the mandatory flag |
| 131 | TLGWU_seperated_flag | varchar | Specifies the separated flag |
| 132 | TLGWU_ext_facility_flag | varchar | Specifies the external facility flag |
| 133 | TLGWU_est_status | varchar | Specifies the estimation status |
| 134 | TLGWU_routing_reg | varchar | Specifies the routing requirement flag |
| 135 | TLGWU_repair_class | varchar | Specifies the repair classification |
| 136 | TLGWU_repair_agency | varchar | Specifies the repair agency |
| 137 | TLGWU_ro_no | varchar | Specifies the repair order number |
| 138 | TLGWU_eventid | varchar | Specifies the event ID |
| 139 | TLGWU_parent_task_trackid | bigint | Specifies the parent task unique ID |
| 140 | TLGWU_est_purpose | varchar | Specifies the estimation purpose |
| 141 | TLGWU_est_inst_id | varchar | Specifies the estimation instance ID |
| 142 | TLGWU_quote_rel_id | varchar | Specifies the quotation related identifier |
| 143 | TLGWU_charge_est_flag | varchar | Specifies the flag related to estimation |
| 144 | TLGWU_other_est_flag | varchar | Specifies other estimation flag |
| 145 | TLGWU_part_est_flag | varchar | Specifies part estimation flag |
| 146 | TLGWU_res_est_flag | varchar | Specifies resource estimation flag |
| 147 | TLGWU_source_flag | varchar | Specifies the source flag |
| 148 | TLGWU_TRACK_ID 🔑 | bigint | Specifies the task track ID which uniquely identifies the task in a package |
| 149 | TLGWU_cust_warr_flag | varchar | Specifies the customer warranty flag |
| 150 | TLGWU_WRK_SCOP_COM | varchar | Specifies the working scoping COM |
| 151 | TLGWU_REF_TALLY_NO | Bigint | Specifies the reference tally number |
| 152 | tlgwu_base_source_flag | varchar | Specifies the online/offline flag applicable for OFMS operations |
| 153 | tlgwu_isscom_flag | varchar | Specifies the issue COM flag |
| 154 | TLGWU_Execcode | varchar | Specifies the execution code |
| 155 | tlgwu_adhoc_flag | varchar | Specifies the adhoc flag |
| 156 | Tlgwu_MaintManualRef | varchar | Specifies the maintenance manual reference number |
| 157 | tlgwu_oldrev_no | varchar | Specifies the old task revision number |
| 158 | tlgwu_baserev_no | varchar | Specifies the task base revision number |
| 159 | TLGWU_Log_Item | varchar | Specifies the log item number |
| 160 | tlgwu_riiskill | varchar | Specifies the RII skill from task master |
| 161 | tlgwu_tskbul_lineno | int | Specifies the task bulk upload line number |
| 162 | tlgwu_planid | Bigint | Specifies the scheduler planning track ID |
| 163 | tlgwu_timefenceflag | varchar | Specifies the task attributes wrench time required flag |
| 164 | tlgwu_tsk_clsdt | datetime | Specifies the task closed datetime |
| 165 | tlgwu_swbs_task | varchar | Specifies the source WBS task number |
| 166 | tlgwu_swbstsk_id | Bigint | Specifies the source WBS task tracking number |
| 167 | tlgwu_swbs_flg | varchar | Specifies the source WBS required flag |
| 168 | TLGWU_ConstDate | datetime | Specifies the constraint datetime for scheduler |
| 169 | TLGWU_ConstType | varchar | Specifies the constraint type for scheduler |
| 170 | TLGWU_FlaggDate | datetime | Specifies the flagged datetime for scheduler |
| 171 | TLGWU_FlaggEmp | varchar | Specifies the employee who flagged the task for scheduler |
| 172 | TLGWU_FlaggRemarks | varchar | Specifies the flagged remarks for scheduler |
| 173 | TLGWU_USER_DEFINED1 | varchar | Specifies user defined data 1 |
| 174 | TLGWU_USER_DEFINED2 | varchar | Specifies user defined data 2 |
| 175 | TLGWU_USER_DEFINED3 | datetime | Specifies user defined data 3 |
| 176 | tlgwu_dtchange_flag | varchar | Specifies the date change flag |
| 177 | tlgwu_emploading_flag | varchar | Specifies the employee loading flag for scheduler |
| 178 | tlgwu_wrenchtime_min | numeric | Specifies the task attributes wrench time in minutes |
| 179 | tlgwu_sch_appl | varchar | Specifies the scheduler applicable flag |
| 180 | tlgwu_qty_type | varchar | Specifies the task attributes quantity type |
| 181 | TLGWU_subseqno | int | Specifies the latest sub task sequence number for task |
| 182 | TLGWU_RIIsign_off_date | datetime | Specifies the RII signed off datetime |
| 183 | tlgwu_rii_sgn_off_comments | varchar | Specifies the RII signed off comments |
| 184 | TLGWU_custseqno | int | Specifies the customer task sequence number |
| 185 | TLGWU_custskcrdno | varchar | Specifies the customer task card number |
| 186 | TLGWU_custpackno | varchar | Specifies the customer package number |
| 187 | TLGWU_MAINTMANUALREF_date | datetime | Specifies the maintenance manual reference revision number |
| 188 | TLGWU_MAINTMANUALREF_Rev | varchar | Specifies the maintenance manual reference datetime |
| 189 | TLGWU_USER_STATUS | varchar | Specifies the task user status |
| 190 | tlgwu_rii_type | varchar | Specifies the task attributes RII type |
| 191 | TLGWU_reqrev | varchar | Specifies the task required revision number |
| 192 | tlgwu_elm_flg | varchar | Specifies the duplicate task flag |
| 193 | TLGWU_cusrqst | varchar | Specifies the customer request |
| 194 | TLGWU_ExecDocUD1 | varchar | Specifies user defined data 1 for execution document number |
| 195 | TLGWU_ExecDocUD2 | varchar | Specifies user defined data 2 for execution document number |
| 196 | tlgwu_act_last | varchar | Specifies the latest action details on the task |
| 197 | tlgwu_act_lastprog | varchar | Specifies the latest action progress notes on the task |
| 198 | tlgwu_act_trackid | bigint | Specifies the latest action record tracking number |
| 199 | TLGWU_SUB_CONTRACTOR | varchar | Specifies the sub contractor number |
Relationships (14)
- AMEPackage (FLOG_TLGMN_TECH_LOG_HDR) →
CONTAINS_TASK(this table is target) (no automatic join)- Package contains task work units
HAS_SUBTASK→ SubTask (FLOG_TLGWU_SUBTSK_DTL) (no automatic join)- Task contains subtasks
HAS_SIGNOFF→ TaskSignOff (FLOG_TLGTSO_TSK_SNOFF)- Join:
FLOG_TLGWU_WORK_UNIT_DTL.TLGWU_TRACK_ID = FLOG_TLGTSO_TSK_SNOFF.TLGTSO_WU_Track_id - Task has sign-off record
- Join:
HAS_PART_CONSUMPTION→ PartConsumption (FLOG_TLGPC_PART_CONSUMP_DTL)- Join:
FLOG_TLGWU_WORK_UNIT_DTL.TLGWU_TRACK_ID = FLOG_TLGPC_PART_CONSUMP_DTL.TLGPC_TASK_Track_id - Task has part consumption records
- Join:
HAS_RESOURCE_CONSUMPTION→ ResourceConsumption (FLOG_TLGRC_RES_CONSUMP_DTL)- Join:
FLOG_TLGWU_WORK_UNIT_DTL.TLGWU_TRACK_ID = FLOG_TLGRC_RES_CONSUMP_DTL.TLGRC_TASK_Track_id - Task has resource consumption records
- Join:
ADDITIONAL_SIGNOFF→ AdditionalSignOff (flog_adlsoff_tsk_dtl) (no automatic join)- Task has additional sign-off
HAS_WORK_ASSIGNMENT→ WorkAssignment (FLOG_WORK_ASSIGN_DTL)- Join:
FLOG_TLGWU_WORK_UNIT_DTL.TLGWU_TRACK_ID = FLOG_WORK_ASSIGN_DTL.FLOG_TASK_tRACK_ID - Task has work assignment
- Join:
HAS_PARAM_UPDATE→ ParamUpdateDetail (flog_tlgpm_param_upd_dtl)- Join:
FLOG_TLGWU_WORK_UNIT_DTL.TLGWU_TRACK_ID = flog_tlgpm_param_upd_dtl.TLGPM_Wu_Track_id - Task has parameter update details
- Join:
HAS_EXECUTION_COMMENT→ ExecutionComment (FLOG_TLGEC_EXCOMM_HIST)- Join:
FLOG_TLGWU_WORK_UNIT_DTL.TLGWU_TRACK_ID = FLOG_TLGEC_EXCOMM_HIST.TLGECH_WU_Track_id - Task has execution comments
- Join:
HAS_SIGNOFF_COMMENT→ SignOffComment (FLOG_TLGSC_SOCOMM_HIST)- Join:
FLOG_TLGWU_WORK_UNIT_DTL.TLGWU_TRACK_ID = FLOG_TLGSC_SOCOMM_HIST.TLGSCH_WU_Track_id - Task has sign-off comments
- Join:
HAS_ISSUE_RETURN→ IssueReturn (fl_tlissret_issue_dtl)- Join:
FLOG_TLGWU_WORK_UNIT_DTL.TLGWU_TRACK_ID = fl_tlissret_issue_dtl.TLISSRET_Task_Track_ID - Task has issue/return records
- Join:
HAS_BENCH_STOCK→ BenchStockConsump (flog_rbsc_bench_stk_cons_dtl)- Join:
FLOG_TLGWU_WORK_UNIT_DTL.TLGWU_TRACK_ID = flog_rbsc_bench_stk_cons_dtl.rbsc_track_id - Task has bench stock consumption
- Join:
HAS_TIME_BOOKING→ TimeBooking (TA_TD_TIMEBOOKING_DTL) (no automatic join)- Task has time booking records
HAS_MATERIAL_REQUEST→ MaterialRequest (MR_MRMN_MATRL_REQ_MAIN_HDR) (no automatic join)- Task has material request