View Name:cls_dfe_view
View Number:167
Group:Support
Description:View dispatch Field Engineer information for a case or subcase
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
dfe_iddisptchfeobjidDisptchfe internal record number 3 (UNIQUE)
empl_idemployeeobjidEmployee internal record number 
user_idsub_user(user)objidUser internal record number 
wip_idsub_wip(wipbin)objidWIPbin internal record number 18
id_numberdisptchfework_orderWork order number entered by the user 
closer_namesub_user(user)login_nameUser login name 12
site_namesitenameSite name 
contact_f_namecontactfirst_nameContact first name 15
contact_l_namecontactlast_nameContact last name 14
conditionconditiontitleTitle of condition 7
case_wip_idcase_wip(wipbin)objidWIPbin internal record number 
case_owner_idcase_user(user)objidUser internal record number 

Joins:

Join FromJoin To
(case).case_wip2wipbincase_wip(wipbin).wipbin2case
(case).case_owner2usercase_user(user).curr_owner2case
(case).case_reporter2site(site).cust_loc2case
(case).case_reporter2contact(contact).caller2case
(subcase).subcase2case(case).case2subcase
(employee).employee2usersub_user(user).user2employee
My Recent Objects
cls_dfe_view