Notification Upload Staging Characteristics

If desired, you may insert rows into the upload staging characteristics collection. The characteristics collection enables you to define all the core information associated with the upload staging record. Characteristic types will need to be defined for every piece of data you wish to capture. This option may be used in favor of the extension record option, defined below, because you do not need to define new database tables or new user interfaces for each new notification upload type.

The name of this table is CI_NT_UP_CHAR. The following table describes each column on this table.


Column Name	Length	Req'd	Data Type	Comments
NT_UP_ID	12	Y	A/N	This is the unique key of the NUS record to which this collection is linked.
CHAR_TYPE_CD	8	Y	A	This field describes the data that is stored in the characteristic value field. Refer to characteristic type for more information.
SEQ_NUM	3	Y	N	This value is used to differentiate multiple characteristics of the same type. Values are typically incremented by 10.
CHAR_VAL	16	N	A	Populate this field if your characteristic type is predefined.
ADHOC_CHAR_VAL	254	N	A	Populate this field if your characteristic type is ad-hoc or file location.
CHAR_VAL_FK1 - CHAR_VAL_FK5	50 each	N	A	Populate these fields if your characteristic type is foreign key reference. Up to five columns of 50 bytes each are provided to accommodate compound keys.