14.1 sp088_user_units

This table stores users' Gantt Profile settings.

If we need to change the 14.1 sp088_user_units table definition, it is important to consider the impact of that change to the use of sp_ldap utlity and make appropriate changes in sp_ldap usage.

Table Definition

Field	Type	Default	Nullable
user_id	varchar2(50)
unit_type	number(1)
unit_no	number(4)

Keys

primary key (user_id, unit_type, unit_no)
foreign key (user_id) references 14.1 sp085_users (user_id)

Column Descriptions

Field

Description

user_id

Is the reference to the user who owns this persistence data.

unit_type

Is the value which determines which table the unit no refers to, for example

0 = Root, 1 = reserved, 2 = BRU, 3 = reserved, 4 = DRU and 5 = FRU.

A type of BRU requires a lookup on table SP051_BRUS and a type of DRU requires a lookup on table SP053_DRUS.

unit_no

Is the unit number referring to Root, BRU, DRU or FRU.