ResolutionHistory

Every action taken against a discrepancy over its lifetime — diagnosis, repair, sign-off, deferral, revision.

Canonical table: DP_RESLHST_DISC_RESOL_HIST · Key column: RESLHST_DOC_NO

Example record

• RESLHST_SLFSRC_OUINSTANCE: 2
• RESLHST_DOC_TYPE: DP
• RESLHST_DOC_NO: %
• RESLHST_LINE_NO: 1.0
• RESLHST_ACTION: B
• RESLHST_PERF_DATE: 2019-03-17 18:01:50.000
• RESLHST_PERF_STATION: YEG
• RESLHST_REMEDIAL_ACTION: —

Incoming relationships (1)

• Discrepancy → HAS_RESOLUTION_HISTORY
  • via DP_DISCP_DISCREPANCY_DTL.DISCP_DOC_NO = DP_RESLHST_DISC_RESOL_HIST.RESLHST_DOC_NO

See also

• DP_RESLHST_DISC_RESOL_HIST
• Discrepancy