Table Name:	workgroup
Table Number:	3516
Group:	Workflow Mgr
Description:
Flags:
Baseline/Custom:	Custom

Fields
Relations
Indexes
Referenced in Views

select * from table_workgroup

Keyboard shortcuts available

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
dev	LONG	int	151			USER_DEFINED, ALLOW_NULL	Row version number for mobile distribution purposes
objid	LONG	int	3			USER_DEFINED	Internal record number
work_group	CHAR	varchar		20		USER_DEFINED
x_act_supervisor	LONG	int				USER_DEFINED	acting supervisor status for new member of this workgroup
x_after_notify_high	CHAR	varchar		80		USER_DEFINED	list element index for high priority employee notification
x_after_notify_low	CHAR	varchar		80		USER_DEFINED	list element index for low priority employee notification
x_after_notify_med	CHAR	varchar		80		USER_DEFINED	list element index for medium priority employee notification
x_allow_proxy	LONG	int				USER_DEFINED	allow proxy checkbox status for new member of this workgroup
x_fax	CHAR	varchar		20		USER_DEFINED	fax number for new member of this workgroup
x_field_eng	LONG	int				USER_DEFINED	field engineer checkbox status for new member of the workgroup
x_labor_rate	DECIMAL	decimal (19,4)				USER_DEFINED, CURRENCY	labor rate for new member of this workgroup
x_mail_stop	CHAR	varchar		30		USER_DEFINED	mail stop for new member of this workgroup
x_notify_high	CHAR	varchar		80		USER_DEFINED	list element index for high priority employee notification
x_notify_low	CHAR	varchar		80		USER_DEFINED	list element index for low priority employee notification
x_notify_med	CHAR	varchar		80		USER_DEFINED	list element index for medium priority employee notification

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Flags	MTM Table	Used in Views
wgroup_super2empl	MTO	employee	empl2wgroup_super		USER_DEFINED
wgroup_offline2privclass	MTO	privclass	privclass2wgroup_offline		USER_DEFINED
wgroup_online2privclass	MTO	privclass	privclass2wgroup_online		USER_DEFINED
workgroup2queue	MTM	queue	queue2workgroup		USER_DEFINED	mtm_queue27_ workgroup0
workgroup2rc_config	MTO	rc_config	rc_config2workgroup		USER_DEFINED
workgroup2site	MTO	site	site2workgroup		USER_DEFINED
workgroup2wk_work_hr	MTO	wk_work_hr	wk_work_hr2workgroup		USER_DEFINED

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags

Indexes (Defined in Database):

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

Referenced in Views:

View ID	View Name	Tables

My Recent Objects

workgroup

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user