14.1 sp086_user_preferences

This table stores ServiceManager's users' settings.

Table Definition

Field	Type	Default	Nullable
user_id	varchar2(50)
start_date_offset	number(3)
start_date_offset_type	number(1)
end_date_offset	number(3)
end_date_offset_type	number(1)
working_week_days	number(3)
expand_menu	number(1)
default_selection_set	long raw
chart_view_style	number(1)

primary key (user_id)

foreign key (user_id) references 14.1 sp085_users (user_id)

Field	Description
user_id	Is the reference to the user who owns this persistence data.
start_date_offset	The offset from the System Effective Date in units identified by start_date_offset_type that represents the start of the default date range (can be –ve)
start_date_offset_type	An enumeration where 0 represents 'Days', 1 represents 'Weeks', 2 represents 'Months' and 3 represents 'Years'
end_date_offset	The offset from the start of the default date range in units identified by end_date_offset_type that represents the end of the default date range (can be –ve)
end_date_offset_type	An enumeration where 0 represents 'Days', 1 represents 'Weeks', 2 represents 'Months' and 3 represents 'Years'
working_week_days	The days (delimited by commas) number from 0 that define the 'working week'
expand_menu	1 specifies to Expand the menu at startup, otherwise 0
default_selection_set	The set of Operative references (sp210_employees.employee_ref) comprising the default set of operatives
chart_view_style	Specifies the default chart scale to be applied for this user (Operative Availability Chart View). 1 - single day; 2 - seven day; 3 - working week days.