Table: CONTRACTAGC

CONTRACTAGC

Name

CONTRACTAGC

Comment

CONTRACTAGC shows Automatic Generation Control (AGC) contract details for each dispatchable unit. There is a separate contract for each unit.


Description

CONTRACTAGC data is confidential to the relevant participant.

Source

CONTRACTAGC updates only where there is a contract variation.


Notes

Name

Comment

Value

Visibility

 

Private


Primary Key Columns

Name

CONTRACTID

VERSIONNO


Index Columns

Name

LASTCHANGED


Index Columns

Name

PARTICIPANTID

CONTRACTID


Content

Name

Data Type

Mandatory

Comment

CONTRACTID

VARCHAR2(10)

X

Contract Identifier

VERSIONNO

NUMBER(3,0)

X

Contract Version No

STARTDATE

DATE

 

Starting Date of Contract

ENDDATE

DATE

 

End date of contract

PARTICIPANTID

VARCHAR2(10)

 

Unique participant identifier

DUID

VARCHAR2(10)

 

Dispatchable Unit ID

CRR

NUMBER(4,0)

 

Control Range Raise 5 Min MW

CRL

NUMBER(4,0)

 

Control Range Lower 5 Min MW

RLPRICE

NUMBER(10,2)

 

Enabling Price in $

CCPRICE

NUMBER(10,2)

 

Compensation Cap in $

BS

NUMBER(10,2)

 

Block Size

AUTHORISEDBY

VARCHAR2(15)

 

User Name

AUTHORISEDDATE

DATE

 

Date Contract was Authorised

LASTCHANGED

DATE

 

Last date and time record changed


Table: CONTRACTLOADSHED

CONTRACTLOADSHED

Name

CONTRACTLOADSHED

Comment

CONTRACTLOADSHED shows Governor contract details used in the settlement and dispatch of this service. Note: services are dispatched as 6 and 60 raise Frequency Control Ancillary Services (FCAS). Mandatory requirements and breakpoint details are not used for load shed.


Description

CONTRACTLOADSHED data is confidential to the relevant participant.

Source

CONTRACTLOADSHED updates only where there is a contract variation.


Notes

Name

Comment

Value

Visibility

 

Private


Primary Key Columns

Name

CONTRACTID

VERSIONNO


Index Columns

Name

LASTCHANGED


Index Columns

Name

PARTICIPANTID


Content

Name

Data Type

Mandatory

Comment

CONTRACTID

VARCHAR2(10)

X

Contract Identifier

VERSIONNO

NUMBER(3,0)

X

Contract Version No.

STARTDATE

DATE

 

Starting Date of Contract

ENDDATE

DATE

 

Termination Date of Contract

PARTICIPANTID

VARCHAR2(10)

 

Unique participant identifier

DUID

VARCHAR2(10)

 

Dispatchable Unit ID

LSEPRICE

NUMBER(6,2)

 

The load shed enabling price for this contract

MCPPRICE

NUMBER(12,2)

 

Minimum Compensation price

TENDEREDPRICE

NUMBER(6,2)

 

Price Tendered for Compensation per Trading interval - Not used since 13/12/1998

LSCR

NUMBER(6,2)

 

Load Shed Control Range

ILSCALINGFACTOR

NUMBER(15,5)

 

SPD scaling factor for load shed vs dispatched, (1 = dispatched)

LOWER60SECBREAKPOINT

NUMBER(9,6)

 

Not used

LOWER60SECMAX

NUMBER(9,6)

 

Not used

LOWER6SECBREAKPOINT

NUMBER(9,6)

 

Not used

LOWER6SECMAX

NUMBER(9,6)

 

Not used

RAISE60SECBREAKPOINT

NUMBER(9,6)

 

Not used

RAISE60SECCAPACITY

NUMBER(9,6)

 

Not used

RAISE60SECMAX

NUMBER(9,6)

 

Maximum 60 second raise

RAISE6SECBREAKPOINT

NUMBER(9,6)

 

Not used

RAISE6SECCAPACITY

NUMBER(9,6)

 

Not used

RAISE6SECMAX

NUMBER(9,6)

 

Limit Equation Raise 6 Second Maximum MW

PRICE6SECRAISEMANDATORY

NUMBER(16,6)

 

Not used

QUANT6SECRAISEMANDATORY

NUMBER(9,6)

 

Not used

PRICE6SECRAISECONTRACT

NUMBER(16,6)

 

Contract Price for 6 Second Raise

QUANT6SECRAISECONTRACT

NUMBER(9,6)

 

Contract Quantity for 6 Second Raise

PRICE60SECRAISEMANDATORY

NUMBER(16,6)

 

Not used

QUANT60SECRAISEMANDATORY

NUMBER(9,6)

 

Not used

PRICE60SECRAISECONTRACT

NUMBER(16,6)

 

Not used

QUANT60SECRAISECONTRACT

NUMBER(9,6)

 

Not used

PRICE6SECLOWERMANDATORY

NUMBER(16,6)

 

Not used

QUANT6SECLOWERMANDATORY

NUMBER(9,6)

 

Not used

PRICE6SECLOWERCONTRACT

NUMBER(16,6)

 

Not used

QUANT6SECLOWERCONTRACT

NUMBER(9,6)

 

Not used

PRICE60SECLOWERMANDATORY

NUMBER(16,6)

 

Not used

QUANT60SECLOWERMANDATORY

NUMBER(9,6)

 

Not used

PRICE60SECLOWERCONTRACT

NUMBER(16,6)

 

Not used

QUANT60SECLOWERCONTRACT

NUMBER(9,6)

 

Not used

AUTHORISEDBY

VARCHAR2(15)

 

User Name

AUTHORISEDDATE

DATE

 

Date Contract was Authorised

LASTCHANGED

DATE

 

Last date and time record changed

DEFAULT_TESTINGPAYMENT_AMOUNT

NUMBER(18,8)

 

The NMAS default payment amount

SERVICE_START_DATE

DATE

 

The NMAS Testing Service Start Date


Table: CONTRACTREACTIVEPOWER

CONTRACTREACTIVEPOWER

Name

CONTRACTREACTIVEPOWER

Comment

CONTRACTREACTIVEPOWER shows Reactive Power contract details used in the settlement and dispatch of this service.


Description

CONTRACTREACTIVEPOWER data is confidential to the relevant participant.

Source

CONTRACTREACTIVEPOWER updates only where there is a contract variation.


Notes

Name

Comment

Value

Visibility

 

Private


Primary Key Columns

Name

CONTRACTID

VERSIONNO


Index Columns

Name

PARTICIPANTID


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

CONTRACTID

VARCHAR2(10)

X

Contract Identifier

VERSIONNO

NUMBER(3,0)

X

Contract Version No.

STARTDATE

DATE

 

Starting Date of Contract

ENDDATE

DATE

 

Termination Date of Contract

PARTICIPANTID

VARCHAR2(10)

 

Unique participant identifier

DUID

VARCHAR2(10)

 

Dispatchable Unit ID

SYNCCOMPENSATION

VARCHAR2(1)

 

Sync Compensation Flag - Y for SYNCCOMP

MVARAPRICE

NUMBER(10,2)

 

Availability price per MVAr of RP absorption capability

MVAREPRICE

NUMBER(10,2)

 

Enabling price

MVARGPRICE

NUMBER(10,2)

 

Availability price per MVAr of RP generation capability

CCPRICE

NUMBER(10,2)

 

Compensation Cap

MTA

NUMBER(10,2)

 

Reactive Power Absorption Capability (MVAr)

MTG

NUMBER(10,2)

 

Reactive Power Generation Capability (MVAr)

MMCA

NUMBER(10,2)

 

Minimum Capability for MVAr Absorption required by Code

MMCG

NUMBER(10,2)

 

Minimum Capability for MVAr Generation required by Code

EU

NUMBER(10,2)

 

Estimated Power consumption of unit when operating on SYNCCOMP

PP

NUMBER(10,2)

 

Estimated Price for supply

BS

NUMBER(10,2)

 

Block Size of Unit

AUTHORISEDBY

VARCHAR2(15)

 

User Name

AUTHORISEDDATE

DATE

 

Date Contract was Authorised

LASTCHANGED

DATE

 

Last date and time record changed

DEFAULT_TESTINGPAYMENT_AMOUNT

NUMBER(18,8)

 

The NMAS default payment amount

SERVICE_START_DATE

DATE

 

The NMAS Testing Service Start Date

AVAILABILITY_MWH_THRESHOLD

NUMBER(18,8)

 

The MWh the unit must produce in a trading interval to be eligible for an excess-to-gen availability payment

MVAR_THRESHOLD

NUMBER(18,8)

 

The threshold value for MegaVar (MVAr) to check whether the service is fully available.

REBATE_CAP

NUMBER(18,8)

 

The maximum capped amount for the rebate payment.

REBATE_AMOUNT_PER_MVAR

NUMBER(18,8)

 

The per MVAR rebate amount used to calculate the rebate payment.

ISREBATEAPPLICABLE

NUMBER(1,0)

 

Used to check whether the contract is eligible for rebate. For new NSCAS contracts to apply new payment methodology this flag is 1.


Table: CONTRACTRESTARTSERVICES

CONTRACTRESTARTSERVICES

Name

CONTRACTRESTARTSERVICES

Comment

CONTRACTRESTARTSERVICES shows Restart Services contract details used in the settlement and dispatch of this service.


Description

CONTRACTRESTARTSERVICES data is confidential to the participant holding the contract.

Source

CONTRACTRESTARTSERVICES updates only where there is a contract variation.


Notes

Name

Comment

Value

Visibility

 

Private


Primary Key Columns

Name

CONTRACTID

VERSIONNO


Index Columns

Name

PARTICIPANTID


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

CONTRACTID

VARCHAR2(10)

X

Contract Identifier

VERSIONNO

NUMBER(3,0)

X

Contract Version No.

STARTDATE

DATE

 

Starting Date of Contract

ENDDATE

DATE

 

Termination Date of Contract

PARTICIPANTID

VARCHAR2(10)

 

Unique participant identifier

RESTARTTYPE

NUMBER(1,0)

 

Restart Type - 0 = BlackStart, 1 = Combination, 2 = Trip To House

RCPRICE

NUMBER(6,2)

 

Availability Price

TRIPTOHOUSELEVEL

NUMBER(5,0)

 

Trip To House Level

AUTHORISEDBY

VARCHAR2(15)

 

User Name

AUTHORISEDDATE

DATE

 

Date Contract was Authorised

LASTCHANGED

DATE

 

Last date and time record changed

DEFAULT_TESTINGPAYMENT_AMOUNT

NUMBER(18,8)

 

The NMAS default payment amount

SERVICE_START_DATE

DATE

 

The NMAS Testing Service Start Date


Table: CONTRACTRESTARTUNITS

CONTRACTRESTARTUNITS

Name

CONTRACTRESTARTUNITS

Comment

CONTRACTRESTARTUNITS shows Restart units provided under a system restart contract. A service can have multiple units.


Description

CONTRACTRESTARTUNITS data is confidential to each participant with a restart contract.

Source

CONTRACTRESTARTUNITS updates only where there is a contract variation.


Notes

Name

Comment

Value

Visibility

 

Private


Primary Key Columns

Name

CONTRACTID

DUID

VERSIONNO


Index Columns

Name

LASTCHANGED


Index Columns

Name

CONTRACTID


Content

Name

Data Type

Mandatory

Comment

CONTRACTID

VARCHAR2(10)

X

Contract Identifier

VERSIONNO

NUMBER(3,0)

X

Version No of contract

DUID

VARCHAR2(10)

X

Dispatchable Unit identifier

LASTCHANGED

DATE

 

Last date and time record changed

AUTHORISEDBY

VARCHAR2(15)

 

 

AUTHORISEDDATE

DATE