BIDOFFERFILETRK

BIDOFFERFILETRK shows an audit trail of all files submitted containing ENERGY / FCAS / MNSP bid, including corrupt bids and rebids.

Package

BIDS

Private

Column	Official MMS Datatype	GR-MMS Datatype	Comment
PARTICIPANTID	varchar(10)	varchar(10)	Unique participant identifier
OFFERDATE	datetime(3)	datetime2(0)	Time this bid was processed and loaded
FILENAME	varchar(80) (not nullable)	varchar(80) (not nullable)	Submitted file name
STATUS	varchar(10)	varchar(10)	Load status [SUCCESSFUL/CORRUPT]
LASTCHANGED	datetime(3)	datetime2(0)	Last date and time record changed
AUTHORISEDBY	varchar(20)	varchar(20)	Participant agent who created the Offer
AUTHORISEDDATE	datetime(3)	datetime2(0)	When the Offer was processed - synonymous with LastChanged
TRANSACTION_ID	varchar(100)	varchar(100)	A GUID used to identify the submission transaction in AEMOs systems
REFERENCE_ID	varchar(100)	varchar(100)	A participant provided reference, which is required to be unique per submission (for a PARTICIPANTID)
SUBMISSION_TIMESTAMP	datetime(3)	datetime2(0)	The participant provided date/time for the submission
COMMENTS	varchar(1000)	varchar(1000)	A participant provided comment
SUBMISSION_METHOD	varchar(20)	varchar(20)	Method by which this submission was made typically FTP, API, WEB

Index name	Index type	Index columns (in order)
BIDOFFERFILETRK_FILE_UK	nonclustered, unique, unique key	FILENAME
BIDOFFERFILETRK_LCHD_IDX	nonclustered	LASTCHANGED
BIDOFFERFILETRK_PK	clustered, unique, primary key	PARTICIPANTID, OFFERDATE

Index name	Index type	Index columns (in order)
IX_BIDOFFERFILETRK_FILENAME	nonclustered, unique	FILENAME
IX_BIDOFFERFILETRK_LASTCHANGED	nonclustered	LASTCHANGED
PK_BIDOFFERFILETRK	clustered, unique, primary key	PARTICIPANTID, OFFERDATE

Index name	Index type	Index columns (in order)
BIDOFFERFILETRK_FILE_UK	nonclustered, unique, unique key	FILENAME
BIDOFFERFILETRK_LCHD_IDX	nonclustered	LASTCHANGED
BIDOFFERFILETRK_PK	clustered, unique, primary key	PARTICIPANTID, OFFERDATE