Interval Value Set
You must create a data set for each batch of records being uploaded in the system for the same bill factor / characteristic. The name of this table is CI_INTV_VAL_SET . The following table describes each column on this table.
Column Name | Length | Req'd | Data Type | Comments |
---|---|---|---|---|
INTV_VAL_SET_ID | 12 | Y | A/N |
This is a random unique key. This key is referenced on the interval value record. It's suggested that this is a random number. If your process that inserts records on this table is capable of calling a COBOL routine, call CIPZKEYG and it will supply a 12 digit random number for you. |
BF_CD | 8 | Y | A/N |
This along with CHAR_TYPE_CD and CHAR_VAL indicate the bill factor / characteristic to which this interval value set belongs. Refer to Setting Up Bill Factors for more information. |
CHAR_TYPE_CD | 8 | Y | A/N |
This along with BF_CD and CHAR_VAL indicate the bill factor / characteristic to which this interval value set belongs. Refer to Setting Up Bill Factors for more information. |
CHAR_VAL | 16 | Y | A/N |
This along with BF_CD and CHAR_TYPE_CD indicate the bill factor / characteristic to which this interval value set belongs. Refer to Setting Up Bill Factors for more information. |
SET_DTTM | 26 | Y | DateTime |
This is the data/time that the data set was received. This must be populated with the current date / time. This is considered a server date and will follow the seasonal time shifting as defined on the base time zone. |