Document toolboxDocument toolbox

sp088_user_units

Owned by Jason Andrew
Oct 02, 2024

This table stores users' Gantt Profile settings.

 If we need to change the 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_idvarchar2(50) (error)
unit_typenumber(1) (error)
unit_nonumber(4) (error)

Keys

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

Column Descriptions

FieldDescription
user_idIs 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_noIs the unit number referring to Root, BRU, DRU or FRU.