FLOG_TLGSTSO_SUBTSK_SNOFF
Records sign-off information for sub-tasks completed under Aircraft Maintenance Execution (AME) packages. Captures employee approvals, timestamps, and compliance tracking for maintenance quality assurance.
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 SubTaskSignOff entity.
Primary key
TLGSTSO_WU_Track_id, TLGSTSO_SUBTSK_SEQ_NO
Columns (25)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | TLGSTSO_SLFSRC_OUINSTANCE | #N/A | Specifies the organization unit in which the sub task sign off information is recorded |
| 2 | TLGSTSO_TECHLOG_NO | varchar | Specifies the package for which the sub task sign off information is recorded |
| 3 | TLGSTSO_WU_SEQ_NO | #N/A | Specifies the sequence number which uniquely identifies the task in the package |
| 4 | TLGSTSO_DRILLDOWN_SEQ_NO | #N/A | Specifies the drill down sequence number |
| 5 | TLGSTSO_SUBTSK_SEQ_NO 🔑 | varchar | Specifies the sub task sequence number |
| 6 | TLGSTSO_CRT_OU | #N/A | Specifies the organization unit in which the sign off information is recorded |
| 7 | TLGSTSO_SUB_TASK_DESC | varchar | Specifies the sub task description |
| 8 | TLGSTSO_SKILL_CODE | Varchar | Specifies the skill code |
| 9 | TLGSTSO_RESOURCE_GRP | Varchar | Specifies the resource group |
| 10 | TLGSTSO_OTHER_SNOFF_INFO | varchar | Specifies other sign off information |
| 11 | TLGSTSO_EMP_NO | varchar | Specifies the employee code |
| 12 | TLGSTSO_LAST_MODIFIED_BY | varchar | Specifies the user who last modified the sign off information |
| 13 | TLGSTSO_LAST_MODIFIED_DATE | datetime | Specifies the date and time at which the sign off information is last modified |
| 14 | TLGSTSO_DISC_REP_FLAG | varchar | Indicates the discrepancy flag |
| 15 | TLGSTSO_SIGN_OFF_COMMENTS | varchar | Specifies the sign off comments |
| 16 | TLGSTSO_TIMESTAMP | #N/A | Indicates the number of times the sign off information got modified |
| 17 | TLGSTSO_RECORDED_BY | varchar | Specifies the user who recorded the sign off details |
| 18 | tlgstso_sgnoffsource | varchar | Specifies the source of sign off |
| 19 | TLGSTSO_WU_Track_id 🔑 | bigint | Specifies the task track ID |
| 20 | TLGSTSO_TMSUB_SEQNO | int | Specifies whether the sub task is a sub task or not |
| 21 | TLGSTSO_SUBTSK_Uniqueid | Bigint | Specifies the sub task tracking unique ID |
| 22 | TLGSTSO_CERTIFICATE_NO | varchar | Specifies the certificate number for sub task details |
| 23 | TLGSTSO_LICENSE_NO | varchar | Specifies the license number for sub task details |
| 24 | Tlgstso_sign_off_date | datetime | Specifies the sub task sign off datetime |
| 25 | tlgstso_altskill_code | varchar | Specifies alternate skill code for sub task details |
Relationships (1)
- SubTask (FLOG_TLGWU_SUBTSK_DTL) →
SUBTASK_HAS_SIGNOFF(this table is target)- 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)
TLGSTSO_SLFSRC_OUINSTANCE | TLGSTSO_TECHLOG_NO | TLGSTSO_WU_SEQ_NO | TLGSTSO_DRILLDOWN_SEQ_NO | TLGSTSO_SUBTSK_SEQ_NO | TLGSTSO_CRT_OU |
|---|---|---|---|---|---|
| 2.0 | VP-000390-2012 | 1.0 | 1.0 | 1.1 | 2.0 |
| 2.0 | VP-000408-2013 | 1.0 | 1.0 | 1.1 | 2.0 |
| 2.0 | VP-000408-2013 | 2.0 | 1.0 | 2.2 | 2.0 |
Showing 3 of 311,113 rows.