DP_DPDEF_DISC_DEFERRAL_DTL
Maintains discrepancy deferral details.
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 DeferralRecord entity.
Primary key
DPDEF_MAINT_REPORT_NO, DPDEF_SLFSRC_OUINSTANCE
Columns (29)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | DPDEF_SLFSRC_OUINSTANCE 🔑 | #N/A | Denotes the time since inspection |
| 2 | DPDEF_MAINT_REPORT_NO 🔑 | varchar | Denotes the time since overhaul |
| 3 | DPDEF_CRT_OUINSTANCE | #N/A | Denotes the time since repair |
| 4 | DPDEF_DEF_REV_NO | #N/A | Maintains the Organizational Unit where the deferral record was created |
| 5 | DPDEF_DEF_ITEM_TYPE | varchar | Maintains the revision number of the discrepancy deferral record |
| 6 | DPDEF_DEFERRAL_REASON | Varchar | Maintains the deferral item type associated with the discrepancy deferral such as MEL or CDL |
| 7 | DPDEF_DEF_LIMIT_TYPE | varchar | Maintains the reason provided for the discrepancy deferral |
| 8 | DPDEF_DEF_LIMIT_BASIS | varchar | Maintains the type of limit applied to the deferral such as time based or cycle based |
| 9 | DPDEF_DEF_ITEM_NO | varchar | Maintains the basis for the deferral limit such as flight hours days or number of cycles |
| 10 | DPDEF_LIMIT_CONTROL | varchar | Maintains the deferral item number assigned to the discrepancy deferral |
| 11 | DPDEF_DEFERRAL_AUTH | varchar | Maintains the control parameter of the deferral limits |
| 12 | DPDEF_AUTH_DATETIME | datetime | Maintains the employee ID who approved the deferral |
| 13 | DPDEF_MAINT_EVENT | Varchar | Maintains the date and time at which the discrepancy deferral was authorized |
| 14 | DPDEF_COMMENTS | varchar | Maintains the maintenance event code associated with the deferral |
| 15 | DPDEF_TIME_DUE | decimal | Maintains any comments recorded during the discrepancy deferral process |
| 16 | DPDEF_TIME_UOM | varchar | Maintains the due time for completing the action associated with the discrepancy deferral |
| 17 | DPDEF_CREATED_BY | varchar | Maintains the unit of measure such as hours or days for the due time |
| 18 | DPDEF_CREATED_DATETIME | datetime | Maintains the user ID of the employee who created the deferral record |
| 19 | DPDEF_MODIFIED_BY | varchar | Maintains the date and time when the deferral record was created |
| 20 | DPDEF_MODIFIED_DATETIME | datetime | Maintains the user ID of the employee who last modified the deferral record |
| 21 | DPDEF_TIMESTAMP | #N/A | Maintains the date and time of the last modification to the deferral record |
| 22 | DPDEF_DEF_TASK | varchar | Maintains the system timestamp |
| 23 | DPDEF_HOLD_ITEM_NO | varchar | Maintains the task number related to the discrepancy |
| 24 | DPDEF_NSD | datetime | Maintains the reference date linked to the non scheduled deferral |
| 25 | DPDEF_TRIG_PARAM | varchar | Maintains a flag indicating if the deferral falls under non scheduled deferral |
| 26 | DPDEF_Cal_Rem_Days | int | Maintains the parameter that triggers the deferral action |
| 27 | DPDEF_MRDP_No | varchar | Maintains the calculated number of remaining days before the deferral expires |
| 28 | DPDEF_DUR_TILL_DATE | Datetime | Maintains the maintenance report deferred processing number tied to the discrepancy deferral |
| 29 | DPDEF_UTC_CONV_REQD | varchar | Maintains the area code where the deferral record was created |
Relationships (4)
- Discrepancy (DP_DISCP_DISCREPANCY_DTL) →
HAS_DEFERRAL(this table is target)- Join:
DP_DISCP_DISCREPANCY_DTL.DISCP_MAINT_REPORT_NO = DP_DPDEF_DISC_DEFERRAL_DTL.DPDEF_MAINT_REPORT_NO - Discrepancy has deferral record
- Join:
HAS_USAGE_PARAM→ UsageDefParam (DP_MRUSG_USAGE_DEF_PARAM_VAL)- Join:
DP_DPDEF_DISC_DEFERRAL_DTL.DPDEF_MAINT_REPORT_NO = DP_MRUSG_USAGE_DEF_PARAM_VAL.MRUSG_MAINT_REPORT_NO - Deferral has usage parameters
- Join:
HAS_PARAM_SCHEDULE→ ParamSchedule (DP_PRMSCH_PARAM_SCHEDULE_DTL)- Join:
DP_DPDEF_DISC_DEFERRAL_DTL.DPDEF_MAINT_REPORT_NO = DP_PRMSCH_PARAM_SCHEDULE_DTL.PRMSCH_MAINT_REPORT_NO - Deferral has parameter schedule
- Join:
HAS_DEFERRAL_HISTORY→ DeferralHistory (DP_DEFHST_DISC_DEFERRAL_HST)- 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)
DPDEF_SLFSRC_OUINSTANCE | DPDEF_MAINT_REPORT_NO | DPDEF_CRT_OUINSTANCE | DPDEF_DEF_REV_NO | DPDEF_DEF_ITEM_TYPE | DPDEF_DEFERRAL_REASON |
|---|---|---|---|---|---|
| 2 | MREP-000001-2012 | 2.0 | 0.0 | DMI | — |
| 2 | MREP-000002-2012 | 2.0 | 0.0 | DMI | DEFERRAL REASON |
| 2 | MREP-000003-2012 | 2.0 | 0.0 | DMI | DEFERRAL REASON |
Showing 3 of 850 rows.