|
Name |
|
|
Comment |
The Billing Directions Recovery Details for the participants |
|
Name |
|
BILLRUNNO |
|
CONTRACTYEAR |
|
DIRECTION_ID |
|
PARTICIPANTCATEGORYID |
|
PARTICIPANTID |
|
REGIONID |
|
WEEKNO |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
The Billing Contract Year |
|
WEEKNO |
NUMBER(3,0) |
X |
The Billing WeekNo |
|
BILLRUNNO |
NUMBER(3,0) |
X |
The Billing RunNo |
|
DIRECTION_ID |
VARCHAR2(20) |
X |
The Direction Unique Identifier |
|
PARTICIPANTID |
VARCHAR2(20) |
X |
The Direction Payment Participant ID |
|
PARTICIPANTCATEGORYID |
VARCHAR2(20) |
X |
The Participant Category for recovery Customer/Generator /SmallGen |
|
REGIONID |
VARCHAR2(20) |
X |
The Region ID for the recovery |
|
RECOVERY_AMOUNT |
NUMBER(18,8) |
|
The Direction Recovery Amount |
|
RECOVERY_ENERGY |
NUMBER(18,8) |
|
The Energy Value used for the Recovery |
|
REGION_ENERGY |
NUMBER(18,8) |
|
The total Energy at the Region ID |
|
EXCLUDED_ENERGY |
NUMBER(18,8) |
|
The Energy Value (Scheduled Loads) that is excluded |
|
LASTCHANGED |
DATE |
|
The Last datetime record is updated |
|
|
|