Table Name:	user
Table Number:	20
Group:	Resource Mgr
Description:	System object; defines a database user with login name and password
Flags:
Baseline/Custom:	Baseline

select * from table_user

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
agent_id	CHAR	varchar		30			Used by ACD to identify agent number	Search (1)
alt_login_name	CHAR	varchar		30			Alternate systems login name
CCN_Lic	CLK_TIME	datetime				DONT_DISTR_TO_CLIENT, DONT_DISTR_TO_SERVER	Date/time Sales Force Automation License checked out
CLFO_Lic	CLK_TIME	datetime				DONT_DISTR_TO_CLIENT, DONT_DISTR_TO_SERVER	Date/timeClear Logistics License checked out
CQ_Lic	CLK_TIME	datetime				DONT_DISTR_TO_CLIENT, DONT_DISTR_TO_SERVER	Date/time ClearQuality License checked out
cq_lic_type	LONG	int				DIRECT	0=CQ, 1=CQ-FTS
CQFTS_Lic	CLK_TIME	datetime				DONT_DISTR_TO_CLIENT, DONT_DISTR_TO_SERVER	Reserved; internal
CS_Lic	CLK_TIME	datetime				DONT_DISTR_TO_CLIENT, DONT_DISTR_TO_SERVER	Date/time ClearSupport License checked out
cs_lic_type	LONG	int				DIRECT	0=CS, 1=CS-DE, 2=CS-FTS, 3=CS-FTS-DE
CSDE_Lic	CLK_TIME	datetime				DONT_DISTR_TO_CLIENT, DONT_DISTR_TO_SERVER	Date/time ClearSupport Diagnosis Engine License checked out
CSFTS_Lic	CLK_TIME	datetime				DONT_DISTR_TO_CLIENT, DONT_DISTR_TO_SERVER	Date/time ClearSupport Full Text Search License checked out
CSFTSDE_Lic	CLK_TIME	datetime				DONT_DISTR_TO_CLIENT, DONT_DISTR_TO_SERVER	Date/time ClearSupport Full Text Search and DE License checked out
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
dkt_layout	ARRAY		1	0		DIRECT, BINARY	Associated binary array object	Search (125)
equip_id	CHAR	varchar		30			Used by ACD to identify telephone set ID	Search (1)
last_login	CLK_TIME	datetime				DONT_DISTR_TO_CLIENT, DONT_DISTR_TO_SERVER	Date/Time of last successful login by the user
locale	LONG	smallint			0	DIRECT	Preferred language for receiving communications from the system; i.e., 0=English, 1=SJIS, 2=French, 3=German, 4=Spanish, 5=Chinese Big5 (traditional character), 6=Chinese GB (simplified character), 7=Korean, 8-12 (Reserved), Default=0
login_name	CHAR	varchar	2	30			User login name	Search (146)
node_id	CHAR	varchar		3			Base36 string representation of Node ID. Used by distribution engine	Search (2)
objid	LONG	int	3			DIRECT	Internal record number	Search (125)
passwd_chg	CLK_TIME	datetime					Date/Time password was last changed; used to check for expiration of password
password	CHAR	varchar		30			User password	Search (1)
SFA_Lic	CLK_TIME	datetime				DONT_DISTR_TO_CLIENT, DONT_DISTR_TO_SERVER	Date/time ClearSales License checked out
status	LONG	int			1	DIRECT	User status; i.e., 0=inactive, 1=active, default=1	Search (11)
submitter_ind	LONG	smallint			0	DIRECT	User has Web submitter privileges; i.e., 0=no, 1=yes. Reserved; not used
UNIV_Lic	CLK_TIME	datetime				DONT_DISTR_TO_CLIENT, DONT_DISTR_TO_SERVER	Date/time Universal License checked out
web_login	CHAR	varchar		30			User's Web login name. Reserved; not used
web_password	CHAR	varchar		30			User's Web password. Reserved; not used
wireless_email	CHAR	varchar		80			User's wireless email address
x_authtoken	CHAR	varchar		128		USER_DEFINED	Authorization token used to authenticate web service calls on behalf of this user
x_notify	LONG	int				USER_DEFINED	Controls Dovetail Agent Notifier; 0=Off, 1=On
x_notify_color1	CHAR	varchar		30		USER_DEFINED	fcClinet Notifier; Color of new messages in grid
x_notify_frequency	LONG	int				USER_DEFINED	Dovetail Agent Notifier; Frequency (in seconds) to check for new messages
x_notify_immediate	LONG	int				USER_DEFINED	Dovetail Agent Notifier; Should notify window be fronted upon new messages; 0=No; 1=Yes
x_num_recent_obj	LONG	int				USER_DEFINED	Number of recent objects to display
x_signature	CHAR	text				USER_DEFINED	User's email signature
x_slack_member_id	CHAR	varchar		80		USER_DEFINED	Slack Member ID
x_windows_login_name	CHAR	varchar		128		USER_DEFINED	Used for Windows Authentication to map a {domain}\{username} to a Clarify user	Search (1)

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Flags	MTM Table	Used in Views	Set Name	Type ID Stored in	Objid Stored In
								Exclusive Set Relations
user_access2acd_call	OTM	acd_call	acd_call_empl2user	User's ACD calls
originator2act_entry	OTM	act_entry	act_entry2user	Activity log entries created by the user
user2agent	OTM	agent	agent2user	ACD agents owned by the user
user2alert	OTM	alert	last_update2user	Alerts created or last modified by the user
user2asaf_result	OTM	asaf_result	asaf_result2user	Service interuption report results generated by the user. Reserved; option
originator2bug	OTM	bug	bug_originator2user	Change requests originated by the user
owner2bug	OTM	bug	bug_owner2user	Change requests owned by the user
orig2call_script	OTM	call_script	scr_originator2user	Call scripts originated by the user
curr_owner2campaign	OTM	campaign	cam_owner2user	Campigns user is responsible for
user2canned_response	OTM	canned_resp	canned_response2user	Canned responses created by this user	USER_DEFINED
curr_owner2case	OTM	case	case_owner2user	Cases owned by the user
originator2case	OTM	case	case_originator2user	Cases originated by the user
user2ce_iconified	OTM	ce_iconified	ce_iconified2ce_user	The users who have this query iconified	USER_DEFINED
user2ce_param	OTM	ce_param	ce_param2user	The CE clause parameters for this user	USER_DEFINED
user2ce_query	OTM	ce_query	ce_query2user	Personal queries for this user	USER_DEFINED
refused_queries2ce_query	MTM	ce_query	ce_query2refused_by	Users who reject this shared query	USER_DEFINED	mtm_user116_ ce_query3
shared_queries2ce_query	MTM	ce_query	ce_query2shared_to	Users who accept this shared query	USER_DEFINED	mtm_user115_ ce_query2
user2ce_query_col	OTM	ce_query_col	ce_query_col2user		USER_DEFINED
owner2cls_factory	OTM	cls_factory	factory2user	Templates owned by the user
originator2commit_log	OTM	commit_log	commit_owner2user	User's commitment logs
user_prefs2config_itm	MTM	config_itm	config_itm2user	Configuration preferences for the user		mtm_user50_ config_itm0
user2console_columns	OTM	console_columns	console_columns2user		USER_DEFINED
employees2contact	OTOF	contact	caller2user	Related contact information if user is also a contact
owner2contract	OTM	contract	owner2user	Contracts owned by the user
admin2contract	OTM	contract	contract2admin	Contracts which the user administers
originator2contract	OTM	contract	contr_originator2user	Contract records originated by the user
user2dataset	MTM	dataset	dataset2user	Datasets for this user		mtm_user53_ dataset1
user2user_setting	OTM	db_geom	user_setting2user	Per user geometry information
curr_owner2demand_dtl	OTM	demand_dtl	demand_dtl_owner2user	Part request records owned by the user
originator2demand_dtl	OTM	demand_dtl	demand_dtl_orig2user	Part request records originated by the user
curr_owner2demand_hdr	OTM	demand_hdr	current_owner2owner	Demand header records owned by the user
originator2dialogue	OTM	dialogue	dialogue_orig2user	Dialogues originated by the user
curr_owner2dialogue	OTM	dialogue	dialogue_owner2user	Dialogues owned by the user
originator2disptchfe	OTM	disptchfe	disptchfe_orig2user	Field engineer dispatches originated by the user
user2srvr	MTO	dist_srvr	srvr2user	Home server of the user. Reserved
user2dt_notice	MTM	dt_notice	dt_notice2user		USER_DEFINED	mtm_user134_ dt_notice0
user2dt_search	OTM	dt_search	dt_search2user		USER_DEFINED
user2dt_task	OTM	dt_task	dt_task2user	Tasks with a workflow item that assign to the user	USER_DEFINED
user2dt_token	OTM	dt_token	dt_token2user		USER_DEFINED
user2dt_web_log	OTM	dt_web_log	dt_web_log2user		USER_DEFINED
user2employee	OTOF	employee	employee2user	Related employee information if the user is also an employee
originator2escalation	OTM	escalation	escalate2user	Reserved; not used
user2exc_usr_role	OTM	exc_usr_role	exc_usr_role2user	Exchange roles for the user
user2exch_log	OTM	exch_log	exch_log2user	Exchange entries made by the user
user2fc_login_monitor	OTM	fc_login_monitor	fc_login_monitor2user		USER_DEFINED
curr_owner2fcs_used	OTM	fcs_detail	curr_owner2owner	Reserved; custom
curr_owner2fcs_header	OTM	fcs_header	cur_owner2owner	Reserved; custom
user2filter_query	OTM	filter_query	filter_query2user		USER_DEFINED
user2favorite_query	MTM	filter_query	favorite_query2user		USER_DEFINED	mtm_user128_ filter_query3	Search (1)
user2filter_sort	MTM	filter_sort	filter_sort2user		USER_DEFINED	mtm_user131_ filter_sort1
creator2filter_sub	OTM	filter_sub	filter_sub2creator	User who created the filter_query subscription.	USER_DEFINED
user2filter_sub	OTM	filter_sub	filter_sub2user	Users can have many filter_query subscriptions.	USER_DEFINED
originator2filterset	OTM	filterset	filterset2user	Filtersets created by the user
user2fr_agrmnt	OTM	fr_agrmnt	fr_agrmnt2user	Framework agreements owned by a user
originator2frcst_itm	OTM	frcst_itm	originator2user	Forecast items originated by the user. Reserved; obsolete. User's territory role now owns the frcst_itm
user2frcst_target	OTM	frcst_target	frcst_target2user	Forecast targets owned by the user. Reserved; obsolete. Ter_usr_role now links the user to their forecast targets
user_access2group	MTM	group	assigned_group2user	Reserved; obsolete		mtm_user19_ group2
user2interact	OTM	interact	interact2user	Interactions administered by the user
trial_by2inv_count	OTM	inv_count	trial_by2user	Last trial reconciliation performed by the user
init_by2inv_count	OTM	inv_count	init_by2user	Inventory counts initialized by the user
counted_by2inv_count	OTM	inv_count	counted_by2user	Inventory counts counted by the user
recounted_by2inv_count	OTM	inv_count	recounted_by2user	Inventory counts recounted by the user
entered_by2inv_count	OTM	inv_count	entered_by2user	Inventory counts physically entered into the system by the user
originator2job	OTM	job	job_originator2user	Jobs originated by the user
curr_owner2job	OTM	job	job_owner2user	Jobs owned by the user
lead_orig2lead	OTM	lead	lead_orig2user	Leads originated by the user
lead_owner2lead	OTM	lead	lead_owner2user	Leads currently owned by the user
lead_modifier2lead	OTM	lead	lead_modifier2user	Leads last modified by the user
lit_owner2lit_req	OTM	lit_req	lit_owner2user	Literature request templates owned by the user
lit_orig2lit_req	OTM	lit_req	lit_orig2user	Literature request templates originated by the user
curr_owner2loc_inq	OTM	loc_inq	loc_inq_owner2user	Reserved; future
user_access2monitor	MTM	monitor	monitor2user	Reserved; obsolete		mtm_user20_ monitor0
supvr_default2monitor	OTOP	monitor	def_monitr_supr2user	Reserved; obsolete
supvr_access2monitor	MTM	monitor	super_monitor2user	Reserved; obsolete		mtm_user26_ monitor2
user2N_Breakpoints	OTM	N_BreakPoints	n_brkpnt2user	Workshop debugging breakpoints for the user
user2N_Watches	OTM	N_Watches	n_wtch2user	Workshop debugging watches for the user
originator2notes_log	OTM	notes_log	notes_owner2user	User's notes logs
user2offering	OTM	offering	offering2user	Offerings owned by a user
originator2onsite_log	OTM	onsite_log	onsite_owner2user	User's T&E logs
owner2opportunity	OTM	opportunity	opp_owner2user	Opportunity records owned by the user
originator2opportunity	OTM	opportunity	opp_originator2user	Opportunity records originated by the user
viewer2opportunity	MTM	opportunity	opp_viewer2user	Opportunities which have been viewed by users		mtm_user97_ opportunity38
user2page_class	MTO	page_class	page_class2user	User's resource configuration			Search (2)
curr_owner2part_trans	OTM	part_trans	part_trans_owner2user	Reserved; future
assigned_eng2part_used	OTM	part_used	part_used2assigned_eng	Parts used transactions performed by the user
user2participant	OTM	participant	participant2user		USER_DEFINED
originator2phone_log	OTM	phone_log	phone_owner2user	User's phone logs
user2preference	OTM	preference	pref2user	Preference of the user				owned_by	source_type	source_lowid
originator2price_inst	OTM	price_inst	price_orig2user	Price instances originated by the user
modifier2price_inst	OTM	price_inst	price_modifier2user	Price instances last modified by the user
offline2privclass	MTO	privclass	offline_access2user	Offline privclass for the user
user_access2privclass	MTO	privclass	priv_access2user	User's privilege class			Search (1)
curr_owner2probdesc	OTM	probdesc	probdesc_owner2user	Solutions owned by the user
originator2probdesc	OTM	probdesc	probdesc_orig2user	Solutions originated by the user
owner2proc_inst	OTM	proc_inst	proc_inst_owner2user	Process instances owned by user
process_author2process	OTM	process	author2user	Process definitions created by this user
curr_owner2qry_grp	OTM	qry_grp	qry_grp_owner2user	Query groups owned by the user
user2qual_user	OTM	qual_user	qual_user2user	Mobile sharing rule qualifier assignments for the user
originator2query	OTM	query	query2user	Queries originated by the user
user_assigned2queue	MTM	queue	queue2user	Queues user is a member of		mtm_queue4_ user23
supvr_assigned2queue	MTM	queue	queue_supvr2user	Queues user is supervisor of or personal queues of the user		mtm_queue5_ user24	Search (4)
editor2quick_quote	OTM	quick_quote	qq_editor2user	Quotes the user is currently editing
user2rc_config	MTO	rc_config	rc_config2user	User's resource config			Search (2)
user2recent_obj	OTM	recent_obj	recent_obj2user		USER_DEFINED
rejector2reject_msg	OTM	reject_msg	reject_person2user	Task rejection messages for tasks rejected by the user
originator2resrch_log	OTM	resrch_log	resrch_owner2user	User's research logs
curr_user2restriction	MTO	restriction	restriction2curr_user	relate the user to his current restriction	USER_DEFINED
user2restriction	MTM	restriction	restriction2user	relate the user to his restrictions	USER_DEFINED	mtm_user113_ restriction0
user_access2ripbin	MTM	ripbin	ripbin_access2user	Reserved; obsolete		mtm_user27_ ripbin2
user_access2rpt_param	OTM	rpt_param	param2user	Report parameter sets the user has access to
user2rsrc	OTOF	rsrc	rsrc2user	Resource representing the user				route_to	focus_type	focus_lowid
admin2scr_run	OTM	scr_run	administered2user	Runs of a call script administered by the user
creator2se_session	OTM	se_session	session_creator2user
owner2se_session	OTM	se_session	session_owner2user
search_prefs2search_control	MTM	search_control	search_prefs2user	Full text search controls related to the user		mtm_user47_ search_control0
search_limits2search_limits	OTM	search_limits	search_limits2user	Full text search limits related to the user
user2server_stats	OTM	server_stats	server_stats2user	Statistics for the user				route_to	focus_type	focus_lowid
user2session	OTM	session	session2user	Interaction session of the user
user2shared_item	OTM	shared_item	shared_item2user	Users that are sharing this item.	USER_DEFINED
user2shft_sessn	OTM	shft_sessn	shft_sessn2user	Shift notes written by the user
shipped_by2ship_parts	OTM	ship_parts	shipped_by2user	Reserved; future
originator2status_chg	OTM	status_chg	status_chger2user	Status changes originated by the user. Reserved
curr_owner2subcase	OTM	subcase	subc_owner2user	Subcases owned by the user
originator2subcase	OTM	subcase	subc_orig2user	Subcases originated by the user
user2tag	OTM	tag	tag2user		USER_DEFINED
owner2task	OTM	task	task_owner2user	Task objects owned by user
originator2task	OTM	task	task_originator2user	Task objects originated by user
user2template	OTM	template	tmplt2user	Templates originated by the user
user2trans_record	OTM	trans_record	trans_record2user	Trans_record objects approved by the user
user2trnd	OTM	trnd	trnd2user	Trends owned by the user
user2proxy_user	MTO	user	proxy_user2user		USER_DEFINED
proxy_user2user	OTM	user	user2proxy_user	Relate proxy_user to the user they are proxying. This is used for user impersonation.	USER_DEFINED
user2user_touch	OTM	user_touch	touched_by2user	Selected object last touched by the user
user2usr_bus_role	OTM	usr_bus_role	usr_bus_role2user	Bus_org roles for the user
user2usr_opp_role	OTM	usr_opp_role	opp_role2user	Opportunity roles for the user
user2usr_ter_role	OTM	usr_ter_role	usr_ter_role2user	Territory roles for the user
user2web_user	OTM	web_user	web_user2user	WebSupport user for this user
user_default2wipbin	OTOP	wipbin	default_wipbin2user	User's default WIPbin
owner2wipbin	OTM	wipbin	wipbin_owner2user	User's WIPbins
originator2xfilterset	OTM	xfilterset	xfilterset2user	Filtersets created by the user

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags
login_index	login_name	UNIQUE

Indexes (Defined in Database):

Index Name	Fields	Additional Information
ind_offline2privclass	offline2privclass	nonclustered located on PRIMARY
ind_user_web_login	web_login	nonclustered located on PRIMARY
login_index	login_name	nonclustered, unique located on PRIMARY
objindex	objid	clustered, unique located on PRIMARY

Referenced in Views:

View ID	View Name	Tables
34	finale_lst	probdesc, user
37	case_alst	act_entry, case, gbst_elm, user
38	fnl_alst	act_entry, gbst_elm, probdesc, user
39	subcase_al	act_entry, gbst_elm, gbst_lst, subcase, user
54	user_view	user
55	empl_user	address, country, employee, site, user
56	wipelm_case	case, condition, gbst_elm, site, user, wipbin, workaround
57	wipelm_subcase	condition, gbst_elm, site, subcase, user, wipbin
58	wipelm_dtl	condition, demand_dtl, gbst_elm, mod_level, part_num, user, wipbin
59	queelm_case	case, condition, gbst_elm, queue, site, user, workaround
60	queelm_subcase	condition, gbst_elm, queue, site, subcase, user
61	queelm_dtl	condition, demand_dtl, gbst_elm, mod_level, part_num, queue, user
80	cas_cmitl	case, commit_log, gbst_elm, user
81	subc_cmitl	commit_log, gbst_elm, subcase, user
82	dfe_cmitl	commit_log, disptchfe, gbst_elm, user
106	alert2objects	alert, contact, contract, site, user
116	cls_case_view	case, condition, contact, employee, site, user, wipbin
158	case_view	case, condition, contact, gbst_elm, user
159	monelm_case	case, condition, gbst_elm, monitor, user
160	subcase_view	case, condition, contact, gbst_elm, subcase, user
161	monelm_subcase	condition, gbst_elm, monitor, subcase, user
162	dfe_view	case, condition, contact, disptchfe, gbst_elm, user
164	finale_view	probdesc, user
165	monelm_fnl	condition, monitor, probdesc, user
166	cls_sub_view	case, condition, contact, employee, site, subcase, user, wipbin
167	cls_dfe_view	case, condition, contact, disptchfe, employee, site, user, wipbin
170	monitor_user	monitor, user
186	acd_case_view	case, site, user
187	pinst_alst	act_entry, gbst_elm, site_part, user
188	location_alst	act_entry, gbst_elm, site, user
198	bug_view	bug, condition, gbst_elm, user
199	monelm_bug	bug, condition, gbst_elm, monitor, user
207	bug_alst	act_entry, bug, gbst_elm, user
208	qry_case_view	case, condition, contact, gbst_elm, site, user
209	qry_bug_view	bug, condition, gbst_elm, part_num, user
214	rpt_param_view	rpt, rpt_param, user
215	qry_bug	bug, condition, gbst_elm, part_num, user
238	req_sum	condition, demand_dtl, demand_hdr, gbst_elm, mod_level, part_num, user
248	qry_subcase_view	condition, contact, gbst_elm, site, subcase, user
254	acct_team	bus_empl_role, bus_org, employee, site, user
272	list_subcase	case, condition, gbst_elm, subcase, user
277	biz_cal_alst	act_entry, biz_cal_hdr, gbst_elm, user
278	schedule_alst	act_entry, gbst_elm, schedule, user
295	assoc_bugs	bug, condition, gbst_elm, user
296	master_bug	bug, condition, gbst_elm, user
297	asaf_user_site	asaf_result, site, user
298	empl_view	employee, site, user
311	qry_finale_view	condition, probdesc, user
341	user_case_load	case, condition, gbst_elm, user
355	dtl_alst	act_entry, demand_dtl, gbst_elm, user
359	rc_user	employee, rc_config, user
371	rc_contact	contact, rc_config, user
372	cont_user	contact, user
378	subc_lst	condition, contact, subcase, user
379	case_cmit	case, commit_log, contact, user
380	subc_cmit	commit_log, contact, subcase, user
391	queued_case_dfe	case, condition, disptchfe, queue, user
392	subcase_queued_dfe	condition, disptchfe, queue, subcase, user
393	dfe_case_user	case, disptchfe, queue, user, wipbin
394	dfe_subcase_user	disptchfe, queue, subcase, user, wipbin
396	appt_empl_user	address, employee, site, user
398	rep_bugs	bug, condition, gbst_elm, user
404	qry_owner	query, user
406	qry_grp_owner	qry_grp, query, user
409	part_inst_alst	act_entry, gbst_elm, part_inst, part_trans, user
4603	assoc_bugs_master	bug, condition, gbst_elm, user
4604	rep_bugs_master	bug, condition, gbst_elm, user
4615	fc_case_view	bus_org, bus_site_role, case, condition, contact, gbst_elm, site, user
4617	fc_gen_alst	act_entry, gbst_elm, participant, user
4621	fc_acct_task_view	bus_org, condition, gbst_elm, task, user
4622	fc_acct_opp_view	bus_opp_role, bus_org, currency, cycle_stage, opportunity, user
4624	fc_acct_notes_view	act_entry, gbst_elm, notes_log, participant, user
4625	fc_acct_phone_view	act_entry, gbst_elm, participant, phone_log, user
4626	fc_acct_email_view	act_entry, email_log, gbst_elm, participant, user
4627	fc_quote_view	bus_org, contact, contract, currency, gbst_elm, user
4650	fc_user_case_view	case, condition, contact, employee, gbst_elm, queue, site, user, wipbin, workaround
4651	fc_user_subcase_view	case, condition, contact, employee, gbst_elm, queue, site, subcase, user, wipbin
4652	fc_user_solution_view	condition, employee, probdesc, queue, user
4653	fc_filter_qry_favorites	employee, filter_query, filter_sub, user
4663	tagged_cases	case, condition, tag, user
4664	tagged_subcases	condition, subcase, tag, user
4665	tagged_solutions	condition, probdesc, tag, user
4666	tagged_part_requests	condition, demand_dtl, tag, user
4667	tagged_action_items	condition, tag, task, user
4678	tagged_crs	bug, condition, tag, user
5042	contr_alst	act_entry, contract, gbst_elm, user
5045	opp_alst	act_entry, gbst_elm, opportunity, user
5047	sub_preview	cls_factory, gbst_elm, subcase, user
5050	qry_ccn_hdr_view	bus_org, condition, contact, contract, gbst_elm, user
5070	contact_alst	act_entry, contact, gbst_elm, user
5071	cmp_lsc_opp	campaign, gbst_lst, lead_source, opportunity, user
5072	opp_stage	gbst_lst, lead_source, opportunity, user
5073	opp_view	condition, cycle_stage, opportunity, user
5077	task_con	bus_org, condition, contact, gbst_elm, opportunity, task, user
5089	task_alst	act_entry, gbst_elm, task, user
5092	terr_empl_view	emp_ter_role, employee, territory, user
5095	con_opp_view	con_opp_role, contact, currency, cycle_stage, opportunity, user
5106	nlog_actitm	notes_log, task, user
5109	ccn_bill_view	bus_org, condition, contr_schedule, contract, currency, site, user
5158	frtrgt_view	currency, frcst_target, territory, user
5159	frcstitem_view	currency, frcst_itm, opportunity, territory, user
5161	exch_alst	act_entry, exch_log, exchange, gbst_elm, user
5165	web_usrlst	employee, privclass, user, web_user
5166	web_usrcas	case, condition, gbst_elm, user
5170	qry_scasev	case, contact, gbst_elm, site, user
5178	reconcilecnt	count_setup, inv_count, user
5187	task_preview	cls_factory, condition, contact, gbst_elm, task, user
5189	v_frcstitem	currency, frcst_itm, opportunity, territory, user
5213	ccc_scr_v	call_script, user
5229	lit_req_view	gbst_elm, lit_req, user
5230	oppempl_view	cycle_stage, employee, opportunity, territory, user
5231	taskempl_view	employee, gbst_elm, opportunity, task, user
5232	ai2oltsk_apt	condition, contact, gbst_elm, task, task_desc, user
5234	subc2oltsk	contact, gbst_elm, subcase, user
5235	cmit2oltsk	commit_log, contact, user
5289	gen_alst	act_entry, gbst_elm, participant, user
5308	case_reject_msg	act_entry, case, reject_msg, user
5324	lead_view	lead, lead_source, user
5328	act_view	act_entry, gbst_elm, user
5332	req_demand	condition, demand_dtl, demand_hdr, gbst_elm, mod_level, user
5341	sfa_opp_v	bus_opp_role, bus_org, currency, cycle_stage, opportunity, user
5342	sfa_task_v	gbst_elm, task, user
5343	sfa_quote_v	bus_org, contact, contract, currency, gbst_elm, user
5344	sfa_frcst_v	bus_org, currency, frcst_itm, opportunity, territory, user
5345	sfa_camp_v	campaign, currency, price_prog, user
5347	sfa_target	bus_org, currency, frcst_target, gbst_elm, territory, user
5348	sfa_acct_tm	bus_org, contact, employee, user, usr_bus_role
5349	sfa_terr_tm	contact, employee, territory, user, usr_ter_role
5350	sfa_opp_tm	contact, employee, opportunity, user, usr_opp_role
5351	sfa_user_v	contact, employee, user
5356	sfa_opp_wk_v	condition, gbst_elm, opportunity, queue, user, wipbin
5358	sfa_tsk_wk_v	condition, gbst_elm, queue, task, user, wipbin
5363	sfa_pipeline	currency, gbst_elm, gbst_lst, opportunity, user
5364	subc_alst	act_entry, case, gbst_elm, gbst_lst, subcase, user
5395	rs_lst	contact, r_rqst, rsrc, user
5397	select_dialog	condition, dialogue, gbst_elm, user
5430	N_Users	address, country, employee, user
5446	sfa_opp_seen	opportunity, user
5462	wap_case_info	address, case, condition, contact, contract, employee, gbst_elm, queue, site, site_part, user, wipbin
5476	page_class_empl	employee, page_class, user
5477	page_class_contact	contact, page_class, user
5478	sales_quote_v	bus_org, condition, contact, contract, currency, gbst_elm, opportunity, user
5512	cont_user_lookup	contact, user
5547	sfa_task_cond_v	condition, gbst_elm, task, user
5597	iclient_opp_view	condition, currency, cycle_stage, opportunity, user
5679	subcase_list	case, condition, gbst_elm, subcase, user
5680	case_list	case, condition, contact, gbst_elm, site, user
5681	prev_case	case, condition, gbst_elm, user
5688	af_case_list	case, condition, gbst_elm, user
5689	solution_list	probdesc, user
5705	xfilterset_user	user, xfilterset
5706	act_vw	act_entry, gbst_elm, user
5712	alert2user	alert, user
5739	case_overview	address, case, condition, contact, contact_role, contract, country, gbst_elm, mod_level, queue, site, site_part, user, workaround
5740	case_more_info	address, case, condition, contact, country, gbst_elm, queue, site, user, wipbin
5741	subcase_overview	case, condition, contact, gbst_elm, queue, subcase, user, wipbin
5784	af_offering_list	offering, user
5793	part_in_offr_v	mod_level, offering, price_qty, user
5809	fr_agreement_details_v	bus_org, fr_agr_bus_role, fr_agrmnt, user
5848	open_script_v	gbst_elm, process, user
5857	scr_proc_inst_view	proc_inst, proc_inst_log, process, user
5860	agent_list	employee, intrxn, session, user
5863	user_empl	employee, user
5864	call_center_interact	case, contact, interact, interact_txt, opportunity, user
5866	employee_user	employee, user
5869	user_employee	employee, user
5957	se_session_view	dm_analysis, gbst_elm, se_session, user
5974	session_status_view	dm_analysis, gbst_elm, se_session, user
5983	addr_book_emp_vw	employee, user
5987	case_cmit2	case, commit_log, contact, user
5988	subc_cmit2	commit_log, contact, subcase, user
5994	part_in_offr_view	mod_level, offering, price_qty, user
5995	grp_in_offr_view	offering, offering_grp, offr_grp_role, user
6017	schdl_tracker_sub_v1	address, appointment, employee, hgsl2hgse, site, user
6018	schdl_tracker_sub_v2	address, case, disptchfe, employee, hgsl2hgse, queue, site, user, wipbin
6019	schdl_tracker_sub_v3	address, disptchfe, employee, hgsl2hgse, queue, site, subcase, user, wipbin
6020	schdl_tracker_sub_v4	address, disptchfe, employee, hgsl2hgse, queue, site, user
6021	schdl_tracker_sub_v5	address, disptchfe, employee, hgsl2hgse, queue, site, user
6022	schdl_tracker_sub_v6	address, appointment, employee, hgsl2hgse, site, user
6023	schdl_tracker	user
6027	prtuse_view1	mod_level, part_num, part_used, site_part, user
6028	prtuse_view2	mod_level, part_used, site_part, user

My Recent Objects

user

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