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 |
|
|
|