|
Name |
|
|
Comment |
Provides details of the RERT Recovery Amount for the Market Customers. |
|
Name |
|
BILLRUNNO |
|
CONTRACTYEAR |
|
PARTICIPANTID |
|
PAYMENT_TYPE_ID |
|
PUBLICATION_ID |
|
REGIONID |
|
WEEKNO |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
Billing contract year |
|
WEEKNO |
NUMBER(3,0) |
X |
Billing week number |
|
BILLRUNNO |
NUMBER(3,0) |
X |
Billing posted run number |
|
PUBLICATION_ID |
VARCHAR2(40) |
X |
Unique Publication Identifier for RERT Payment |
|
PARTICIPANTID |
VARCHAR2(20) |
X |
Participant identifier. |
|
PAYMENT_TYPE_ID |
VARCHAR2(20) |
X |
RERT payment type ID. Possible values are USAGE or OTHER |
|
REGIONID |
VARCHAR2(20) |
X |
Region from which the amount is recovered |
|
PARTICIPANT_DEMAND |
NUMBER(18,8) |
|
Participant Demand Value used for RERT Recovery |
|
REGION_DEMAND |
NUMBER(18,8) |
|
Region Demand Value used for RERT Recovery |
|
ELIGIBILITY_START_INTERVAL |
DATE |
|
Starting Period of RERT Recovery for Usage Payments |
|
ELIGIBILITY_END_INTERVAL |
DATE |
|
Ending Period of RERT Recovery for Usage Payments |
|
RECOVERY_AMOUNT |
NUMBER(18,8) |
|
Recovery Amount applicable for each Market Customer |
|
|
|