FLOG_TLGTSO_TSK_SNOFF
Maintains approval and Sign-Off completion details at the task level in Aircraft Maintenance Execution (AME) packages. Supports regulatory compliance, accountability, and maintenance close-out procedures.
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 TaskSignOff entity.
Primary key
TLGTSO_WU_Track_id
Columns (14)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | TLGTSO_SLFSRC_OUINSTANCE | #N/A | Specifies the organization unit in which the task level sign off information is recorded |
| 2 | TLGTSO_TECHLOG_NO | varchar | Specifies the package for which the task level sign off information is recorded |
| 3 | TLGTSO_WU_SEQ_NO | #N/A | Specifies the unique sequence number which identifies the task in the package |
| 4 | TLGTSO_DRILLDOWN_SEQ_NO | #N/A | Specifies the unique sequence number which identifies the sign off details in the package |
| 5 | TLGTSO_CRT_OU | #N/A | Specifies the organization unit in which the task level sign off information is recorded |
| 6 | TLGTSO_WORK_PACKAGE_NO | varchar | Specifies the work package number no longer used |
| 7 | TLGTSO_STD_PROC_NO | varchar | Specifies the standard procedure number no longer used |
| 8 | TLGTSO_TASK_NO | varchar | Specifies the task number for which sign off information is recorded |
| 9 | TLGTSO_TASK_OU | #N/A | Specifies the organization unit in which the task is defined |
| 10 | TLGTSO_TSK_SIGNOFF_INFO | varchar | Specifies the sign off information |
| 11 | TLGTSO_TASK_REV_NO | varchar | Specifies the task revision number |
| 12 | TLGTSO_TIMESTAMP | #N/A | Indicates the number of times the sign off information got modified |
| 13 | tlgtso_sgnoffsource | varchar | Specifies the source of sign off information |
| 14 | TLGTSO_WU_Track_id 🔑 | bigint | Specifies the task tracking ID which uniquely identifies the task in packages |
Relationships (1)
- Task (FLOG_TLGWU_WORK_UNIT_DTL) →
HAS_SIGNOFF(this table is target)- Join:
FLOG_TLGWU_WORK_UNIT_DTL.TLGWU_TRACK_ID = FLOG_TLGTSO_TSK_SNOFF.TLGTSO_WU_Track_id - Task has sign-off record
- Join:
Sample rows (from live DB)
TLGTSO_SLFSRC_OUINSTANCE | TLGTSO_TECHLOG_NO | TLGTSO_WU_SEQ_NO | TLGTSO_DRILLDOWN_SEQ_NO | TLGTSO_CRT_OU | TLGTSO_WORK_PACKAGE_NO |
|---|---|---|---|---|---|
| 2.0 | VP-000390-2012 | 1.0 | 1.0 | 2.0 | — |
| 2.0 | VP-000408-2013 | 1.0 | 1.0 | 2.0 | — |
| 2.0 | VP-000408-2013 | 2.0 | 1.0 | 2.0 | — |
Showing 3 of 189,289 rows.