FLOG_TLGWU_SUBTSK_DTL
Contains detailed records of sub-tasks associated with main tasks in Aircraft Maintenance Execution (AME) packages. Enables breakdown of maintenance work into smaller actionable units for execution and monitoring.
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 SubTask entity.
Primary key
TLGSBTSK_SUBTsk_Uniqueid
Columns (26)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | TLGSBTSK_Ouinstance | int | Organization Unit identifies the organization unit associated with the entry |
| 2 | TLGSBTSK_SUBTsk_Uniqueid 🔑 | Bigint | Sub Task unique tracking number uniquely identifies the subtask |
| 3 | TLGSBTSK_TechlogNo | varchar | AME document number identifies the AME document |
| 4 | TLGSBTSK_WU_Trackid | Bigint | Task tracking number provides the tracking number of the task |
| 5 | TLGSBTSK_WU_SeqNo | int | Task sequence number for AME document indicates the task sequence within the document |
| 6 | TLGSBTSK_SUBTask_Desc | varchar | Sub Task description provides a detailed description of the subtask |
| 7 | TLGSBTSK_Createddate | datetime | Record created datetime captures the date and time when the record was created |
| 8 | TLGSBTSK_Createdby | varchar | Record created By identifies the user who created the record |
| 9 | TLGSBTSK_Modifieddate | datetime | Record modified datetime captures the date and time when the record was last modified |
| 10 | TLGSBTSK_Modifiedby | varchar | Record modified By identifies the user who last modified the record |
| 11 | tlgsbtsk_estmanhrs | numeric | Sub Task estimated man hours provides the estimated effort in hours for the subtask |
| 12 | tlgsbtsk_timeuom | varchar | Sub Task required time in UOM specifies the required time in the unit of measure |
| 13 | tlgsbtsk_elapsedtime | numeric | Sub Task elapsed time records the time actually spent on the subtask |
| 14 | TLGSBTSK_tmsub_seqno | int | Sub Task sequence from Task Master provides the sequence number from the task master |
| 15 | tlgsbtsk_estskill | varchar | Estimated Skill identifies the skill estimated for the subtask |
| 16 | tlgsbtsk_planid | Bigint | Scheduler Planner id identifies the planner responsible for scheduling |
| 17 | tlgsbtsk_planstartdate | datetime | Sub Task plan start datetime records the planned start datetime of the subtask |
| 18 | tlgsbtsk_planenddate | datetime | Sub Task plan End datetime records the planned end datetime of the subtask |
| 19 | tlgsbtsk_emp_loading | varchar | Employee loading captures the workload allocation for the employee |
| 20 | TLGSBTSK_sch_appl | varchar | Scheduler applicable flag indicates whether the scheduler applies to this subtask |
| 21 | tlgsbtsk_schworktime | varchar | Schedule with Work time specifies whether the schedule is aligned with work hours |
| 22 | TLGSBTSK_EXEC_COMMENTS | varchar | Sub Task execution comments captures execution-related comments for the subtask |
| 23 | tlgsbtsk_OPQTY_Type | varchar | Output quantity type specifies the type of output quantity for the subtask |
| 24 | tlgsbtsk_laddlsdt | datetime | Latest Additional Sign off Datetime records the most recent additional sign off datetime |
| 25 | tlgsbtsk_laddlsoff | varchar | Latest Additional Sign off by records the user who performed the latest additional sign off |
| 26 | tlgsbtsk_lsocomm | varchar | Latest Additional Sign off Comments records the comments from the latest additional sign off |
Relationships (2)
- Task (FLOG_TLGWU_WORK_UNIT_DTL) →
HAS_SUBTASK(this table is target) (no automatic join)- Task contains subtasks
SUBTASK_HAS_SIGNOFF→ SubTaskSignOff (FLOG_TLGSTSO_SUBTSK_SNOFF)- Join:
FLOG_TLGWU_SUBTSK_DTL.TLGSBTSK_SUBTsk_Uniqueid = FLOG_TLGSTSO_SUBTSK_SNOFF.TLGSTSO_SUBTSK_Uniqueid - Subtask has sign-off record
- Join:
Sample rows (from live DB)
TLGSBTSK_Ouinstance | TLGSBTSK_SUBTsk_Uniqueid | TLGSBTSK_TechlogNo | TLGSBTSK_WU_Trackid | TLGSBTSK_WU_SeqNo | TLGSBTSK_SUBTask_Desc |
|---|---|---|---|---|---|
| 2 | -2147482711 | LP-000787-2020 | 87276 | 1 | efv |
| 2 | -2147482710 | LP-000423-2020 | 81749 | 5 | Ca-4 |
| 2 | -2147482709 | LP-000423-2020 | 81749 | 5 | Fgcgfgbnbjbbj |
Showing 3 of 98,251 rows.