Table: SETRESTARTPAYMENT

SETRESTARTPAYMENT

Name

SETRESTARTPAYMENT

Comment

SETRESTARTPAYMENT shows specific payment details for System Restart services by period.


Description

SETRESTARTPAYMENT data is confidential to the relevant participant.

Source

SETRESTARTPAYMENT updates with each settlement run.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Private


Primary Key Columns

Name

CONTRACTID

PARTICIPANTID

PERIODID

SETTLEMENTDATE

VERSIONNO


Index Columns

Name

LASTCHANGED


Index Columns

Name

PARTICIPANTID


Content

Name

Data Type

Mandatory

Comment

SETTLEMENTDATE

DATE

X

Settlement Date

VERSIONNO

NUMBER(3,0)

X

Settlement Run No.

PARTICIPANTID

VARCHAR2(10)

X

Participant Identifier

CONTRACTID

VARCHAR2(10)

X

Contract Identifier

PERIODID

NUMBER(3,0)

X

Trading Interval

REGIONID

VARCHAR2(10)

 

Region Identifier

RESTARTTYPE

NUMBER(1,0)

 

System Restart Type (0 = FRC, 1 = GRC, 2 = TTH)

AVAFLAG

NUMBER(1,0)

 

Availability Flag

AVAILABILITYPRICE

NUMBER(15,5)

 

Availability Price

TCF

NUMBER(1,0)

 

Service Test Flag

AVAILABILITYPAYMENT

NUMBER(15,5)

 

Availability Payment

CONTRACTVERSIONNO

NUMBER(3,0)

 

Contract Version No.

OFFERDATE

DATE

 

Re-offer offer date

OFFERVERSIONNO

NUMBER(3,0)

 

Re-Offer Version No.

LASTCHANGED

DATE

 

Last date and time record changed

ENABLINGPAYMENT

NUMBER(18,8)

 

The enabling payment made for system restart in this half-hour interval