Discrepancy
This category groups 7 relationships in the Ramco Aviation domain.
Edges
HAS_DEFERRAL — Discrepancy → DeferralRecord
Discrepancy has deferral record
- Source table: DP_DISCP_DISCREPANCY_DTL
- Target table: DP_DPDEF_DISC_DEFERRAL_DTL
- SQL join:
DP_DISCP_DISCREPANCY_DTL.DISCP_MAINT_REPORT_NO = DP_DPDEF_DISC_DEFERRAL_DTL.DPDEF_MAINT_REPORT_NO - Inference:
manual_override
HAS_RESOLUTION_HISTORY — Discrepancy → ResolutionHistory
Discrepancy has resolution history
- Source table: DP_DISCP_DISCREPANCY_DTL
- Target table: DP_RESLHST_DISC_RESOL_HIST
- SQL join:
DP_DISCP_DISCREPANCY_DTL.DISCP_DOC_NO = DP_RESLHST_DISC_RESOL_HIST.RESLHST_DOC_NO - Inference:
parent_pk_in_child
HAS_WORKUNIT_HISTORY — Discrepancy → WorkUnitHistory
Discrepancy has work unit history
- Source table: DP_DISCP_DISCREPANCY_DTL
- Target table: DP_WUHST_RESL_WORKUNIT_HST
- SQL join:
DP_DISCP_DISCREPANCY_DTL.DISCP_DOC_NO = DP_WUHST_RESL_WORKUNIT_HST.WUHST_DOC_NO - Inference:
parent_pk_in_child
HAS_USAGE_PARAM — DeferralRecord → UsageDefParam
Deferral has usage parameters
- Source table: DP_DPDEF_DISC_DEFERRAL_DTL
- Target table: DP_MRUSG_USAGE_DEF_PARAM_VAL
- SQL join:
DP_DPDEF_DISC_DEFERRAL_DTL.DPDEF_MAINT_REPORT_NO = DP_MRUSG_USAGE_DEF_PARAM_VAL.MRUSG_MAINT_REPORT_NO - Inference:
parent_pk_in_child
HAS_PARAM_SCHEDULE — DeferralRecord → ParamSchedule
Deferral has parameter schedule
- Source table: DP_DPDEF_DISC_DEFERRAL_DTL
- Target table: DP_PRMSCH_PARAM_SCHEDULE_DTL
- SQL join:
DP_DPDEF_DISC_DEFERRAL_DTL.DPDEF_MAINT_REPORT_NO = DP_PRMSCH_PARAM_SCHEDULE_DTL.PRMSCH_MAINT_REPORT_NO - Inference:
parent_pk_in_child
HAS_DEFERRAL_HISTORY — DeferralRecord → DeferralHistory
Deferral has history records
- Source table: DP_DPDEF_DISC_DEFERRAL_DTL
- Target table: DP_DEFHST_DISC_DEFERRAL_HST
- SQL join:
DP_DPDEF_DISC_DEFERRAL_DTL.DPDEF_MAINT_REPORT_NO = DP_DEFHST_DISC_DEFERRAL_HST.DEFHST_MAINT_REPORT_NO - Inference:
parent_pk_in_child
HAS_CATEGORY — Discrepancy → DiscCategory (no automatic join)
Discrepancy has category classification
- Source table: DP_DISCP_DISCREPANCY_DTL
- Target table: Dp_DisCat_category_Dtl