DAYTRACK
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.
Package
SETTLEMENT_DATA
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| SETTLEMENTDATE |
datetime(3)  |
datetime2(0) |
Calendar Settlement Date |
| EXPOSTRUNNO |
numeric(3, 0) |
smallint |
Settlement Run No |
| REGIONID |
varchar(10) |
varchar(10) |
Not Used |
| EXANTERUNSTATUS |
varchar(15) |
varchar(15) |
This is to determine whether the Settlement Run is a valid run or not. |
| EXANTERUNNO |
numeric(3, 0) |
smallint |
Not Used |
| EXPOSTRUNSTATUS |
varchar(15) |
varchar(15) |
Estimate for DAILY/INITIAL and Actual for PRELIM/FINAL and REVISE. |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
| SETTLEMENTINTERVALLENGTH |
numeric(3, 0) |
smallint |
Length of a settlement interval, in minutes (was 30 minutes, will be 5 minutes starting the commencement of 5MS rule change date). |
| METER_CASEID |
numeric(5, 0) |
smallint |
The Metering Case Id used for the Settlement Run. For Estimate Daily Run this will be 0 |
| METER_RUNTYPE |
varchar(10) |
varchar(10) |
The Type of Settlement Run(ESTIMATE/PRELIM/FINAL/REVISE) |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| DAYTRACK_LCX |
nonclustered |
LASTCHANGED |
| DAYTRACK_PK |
clustered, unique, primary key |
SETTLEMENTDATE, EXPOSTRUNNO |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_DAYTRACK_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_DAYTRACK |
clustered, unique, primary key |
SETTLEMENTDATE, EXPOSTRUNNO |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| DAYTRACK_LCX |
nonclustered |
LASTCHANGED |
| DAYTRACK_PK |
clustered, unique, primary key |
SETTLEMENTDATE, EXPOSTRUNNO |