Table: SET_ENERGY_TRAN_SAPS

SET_ENERGY_TRAN_SAPS

Name

SET_ENERGY_TRAN_SAPS

Comment

The table shows the Transaction Details for the SAPS Connection Points. The table contains both the MSRPs and Retailers data


Primary Key Columns

Name

PARTICIPANTID

PERIODID

SETTLEMENTDATE

TNI

VERSIONNO


Content

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