FLOG_TLGSNG_TECH_LOG_SNAG_DTL
Captures snags and discrepancies reported within Aircraft Maintenance Execution ( AME ) packages. Includes snag descriptions, severity, and corrective action references.
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
TLGSNG_SLFSRC_OUINSTANCE, TLGSNG_TECHLOG_NO, TLGSNG_DISCREPANCY_NO
Columns (15)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | TLGSNG_SLFSRC_OUINSTANCE 🔑 | #N/A | Specifies the organization unit in which the snag discrepancy details are recorded |
| 2 | TLGSNG_TECHLOG_NO 🔑 | varchar | Identifies the Aircraft Maintenance Execution package through which the discrepancy is recorded |
| 3 | TLGSNG_DISCREPANCY_NO 🔑 | varchar | Specifies the unique discrepancy number used for tracking and resolution |
| 4 | TLGSNG_DISCREPANCY_OU | #N/A | Captures the organization unit in which the snag or discrepancy is defined |
| 5 | TLGSNG_CRT_OU | #N/A | Captures the organization unit in which the discrepancy details are recorded |
| 6 | TLGSNG_ACTION | varchar | Defines the action identified to resolve the discrepancy |
| 7 | TLGSNG_CREATED_BY | varchar | Records the user ID of the employee who created the discrepancy record |
| 8 | TLGSNG_CREATED_DATETIME | datetime | Records the date and time when the discrepancy was first logged |
| 9 | TLGSNG_MODIFIED_BY | varchar | Records the user ID of the employee who last modified the discrepancy record |
| 10 | TLGSNG_MODIFIED_DATETIME | datetime | Records the date and time when the discrepancy was last modified |
| 11 | TLGSNG_TIMESTAMP | #N/A | Indicates the number of times the discrepancy record has been updated |
| 12 | TLgSng_Task_No | varchar | Provides the task reference number linked to the discrepancy |
| 13 | TLGSNG_LOG_LEAF_NO | varchar | Specifies the log leaf number associated with the discrepancy |
| 14 | TLGSNG_SIGNOFF_REQT | varchar | Indicates whether a sign off is required for the discrepancy |
| 15 | TLgSng_Task_Track_id | bigint | Provides the task track identifier for monitoring and tracing the task lifecycle |
Sample rows (from live DB)
TLGSNG_SLFSRC_OUINSTANCE | TLGSNG_TECHLOG_NO | TLGSNG_DISCREPANCY_NO | TLGSNG_DISCREPANCY_OU | TLGSNG_CRT_OU | TLGSNG_ACTION |
|---|---|---|---|---|---|
| 2.0 | LC-000001-2019 | GYYHG | 2.0 | 2.0 | — |
| 2.0 | LC-000001-2019 | hdfckjsdcfhsdkj | 2.0 | 2.0 | — |
| 2.0 | LC-000001-2019 | HGFH | 2.0 | 2.0 | — |
Showing 3 of 7,021 rows.