Wiki·ontology·ontology/amepackage.md

AMEPackage

Aircraft Maintenance Execution package — a work bundle against an aircraft. Also called a tech log in operations. Each AME package is for one aircraft, lasts from arrival to gate-out, and can contain many tasks, snags, sign-offs, and part consumption events.

Canonical table: FLOG_TLGMN_TECH_LOG_HDR · Key column: TLGMN_TECHLOG_NO

Example record

  • TLGMN_TECHLOG_NO: LC-000001-2019
  • TLGMN_SLFSRC_OUINSTANCE: 2.0
  • TLGMN_TECHLOG_CATEGORY: 1-Repair
  • TLGMN_ACT_ARRIVAL_DATETIME: —
  • TLGMN_AIRCRAFT_OUINSTANCE: 2.0
  • TLGMN_UTC_ACT_ARR_DATETIME: —
  • TLGMN_AIRCRAFT_REG_NO: 101
  • TLGMN_CONFIRMED_BY: —

Outgoing relationships (9)

  • CONTAINS_TASK → Task (no automatic join)
    • Package contains task work units
  • HAS_CERTIFICATE → CertificateOfMaintenance
    • via FLOG_TLGMN_TECH_LOG_HDR.TLGMN_TECHLOG_NO = FLOG_TLGCOM_TECH_COM_DTL.TLgCOM_TechLog_No
    • Package has certificate of maintenance
  • BELONGS_TO_OU → OrganizationUnit (to virtual entity)
    • Package belongs to organization unit
  • FOR_AIRCRAFT → Aircraft
    • via FLOG_TLGMN_TECH_LOG_HDR.TLGMN_AIRCRAFT_REG_NO = AC_ACI_AIRCRAFT_INFO.ACI_AIRCRAFT_REG_NO
    • AME Package is for a specific aircraft
  • AT_STATION → Station
    • via FLOG_TLGMN_TECH_LOG_HDR.TLGMN_FROM_STATION = CM_STNDTL_STATION_DTL.STNDTL_STATION
    • AME Package executed at station
  • AT_WORK_CENTER → Workcenter
    • via FLOG_TLGMN_TECH_LOG_HDR.TLGMN_WORK_CENTER = BAS_WCLOG_WC_LOGICAL_WC_DTL.WCLOG_WORK_CENTER
    • AME Package executed at workcenter
  • HAS_COMPONENT_REPLACEMENT → COMPONENT_REPLACEMENT (no automatic join)
    • Package has component replacement records
  • HAS_CUSTOMER_ORDER → CustomerOrder (to virtual entity)
    • AME Package having customer order reference
  • FOR_CUSTOMER → Customer
    • via FLOG_TLGMN_TECH_LOG_HDR.tlgmn_cust_no = Cu_CMH_Cust_Master_Hdr.CMH_Cust_No
    • AME Package having customer reference

Incoming relationships (1)

  • DefDiscResolution → RESOLVED_BY_AME
    • via FLOG_DFDPRSL_DEF_DISC_RESOL.DFDPRSL_TECHLOG_NO = FLOG_TLGMN_TECH_LOG_HDR.TLGMN_TECHLOG_NO

See also