Table: SETRESERVERECOVERY

SETRESERVERECOVERY

Name

SETRESERVERECOVERY

Comment

SETRESERVERECOVERY shows reserve recovery details.


Description

SETRESERVERECOVERY is unused.

Source

Unused; was updated when reserve recovery occurred in a billing run.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Private


Primary Key Columns

Name

CONTRACTID

PARTICIPANTID

PERIODID

SETTLEMENTDATE

VERSIONNO


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

SETTLEMENTDATE

DATE

X

Settlement Date

VERSIONNO

NUMBER(3,0)

X

Settlement Run No.

PERIODID

NUMBER(3,0)

X

Period Identifier

CONTRACTID

VARCHAR2(10)

X

 

RCF

CHAR(1)

 

Regional Recovery Flag

SPOTPAYMENT

NUMBER(12,5)

 

Cap difference for generator

PARTICIPANTID

VARCHAR2(10)

X

Unique participant identifier

PARTICIPANTDEMAND

NUMBER(12,5)

 

Demand of Participant in Region/Market

TOTALDEMAND

NUMBER(12,5)

 

Total Demand of Region/Market

RESERVEPAYMENT

NUMBER(12,5)

 

Payment made to generator for Reserve Trader Contract

RESERVEAMOUNT

NUMBER(12,5)

 

Payment owed by Retailer to pool for Reserve Trader Contract

LASTCHANGED

DATE

 

Last date and time record changed

REGIONID

VARCHAR2(10)

 

Region Identifier