|
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 |
|
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 |
|
|
|