Table Name:	employee
Table Number:	44
Group:	Resource Mgr
Description:	Employee object; generally a ClearSupport user
Flags:
Baseline/Custom:	Baseline

select * from table_employee

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
acting_supvr	LONG	int				DIRECT	Indicates if the employee is an acting supervisor	Search (2)
after_biz_high	CHAR	varchar		32			High urgency notify method after business hours	Search (1)
after_biz_low	CHAR	varchar		32			Low urgency notify method after business hours	Search (1)
after_biz_mid	CHAR	varchar		32			Medium urgency notify method after business hours	Search (1)
allow_proxy	LONG	int				DIRECT	Indicates if the employee can allow another employee to switch to	Search (2)
alt_phone	CHAR	varchar		20			Employee's alternate phone number which includes area code, number, and extension
avail_note	CHAR	varchar		255			Reserved; indicates reason for employee unavailability; was used in the availability command; no longer supported	Search (2)
available	LONG	int			1	DIRECT	Reserved; indicates employee's availability; was used in the availability command; no longer supported	Search (2)
beeper	CHAR	varchar		20			Employee's beeper number which includes area code and number	Search (6)
case_threshold	LONG	int				DIRECT	Reserved; custom. Highest number of open cases for employee for workload monitoring
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
e_mail	CHAR	varchar		80			Employee's e-mail address	Search (8)
employee_no	CHAR	varchar		8			Employee's ID number	Search (2)
fax	CHAR	varchar		20			Employee's fax number which includes area code, number, and extension	Search (7)
field_eng	LONG	int				DIRECT	Indicates if the employee is a field engineer. Reserved; not used
first_name	CHAR	varchar	15	30		CHANGE_FIELD	Employee first name	Search (31)
labor_rate	FLOAT	real				CURRENCY	Employee's hourly labor rate	Search (2)
last_name	CHAR	varchar	14	30		CHANGE_FIELD	Employee last name	Search (31)
local_login	CHAR	varchar		30			Employee host login name; used for the case dial site form for remote dialups
local_password	CHAR	varchar		30			Employee host password
mail_stop	CHAR	varchar		30			Employee's internal company mail address/stop
normal_biz_high	CHAR	varchar		32			High urgency notify method during business hours	Search (1)
normal_biz_low	CHAR	varchar		32			Low urgency notify method during business hours	Search (1)
normal_biz_mid	CHAR	varchar		32			Medium urgency notify method during business hours	Search (1)
objid	LONG	int	3			DIRECT	Internal record number	Search (27)
on_call_hw	LONG	int				DIRECT	Reserved; custom. When checked, indicates employee is available to be paged for hardware calls	Search (1)
on_call_sw	LONG	int				DIRECT	Reserved; custom. When checked, indicates employee is available to be paged for software calls
phone	CHAR	varchar		20			Employee's primary phone number which includes area code, number, and extension	Search (13)
printer	CHAR	varchar		40			Employee's printer name. This is from a user-defined popup with default name DEFAULT_PRINTER	Search (2)
salutation	CHAR	varchar		20		ALLOW_NULL	A form of address; e.g., Mr., Miss, Mrs	Search (2)
site_strt_date	CLK_TIME	datetime					Date employee began at current site<office>	Search (1)
title	CHAR	varchar		30		ALLOW_NULL	Employee's professional title	Search (2)
voice_mail_box	CHAR	varchar		20			Employee voice mail box number. Reserved; not used
wg_strt_date	CLK_TIME	datetime					Date employee started with current work group	Search (1)
work_group	CHAR	varchar		80			Work group to which employee belongs. From a user-defined pop up with default name WORKGROUP	Search (5)
x_autodest	CHAR	varchar		20		USER_DEFINED	Auto Destination Preference
x_modify_stmp	CLK_TIME	datetime				CHANGE_DATE, USER_DEFINED	The date and time when change fields were last updated	Search (1)

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Flags	MTM Table	Used in Views
employee2act_entry	OTM	act_entry	act_entry2employee	Activity log entries for activities performed on employee record; changes to work group or site
empl_hrs2biz_cal_hdr	OTOP	biz_cal_hdr	biz_cal_hdr2empl_hrs	Employee's business hours
cc_list2bug	MTO	bug	bug_cc_list2employee	Change requests that employee is cc'd on. Reserved; obsolete
empl2bus_empl_role	OTM	bus_empl_role	bus_empl_role2employee	Employee roles for the business organization. Reserved
creator2case	OTM	case	case_empl2employee	Cases created by employee. Reserved; obsolete
closer2close_case	OTM	close_case	closer2employee	Close case records <activities> performed by employee
intcontact2commit_log	OTM	commit_log	commit_empl2employee	Reserved; not used
solver2commit_log	OTM	commit_log	cmit_solver2employee	Related commitments
employee2contact	OTOP	contact	contact2employee	For employees that are contacts, the related contact. Reserved; not used
employee2e_addr	OTM	e_addr	eaddr2employee	Electronic addresses owned by the employee
employee2email_log	OTM	email_log	email_log2employee		USER_DEFINED
empl2emp_ter_role	OTM	emp_ter_role	emp_ter_role2employee	Employee roles for sales territories. Reserved; obsolete. Replaced by usr_ter_role
emp_supvr2employee	MTO	employee	supvr2employee	Employee's supervisor
supvr2employee	OTM	employee	emp_supvr2employee	Employees supervised by the employee
employee2onsite_doer	OTM	onsite_log	onsite_doer2employee	Time & Expense Logs performed by the employee
empl2person	OTOF	person	person2employee	Related person object
intcontact2phone_log	OTM	phone_log	phone_empl2employee	Phone logs intitiated by the employee
creator2probdesc	MTM	probdesc	probdesc_emp2employee	Solutions created by the employee		mtm_probdesc10_ employee6
primary2productbin	OTM	productbin	productbin2primary	Product bins for which the employee serves as primary support
backup2productbin	OTM	productbin	productbin2backup	Product bins for which the employee serves a backup
employee2queue_cc	OTM	queue_cc	queue_cc2employee	Reserved; obsolete
employee2schedule	OTM	schedule	schedule2employee	Related employee schedule
employee2scr_run	OTM	scr_run	scr_run2employee	Script runs initiated by the employee
supp_person_off2site	MTO	site	support_off2employee	Employee's office site			Search (12)
supp_person2site	OTM	site	site_support2employee	Sites for which the employee is the primary support person
altsupp_person2site	OTM	site	site_altsupp2employee	Sites for which the employee is the alternate support person
primary2site_part	OTM	site_part	site_part2primary	Parts for which the employee is the primary support person
backup2site_part	OTM	site_part	site_part2backup	Parts for which the employee is the backup support person
creator2subcase	OTM	subcase	subc_empl2employee	Subcases created by the employee
emp_cmits2time_bomb	OTM	time_bomb	cmit_creator2employee	Employee's commitment time bombs
recipient2time_bomb	MTM	time_bomb	recipient2employee	Time bombs which will be directed at the employee. Reserved		mtm_employee13_ time_bomb2
employee2user	OTOP	user	user2employee	Relation to employee's database user record			Search (34)
emp_access2wipbin	MTM	wipbin	wipbin2employee	WIPbins to which the employee has access. Reserved		mtm_wipbin4_ employee7
empl2wgroup_super	OTM	workgroup	wgroup_super2empl	supervisor of Related workgroup	USER_DEFINED

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags

Indexes (Defined in Database):

Index Name	Fields	Additional Information
ind_cc_list2bug	cc_list2bug	nonclustered located on PRIMARY
ind_emp_supvr2employee	emp_supvr2employee	nonclustered located on PRIMARY
ind_employee_last_name	last_name, first_name	nonclustered located on PRIMARY
ind_employee_no	employee_no	nonclustered located on PRIMARY
ind_employee2user	employee2user	nonclustered located on PRIMARY
ind_first_name	first_name, last_name	nonclustered located on PRIMARY
ind_supp_person_off2site	supp_person_off2site	nonclustered located on PRIMARY
objindex	objid	clustered, unique located on PRIMARY

Referenced in Views:

View ID	View Name	Tables
55	empl_user	address, country, employee, site, user
113	slv_contct	address, country, employee, site
116	cls_case_view	case, condition, contact, employee, site, user, wipbin
149	intactcase	case, condition, employee, gbst_elm, site
166	cls_sub_view	case, condition, contact, employee, site, subcase, user, wipbin
167	cls_dfe_view	case, condition, contact, disptchfe, employee, site, user, wipbin
234	com_to_template_view	com_tmplte, employee, time_bomb
254	acct_team	bus_empl_role, bus_org, employee, site, user
298	empl_view	employee, site, user
359	rc_user	employee, rc_config, user
395	employee_appt	appointment, employee, schedule
396	appt_empl_user	address, employee, site, 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
5092	terr_empl_view	emp_ter_role, employee, territory, user
5165	web_usrlst	employee, privclass, user, web_user
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
5230	oppempl_view	cycle_stage, employee, opportunity, territory, user
5231	taskempl_view	employee, gbst_elm, opportunity, task, 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
5430	N_Users	address, country, employee, 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
5860	agent_list	employee, intrxn, session, user
5863	user_empl	employee, user
5866	employee_user	employee, user
5869	user_employee	employee, user
5983	addr_book_emp_vw	employee, 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

My Recent Objects

employee

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