FLOG_TLGCOM_TECH_COM_DTL
Maintains records of Certificates of Maintenance (COM) issued under Aircraft Maintenance Execution (AME) packages. Ensures compliance documentation is complete and traceable.
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 CertificateOfMaintenance entity.
Primary key
TLgCOM_SlfSrc_OuInstance, TLgCOM_TechLog_No, TLgCOM_Com_NO
Columns (24)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | TLgCOM_SlfSrc_OuInstance 🔑 | int | Specifies the organization unit in which the CoM is issued |
| 2 | TLgCOM_TechLog_No 🔑 | varchar | Specifies the package number for which the CoM is issued |
| 3 | TLgCOM_Com_NO 🔑 | varchar | Specifies the certificate of maintenance number |
| 4 | TLgCOM_Com_Type | varchar | Specifies the type of CoM |
| 5 | TLgCOM_Com_Status | varchar | Specifies the CoM status |
| 6 | TLgCOM_User_Status | varchar | Specifies the user status |
| 7 | TLgCOM_Employee_No | varchar | Specifies the employee who issued the CoM |
| 8 | TLgCOM_Primary_Skill_No | varchar | Specifies the primary skill of the employee who issued the CoM |
| 9 | TLgCOM_License_No | varchar | Specifies the license number of the employee |
| 10 | TLgCOM_Remarks | varchar | Specifies remarks |
| 11 | TLgCOM_Com_Datetime | datetime | Specifies the CoM issued date and time |
| 12 | TLgCOM_Filename | varchar | Specifies the name of the file associated with the CoM |
| 13 | TLgCOM_Comments | varchar | Specifies the comments |
| 14 | TLgCOM_Created_Datetime | datetime | Specifies the CoM created date and time |
| 15 | TLgCOM_Created_By | varchar | Specifies the user who generated the CoM |
| 16 | TLgCOM_Modified_Datetime | datetime | Specifies the last modified date and time of CoM |
| 17 | TLgCOM_Modified_By | varchar | Specifies the user who last modified the CoM |
| 18 | TLgCOM_Auth_Datetime | datetime | Specifies the CoM authorization date and time |
| 19 | TLgCOM_Auth_By | varchar | Specifies the user who authorized the CoM |
| 20 | TLgCOM_Timestamp | int | Specifies the timestamp |
| 21 | TLgCOM_Crt_OU | int | Specifies the created organization unit |
| 22 | TLGCOM_CERTIFICATE_NO | varchar | Specifies the certificate number |
| 23 | TLgCOM_Auth_By_sign | varchar | Specifies the authorized by user name |
| 24 | TLgCOM_Created_By_sign | varchar | Specifies the created by user name |
Relationships (2)
- AMEPackage (FLOG_TLGMN_TECH_LOG_HDR) →
HAS_CERTIFICATE(this table is target)- Join:
FLOG_TLGMN_TECH_LOG_HDR.TLGMN_TECHLOG_NO = FLOG_TLGCOM_TECH_COM_DTL.TLgCOM_TechLog_No - Package has certificate of maintenance
- Join:
HAS_COM_SKILL→ COMSkill (FLOG_TLGSKL_COM_SKILL_DTL)- Join:
FLOG_TLGCOM_TECH_COM_DTL.TLgCOM_Com_NO = FLOG_TLGSKL_COM_SKILL_DTL.TLgSkl_Com_NO - Certificate has skill details
- Join:
Sample rows (from live DB)
TLgCOM_SlfSrc_OuInstance | TLgCOM_TechLog_No | TLgCOM_Com_NO | TLgCOM_Com_Type | TLgCOM_Com_Status | TLgCOM_User_Status |
|---|---|---|---|---|---|
| 2 | LC-000063-2020 | COM-000226-2020 | R | CF | — |
| 2 | LP-000007-2019 | COM-000203-2020 | R | CF | — |
| 2 | LP-000197-2019 | COM-000229-2020 | R | CF | — |
Showing 3 of 52 rows.