|
Name |
|
|
Comment |
MT PASA input table defining a MT PASA Reserve Requirement within a single set. An MT PASA Reserve Requirement can span more than one region. |
|
Source MTPASA_RESERVELIMIT is updated on an ad hoc basis when a new Reserve Requirement is published. Volume ~20 rows per year |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
EFFECTIVEDATE |
|
RESERVELIMITID |
|
VERSION_DATETIME |
|
Name |
Data Type |
Mandatory |
Comment |
|
EFFECTIVEDATE |
DATE |
X |
Trade date when the set of reserve requirements become effective |
|
VERSION_DATETIME |
DATE |
X |
Timestamp when the set of reserve requirements become effective |
|
RESERVELIMITID |
VARCHAR2(20) |
X |
MT PASA Reserve Requirement identifier |
|
DESCRIPTION |
VARCHAR2(200) |
|
Description of this Reserve Requirement |
|
RHS |
NUMBER(16,6) |
|
Right hand side value for this Reserve requirement |
|
LASTCHANGED |
DATE |
|
Timestamp the record was last modified. |
|
Name |
|
|
Comment |
MT PASA input table to define the regions that are part of a single MT PASA Reserve Requirement |
|
Source MTPASA_RESERVELIMIT_REGION is updated on an ad hoc basis when a new Reserve Requirement is published. Volume ~50 rows per year |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
EFFECTIVEDATE |
|
REGIONID |
|
RESERVELIMITID |
|
VERSION_DATETIME |
|
Name |
Data Type |
Mandatory |
Comment |
|
EFFECTIVEDATE |
DATE |
X |
Trade date when the set of reserve requirements become effective |
|
VERSION_DATETIME |
DATE |
X |
Timestamp when the set of reserve requirements become effective |
|
RESERVELIMITID |
VARCHAR2(20) |
X |
MT PASA Reserve requirement identifier |
|
REGIONID |
VARCHAR2(20) |
X |
Region ID - identifier of a NEM region included in this requirement |
|
COEF |
NUMBER(16,6) |
|
Coefficient for the region in this reserve requirement |
|
LASTCHANGED |
DATE |
|
Timestamp the record was last modified |
|
Name |
|
|
Comment |
MT PASA input table defining a set of MT PASA Reserve Requirements. Note only one set can be active on a given date. |
|
Source MTPASA_RESERVELIMIT_SET is updated on an ad hoc basis when a new Reserve Requirement is published. Volume ~2 rows per year |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
EFFECTIVEDATE |
|
VERSION_DATETIME |
|
Name |
Data Type |
Mandatory |
Comment |
|
EFFECTIVEDATE |
DATE |
X |
Trade date when the set of reserve requirements become effective |
|
VERSION_DATETIME |
DATE |
X |
Timestamp when the set of reserve requirements become effective |
|
RESERVELIMIT_SET_ID |
VARCHAR2(20) |
|
MT PASA LRC Reserve Requirement Set Identifier |
|
DESCRIPTION |
VARCHAR2(200) |
|
Description of this set of Reserve Requirements |
|
AUTHORISEDDATE |
DATE |
|
Date the requirement set was authorised |
|
AUTHORISEDBY |
VARCHAR2(20) |
|
User authorising this requirement set |
|
LASTCHANGED |
DATE |
|
Timestamp the record was last modified |
|
|
|