DP_DEFHST_DISC_DEFERRAL_HST
Maintains historical records of all discrepancy deferrals processed in aircraft maintenance. Provides traceability of deferral approvals, changes, and compliance audits.
Process: LINEMAINTENANCE · Component: BasDP · Table type: Transaction Table Category: Groups the tables related to the discrepancy details, deferrals, deferral history, deferral categories, and resolution history
This table is the canonical store for the DeferralHistory entity.
Primary key
replication_key
Columns (26)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | DEFHST_SLFSRC_OUINSTANCE | #N/A | Maintains the Organizational Unit number that raised the initial discrepancy deferral request |
| 2 | DEFHST_MAINT_REPORT_NO | varchar | Maintains the maintenance report number associated with the discrepancy deferral record |
| 3 | DEFHST_REV_NO | #N/A | Maintains the revision number of the discrepancy deferral record |
| 4 | DEFHST_DEF_REASON | Varchar | Maintains the reason provided for initiating the discrepancy deferral |
| 5 | DEFHST_DEF_AUTH | varchar | Maintains the employee approving the discrepancy deferral |
| 6 | DEFHST_DEF_OU | #N/A | Maintains the Organizational Unit in which the discrepancy deferral was performed |
| 7 | DEFHST_DEF_DATE | datetime | Maintains the date on which the discrepancy deferral was performed |
| 8 | DEFHST_DEF_COMMENTS | varchar | Maintains any comments recorded during the discrepancy deferral |
| 9 | DEFHST_DEF_BY | varchar | Maintains the employee user ID who performed or authorized the discrepancy deferral |
| 10 | DEFHST_DEF_ITEM_TYPE | varchar | Maintains the deferral item type associated with the recorded discrepancy deferral such as Minimum Equipment List or Configuration Deviation List |
| 11 | DEFHST_DEF_LIMIT_TYPE | varchar | Maintains the type of limit applicable to the discrepancy deferral such as time based or cycle based |
| 12 | DEFHST_DEF_LIMIT_BASIS | varchar | Maintains the basis on which the deferral limit is defined such as flight hours calendar days or flights |
| 13 | DEFHST_DEF_ITEM_NO | varchar | Maintains the Minimum Equipment List number or Configuration Deviation List number assigned to the discrepancy deferral |
| 14 | DEFHST_LIMIT_CONTROL | varchar | Maintains the control used to monitor and enforce the deferral limits |
| 15 | DEFHST_AUTH_DATETIME | varchar | Maintains the date and time when the discrepancy deferral was authorized |
| 16 | DEFHST_MAINT_EVENT | varchar | Maintains the maintenance event code related to the discrepancy deferral |
| 17 | DEFHST_TIME_DUE | numeric | Maintains the due time by which deferred discrepancies must be resolved |
| 18 | DEFHST_TIME_UOM | varchar | Maintains the unit of measure such as hours or days for the deferral due time |
| 19 | DEFHST_DEF_TASK | varchar | Maintains the task number associated with the discrepancy |
| 20 | DEFHST_HOLD_ITEM_NO | varchar | Maintains the holding item number if applicable related to the deferral or MEL entry |
| 21 | DPDEF_NSD_Ref_Date | datetime | Maintains the reference date associated with the deferral |
| 22 | DEFHST_NSD | datetime | Maintains an indicator showing whether the deferral falls under non scheduled deferral criteria |
| 23 | DEFHST_Paramcode | varchar | Maintains the parameter code linked to the discrepancy deferral |
| 24 | DEFHST_MRDP_No | varchar | Maintains the maintenance report number associated with the deferral |
| 25 | DEFHST_DUR_TILL_DATE | Datetime | Maintains the date until which the deferral remains valid before it becomes overdue |
| 26 | DPDEF_NSD_Ref_Date | datetime | Maintains the hold item number related to the deferral or MEL entry |
Relationships (1)
- DeferralRecord (DP_DPDEF_DISC_DEFERRAL_DTL) →
HAS_DEFERRAL_HISTORY(this table is target)- Join:
DP_DPDEF_DISC_DEFERRAL_DTL.DPDEF_MAINT_REPORT_NO = DP_DEFHST_DISC_DEFERRAL_HST.DEFHST_MAINT_REPORT_NO - Deferral has history records
- Join:
Sample rows (from live DB)
DEFHST_SLFSRC_OUINSTANCE | DEFHST_MAINT_REPORT_NO | DEFHST_REV_NO | DEFHST_DEF_REASON | DEFHST_DEF_AUTH | DEFHST_DEF_OU |
|---|---|---|---|---|---|
| 2.0 | MREP-000094-2019 | 0.0 | DEFERRAL REASON | 1234 | 2.0 |
| 2.0 | MREP-000094-2019 | 0.0 | DEFERRAL REASON | 1234 | 2.0 |
| 2.0 | MREP-000094-2019 | 0.0 | DEFERRAL REASON | 1234 | 2.0 |
Showing 3 of 2,196 rows.