|
Name |
|
|
Comment |
MNSP_FILETRK shows all MNSPOFFERS transmitted to the MMS system. |
|
MNSP_FILETRK is confidential to the relevant participant. Source MNSP_FILETRK updates for every submitted MNSP bid. Volume 4000 per year, being one per bid containing an MNSP bid |
|
Name |
|
FILENAME |
|
OFFERDATE |
|
PARTICIPANTID |
|
SETTLEMENTDATE |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Market Date from which bid is active |
|
OFFERDATE |
DATE |
X |
The actual date and time the bid file was submitted by the participant |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Participant Identifier |
|
FILENAME |
VARCHAR2(40) |
X |
File name for default bids, bids, rebids, re-offers or meter files, as appropriate to table |
|
STATUS |
VARCHAR2(10) |
|
Load status [SUCCESSFUL/CORRUPT] |
|
ACKFILENAME |
VARCHAR2(40) |
|
Acknowledge file name for bids, rebids |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
|
|