Table: SET_RUN_PARAMETER

SET_RUN_PARAMETER

Name

SET_RUN_PARAMETER

Comment

SET_RUN_PARAMETER shows the input parameters and value associated with each settlement run (e.g. Residual System Load Causer Pays Factor).


Description

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


Primary Key Columns

Name

PARAMETERID

SETTLEMENTDATE

VERSIONNO


Index Columns

Name

LASTCHANGED


Content

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