DP_MRUSG_USAGE_DEF_PARAM_VAL
Tracks usage-based deferrals applied to discrepancies. Stores associated parameter values, thresholds, and conditions used to determine deferral eligibility.
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 UsageDefParam entity.
Primary key
MRUSG_PARAMETER_CODE, MRUSG_PARAMETER_OU, MRUSG_MAINT_REPORT_NO, MRUSG_SLFSRC_OUINSTANCE
Columns (12)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | MRUSG_SLFSRC_OUINSTANCE 🔑 | #N/A | Maintains the Organizational Unit number under which the usage deferral record was created |
| 2 | MRUSG_MAINT_REPORT_NO 🔑 | varchar | Maintains the maintenance report number associated with the usage based deferral |
| 3 | MRUSG_PARAMETER_OU 🔑 | #N/A | Maintains the Organizational Unit that manages the parameter for the usage deferral |
| 4 | MRUSG_PARAMETER_CODE 🔑 | varchar | Maintains the code of the parameter used for tracking deferral values |
| 5 | MRUSG_CRT_OUINSTANCE | #N/A | Maintains the Organizational Unit where the parameter deferral record was generated |
| 6 | MRUSG_PARAMETER_DEFERRAL_VALUE | decimal | Maintains the actual value of the parameter used in the usage based deferral |
| 7 | MRUSG_THRESHOLD_VALUE | decimal | Maintains the threshold value beyond which the deferral cannot be extended |
| 8 | MRUSG_DEFTILL_DATE | datetime | Maintains the date up to which the usage based deferral is valid |
| 9 | MRUSG_REFERENCE_VALUE | numeric | Maintains the reference value against which usage deferral compliance is measured |
| 10 | MRUSG_REMAINING_VAL | numeric | Maintains the remaining allowable value before the threshold is reached for the deferral |
| 11 | MRUSG_REMAINING_DAYS | numeric | Maintains the remaining allowable days before the threshold is reached for the deferral |
| 12 | MRUSG_MRDP_No | varchar | Maintains the maintenance report deferred processing number linked to the parameter deferral entry |
Relationships (1)
- DeferralRecord (DP_DPDEF_DISC_DEFERRAL_DTL) →
HAS_USAGE_PARAM(this table is target)- Join:
DP_DPDEF_DISC_DEFERRAL_DTL.DPDEF_MAINT_REPORT_NO = DP_MRUSG_USAGE_DEF_PARAM_VAL.MRUSG_MAINT_REPORT_NO - Deferral has usage parameters
- Join:
Sample rows (from live DB)
MRUSG_SLFSRC_OUINSTANCE | MRUSG_MAINT_REPORT_NO | MRUSG_PARAMETER_OU | MRUSG_PARAMETER_CODE | MRUSG_CRT_OUINSTANCE | MRUSG_PARAMETER_DEFERRAL_VALUE |
|---|---|---|---|---|---|
| 2.0 | MREP-000658-2024 | 2.0 | 12.0AB51 | 2.0 | 12.0 |
| 2.0 | MREP-000064-2017 | 2.0 | AB51 | 2.0 | 1.0 |
| 2.0 | MREP-000070-2017 | 2.0 | AB51 | 2.0 | 1.0 |
Showing 3 of 867 rows.