DP_DISCP_DISCREPANCY_DTL

Maintains comprehensive records of discrepancies identified during aircraft maintenance. Includes discrepancy descriptions, severity levels, timestamps, and associated task references for investigation and resolution.

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

Primary key

DISCP_DOC_NO, DISCP_DOC_TYPE, DISCP_SLFSRC_OUINSTANCE

Columns (127)

#	Column	Type	Description
1	`DISCP_SLFSRC_OUINSTANCE` 🔑	#N/A	Maintains the Organizational Unit number that reported the discrepancy
2	`DISCP_DOC_TYPE` 🔑	varchar	Maintains the document type of the discrepancy recorded such as Aircraft Maintenance Execution or Shop
3	`DISCP_DOC_NO` 🔑	varchar	Maintains the document number in which the discrepancy is reported
4	`DISCP_CRT_OUINSTANCE`	#N/A	Maintains the Organizational Unit in which the discrepancy was created
5	`DISCP_MAINT_REPORT_OU`	#N/A	Maintains the Organizational Unit in which the maintenance report for the discrepancy is created
6	`DISCP_MAINT_REPORT_NO`	varchar	Maintains the maintenance report number associated with the discrepancy
7	`DISCP_DISCREPANCY_DESC`	varchar	Maintains a detailed textual description of the discrepancy reported
8	`DISCP_TYPE`	varchar	Maintains the type classification of the discrepancy such as mechanic reported or pilot reported
9	`DISCP_CATEGORY`	Varchar	Maintains the category of the discrepancy
10	`DISCP_APPLICABILITY`	varchar	Maintains the applicability of the discrepancy determining whether it is reported on an aircraft or a component
11	`DISCP_ACORCOMP_OU`	#N/A	Maintains the Organizational Unit for the affected aircraft or component
12	`DISCP_AIRCRAFT_NO`	varchar	Maintains the aircraft registration number where the discrepancy was found
13	`DISCP_COMPONENT_ID`	varchar	Maintains the component number where the discrepancy was found
14	`DISCP_RECORD_STATUS`	varchar	Maintains the current status of the discrepancy record such as open or closed
15	`DISCP_PROCESS_STATUS`	varchar	Maintains the process status for the discrepancy
16	`DISCP_TRACKING_STATUS`	Varchar	Maintains the tracking status of the discrepancy
17	`DISCP_MR_CLASS`	Varchar	Maintains the classification type defined for the maintenance report
18	`DISCP_ATA_OU`	#N/A	Maintains the Organizational Unit number which is associated to the ATA information of the reported discrepancy
19	`DISCP_ATA_NO`	varchar	Maintains the ATA chapter number on which the discrepancy is reported
20	`DISCP_FAULT_OU`	#N/A	Maintains the Organizational Unit associated with the fault information
21	`DISCP_FAULT_NO`	varchar	Maintains the fault number associated with the discrepancy
22	`DISCP_CAUSE_OU`	#N/A	Maintains the Organizational Unit associated with the cause code
23	`DISCP_CAUSE_CODE`	varchar	Maintains the cause code associated with the discrepancy based on the fault code mapping
24	`DISCP_EXECDOC_REF_NO`	varchar	Maintains the reference number of the execution document linked to the discrepancy
25	`DISCP_SRC_DOC_TYPE`	varchar	Maintains the type of the source document
26	`DISCP_SRC_DOC_OU`	#N/A	Maintains the Organizational Unit information in which the source document is available
27	`DISCP_SRC_DOC_NO`	varchar	Maintains the source document number
28	`DISCP_FILE_NAME`	varchar	Maintains the name of the file or attachment linked with the discrepancy record
29	`DISCP_REPORTED_BY`	varchar	Maintains the employee user ID who reported the discrepancy
30	`DISCP_REPORTING_STATION`	varchar	Maintains the name of the station where the discrepancy was reported
31	`DISCP_CAUSED_DELAY`	varchar	Maintains a flag indicating if the discrepancy caused a flight delay
32	`DISCP_TRNS_DOC_TYPE`	varchar	Maintains the document type for which the discrepancy is being transferred
33	`DISCP_TRNS_DOC_OU`	#N/A	Maintains the Organizational Unit of the document to which the discrepancy is being transferred
34	`DISCP_TRNS_DOC_NO`	varchar	Maintains the document number to which the discrepancy is being transferred
35	`DISCP_TRNTO_COMPONENT_ID`	varchar	Maintains the component number where the discrepancy is identified which will be transferred to a separate document for execution
36	`DISCP_TRNTO_PART_OU`	#N/A	Maintains the Organizational Unit managing the transferred part
37	`DISCP_TRNTO_PART_NO`	varchar	Maintains the part number where the discrepancy is identified which will be transferred to a separate document for execution
38	`DISCP_TRNTO_PART_SRLNO`	varchar	Maintains the serial number where the discrepancy is identified which will be transferred to a separate document for execution
39	`DISCP_REMARKS`	varchar	Maintains remarks recorded as part of discrepancy documentation
40	`DISCP_RECTIFIED_BY`	varchar	Maintains the user ID of the employee who rectified the discrepancy
41	`DISCP_RECTIFIED_DATE`	datetime	Maintains the date when the discrepancy was rectified
42	`DISCP_INSPECTED_BY`	varchar	Maintains the employee ID who performed the inspection after rectification
43	`DISCP_INSPECTED_DATE`	datetime	Maintains the date when the discrepancy was inspected after being rectified
44	`DISCP_EAN_OU`	#N/A	Maintains the Organizational Unit responsible in which Engineering Advice Note is generated for a discrepancy
45	`DISCP_EAN_NO`	varchar	Maintains the Engineering Advice Note created for the discrepancy
46	`DISCP_EAN_REV_NO`	#N/A	Maintains the revision number of the associated Engineering Advice Note document
47	`DISCP_REF_DOC_TYPE`	varchar	Maintains the reference document type linked to the discrepancy
48	`DISCP_REF_DOC_OU`	#N/A	Maintains the Organizational Unit number in which the reference document is created
49	`DISCP_REF_DOC_NO`	varchar	Maintains the reference document number related to the discrepancy
50	`DISCP_RESOLVED_STATION`	varchar	Maintains the station where the discrepancy was resolved and closed
51	`DISCP_RESOLVED_DATETIME`	datetime	Maintains the date and time when the discrepancy was resolved
52	`DISCP_REMEDIAL_ACTION`	varchar	Maintains details of the remedial action taken to address the discrepancy
53	`DISCP_ACTION_FLAG`	varchar	Maintains information on the latest action performed on the discrepancy
54	`DISCP_DEFMR_REV_NO`	#N/A	Maintains the revision number of the deferral maintenance report linked to the discrepancy
55	`DISCP_SCH_TYPE`	varchar	Maintains the type of schedule associated with the discrepancy action
56	`DISCP_SCH_ON_TRANSFER_FLAG`	varchar	Maintains the flag indicating if re scheduling is required on component transfer
57	`DISCP_SCH_TIME_UOM`	varchar	Maintains the unit of measurement such as hours or days for scheduled discrepancy actions
58	`DISCP_SCH_FIXED_INTERVAL`	decimal	Maintains the fixed interval defined for the scheduled action
59	`DISCP_SCH_FLOATING_INTERVAL`	decimal	Maintains the floating interval for the scheduled task related to the discrepancy
60	`DISCP_SCH_TERMINATING_TIME`	decimal	Maintains the terminating time after which the scheduled action becomes invalid
61	`DISCP_SCH_ALERT_TIME`	decimal	Maintains the alert time to notify about upcoming scheduled discrepancy actions
62	`DISCP_SCH_POSITIVE_TOLERANCE`	decimal	Maintains the allowable positive tolerance for scheduled task execution
63	`DISCP_SCH_NEGATIVE_TOLERANCE`	decimal	Maintains the allowable negative tolerance for scheduled task execution
64	`DISCP_WU_FLAG`	varchar	Maintains the work unit flag for the discrepancy such as DP TSK or NST
65	`DISCP_ANALYSED_OU`	#N/A	Maintains the Organizational Unit in which discrepancy analysis is performed
66	`DISCP_ANALYSED_DATE`	datetime	Maintains the date on which the analysis of the discrepancy was completed
67	`DISCP_PRIORITY_NO`	#N/A	Maintains the priority number assigned to the discrepancy for maintenance planning
68	`DISCP_SRC_GRP_REF`	#N/A	Maintains the reference ID of the source group from which the discrepancy originated
69	`DISCP_DEF_OU`	#N/A	Maintains the Organizational Unit responsible for the discrepancy deferral
70	`DISCP_CREATED_BY`	varchar	Maintains the employee ID who created the discrepancy record
71	`DISCP_CREATED_DATETIME`	datetime	Maintains the date and time on which the discrepancy record was created
72	`DISCP_MODIFIED_BY`	varchar	Maintains the user ID who last modified the discrepancy record
73	`DISCP_MODIFIED_DATETIME`	datetime	Maintains the date and time of the last modification to the discrepancy record
74	`DISCP_TIMESTAMP`	#N/A	Maintains the system timestamp
75	`DISCP_WF_DOC_KEY`	#N/A	Maintains the workflow document key used for tracking change approval or routing
76	`DISCP_WF_NEW_STATE`	varchar	Maintains the updated workflow state of the discrepancy document
77	`DISCP_WORKCENTER`	varchar	Maintains the work center assigned for resolving the discrepancy
78	`DISCP_PROC_FLAG`	varchar	Maintains the processing flag of the discrepancy
79	`DISCP_IMPOPT_FLAG`	varchar	Maintains the flag indicating if the discrepancy requires immediate operational attention
80	`DISCP_LOG_LEAF_NO`	varchar	Maintains the log item number associated with the discrepancy
81	`Discp_plan_start_date`	datetime	Maintains the planned start date for resolving the discrepancy
82	`Discp_plan_end_date`	datetime	Maintains the planned end date by which the discrepancy should be resolved
83	`Discp_plang_Comments`	varchar	Maintains planning comments related to the discrepancy resolution
84	`DISCP_ESTMANHRS`	numeric	Maintains the estimated man hours required to resolve the discrepancy
85	`DISCP_PRT_REQ`	varchar	Maintains part requirement details necessary for resolving the discrepancy
86	`DISCP_MAJ_ITEM`	varchar	Maintains the major item number affected by the discrepancy
87	`DISCP_CORR_REL`	varchar	Maintains the corresponding relation to other corrective actions
88	`DISCP_ADAPR_REQ`	varchar	Maintains the flag indicating whether an Airworthiness Directive or Approved Repair is required for the discrepancy
89	`DISP_REPEAT`	varchar	Maintains the flag indicating if the discrepancy is a repeat occurrence
90	`DISP_ALLOW_MODIFIED`	varchar	Maintains the flag indicating if modification to discrepancy details is allowed
91	`DISCP_RADIO_COMM`	varchar	Maintains any radio communication remarks related to the discrepancy report
92	`DISCP_DEF_PRIORITY`	varchar	Maintains the default priority classification for the discrepancy
93	`DISP_INSPSRCDOC_TYPE`	varchar	Maintains the type of document used for inspection source of the discrepancy
94	`DISP_INSPSRCDOC_NO`	varchar	Maintains the number of the inspection source document linked to the discrepancy
95	`DISCP_APPROVED_DATE`	datetime	Maintains the date on which the discrepancy was approved for deferral
96	`DISCP_APPR_REV_REMARKS`	varchar	Maintains approval remarks recorded during revision approval
97	`DISCP_ESR_OU`	int	Maintains the Organizational Unit that issued the Engineering Service Request document
98	`DISCP_ESR_NO`	varchar	Maintains the Engineering Service Request number linked to the discrepancy
99	`DISCP_Part_No`	varchar	Maintains the part number of the component affected by the discrepancy
100	`DISCP_Part_OU`	varchar	Maintains the Organizational Unit managing the affected part
101	`DISCP_PART_SRLNO`	varchar	Maintains the serial number of the affected part
102	`DISCP_POSITION_CODE`	varchar	Maintains the position code identifying the location of the discrepancy
103	`DISCP_REPDATETIME`	datetime	Maintains the date and time when the discrepancy was reported
104	`DISCP_REPUTC_DATETIME`	datetime	Maintains the discrepancy reported date and time with respect to UTC format
105	`DISCP_MRDP_No`	varchar	Maintains the maintenance report number associated with the discrepancy
106	`DISCP_TSTD_PRIOR_TRDWN`	varchar	Maintains the test details done prior to component teardown inspection
107	`DISCP_PRMY_CAUSE_FAILURE`	varchar	Maintains the primary cause of failure identified in the discrepancy analysis
108	`DISCP_AOG`	varchar	Maintains the flag indicating whether the discrepancy falls under Aircraft on Ground status
109	`DISCP_INCI_NOTES`	varchar	Maintains the incident notes raised during discrepancy investigation
110	`DISCP_INCI_TYPE`	Char	Maintains the type of incident such as safety or technical associated with the discrepancy
111	`DISCP_INCI_REPORTED`	varchar	Maintains a flag indicating how the discrepancy was reported
112	`DISCP_DELAY_NOTES`	varchar	Maintains textual notes related to delays caused by the discrepancy
113	`DISCP_DELAY_REFNO`	Char	Maintains the reference number of the delay record linked to the discrepancy
114	`DISCP_INCI_REFNO`	varchar	Maintains the reference number of the incident related to the discrepancy
115	`DISCP_INV_FINDINGS`	varchar	Maintains the investigation findings documented for the reported discrepancy
116	`DISCP_INV_CONCLUSION`	Char	Maintains the final investigation conclusion recorded for the discrepancy
117	`discp_source_flag`	varchar	Maintains the flag indicating the source of the discrepancy
118	`discp_affecfunction`	varchar	Maintains the function affected by the discrepancy
119	`discp_confirm`	varchar	Maintains a flag indicating whether the discrepancy was confirmed during maintenance
120	`discp_defecttype`	varchar	Maintains the type of defect reported in the discrepancy record
121	`discp_no_of_channels`	int	Maintains the number of affected channels associated with the discrepancy
122	`discp_pax_abuse`	varchar	Maintains a flag indicating whether the discrepancy involves suspected passenger abuse
123	`discp_safety_related`	varchar	Maintains a flag indicating whether the discrepancy is related to safety
124	`discp_act_last`	varchar	Maintains the last action taken on the discrepancy
125	`discp_act_lastprog`	varchar	Maintains the program in which the last action was executed
126	`discp_act_trackid`	Bigint	Maintains the tracking ID used for the last discrepancy action
127	`DISCP_PREV_PNDDEF_STS`	varchar	Maintains the previous pending deferral status before the current discrepancy update

Relationships (6)

HAS_DEFERRAL → DeferralRecord (DP_DPDEF_DISC_DEFERRAL_DTL)
- Join: DP_DISCP_DISCREPANCY_DTL.DISCP_MAINT_REPORT_NO = DP_DPDEF_DISC_DEFERRAL_DTL.DPDEF_MAINT_REPORT_NO
- Discrepancy has deferral record
HAS_RESOLUTION_HISTORY → ResolutionHistory (DP_RESLHST_DISC_RESOL_HIST)
- Join: DP_DISCP_DISCREPANCY_DTL.DISCP_DOC_NO = DP_RESLHST_DISC_RESOL_HIST.RESLHST_DOC_NO
- Discrepancy has resolution history
HAS_WORKUNIT_HISTORY → WorkUnitHistory (DP_WUHST_RESL_WORKUNIT_HST)
- Join: DP_DISCP_DISCREPANCY_DTL.DISCP_DOC_NO = DP_WUHST_RESL_WORKUNIT_HST.WUHST_DOC_NO
- Discrepancy has work unit history
FOR_AIRCRAFT → Aircraft (AC_ACI_AIRCRAFT_INFO)
- Join: DP_DISCP_DISCREPANCY_DTL.DISCP_AIRCRAFT_NO = AC_ACI_AIRCRAFT_INFO.ACI_AIRCRAFT_REG_NO
- Discrepancy reported for aircraft
FOR_COMPONENT → ComponentID (AC_CMPID_COMPONENT_ID_INFO)
- Join: DP_DISCP_DISCREPANCY_DTL.DISCP_COMPONENT_ID = AC_CMPID_COMPONENT_ID_INFO.CMPID_COMPONENT_ID
- Discrepancy reported for component
HAS_CATEGORY → DiscCategory (Dp_DisCat_category_Dtl) (no automatic join)
- Discrepancy has category classification

Sample rows (from live DB)

`DISCP_SLFSRC_OUINSTANCE`	`DISCP_DOC_TYPE`	`DISCP_DOC_NO`	`DISCP_CRT_OUINSTANCE`	`DISCP_MAINT_REPORT_OU`	`DISCP_MAINT_REPORT_NO`
2	DP	0264	2.0	—	—
2	DP	0975	2.0	—	—
2	DP	1/5	2.0	2.0	MREP-000444-2023

Showing 3 of 7,166 rows.

DP_DISCP_DISCREPANCY_DTL

Primary key

Columns (127)

Relationships (6)

Sample rows (from live DB)

See also