Wikiยทschemaยทschema/flog-dfdprsl-def-disc-resol.md

FLOG_DFDPRSL_DEF_DISC_RESOL

Stores records of deferred Maintenance Requests (MR) linked to Aircraft Maintenance Execution (AME) documents. Ensures traceability of deferred actions within compliance limits.

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 DefDiscResolution entity.

Primary key

DFDPRSL_TECHLOG_NO, DFDPRSL_SLFSRC_OUINSTANCE, DFDPRSL_MAINT_REPORT_OU, DFDPRSL_MAINT_REPORT_NO

Columns (6)

#ColumnTypeDescription
1DFDPRSL_TECHLOG_NO ๐Ÿ”‘varcharAircraft Maintenance Execution Reference Document Number or Package Number identifies the document or package through which the discrepancy is deferred
2DFDPRSL_SLFSRC_OUINSTANCE ๐Ÿ”‘decimalCaptures the organization unit in which the Aircraft Maintenance Execution Reference Document number or Package number is reported
3DFDPRSL_MAINT_REPORT_OU ๐Ÿ”‘decimalCaptures the organization unit in which the maintenance report is recorded
4DFDPRSL_MAINT_REPORT_NO ๐Ÿ”‘varcharSpecifies the unique maintenance report number used for identification and tracking
5DFDPRSL_RESOL_ACTIONvarcharDefines the resolution action taken against the maintenance report such as Closed No Fault Found or Cancel
6DfDpRsL_Task_novarcharRepresents the unique task number associated with the maintenance activity

Relationships (1)

  • RESOLVED_BY_AME โ†’ AMEPackage (FLOG_TLGMN_TECH_LOG_HDR)
    • Join: FLOG_DFDPRSL_DEF_DISC_RESOL.DFDPRSL_TECHLOG_NO = FLOG_TLGMN_TECH_LOG_HDR.TLGMN_TECHLOG_NO
    • Deferred discrepancy resolved by AME Package

See also