flog_tlget_tsk_eliminate
Captures and eliminates duplicate task entries recorded in Aircraft Maintenance Execution (AME) packages. Ensures task uniqueness and data consistency for maintenance planning and 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.
Primary key
(NEXT VALUE FOR [flog_tlget_tsk_eliminate_seq])
Columns (23)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | tlget_unique_id | bigint | Task Eliminated tracking number |
| 2 | tlget_src_ou | int | Organization Unit |
| 3 | tlget_doc_ou | int | Aircraft Maintenance Execution ( AME ) Organization Unit |
| 4 | tlget_doc_no | varchar | Aircraft Maintenance Execution ( AME )Package document number |
| 5 | tlget_tsk_no | varchar | Unique ID of the eliminated task |
| 6 | tlget_tsk_prtno | varchar | Part number linked to the eliminated task |
| 7 | tlget_tsk_prtsrlno | varchar | Serial number of the part linked to the eliminated task |
| 8 | tlget_tsk_desc | varchar | Description of the eliminated task |
| 9 | tlget_refdup_tskid | Bigint | Reference child task tracking number eliminated |
| 10 | tlget_refdup_tskno | varchar | Reference child task number eliminated |
| 11 | tlget_refdup_tallyno | int | Reference child task tally number eliminated |
| 12 | tlget_src_tskno | varchar | Reference task number eliminated |
| 13 | tlget_root_tskno | varchar | Reference root task number eliminated |
| 14 | tlget_orgrep_seqno | int | Sequence number where task originated |
| 15 | tlget_work_area | varchar | Work area linked to the task |
| 16 | tlget_zone | varchar | Zone associated with the task |
| 17 | tlget_srcdup_tsklt | varchar | Reference task tracking number eliminated |
| 18 | tlget_elm_reason | varchar | Reason for eliminating the task |
| 19 | tlget_elm_datetime | datetime | Date and time when task was eliminated |
| 20 | tlget_elm_type | varchar | Type/category of elimination |
| 21 | tlget_elm_flg | varchar | Flag indicating task elimination |
| 22 | tlget_elm_by | varchar | User who eliminated the task |
| 23 | tlget_elm_service | varchar | Service reference for eliminated task |
Sample rows (from live DB)
tlget_unique_id | tlget_src_ou | tlget_doc_ou | tlget_doc_no | tlget_tsk_no | tlget_tsk_prtno |
|---|---|---|---|---|---|
| -2147483648 | 2 | 2 | VP-001448-2022 | AIRFRAME CHILD TASKCARD 2 | — |
| -2147483647 | 2 | 2 | VP-001448-2022 | AIRFRAME CHILD TASKCARD 3 | — |
| -2147483646 | 2 | 2 | VP-001448-2022 | AIRFRAME CHILD TASKCARD 2 | — |
Showing 3 of 3,263 rows.