CertificateOfMaintenance

The Certificate of Release to Service (COM/CRS) — issued when all required tasks are closed and the aircraft is legally released back to operations.

Canonical table: FLOG_TLGCOM_TECH_COM_DTL · Key column: TLgCOM_Com_NO

Example record

• TLgCOM_SlfSrc_OuInstance: 2
• TLgCOM_TechLog_No: LC-000063-2020
• TLgCOM_Com_NO: COM-000226-2020
• TLgCOM_Com_Type: R
• TLgCOM_Com_Status: CF
• TLgCOM_User_Status: —
• TLgCOM_Employee_No: 00001413
• TLgCOM_Primary_Skill_No: 01

Outgoing relationships (1)

• HAS_COM_SKILL → COMSkill
  • via FLOG_TLGCOM_TECH_COM_DTL.TLgCOM_Com_NO = FLOG_TLGSKL_COM_SKILL_DTL.TLgSkl_Com_NO
  • Certificate has skill details

Incoming relationships (1)

• AMEPackage → HAS_CERTIFICATE
  • via FLOG_TLGMN_TECH_LOG_HDR.TLGMN_TECHLOG_NO = FLOG_TLGCOM_TECH_COM_DTL.TLgCOM_TechLog_No

See also

• AMEPackage
• COMSkill
• FLOG_TLGCOM_TECH_COM_DTL