Table Name:	scr_run
Table Number:	5209
Group:	Script Mgr
Description:	Represents an instance of the execution of a call script
Flags:
Baseline/Custom:	Baseline

select * from table_scr_run

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
arch_ind	LONG	int			0	DIRECT, ALLOW_NULL	When set to 1, indicates the object is ready for purge/archive
create_date	CLK_TIME	datetime					Reserved; future	Search (1)
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
end_time	CLK_TIME	datetime					Ending date and time of the call script run	Search (2)
init_ind	LONG	tinyint			0	DIRECT	Initiate whether the script run was initiated from another object; i.e., 0=no, 1=yes, default=0
node_key	CHAR	varchar		255			Used for rollup of script runs. Holds the sequence of objid of the script runs within a single user session	Search (1)
objid	LONG	int	3			DIRECT	Internal record number	Search (2)
result	CHAR	varchar		20			Result of the script: e.g., was it completed, abandoned, and why? Filled in from a user-defined popup list with default name	Search (1)
score	LONG	int				DIRECT	Total score attained during the run of the call script	Search (2)
start_time	CLK_TIME	datetime					Starting date and time of the call script run	Search (2)
title	CHAR	varchar		255			Name of the script that was run	Search (2)

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Used in Views
scr_run2bug	MTO	bug	bug2scr_run	The change request which initiated the script run	Search (1)
scr_run2bus_org	MTO	bus_org	bus_org2scr_run	The business organization which initiated the script run	Search (1)
scr_run2call_script	MTO	call_script	scr2scr_run	Call script that was executed
scr_run2campaign	MTO	campaign	campaign2scr_run	The campaign which initiated the script run	Search (1)
scr_run2case	MTO	case	case2scr_run	The case which initiated the script run	Search (1)
scr_run2contact	MTO	contact	contact2scr_run	Contact who initiated the script
scr_run2contr_itm	MTO	contr_itm	contr_itm2scr_run	The contract/quote item which initiated the script run	Search (1)
scr_run2contract	MTO	contract	contract2scr_run	The contract/quote which initiated the script run	Search (1)
scr_run2demand_dtl	MTO	demand_dtl	demand_dtl2scr_run	The part request which initiated the script run	Search (1)
scr_run2employee	MTO	employee	employee2scr_run	The employee who initiated the script run	Search (1)
scr_run2interact	MTO	interact	interact2scr_run	Interaction which triggered the script run
scr_run2lead	MTO	lead	lead2scr_run	If the script was run for a lead, the related lead
scr_run2lead_source	MTO	lead_source	source2scr_run	The lead_source which initiated the script run	Search (1)
scr_run2opportunity	MTO	opportunity	opp2scr_run	The opportunity which initiated the script run	Search (1)
scr_run2probdesc	MTO	probdesc	probdesc2scr_run	The solution which initiated the script run	Search (1)
scr_run2scr_response	OTM	scr_response	response2scr_run	Actual responses to the script which was run
all2scr_response	OTM	scr_response	first_scr2scr_run	For the initial script run in a set of scripts run together, all responses that were made during the session to all the scripts used
first2scr_run	OTM	scr_run	run_with2scr_run	Other script runs which followed the current run
run_with2scr_run	MTO	scr_run	first2scr_run	The first script run in a session of which this was part
scr_run2site	MTO	site	site2scr_run	The site which initiated the script run	Search (1)
scr_run2site_part	MTO	site_part	site_part2scr_run	The site part which initiated the script run	Search (1)
scr_run2subcase	MTO	subcase	subcase2scr_run	The subcase which initiated the script run	Search (1)
scr_run2task	MTO	task	task2scr_run	The task which initiated the script run	Search (1)
administered2user	MTO	user	admin2scr_run	User who administered the call script

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags

Indexes (Defined in Database):

Index Name	Fields	Additional Information
ind_administered2user	administered2user	nonclustered located on PRIMARY
ind_run_with2scr_run	run_with2scr_run	nonclustered located on PRIMARY
ind_scr_run2call_script	scr_run2call_script	nonclustered located on PRIMARY
ind_scr_run2interact	scr_run2interact	nonclustered located on PRIMARY
objindex	objid	clustered, unique located on PRIMARY

Referenced in Views:

View ID	View Name	Tables
5216	ccc_srun_v	scr_response, scr_run, scrqstn_rspns
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

My Recent Objects

scr_run

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