Table Name:	privclass
Table Number:	33
Group:	System
Description:	Defines user privilege classes; i.e., what commands and functions groups of users have/do not have access to
Flags:
Baseline/Custom:	Baseline

select * from table_privclass

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
access_mask	CHAR	varchar		80			Reserved; not used
access_type	LONG	tinyint			0	DIRECT	Defines the type access of the privilege class: 0=online (WAN/LAN); 1=offline (remote)
CCN_allowed	LONG	int				DIRECT	Reserved; obsolete
class_name	CHAR	varchar		80			Privilage class name	Search (2)
CLFO_allowed	LONG	int				DIRECT	Reserved; obsolete
CQ_allowed	LONG	int				DIRECT	Reserved; obsolete	Search (1)
CS_allowed	LONG	int				DIRECT	Reserved; obsolete	Search (1)
db_permission	LONG	int				DIRECT	Reserved; internal
description	CHAR	varchar		255			Description of the purpose/use of the privilege class
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
member_type	CHAR	varchar		30			Type of users who can be added to the class; i.e., 0=employee, 1=contacts
objid	LONG	int	3			DIRECT	Internal record number	Search (6)
owner_case_mod	LONG	int				DIRECT	Indicates if the class of user can perform non-owner mods on case
owner_cr_mod	LONG	int				DIRECT	Indicates if the class of user can perform non-owner mods on bug
owner_rma_mod	LONG	int				DIRECT	Indicates if the class of user can perform non-owner mods on part request
owner_sbcse_mod	LONG	int				DIRECT	Indicates if the class of user can perform non-owner mods on subcase
owner_sol_mod	LONG	int				DIRECT	Indicates if the class of user can perform non-owner mods on solution
owner_subc_add	LONG	int				DIRECT	Indicates if the class of user can add subcases to cases they do not own
pswrd_exp_per	LONG	int				DIRECT	Number of days password can remain active
remote_allowed	LONG	int				DIRECT	Indicates if the class of user can dispatch to remote queues
SFA_allowed	LONG	int				DIRECT	Reserved; obsolete
trans_mask	CHAR	varchar		255			A position number in the field relates to a value of the rank field of the transition object. A value of 1 in a position enables the corresponding transition for the privclass
warning_period	LONG	int				DIRECT	Number of days before password will expire that warning messages should begin to be sent to user at time of login

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Flags	MTM Table
privclass2control_db	MTM	control_db	control_db2privclass	Controls that are disabled for the privilege class		mtm_privclass1_ control_db2
privclass2menu_item	MTM	menu_item	menu_item2privclass	Pulldown commands that are disabled for the privilege class		mtm_privclass3_ menu_item1
privclass2object	OTM	object_secure	object2privclass	Related object restriction for the privclass
privclass2readonly	OTM	readonly	readonly2privclass	Forms that are read-only for the privilege class. Reserved; future
privclass2rpt	MTM	rpt	rpt2privclass	Reports that are unavailable for the privilege class. Reserved; future		mtm_privclass4_ rpt2
privclass2rqst_def	MTM	rqst_def	rqst_def2privclass	Related service request for the privclass		mtm_privclass9_ rqst_def3
priv_access2user	OTM	user	user_access2privclass	Users who have been assigned the privilege class
offline_access2user	OTM	user	offline2privclass	Users who are assigned to this offline privilege class
privclass2value_item	MTM	value_item	value_item2privclass	Value items assigned to the privclass		mtm_privclass7_ value_item2
privclass2web_object	MTM	web_object	web_object2privclass	Web objects assigned to the privilege class		mtm_privclass8_ web_object0
privclass2wgroup_offline	OTM	workgroup	wgroup_offline2privclass	offline privelege class for related workgroup	USER_DEFINED
privclass2wgroup_online	OTM	workgroup	wgroup_online2privclass	online privelege class for related workgroup	USER_DEFINED
privclass2x_web_cmd	MTM	x_web_cmd	x_web_cmd2privclass	Web commands assigned to the privclass	USER_DEFINED	mtm_privclass10_ x_web_cmd0

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags
class_index	class_name	UNIQUE

Indexes (Defined in Database):

Index Name	Fields	Additional Information
class_index	class_name	nonclustered, unique located on PRIMARY
objindex	objid	clustered, unique located on PRIMARY

Referenced in Views:

View ID	View Name	Tables
321	priv_controls	control_db, privclass, window_db
322	priv_readonly	privclass, readonly, window_db
323	priv_menu_item	menu_bar, menu_item, privclass
5165	web_usrlst	employee, privclass, user, web_user
5296	priv_ctxtmenu	control_db, privclass, value_item, window_db
5509	web_object_priv	privclass, web_object
5840	priv_svc_rqst	privclass, rqst_def, svc_type

My Recent Objects

privclass

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user

alt-s	Execute SQL
alt-t	Execute SQL, getting latest 10 rows
?	Bring up this help dialog