|
Name |
|
|
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. |
|
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. |
|
Name |
Comment |
Value |
|
Visibility |
Data in this table is: |
Public |
|
Name |
|
EXPOSTRUNNO |
|
SETTLEMENTDATE |
|
Name |
|
LASTCHANGED |
|
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,will be 5 with 5MS) |
|
|
|