Table: OARTRACK

OARTRACK

Name

OARTRACK

Comment

OARTRACK shows an audit trail of bids for a particular settlement day. Corrupt bids do not update OARTRACK, but are just in OFFERFILETRK.


Description

Not in Use - discontinued 16/11/2003

Status

The OARTRACK table is obsolete. Please refer to BIDOFFERFILETRK. As a transition assist, the OARTRACK views expose data based on BIDOFFERFILETRK.

Source

Own (confidential) data updates as bids are processed. All bids are available as part of next day market data.


Primary Key Columns

Name

OFFERDATE

PARTICIPANTID

SETTLEMENTDATE

VERSIONNO


Index Columns

Name

LASTCHANGED


Index Columns

Name

PARTICIPANTID


Content

Name

Data Type

Mandatory

Comment

SETTLEMENTDATE

DATE

X

Settlement date

OFFERDATE

DATE

X

Date file offered

VERSIONNO

NUMBER(3,0)

X

Version no for this offer date

PARTICIPANTID

VARCHAR2(10)

X

Unique participant identifier

FILENAME

VARCHAR2(40)

 

Load file name

AUTHORISEDDATE

DATE

 

Date record authorised

AUTHORISEDBY

VARCHAR2(10)

 

User authorising record

LASTCHANGED

DATE

 

Last date and time record changed