Name |
|
Comment |
The table shows the Transaction Details for the SAPS Connection Points. The table contains both the MSRPs and Retailers data |
Name |
PARTICIPANTID |
PERIODID |
SETTLEMENTDATE |
TNI |
VERSIONNO |
Name |
Data Type |
Mandatory |
Comment |
SETTLEMENTDATE |
DATE |
X |
The Settlement Date of the Billing Week |
VERSIONNO |
NUMBER(3,0) |
X |
The Settlement Run No |
PERIODID |
NUMBER(3,0) |
X |
The Period Id identifier |
PARTICIPANTID |
VARCHAR2(20) |
X |
The Participant ID for the SAPS TNI |
TNI |
VARCHAR2(20) |
X |
The SAPS Connection Point Identifier |
REGIONID |
VARCHAR2(20) |
|
The SAPS Region ID |
SAPS_RRP |
NUMBER(18,8) |
|
The SAPS Settlement Price for the Region |
CONSUMED_ENERGY_MWH |
NUMBER(18,8) |
|
The Energy MWh Consumed for that TNI for the Participant ID |
SENTOUT_ENERGY_MWH |
NUMBER(18,8) |
|
The Energy MWh Sent Out for the TNI for the Participant Id |
CONSUMED_ENERGY_COST |
NUMBER(18,8) |
|
The Cost of the Consumed Energy |
SENTOUT_ENERGY_COST |
NUMBER(18,8) |
|
The Cost of the Sent Out Energy |
LASTCHANGED |
DATE |
|
The Last changed Date time of the record |
|
|
|