FLOG_TLGSKL_COM_SKILL_DTL
Stores skill requirement details for performing specific tasks in Aircraft Maintenance Execution (AME) packages. Includes skill codes, categories, and mappings to ensure appropriately qualified staff are allocated.
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 COMSkill entity.
Primary key
TLgSkl_SlfSrc_OuInstance, TLgSkl_TechLog_No, TLgSkl_Com_NO, TLgSkl_Employee_No
Columns (8)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | TLgSkl_SlfSrc_OuInstance 🔑 | int | Specifies the main organization unit which interacts with the logged-in unit |
| 2 | TLgSkl_TechLog_No 🔑 | varchar | Specifies the Aircraft Maintenance Execution package number |
| 3 | TLgSkl_Com_NO 🔑 | varchar | Specifies the certificate of maintenance number |
| 4 | TLgSkl_Employee_No 🔑 | varchar | Specifies the employee number |
| 5 | TLgSkL_Crt_OU | int | Specifies the created organization unit |
| 6 | TLgSkl_Skill_No | varchar | Specifies the skill code |
| 7 | TLgSkl_License_No | varchar | Specifies the license number |
| 8 | TLgSkl_Remarks | varchar | Specifies remarks |
Relationships (2)
- CertificateOfMaintenance (FLOG_TLGCOM_TECH_COM_DTL) →
HAS_COM_SKILL(this table is target)- Join:
FLOG_TLGCOM_TECH_COM_DTL.TLgCOM_Com_NO = FLOG_TLGSKL_COM_SKILL_DTL.TLgSkl_Com_NO - Certificate has skill details
- Join:
- Employee (—) →
HAS_SKILL(this table is target) (no automatic join)- Employee has skill
Sample rows (from live DB)
TLgSkl_SlfSrc_OuInstance | TLgSkl_TechLog_No | TLgSkl_Com_NO | TLgSkl_Employee_No | TLgSkL_Crt_OU | TLgSkl_Skill_No |
|---|---|---|---|---|---|
| 2 | LP-007416-2024 | COM-000892-2024 | 00001413 | 2 | 00 |
| 2 | VP-000754-2016 | COM-000180-2018 | 00041383 | 2 | 01 |
Showing 2 of 2 rows.