|
Name |
|
|
Comment |
Participant submitted Offers for MTPASA process |
|
Name |
|
EFFECTIVEDATE |
|
OFFERDATETIME |
|
PARTICIPANTID |
|
UNITID |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
PARTICIPANTID |
VARCHAR2(20) |
X |
Unique participant identifier |
|
OFFERDATETIME |
DATE |
X |
Date time file processed |
|
UNITID |
VARCHAR2(20) |
X |
either duid or mnsp linkid |
|
EFFECTIVEDATE |
DATE |
X |
trade date when the offer becomes effective |
|
ENERGY |
NUMBER(9) |
|
weekly energy constraint value |
|
CAPACITY1 |
NUMBER(9) |
|
capacity value day 1 (sunday) |
|
CAPACITY2 |
NUMBER(9) |
|
capacity value day 2 (monday) |
|
CAPACITY3 |
NUMBER(9) |
|
capacity value day 3 (tuesday) |
|
CAPACITY4 |
NUMBER(9) |
|
capacity value day 4 (wednesday) |
|
CAPACITY5 |
NUMBER(9) |
|
capacity value day 5 (thursday) |
|
CAPACITY6 |
NUMBER(9) |
|
capacity value day 6 (friday) |
|
CAPACITY7 |
NUMBER(9) |
|
capacity value day 7 (saturday) |
|
LASTCHANGED |
DATE |
|
timestamp when record last changed |
|
UNITSTATE1 |
VARCHAR2(20) |
|
The unit state value for day 1 Sunday |
|
UNITSTATE2 |
VARCHAR2(20) |
|
The unit state value for day 2 Monday |
|
UNITSTATE3 |
VARCHAR2(20) |
|
The unit state value for day 3 Tuesday |
|
UNITSTATE4 |
VARCHAR2(20) |
|
The unit state value for 4 Wednesday |
|
UNITSTATE5 |
VARCHAR2(20) |
|
The unit state value for day 5 Thursday |
|
UNITSTATE6 |
VARCHAR2(20) |
|
The unit state value for day 6 Friday |
|
UNITSTATE7 |
VARCHAR2(20) |
|
The unit state value for day 7 Saturday |
|
RECALLTIME1 |
NUMBER(4) |
|
The recall time associated with the unit state for day 1 Sunday |
|
RECALLTIME2 |
NUMBER(4) |
|
The recall time associated with the unit state for day 2 Monday |
|
RECALLTIME3 |
NUMBER(4) |
|
The recall time associated with the unit state for day 3 Tuesday |
|
RECALLTIME4 |
NUMBER(4) |
|
The recall time associated with the unit state for day 4 Wednesday |
|
RECALLTIME5 |
NUMBER(4) |
|
The recall time associated with the unit state for day 5 Thursday |
|
RECALLTIME6 |
NUMBER(4) |
|
The recall time associated with the unit state for day 6 Friday |
|
RECALLTIME7 |
NUMBER(4) |
|
The recall time associated with the unit state for day 7 Saturday |
|
|
|