Table: SET_NMAS_RECOVERY_RBF

SET_NMAS_RECOVERY_RBF

Name

SET_NMAS_RECOVERY_RBF

Comment

SET_NMAS_RECOVERY_RBF publishes the RBF for NSCAS non testing payments on a half hourly basis.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Public


Primary Key Columns

Name

CONTRACTID

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 number

PERIODID

NUMBER(3,0)

X

Half Hourly Interval

SERVICE

VARCHAR(10)

X

The type of NSCAS service. Current value values are:
- REACTIVE
- LOADSHED

CONTRACTID

VARCHAR(10)

X

The NMAS Contract Id

PAYMENTTYPE

VARCHAR(20)

X

The type of payment being recovered. Valid values are:
- AVAILABILITY
- ENABLEMENT
- COMPENSATION

REGIONID

VARCHAR(10)

X

The region from where the amount is recovered

RBF

NUMBER(18,8)

 

The Benefitting Factor for the RegionId

PAYMENT_AMOUNT

NUMBER(18,8)

 

The total Payment Amount to recover from all benefitting regions

RECOVERY_AMOUNT

NUMBER(18,8)

 

The Total recovery amount for the period for the REGIONID

LASTCHANGED

DATE

 

The Last Updated date and time