Name |
|
Comment |
SET_RUN_PARAMETER shows the input parameters and value associated with each settlement run (e.g. Residual System Load Causer Pays Factor). |
Change History 19 August 2005 for 4.5.0: Changed index name again to have suffix of _LCX Note: primary key shows PK_ as prefix in Oracle SQL script, even though name of key has _PK as suffix - but cannot change since would not improve participant systems .
17 August 2005 for v4.5.0 Added tablespace (02) for recently added index, and gave index a better name |
Name |
Comment |
Value |
Visibility |
Data in this table is: |
Public |
Name |
PARAMETERID |
SETTLEMENTDATE |
VERSIONNO |
Name |
LASTCHANGED |
Name |
Data Type |
Mandatory |
Comment |
SETTLEMENTDATE |
DATE |
X |
Settlement Date (Calendar) |
VERSIONNO |
NUMBER(3) |
X |
Settlement Run Number for this date |
PARAMETERID |
VARCHAR2(20) |
X |
Parameter Identifier |
NUMVALUE |
NUMBER(18,8) |
|
Settlement Run Amount for the Constant Identifier |
LASTCHANGED |
DATE |
|
Last date the record changed |
|
|
|