Table: SET_MR_PAYMENT

SET_MR_PAYMENT

Name

SET_MR_PAYMENT

Comment

SET_MR_PAYMENT shows trading interval payments on a dispatchable unit basis for accepted MR capacity.


Description

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


Notes

Name

Comment

Value

Visibility

Data in this table is:

Private


Primary Key Columns

Name

DUID

PERIODID

REGIONID

SETTLEMENTDATE

VERSIONNO


Index Columns

Name

LASTCHANGED


Content

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