Document toolboxDocument toolbox

sp089_user_categories

This table stores user categories to determine whether a user is a 'system' level user, or a 'standard' level user.


 

Table Definition

Field
Type
Default
Nullable
user_categorynumber(3) (error)
descriptionvarchar2(30) (error)
field_idvarchar2(100) (error)

Keys

primary key (user_category) 

Primary Key Referenced From

 

 Column Descriptions

FieldDescription
user_category

Is the category for this particular user

  • 0 = system
  • null or 1 = standard.
descriptionname for the category.
field_idkey to language translations in sp900 for description.