Table: DAYTRACK

DAYTRACK

Name

DAYTRACK

Comment

DAYTRACK identifies the actual settlement run processed for each settlement day. Settlement run is in the column EXPOSTRUNNO. Generally the number of the settlement run used in the latest statement is the maximum number.


Description

DAYTRACK is a public data, and is available to all participants.

Source

DAYTRACK is populated by the posting of a billing run.

Volume

Daily billing runs insert one row per day. A non-interim statement has seven records inserted per week. An indicative maximum is 35 records inserted per week.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Public


Primary Key Columns

Name

EXPOSTRUNNO

SETTLEMENTDATE


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

SETTLEMENTDATE

DATE

X

Calendar Settlement Date

REGIONID

VARCHAR2(10)

 

Not Used

EXANTERUNSTATUS

VARCHAR2(15)

 

Not Used

EXANTERUNNO

NUMBER(3,0)

 

Not Used

EXPOSTRUNSTATUS

VARCHAR2(15)

 

Not Used

EXPOSTRUNNO

NUMBER(3,0)

X

Settlement Run No

LASTCHANGED

DATE

 

Last date and time record changed

SETTLEMENTINTERVALLENGTH

NUMBER(3,0)

 

Length of a settlement interval, in minutes (was 30 minutes, will be 5 minutes starting the commencement of 5MS rule change date).