FLOG_WORK_ASSIGN_DTL
Stores detailed information about employees assigned to specific tasks within Aircraft Maintenance Execution (AME) packages. Includes assignment IDs, task references, employee identifiers, and allocation details to support tracking of workforce allocation.
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 WorkAssignment entity.
Primary key
replication_key
Columns (30)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | FLOG_OUINSTANCE | numeric | Org unit where employee work assignments are done |
| 2 | FLOG_REFDOCNO | varchar | Reference package or document specifies the reference package or document associated with the task |
| 3 | FLOG_REFDOCTYPE | varchar | AME Package Type identifies the type of Aircraft Maintenance Execution package |
| 4 | FLOG_SEQNO | int | Task Sequence Number indicates the sequence number of the task within the package |
| 5 | FLOG_TASKNO | varchar | Task Number for which the employee assignment is done identifies the specific task assigned to the employee |
| 6 | FLOG_WORKCENTER | varchar | Work center in which the task is performed identifies the work center where the task is executed |
| 7 | FLOG_EMPOU | numeric | The organization unit in which the employee is defined specifies the unit to which the employee belongs |
| 8 | FLOG_EMPNO | varchar | Employee Code identifies the employee assigned to the task |
| 9 | FLOG_FROMDATE | datetime | Assigned From DateTime records the start date and time of the assignment |
| 10 | FLOG_TODATE | datetime | Assigned To DateTime records the end date and time of the assignment |
| 11 | FLOG_ASSIGN_HOURS | numeric | Assigned Hours for an Employee captures the total assigned hours for the employee |
| 12 | FLOG_ASSIGN_COMMENTS | varchar | Assigned Comments for an Employee records any comments associated with the assignment |
| 13 | FLOG_CREATED_BY | varchar | The user who has done the assignments identifies the person who performed the assignment |
| 14 | FLOG_CREATED_DATETIME | datetime | The date and time at which the assignment is done records when the assignment was created |
| 15 | FLOG_MODIFIED_BY | varchar | The user who last modified the employee work assignment identifies the last user who updated the assignment |
| 16 | FLOG_MODIFIED_DATETIME | datetime | The date and time at which the employee work assignment is last modified records the last modification timestamp |
| 17 | FLOG_TIMESTAMP | int | Timestamp helps to identify the number of times the employee work assignment is modified |
| 18 | FLOG_KEYSEQNO | int | Running number for employee work assignments at package level provides a unique sequence for assignments within the package |
| 19 | flog_updated_remarks | varchar | Updated remarks capture any updates made to the assignment |
| 20 | flog_updated_datetime | datetime | Updated date and time records when the assignment updates were made |
| 21 | flog_updated_by | varchar | The user who has updated the employee work assignments identifies who performed the update |
| 22 | FLOG_TASK_tRACK_ID | bigint | Task Track Id uniquely identifies the task within the package |
| 23 | flog_emp_comments | varchar | Employee Comments captures comments provided by the assigned employee |
| 24 | FLOG_uniqueid | int | IPO identifies the row using a unique key for the assignment |
| 25 | flog_UnitsPercent | int | Assigned Employee availability for task in percentage indicates the employee’s availability for the assigned task |
| 26 | flog_license | varchar | License specifies the license of the assigned employee if applicable |
| 27 | flog_resourcegrp | varchar | Resource group identifies the resource group associated with the task |
| 28 | flog_skill_flag | varchar | Skill available flag indicates whether the assigned skill is available |
| 29 | flog_userdefined | varchar | User defined details captures any user-defined information for the assignment |
| 30 | flog_skillcode | varchar | Skill code details specifies the skill codes associated with the task |
Relationships (2)
- Task (FLOG_TLGWU_WORK_UNIT_DTL) →
HAS_WORK_ASSIGNMENT(this table is target)- Join:
FLOG_TLGWU_WORK_UNIT_DTL.TLGWU_TRACK_ID = FLOG_WORK_ASSIGN_DTL.FLOG_TASK_tRACK_ID - Task has work assignment
- Join:
- Employee (—) →
HAS_ASSIGNMENT(this table is target) (no automatic join)- Employee has work assignment
Sample rows (from live DB)
FLOG_OUINSTANCE | FLOG_REFDOCNO | FLOG_REFDOCTYPE | FLOG_SEQNO | FLOG_TASKNO | FLOG_WORKCENTER |
|---|---|---|---|---|---|
| 2.0 | LC-000004-2019 | Log card | 1 | A320-211-0001A-106 | 185-20 |
| 2.0 | LC-000004-2019 | Log card | 2 | A320-211-0001A-105 | 185-20 |
| 2.0 | LC-000004-2019 | Log card | 3 | A320-211-0001A-104 | 185-20 |
Showing 3 of 3,142 rows.