DP_PRMSCH_PARAM_SCHEDULE_DTL
Maintains scheduling information for parameters linked to discrepancy management. Supports periodic monitoring and automatic trigger of discrepancy checks or deferrals.
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 ParamSchedule entity.
Primary key
PRMSCH_PARAMETER_CODE, PRMSCH_PARAMETER_OU, PRMSCH_MAINT_REPORT_NO, PRMSCH_SLFSRC_OUINSTANCE
Columns (11)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | PRMSCH_SLFSRC_OUINSTANCE 🔑 | #N/A | Maintains the Organizational Unit number from which the schedule record was generated |
| 2 | PRMSCH_MAINT_REPORT_NO 🔑 | varchar | Maintains the maintenance report number related to the parameter schedule |
| 3 | PRMSCH_PARAMETER_OU 🔑 | #N/A | Maintains the Organizational Unit managing the parameter schedule |
| 4 | PRMSCH_PARAMETER_CODE 🔑 | varchar | Maintains the code identifying the parameter scheduled for monitoring |
| 5 | PRMSCH_CRT_OUINSTANCE | #N/A | Maintains the Organizational Unit in which the parameter schedule was entered |
| 6 | PRMSCH_SCH_FIXED_INTERVAL | decimal | Maintains the fixed time interval set for executing the scheduled parameter action |
| 7 | PRMSCH_SCH_FLOATING_INTERVAL | decimal | Maintains the floating interval duration |
| 8 | PRMSCH_SCH_TERMINATING_TIME | decimal | Maintains the end time after which the parameter schedule is no longer valid |
| 9 | PRMSCH_SCH_ALERT_TIME | decimal | Maintains the alert threshold at which a warning is triggered for upcoming scheduled action |
| 10 | PRMSCH_SCH_POSITIVE_TOLERANCE | decimal | Maintains the upper tolerance range beyond the scheduled time |
| 11 | PRMSCH_SCH_NEGATIVE_TOLERANCE | decimal | Maintains the lower tolerance range allowing early execution before scheduled time |
Relationships (1)
- DeferralRecord (DP_DPDEF_DISC_DEFERRAL_DTL) →
HAS_PARAM_SCHEDULE(this table is target)- Join:
DP_DPDEF_DISC_DEFERRAL_DTL.DPDEF_MAINT_REPORT_NO = DP_PRMSCH_PARAM_SCHEDULE_DTL.PRMSCH_MAINT_REPORT_NO - Deferral has parameter schedule
- Join: