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