Each piece of interval data for the same bill factor/characteristic
will be stored as an Interval Value record linked to the newly created
data set. The name of this table is
CI_INTV_VAL
.
Table 1. - CI_INTV_VAL Table ColumnsThe following table lists and describes the columns of the CI_INTV_VAL table:
Column Name |
Length |
Req'd |
Data Type |
Comments |
INTV_VAL_SET_ID |
12
|
Y
|
A/N
|
This is a foreign key reference to the Interval Value Set that
groups the interval values together. This should be your newly created
id from |
INTV_VAL_DTTM |
26 |
Y |
DateTime |
This is the date and time of the interval value. This must
be stored relative to the base time zone. |
INTV_VAL
|
18.7
|
Y
|
N |
This is the value (price) for the interval. |
Table 2. - CI_INTV_VAL Table ColumnsThe following table lists and describes the columns of the CI_INTV_VAL table:
Column Name |
Length |
Req'd |
Data Type |
Comments |
INTV_VAL_SET_ID |
12
|
Y
|
A/N
|
This is a foreign key reference to the Interval Value Set that
groups the interval values together. This should be your newly created
id from |
INTV_VAL_DTTM |
26 |
Y |
DateTime |
This is the date and time of the interval value. This must
be stored relative to the base time zone. |
INTV_VAL
|
18.7
|
Y
|
N |
This is the value (price) for the interval. |