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:
|
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 |