Table: SETGOVRECOVERY

SETGOVRECOVERY

Name

SETGOVRECOVERY

Comment

SETGOVRECOVERY shows reimbursements for the Governor Ancillary Services to be recovered from participants.


Description

SETGOVRECOVERY became unused when Ancillary Services Review was implemented. For more details, see Change Notice 126.

SETGOVRECOVERY data is confidential to each participant.

Source

SETGOVRECOVERY updates with each settlement run.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Private


Primary Key Columns

Name

PARTICIPANTID

PERIODID

REGIONID

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.

PARTICIPANTID

VARCHAR2(10)

X

Participant to pay recovery

CONTRACTID

VARCHAR2(10)

 

 

PERIODID

NUMBER(3,0)

X

Trading Interval

REGIONID

VARCHAR2(10)

X

Region Identifier

ENABLING6RPAYMENT

NUMBER(15,5)

 

Enabling Payment 6 Second Raise

ENABLING60RPAYMENT

NUMBER(15,5)

 

Enabling Payment 60 Second Raise

ENABLING6LPAYMENT

NUMBER(15,5)

 

Enabling Payment 6 Second Lower

ENABLING60LPAYMENT

NUMBER(15,5)

 

Enabling Payment 60 Second Lower

PARTICIPANTDEMAND

NUMBER(15,5)

 

Participant Demand in Region

REGIONDEMAND

NUMBER(15,5)

 

Total Regional Demand

ENABLING6RRECOVERY

NUMBER(15,5)

 

Enabling Recovery 6 Second Raise

ENABLING60RRECOVERY

NUMBER(15,5)

 

Enabling Recovery 60 Second Raise

ENABLING6LRECOVERY

NUMBER(15,5)

 

Enabling Recovery 6 Second Lower

ENABLING60LRECOVERY

NUMBER(15,5)

 

Enabling Recovery 60 Second Lower

LASTCHANGED

DATE

 

Last date and time record changed

ENABLING6LRECOVERY_GEN

NUMBER(15,5)

 

Enabling Recovery 6 Second Lower for Generator

ENABLING6RRECOVERY_GEN

NUMBER(15,5)

 

Enabling Recovery 6 Second Raise for Generator

ENABLING60LRECOVERY_GEN

NUMBER(15,5)

 

Enabling Recovery 60 Second Lower for Generator

ENABLING60RRECOVERY_GEN

NUMBER(15,5)

 

Enabling Recovery 60 Second Raise for Generator

PARTICIPANTDEMAND_GEN

NUMBER(15,5)

 

Participant Demand in Region for Generator

REGIONDEMAND_GEN

NUMBER(15,5)

 

Total Regional Demand for Generator