Table Name:	disptchfe
Table Number:	26
Group:	Support
Description:	Dispatch Engineer object which contains all the info required for the field engineer to perform a task at a customer site. Site and contact info comes from the case, but can be edited and is stored locally on the object
Flags:	CACHEOBJIDS
Baseline/Custom:	Baseline

select * from table_disptchfe

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
address1	CHAR	varchar		200			Line one of street address of site at which FE is to perform work
address2	CHAR	varchar		200			Line two of street address of site at which FE is to perform work
alt_phone	CHAR	varchar		20			Contact alternate phone number
appointment	CLK_TIME	datetime					Proposed date/time of scheduled appointment or commitment	Search (10)
appt_confirm	LONG	smallint			0	DIRECT	0=unconfirmed, 1=confirmed, default=0	Search (8)
cell_text	CHAR	varchar		255			Contains a concatination of locally-selected fields for display by Schedule Tracker. Default is field case.id_number	Search (8)
city	CHAR	varchar		30			City where site is located
cont_fname	CHAR	varchar		30			Contact first name
cont_lname	CHAR	varchar		30			Contact last name
description	CHAR	varchar		255			Task description	Search (3)
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
disptime	CLK_TIME	datetime					Date and time the dispatch engineer object was created	Search (1)
duration	LONG	int				DIRECT	Expected/actual amount of time to complete the task in seconds	Search (8)
main_phone	CHAR	varchar		20			Contact main phone number
notes	CHAR	text				ALLOW_NULL	Notes describing additional information needed by the engineer to complete the task
objid	LONG	int	3			DIRECT	Internal record number	Search (23)
pay_method	CHAR	varchar		40			Method of payment for the service; e.g., credit card, PO, etc. Populated from a user defined pop-up
ref_number	CHAR	varchar		80			Reference number for payment method; e.g., PO number, etc
requested_eta	CLK_TIME	datetime					Requested date and time of field engineer's arrival at dispatch site	Search (8)
state	CHAR	varchar		30			State where site is located
work_order	CHAR	varchar		80			Work order number entered by the user	Search (6)
zip	CHAR	varchar		20			Site zip or other postal code

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Used in Views
disptchfe2act_entry	OTM	act_entry	act_entry2disptchfe	Activity log entry for the field engineer dispatch activity
disptchfe2case	MTO	case	case_onsite2disptchfe	Case for the field engineer dispatch	Search (11)
disptchfe2fcs_detail	OTOP	fcs_detail	fcs_detail2disptchfe	Reserved; custom
disptchfe2onsite_log	OTM	onsite_log	disfe_onsit2disptchfe	T&E summaries for the dispatch event
disptchfe2subcase	MTO	subcase	subcase_onsite2disptchfe	Subcase for the field engineer dispatch	Search (5)
disptchfe_orig2user	MTO	user	originator2disptchfe	User that originated the dispatch

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags

Indexes (Defined in Database):

Index Name	Fields	Additional Information
ind_disptchfe2case	disptchfe2case	nonclustered located on PRIMARY
ind_disptchfe2subcase	disptchfe2subcase	nonclustered located on PRIMARY
objindex	objid	clustered, unique located on PRIMARY

Referenced in Views:

View ID	View Name	Tables
82	dfe_cmitl	commit_log, disptchfe, gbst_elm, user
122	case2wip_dfe	case, disptchfe, wipbin
162	dfe_view	case, condition, contact, disptchfe, gbst_elm, user
167	cls_dfe_view	case, condition, contact, disptchfe, employee, site, user, wipbin
177	dfe2cnvlg	disptchfe, phone_log
178	dfe2rsrch	disptchfe, resrch_log
180	case2dfe_cls	case, close_case, disptchfe
183	case2rip_dfe	case, disptchfe, ripbin
191	v_cls_dfe	case, condition, contact, disptchfe, site
274	list_dfe	case, disptchfe
275	list_oslog	disptchfe, onsite_log
279	list_sub_dfe	disptchfe, subcase
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
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
6037	list_select_dfe	disptchfe
6050	onsite_dfe_case	case, disptchfe, onsite_log
6051	onsite_dfe_subc	disptchfe, onsite_log, subcase

My Recent Objects

disptchfe

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