Table Name:	transition
Table Number:	300
Group:	Policy Mgr
Description:	Defines allowable transitions of Change Request or Part Request from one status to another based on privilege class
Flags:
Baseline/Custom:	Baseline

Fields
Relations
Indexes
Referenced in Views

select * from table_transition

Keyboard shortcuts available

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
appl_id	CHAR	varchar		20			Clarify application identifier
description	CHAR	varchar		255			Description of the transition	Search (1)
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
dialog_id	LONG	int				DIRECT	ID of form which should be posted during the transition	Search (1)
focus_subtype	CHAR	varchar		40			Subtype of the focus object; e.g.,demand_dtl.demand_subtype. From user-defined popup with default name RMA_TYPE	Search (1)
focus_type	LONG	smallint				DIRECT	Object type ID (e.g., case=0, probdesc=1) of the transition's focus object. The combination of focus_type and focus_subtype fully identify the transition's focus object	Search (1)
name	CHAR	varchar		40			Name of the transition
objid	LONG	int	3			DIRECT	Internal record number	Search (1)
rank	LONG	int	9			DIRECT	The sequence number of a transition. It relates to an entry in the trans_mask field of the privclass object	Search (1)
status	LONG	smallint			0	DIRECT	0=inactive, 1=active

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Flags	MTM Table	Used in Views
from_state2gbst_elm	MTO	gbst_elm	from_state2transition	The from state of the state transition			Search (1)
to_state2gbst_elm	MTO	gbst_elm	to_state2transition	The permitted to state of the state transition			Search (1)

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags
transitn_index	rank:focus_type:focus_subtype	UNIQUE

Indexes (Defined in Database):

Index Name	Fields	Additional Information
focus_index	focus_type, focus_subtype	nonclustered located on PRIMARY
ind_from_state2gbst_elm	from_state2gbst_elm, to_state2gbst_elm	nonclustered located on PRIMARY
ind_to_state2gbst_elm	to_state2gbst_elm, from_state2gbst_elm	nonclustered located on PRIMARY
objindex	objid	clustered, unique located on PRIMARY
transitn_index	rank, focus_type, focus_subtype	nonclustered, unique located on PRIMARY

Referenced in Views:

View ID	View Name	Tables
301	trans_view	gbst_elm, gbst_lst, transition

My Recent Objects

transition

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user