|
Name |
|
|
Comment |
METERDATATRK records meter data files submitted for each connection point on a daily basis. The same data is provided in METERDATA period by period (i.e. 48 records), whereas METERDATATRK shows one record per day for each file submitted for a connection point. |
|
METERDATATRK data is confidential to the relevant participant. Source METERDATATRK updates whenever meter files are processed. Volume Depends on the number of TNI, FRMP and LR combinations plus the number of data file loads (versions) from MSATS per settlement run. |
|
Name |
Comment |
Value |
|
Visibility |
Data in this table is: |
Private |
|
Name |
|
CONNECTIONPOINTID |
|
HOSTDISTRIBUTOR |
|
METERINGDATAAGENT |
|
METERRUNNO |
|
PARTICIPANTID |
|
SETTLEMENTDATE |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Settlement calendar date |
|
METERRUNNO |
NUMBER(6,0) |
X |
Meter data version number |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Participant identifier |
|
FILENAME |
VARCHAR2(40) |
|
Meter file name (MSATS file name) |
|
ACKFILENAME |
VARCHAR2(40) |
|
Not used |
|
CONNECTIONPOINTID |
VARCHAR2(10) |
X |
Transmission Node Identifier (TNI) |
|
AUTHORISEDDATE |
DATE |
|
Date processed |
|
AUTHORISEDBY |
VARCHAR2(15) |
|
Not used |
|
METERINGDATAAGENT |
VARCHAR2(10) |
X |
Defaults to MSATS |
|
HOSTDISTRIBUTOR |
VARCHAR2(10) |
X |
Local retailer participant identifier |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
|
|