Table: SET_ANCILLARY_SUMMARY

SET_ANCILLARY_SUMMARY

Name

SET_ANCILLARY_SUMMARY

Comment

SET_ANCILLARY_SUMMARY summarises payments for all Ancillary Services to participants on the basis of regions and trading intervals.


Description

SET_ANCILLARY_SUMMARY data is available to all participants.

Volume

Approximately 30, 000 per week.


Primary Key Columns

Name

PAYMENTTYPE

PERIODID

REGIONID

SERVICE

SETTLEMENTDATE

VERSIONNO


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

SETTLEMENTDATE

DATE

X

Settlement Date

VERSIONNO

NUMBER(3,0)

X

Settlement Run No

SERVICE

VARCHAR2(20)

X

Ancillary service identifier (e.g. REACTIVE_POWER)

PAYMENTTYPE

VARCHAR2(20)

X

Payment type identifier (e.g. COMPENSATION)

REGIONID

VARCHAR2(10)

X

Region Identifier

PERIODID

NUMBER(3,0)

X

Trading interval

PAYMENTAMOUNT

NUMBER(18,8)

 

The NEM ancillary summary regional payment amount ($)

LASTCHANGED

DATE

 

Last date and time record changed