Table: OFFERFILETRK

OFFERFILETRK

Name

OFFERFILETRK

Comment

OFFERFILETRK shows an audit trail of all bid files submitted containing energy bids, including corrupt bids/rebids.


Description

Status

OFFERFILETRK is obsolete. Please see BIDOFFERFILETRK.

Source

OFFERFILETRK is obsolete.


Primary Key Columns

Name

FILENAME

OFFERDATE

PARTICIPANTID


Index Columns

Name

LASTCHANGED


Index Columns

Name

PARTICIPANTID


Content

Name

Data Type

Mandatory

Comment

OFFERDATE

DATE

X

Date file offered

PARTICIPANTID

VARCHAR2(10)

X

Unique participant identifier

STATUS

VARCHAR2(10)

 

Load status [SUCCESSFUL/CORRUPT]

ACKFILENAME

VARCHAR2(40)

 

Acknowledge file name

ENDDATE

DATE

 

Not used

FILENAME

VARCHAR2(40)

X

Load file name

LASTCHANGED

DATE

 

Last date and time record changed