|
Name |
|
|
Comment |
SET_NMAS_RECOVERY sets out the NSCAS recovery data for payments other than testing. |
|
Name |
Comment |
Value |
|
Visibility |
Data in this table is: |
Private |
|
Name |
|
CONTRACTID |
|
PARTICIPANTID |
|
PAYMENTTYPE |
|
PERIODID |
|
REGIONID |
|
SERVICE |
|
SETTLEMENTDATE |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
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: |
|
CONTRACTID |
VARCHAR(10) |
X |
The NMAS Contract Id |
|
PAYMENTTYPE |
VARCHAR(20) |
X |
The type of payment being recovered. Valid values are: |
|
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 |
|
|
|