Table: SET_NMAS_RECOVERY

SET_NMAS_RECOVERY

Name

SET_NMAS_RECOVERY

Comment

SET_NMAS_RECOVERY sets out the NSCAS recovery data for payments other than testing.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Private


Primary Key Columns

Name

CONTRACTID

PARTICIPANTID

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

PARTICIPANTID

VARCHAR(20)

X

The Participant from whom the amount is recovered

SERVICE

VARCHAR(10)

X

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

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

PARTICIPANT_ENERGY

NUMBER(18,8)

 

The Participant energy in MWh for the period

REGION_ENERGY

NUMBER(18,8)

 

The RegionId energy in MWh for the period

RECOVERY_AMOUNT

NUMBER(18,8)

 

The Total recovery amount for the period for the PARTICIPANTID and REGIONID

LASTCHANGED

DATE

 

The Last Updated date and time

PARTICIPANT_GENERATION

NUMBER(18,8)

 

Participant Generator Energy in the benefitting region

REGION_GENERATION

NUMBER(18,8)

 

The generator energy in the benefitting region

RECOVERY_AMOUNT_CUSTOMER

NUMBER(18,8)

 

The recovery amount allocated to customers

RECOVERY_AMOUNT_GENERATOR

NUMBER(18,8)

 

The recovery amount allocated to generators