MTPASA_OFFERDATA
Participant submitted Offers for MTPASA process.
Package
BIDS
Visibility
Private
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| PARTICIPANTID |
varchar(20)  |
varchar(20) |
Unique participant identifier |
| OFFERDATETIME |
datetime(3) |
datetime2(0) |
Date time file processed |
| UNITID |
varchar(20) |
varchar(20) |
either duid or mnsp linkid |
| EFFECTIVEDATE |
datetime(3) |
datetime2(0) |
trade date when the offer becomes effective |
| ENERGY |
numeric(9, 0) |
int |
weekly energy constraint value |
| CAPACITY1 |
numeric(9, 0) |
smallint |
capacity value day 1 (sunday) |
| CAPACITY2 |
numeric(9, 0) |
smallint |
capacity value day 2 (monday) |
| CAPACITY3 |
numeric(9, 0) |
smallint |
capacity value day 3 (tuesday) |
| CAPACITY4 |
numeric(9, 0) |
smallint |
capacity value day 4 (wednesday) |
| CAPACITY5 |
numeric(9, 0) |
smallint |
capacity value day 5 (thursday) |
| CAPACITY6 |
numeric(9, 0) |
smallint |
capacity value day 6 (friday) |
| CAPACITY7 |
numeric(9, 0) |
smallint |
capacity value day 7 (saturday) |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
timestamp when record last changed |
| RECALLTIME1 |
numeric(4, 0) |
smallint |
The recall time associated with the unit state for day 1 Sunday |
| RECALLTIME2 |
numeric(4, 0) |
smallint |
The recall time associated with the unit state for day 2 Monday |
| RECALLTIME3 |
numeric(4, 0) |
smallint |
The recall time associated with the unit state for day 3 Tuesday |
| RECALLTIME4 |
numeric(4, 0) |
smallint |
The recall time associated with the unit state for day 4 Wednesday |
| RECALLTIME5 |
numeric(4, 0) |
smallint |
The recall time associated with the unit state for day 5 Thursday |
| RECALLTIME6 |
numeric(4, 0) |
smallint |
The recall time associated with the unit state for day 6 Friday |
| RECALLTIME7 |
numeric(4, 0) |
smallint |
The recall time associated with the unit state for day 7 Saturday |
| UNITSTATE1 |
varchar(20) |
varchar(20) |
The unit state value for day 1 Sunday |
| UNITSTATE2 |
varchar(20) |
varchar(20) |
The unit state value for day 2 Monday |
| UNITSTATE3 |
varchar(20) |
varchar(20) |
The unit state value for day 3 Tuesday |
| UNITSTATE4 |
varchar(20) |
varchar(20) |
The unit state value for 4 Wednesday |
| UNITSTATE5 |
varchar(20) |
varchar(20) |
The unit state value for day 5 Thursday |
| UNITSTATE6 |
varchar(20) |
varchar(20) |
The unit state value for day 6 Friday |
| UNITSTATE7 |
varchar(20) |
varchar(20) |
The unit state value for day 7 Saturday |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| MTPASA_OFFERDATA_LCX |
nonclustered |
LASTCHANGED |
| MTPASA_OFFERDATA_PK |
clustered, unique, primary key |
PARTICIPANTID, OFFERDATETIME, UNITID, EFFECTIVEDATE |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_MTPASA_OFFERDATA_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_MTPASA_OFFERDATA |
clustered, unique, primary key |
PARTICIPANTID, OFFERDATETIME, UNITID, EFFECTIVEDATE |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| MTPASA_OFFERDATA_LCX |
nonclustered |
LASTCHANGED |
| MTPASA_OFFERDATA_PK |
clustered, unique, primary key |
PARTICIPANTID, OFFERDATETIME, UNITID, EFFECTIVEDATE |