Table: MTPASA_OFFERDATA

MTPASA_OFFERDATA

Name

MTPASA_OFFERDATA

Comment

Participant submitted Offers for MTPASA process


Notes

Name

Comment

Value

Visibility

Data in this table is:

Private;


Primary Key Columns

Name

EFFECTIVEDATE

OFFERDATETIME

PARTICIPANTID

UNITID


Index Columns

Name

LASTCHANGED


Content

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