Table Name:	cycle_stage
Table Number:	5013
Group:	Task Mgr
Description:	Specifies a stage in a life cycle
Flags:
Baseline/Custom:	Baseline

Fields
Relations
Indexes
Referenced in Views

select * from table_cycle_stage

Keyboard shortcuts available

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
buyer_actions	CHAR	varchar		255			Actions that the buyer must perform
close_days	LONG	smallint				DIRECT	Average number of days to close from the stage
close_pct	FLOAT	real					Average percent of deals that eventually close from the stage	Search (1)
description	CHAR	varchar		255			Description of the stage
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
fallout_pct	FLOAT	real					Average percent of deals that do not move forward to the next stage
in_days	LONG	smallint				DIRECT	Average number of days spent in the stage
name	CHAR	varchar	2	50			Name of the stage	Search (10)
num_calls	LONG	smallint				DIRECT	Average number of calls in the stage
objective	CHAR	varchar		255			Objective or desired outcome of the stage
objid	LONG	int	3			DIRECT	Internal record number	Search (8)
seller_actions	CHAR	varchar		255			Actions that the seller must perform
stage_id	CHAR	varchar		25			Identifier of the stage within life cycle

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Flags	MTM Table	Used in Views
stage2cls_group	OTOP	cls_group	group2cycle_stage	Factory group which implements the stage
stage_status2gbst_elm	MTO	gbst_elm	status2cycle_stage	Status assigned to the cycle stage			Search (1)
stage2opportunity	OTM	opportunity	opp2cycle_stage	Opportunities in the stage
stage2stage_assign	OTM	stage_assign	assign2cycle_stage	Life cycle assignment
stage2stage_metric	OTM	stage_metric	metric2cycle_stage	Metrics for the stage
stage2task_set	MTM	task_set	task_set2cycle_stage	Task sets assigned to the stage		mtm_cycle_stage5_ task_set3
stage2tsk_stg_role	OTM	tsk_stg_role	role2cycle_stage	Tasks assigned to the life cycle stage

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags
cycle_stage_ind	stage_id	UNIQUE

Indexes (Defined in Database):

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

Referenced in Views:

View ID	View Name	Tables
4622	fc_acct_opp_view	bus_opp_role, bus_org, currency, cycle_stage, opportunity, user
5073	opp_view	condition, cycle_stage, opportunity, user
5095	con_opp_view	con_opp_role, contact, currency, cycle_stage, opportunity, user
5105	stgassign_v	cycle_stage, life_cycle, stage_assign
5230	oppempl_view	cycle_stage, employee, opportunity, territory, user
5341	sfa_opp_v	bus_opp_role, bus_org, currency, cycle_stage, opportunity, user
5355	sfa_stage_v	cycle_stage, gbst_elm, gbst_lst, life_cycle, stage_assign
5357	sfa_opp_mto_v	currency, cycle_stage, lead_source, life_cycle, opportunity, territory
5597	iclient_opp_view	condition, currency, cycle_stage, opportunity, user
5742	opp_summary_v	currency, cycle_stage, lead_source, life_cycle, opportunity, territory

My Recent Objects

cycle_stage

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user