Table: BIDTYPESTRK

BIDTYPESTRK

Name

BIDTYPESTRK

Comment

BIDTYPESTRK, together with the associated data in BIDTYPES, define a set of ancillary services with bidding parameters from a given date.


Description

BIDTYPESTRK is public to participants

Source

BIDTYPESTRK updates when the static data relating to an ancillary service type is modified.

Volume

Expect modifications to be rare. Allow for approximately 20 records per year.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Public


Primary Key Columns

Name

EFFECTIVEDATE

VERSIONNO


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

EFFECTIVEDATE

DATE

X

Market date starting at 04:30 inclusive

VERSIONNO

NUMBER(3,0)

X

Record version number

AUTHORISEDDATE

DATE

 

Date of record authorisation. A NULL value indicates the record is not authorised.

AUTHORISEDBY

VARCHAR2(15)

 

User that authorised record. A NULL value indicates the record is not authorised.

LASTCHANGED

DATE

 

Last date and time record changed