Register Data Set

You must create a data set for each batch of records being uploaded in the system for the same register. The name of this table is CI_​REG_​DATA_​SET. The following table describes each column on this table.

Column Name

Length

Req'd

Data Type

Comments

REG_​DATA_​SET_​ID

12

Y

A/N

This is a unique key. This key is referenced on the register data record.

It's suggested that this key is built as follows:

  • The first five digits are the first five digits of the REG_​ID.
    • The last seven digits are randomly generated.

      This facilitates set based processing of the data. If your process that inserts records on this table is capable of calling a routine, call ProgramCIPZKEYG passing the first five digits and it supplies a seven-digit random number.

REG_​ID

10

N

A/N

This is a foreign key reference to the interval register to which this set is linked. It is required if an external ID is not specified.

REG_​DS_​EXT_​ID

60

N

A/N

This is the external identifier of the register to which this data belongs. It should correspond to the channel ID of its register. It is required if register ID is not specified.

SET_​DTTM

26

Y

DateTime

This is the date/time that the data set was received. This must be populated with the current date/time. This is considered a server date and follows the seasonal time shifting as defined on the base time zone. Refer to Seasonal Time Shifts for more information.

Refer to Algorithms Find the Most Up-To-Date Data for information about why this date/time is important.

REG_​DS_​STATUS_​FLG

2

Y

A/N

Set this value based on whether it will be validated in the system.

Set to P for Pending if the register ID is blank or if the register's register type indicates a validation algorithm.

Set to C for Complete if the data will not go through any further validation.

Refer to Life Cycle of Interval Register Data for more information