|
Name |
|
|
Comment |
RESDEMANDTRK defines the existence and versioning information of a forecast for a specific region and trading date. |
|
RESDEMANDTRK data is public, so is available to all participants. Source RESDEMANDTRK updates are ad hoc. Volume 27000 rows per year. |
|
Name |
Comment |
Value |
|
Visibility |
Data in this table is: |
Public |
|
Name |
|
EFFECTIVEDATE |
|
OFFERDATE |
|
REGIONID |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
EFFECTIVEDATE |
DATE |
X |
Trading Date of the regional forecast |
|
REGIONID |
VARCHAR2(10) |
X |
Unique RegionID |
|
OFFERDATE |
DATE |
X |
Date the forecast was created |
|
VERSIONNO |
NUMBER(3,0) |
X |
Version of this forecast with respect to the Effectivedate and Offerdate |
|
FILENAME |
VARCHAR2(40) |
|
Tracking purposes only |
|
AUTHORISEDDATE |
DATE |
|
Date forecast authorised |
|
AUTHORISEDBY |
VARCHAR2(10) |
|
Identifier of authorising user |
|
LASTCHANGED |
DATE |
|
Date and time the record was last modified |
|
|
|