Table Name:	campaign
Table Number:	5016
Group:	Sales Mgr
Description:	A set of information about a marketing program that potentially results in downstream sales activity. Examples include advertising campaigns, trade shows, seminars, etc
Flags:
Baseline/Custom:	Baseline

select * from table_campaign

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
arch_ind	LONG	int				DIRECT, ALLOW_NULL	When set to 1, indicates the object is ready for purge/archive
audience	CHAR	varchar		80			Target audience for the campaign	Search (1)
budget_amt	DECIMAL	decimal (19,4)				CURRENCY	Goal in currency for the cost of the campaign	Search (1)
cam_code	CHAR	varchar		20			Campaign code; from a user-defined pop up list
cam_type	CHAR	varchar		40			Type of marketing campaign: This is a user-defined pop up with default name Campaign Type	Search (1)
cost	DECIMAL	decimal (19,4)				CURRENCY	Amount spent on campaign	Search (1)
description	CHAR	varchar		255			Description of the campaign	Search (1)
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
end_date	CLK_TIME	datetime					The ending date for the campaign	Search (1)
ext_rsrc	CHAR	varchar		50			Description of external resources working on the campaign
int_rsrc	CHAR	varchar		50			Description of internal resources working on the campaign
name	CHAR	varchar		80			Name of the campaign	Search (4)
objective	CHAR	varchar		255			What the campaign is intended to achieve	Search (1)
objid	LONG	int	3			DIRECT	Internal record number	Search (6)
opps_goal	LONG	int				DIRECT	Goal in number of opportunities generated from the campaign	Search (1)
products	CHAR	varchar		80			Product families addressed by the campaign	Search (1)
revenue_goal	DECIMAL	decimal (19,4)				CURRENCY	Goal in currency of revenue generated from the campaign	Search (1)
start_date	CLK_TIME	datetime					The starting date for the campaign	Search (1)
status	CHAR	varchar		40			Status of the campaign. This is a user-defined popup with default name Campaign Status	Search (1)
won_goal	LONG	smallint				DIRECT	Goal in number of deals won from the campaign	Search (1)

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	MTM Table	Used in Views
campaign2call_script	MTM	call_script	scr2campaign	Call scripts used in the campaign	mtm_campaign4_ call_script0
cam2cam_per_role	OTM	cam_per_role	cam_role2campaign	People resources for the campaign. Reserved; not used
campaign2contact	MTM	contact	contact2campaign	Contacts for the campaign. Reserved; obsolete. See con_lsc_role	mtm_contact17_ campaign6
campaign2currency	MTO	currency	currency2campaign	Currency in which campaign is denominated		Search (1)
campaign2doc_inst	OTM	doc_inst	doc_inst2campaign	Documents for the campaign
campaign2lead_source	OTM	lead_source	source2campaign	Related lead source
campaign2price_prog	MTO	price_prog	price_prog2campaign	Price program used for the campaign		Search (1)
campaign2proc_inst	OTM	proc_inst	proc_inst2campaign	Sales campaign that runs this process/script
campaign2process	MTM	process	process2campaign	Sales campaigns that may run this process/script	mtm_campaign9_ process6
campaign2scr_run	OTM	scr_run	scr_run2campaign	Call scripts run from the campaign
cam_owner2user	MTO	user	curr_owner2campaign	User responsible for the campaign		Search (1)

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags
campaign_ind	name	UNIQUE

Indexes (Defined in Database):

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

Referenced in Views:

View ID	View Name	Tables
5071	cmp_lsc_opp	campaign, gbst_lst, lead_source, opportunity, user
5075	cmp_lsc	campaign, lead_source
5217	ccc_rundsply	bug, bus_org, campaign, case, contact, contr_itm, contract, demand_dtl, employee, lead_source, opportunity, probdesc, scr_run, site, site_part, subcase, task
5345	sfa_camp_v	campaign, currency, price_prog, user
5346	sfa_leadsrc	campaign, lead_source
5503	campaign_lead_source	campaign, lead_source

My Recent Objects

campaign

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