Table: DISPATCH_MR_SCHEDULE_TRK

DISPATCH_MR_SCHEDULE_TRK

Name

DISPATCH_MR_SCHEDULE_TRK

Comment

DISPATCH_MR_SCHEDULE_TRK records the Mandatory Restrictions Acceptance Schedule applied to this dispatch interval for this region.
DISPATCH_MR_SCHEDULE_TRK is populated by the Dispatch process and records the MR Offer Stack applied in each dispatch interval. DISPATCH_MR_SCHEDULE_TRK is used by Settlements to calculate payments according to the correct MR offer stack.


Description

DISPATCH_MR_SCHEDULE_TRK data is public to all participants.

Source

DISPATCH_MR_SCHEDULE_TRK updates are ad hoc.

Volume

2 rows per year.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Public


Primary Key Columns

Name

REGIONID

SETTLEMENTDATE


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

SETTLEMENTDATE

DATE

X

Date Time of the Dispatch Interval

REGIONID

VARCHAR2(10)

X

Unique RegionID; Key reference to MR_Event_Schedule

MR_DATE

DATE

 

Mandatory Restriction date; Key reference to MR_Event_Schedule table

VERSION_DATETIME

DATE

 

Date Time the MR acceptance stack was created; Key reference to MR_Event_Schedule table

LASTCHANGED

DATE

 

Date and time the record was last inserted/modified