|
Name |
|
|
Comment |
SET_MR_PAYMENT shows trading interval payments on a dispatchable unit basis for accepted MR capacity. |
|
SET_MR_PAYMENT data is confidential to the relevant participant. Source SET_MR_PAYMENT updates are ad hoc, being for MR events only. Volume 24000 rows per year |
|
Name |
|
DUID |
|
PERIODID |
|
REGIONID |
|
SETTLEMENTDATE |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Settlement Date (Calendar) |
|
VERSIONNO |
NUMBER(3,0) |
X |
Settlement Run Number for this date |
|
REGIONID |
VARCHAR2(10) |
X |
Unique Region Identifier |
|
PARTICIPANTID |
VARCHAR2(10) |
|
Unique Participant identifier |
|
DUID |
VARCHAR2(10) |
X |
Unique identifier for DUID / MNSP LinkID |
|
PERIODID |
NUMBER(3,0) |
X |
Calendar day Trading Interval number |
|
MR_CAPACITY |
NUMBER(16,6) |
|
Accepted MR Capacity |
|
UNCAPPED_PAYMENT |
NUMBER(16,6) |
|
Uncapped Trading Interval Payment |
|
CAPPED_PAYMENT |
NUMBER(16,6) |
|
Capped Trading Interval Payment |
|
LASTCHANGED |
DATE |
|
Date/Time record inserted/modified |
|
|
|