DP_RESLHST_DISC_RESOL_HIST
Maintains historical records of all discrepancy resolution history 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 ResolutionHistory entity.
Primary key
RESLHST_DOC_NO, RESLHST_DOC_TYPE, RESLHST_LINE_NO, RESLHST_SLFSRC_OUINSTANCE
Columns (20)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | RESLHST_SLFSRC_OUINSTANCE 🔑 | #N/A | Maintains the Organizational Unit number that recorded the discrepancy resolution |
| 2 | RESLHST_DOC_TYPE 🔑 | varchar | Maintains the document type under which the resolution action was performed |
| 3 | RESLHST_DOC_NO 🔑 | varchar | Maintains the document number associated with the discrepancy resolution |
| 4 | RESLHST_LINE_NO 🔑 | #N/A | Maintains the line number reference for the discrepancy resolution entry |
| 5 | RESLHST_ACTION | varchar | Maintains the action performed to resolve the discrepancy |
| 6 | RESLHST_PERF_DATE | datetime | Maintains the date on which the discrepancy resolution was performed |
| 7 | RESLHST_PERF_STATION | varchar | Maintains the station where the discrepancy was resolved |
| 8 | RESLHST_REMEDIAL_ACTION | varchar | Maintains the description of the remedial action taken to resolve the discrepancy |
| 9 | RESLHST_REMARKS | varchar | Maintains any additional remarks associated with the discrepancy resolution |
| 10 | RESLHST_REF_DOC_TYPE | varchar | Maintains the document type that was referenced during the resolution of the discrepancy |
| 11 | RESLHST_REF_DOC_OU | #N/A | Maintains the Organizational Unit that issued the reference document |
| 12 | RESLHST_REF_DOC_NO | varchar | Maintains the number of the document referenced during discrepancy resolution |
| 13 | RESLHST_WU_COUNT | #N/A | Maintains the count of work units involved in resolving the discrepancy |
| 14 | RESLHST_RECTIFIED_BY | varchar | Maintains the ID of the employee who performed the rectification |
| 15 | RESLHST_INSPECTED_BY | varchar | Maintains the ID of the person who inspected the resolved discrepancy |
| 16 | RESLHST_RIIREPORT_BY | varchar | Maintains the ID of the inspector who completed the Required Inspection Item verification |
| 17 | RESLHST_ADDNREPORT_BY | varchar | Maintains the ID of the additional reported by person during resolution entry |
| 18 | RESLHST_MRDP_No | varchar | Maintains the linked maintenance report deferred processing number |
| 19 | RESLHST_MODIFIED_BY | varchar | Maintains the user who last modified the resolution record |
| 20 | RESLHST_MODIFIED_DATE | datetime | Maintains the date and time the resolution record was last modified |
Relationships (1)
- Discrepancy (DP_DISCP_DISCREPANCY_DTL) →
HAS_RESOLUTION_HISTORY(this table is target)- Join:
DP_DISCP_DISCREPANCY_DTL.DISCP_DOC_NO = DP_RESLHST_DISC_RESOL_HIST.RESLHST_DOC_NO - Discrepancy has resolution history
- Join:
Sample rows (from live DB)
RESLHST_SLFSRC_OUINSTANCE | RESLHST_DOC_TYPE | RESLHST_DOC_NO | RESLHST_LINE_NO | RESLHST_ACTION | RESLHST_PERF_DATE |
|---|---|---|---|---|---|
| 2 | DP | % | 1.0 | B | 2019-03-17 18:01:50.000 |
| 2 | DP | % | 2.0 | B | 2019-05-21 10:10:25.000 |
| 2 | DP | % | 3.0 | B | 2019-08-22 17:18:28.207 |
Showing 3 of 20,591 rows.