Users

function

Each row of function identifies a Sierra Desktop Application function.

Column	Data Type	Not NULL?	Comment
id	int	false	System-generated sequential ID.
display_order	int	false	Integer to manage the display order of a list.
code	varchar	false	A code that corresponds to a Sierra Desktop Application function, such as Rapid Update, Global Update, Orders, and so forth.
function_category_id	int	false	Foreign key to function_category.

function_category

Each row of function_category identifies a Sierra Desktop Application function category.

Column	Data Type	Not NULL?	Comment
id	int	false	System-generated sequential ID.
display_order	int	false	Integer to manage the display order of a list.
code	varchar	false	A code corresponding to a Sierra Desktop Application category, such as Cataloging, Circulation, or Acquisitions.

iii_role

Each row of iii_role identifies an assignable user role.

Column	Data Type	Not NULL?	Comment
id	int	false	System-generated sequential ID.
code	varchar	false	A permission code. Refer to the Sierra WebHelp for a complete list of permissions used by Sierra.
iii_role_category_id	int	false	Foreign key to iii_role_category.
is_disabled_during_read_only_access	boolean	false	Specifies whether the role permission is disabled when the Sierra Desktop Application is in read-only mode.

iii_role_category

Each row of iii_role_category identifies a Sierra Desktop Application user role category.

Column	Data Type	Not NULL?	Comment
id	int	false	System-generated sequential ID.
code	varchar	false	Code corresponding to a role category. (Category names appear in iii_role_category_name.)

iii_role_category_name

Each row of iii_role_category_name defines a Sierra Desktop Application user role category name.

Column	Data Type	Not NULL?	Comment
iii_language_id	int	false	Foreign key to iii_language.
iii_role_category_id	int	false	Foreign key to iii_role_category.
name	varchar	false	The role category name.

iii_role_name

Each row of iii_role_name defines a Sierra user role name.

Column	Data Type	Not NULL?	Comment
iii_role_id	int	false	Foreign key to iii_role.
iii_language_id	int	false	Foreign key to iii_language.
name	varchar	false	The user role or "permission" name.

iii_user

Each row of iii_user defines a Sierra user login.

Column	Data Type	Not NULL?	Comment
id	int	false	System-generated sequential ID.
name	varchar	false	The user's login name.
location_group_port_number	int	false	The portloca ID (locations served) associated with this user. Typically '0'.
iii_user_group_code	varchar	false	The code representing the login group to which this login is assigned.
full_name	varchar	false	The user's full name.
iii_language_id	int	false	Foreign key to iii_language.
account_unit	int	false	The accounting unit to which the login is assigned.
statistic_group_code_num	int	false	The statistics group to which the login is assigned.
system_option_group_code_num	int	false	The number of the external options group the user belongs to. An asterisk (*) means no special options group.
timeout_warning_seconds	int	false	The number of seconds that the keyboard may be idle before the system issues a "timeout" warning.
timeout_logout_seconds	int	false	The number of seconds that the keyboard may be idle before the system "times out."
scope_menu_id	int	false	The login's scope.
scope_menu_bitmask	varchar	false	The record types and associated bitmasks for bib, authority, and attached records, as well as program records and their attached section records. Each bit in the bitmask corresponds to a particular scope rule (particular group of locations or BCODE values). If a bit is set to '1' in the bitmask, retrieved records which match the rule will be included in the displayed set. If a bit is set to '0', retrieved records which match the rule will be excluded from the displayed set. Bits are numbered from left to right, e.g., if the display is to be restricted to the location or BCODE value represented by bit 3, then the bitmask contains "001".
is_new_account	boolean	false	Indicates a new user account. If enhanced password functionality is enabled and the login_pw_chg_new EO is set to "true", new user accounts require a password change at the first login. 1 = new account 0 = not a new account
last_password_change_gmt	timestamptz	false	The time at which the password last was changed.
is_exempt	boolean	false	Specifies whether the login is exempt from extended password policy settings.
is_suspended	boolean	false	Specifies whether the login account is suspended.
is_context_only	boolean	false	Specifies whether the login is an SDA Context user only.

iii_user_application_myuser

Each row of iii_user_application_myuser identifies an application for which the user is authorized, with the application name presented in the language associated with the user's login account.

Column	Data Type	Not NULL?	Comment
iii_user_id	int	false	Foreign key to iii_user.
user_name	varchar	false	The user's login name.
application_code	varchar	false	The application code of the authorized application, for example, "milcat", "sysadmin", "webbridge", and so forth.
application_name	varchar	false	The name of the corresponding application.

iii_user_desktop_option

Each row of iii_user_desktop_option defines a Sierra Desktop Application option setting (option) for a user.

Column	Data Type	Not NULL?	Comment
id	int	false	System-generated sequential ID.
iii_user_id	int	false	Foreign key to iii_user.
desktop_option_id	int	false	Foreign key to desktop_option.
value	varchar	false	The Sierra Desktop Application option value.

iii_user_fund_master

Each row of iii_user_fund_master associates a user with a fund.

Column	Data Type	Not NULL?	Comment
id	int	false	System-generated sequential ID.
iii_user_id	int	false	Foreign key to iii_user.
fund_master_id	int	false	Foreign key to fund_master.

iii_user_group

Each row of iii_user_group defines a login user group.

Column	Data Type	Not NULL?	Comment
id	bigint	false	System-generated sequential ID.
code	varchar	false	The name of the login group
concurrent_max	int	false	Specifies the maximum number of concurrent users in the group.
is_independent	boolean	false	Specifies whether this login group does NOT count toward TOTAL logins. NOTE: Independent groups typically are used for alternate database logins, where the library wants to limit the number of users on an alternate db, but they do not want the logins to the alternate db to count against the TOTAL number of logins.

iii_user_iii_role

Each row of iii_user_iii_role associates a user with a role.

Column	Data Type	Not NULL?	Comment
iii_user_id	int	false	Foreign key to iii_user.
iii_role_id	int	false	Foreign key to iii_role.

iii_user_location

Each row of iii_user_location associates a user with a location code.

Column	Data Type	Not NULL?	Comment
id	int	false	System-generated sequential ID.
iii_user_id	int	false	Foreign key to iii_user.
location_code	varchar	false	A branch code.

iii_user_permission_myuser

Each row of iii_user_permission_myuser identifies a permission granted to a user, with the name presented in the language associated with the user's login account.

Column	Data Type	Not NULL?	Comment
iii_user_id	int	false	Foreign key to iii_user.
user_name	varchar	false	The user's login name.
permission_num	int	false	The permission number.
permission_code	varchar	false	The permission (passlevel) code.
permission_name	varchar	false	The permission (role) name.

iii_user_printer_myuser

Each row of iii_user_printer_myuser associates a user and a printer, with the printer name presented in the language associated with the user's login account.

Column	Data Type	Not NULL?	Comment
iii_user_id	int	false	Foreign key to iii_user.
user_name	varchar	false	The user's login name.
printer_code_num	int	false	The code number identifying the printer.
name	varchar	false	The corresponding printer name.

iii_user_workflow

Each row of iii_user_workflow associates a user with a Sierra Desktop Application workflow.

Column	Data Type	Not NULL?	Comment
id	int	false	System-generated sequential ID.
iii_user_id	int	false	Foreign key to iii_user.
workflow_id	int	false	Foreign key to workflow.
display_order	int	false	Integer to manage the display order of a list.

iii_user_workflow_myuser

Each row of iii_user_workflow_myuser associates a user with a Sierra Desktop Application workflow, with the workflow name presented in the language associated with the user's login account.

Column	Data Type	Not NULL?	Comment
iii_user_id	int	false	Foreign key to iii_user.
user_name	varchar	false	The user's login name.
workflow_name	varchar	false	The workflow name.
workflow_menu_name	varchar	false	The workflow name as it appear in the Sierra Desktop Application menu.
display_order	int	false	Integer to manage the display order of a list.

system_option_group

Each row of system_option_group specifies a user options group.

Column	Data Type	Not NULL?	Comment
id	int	false	System-generated sequential ID.
code_num	int	false	The code representing a user options group.

system_option_group_name

Each row of system_option_group_name specifies a user options group's name for the associated language.

Column	Data Type	Not NULL?	Comment
system_option_group_id	int	false	Foreign key to system_option_group.
iii_language_id	int	false	Foreign key to iii_language.
name	varchar	false	The user options group name for the associated language.

workflow

Each row of workflow defines a Sierra workflow.

Column	Data Type	Not NULL?	Comment
id	int	false	System-generated sequential ID.
display_order	int	false	Integer to manage the display order of a list.
name	varchar	false	The workflow name.

workflow_function

Each row of workflow_function associates a workflow with a Sierra function.

Column	Data Type	Not NULL?	Comment
id	int	false	System-generated sequential ID.
workflow_id	int	false	Foreign key to workflow.
function_id	int	false	Foreign key to function.
display_order	int	false	Integer to manage the display order of a list.

workflow_name

Each row of workflow_name specifies a workflow's menu name for the associated language.

Column	Data Type	Not NULL?	Comment
workflow_id	int	false	Foreign key to workflow.
iii_language_id	int	false	Foreign key to iii_language.
menu_name	varchar	false	The workflow menu name for the associated language.