View Name:dfe_case_user
View Number:393
Group:Resource Mgr
Description:Gets case dispatches associated with users. Used by Schedule Tracker form (899)
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline
select * from table_dfe_case_user
Keyboard shortcuts available

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
user_objiduserobjidEmployee objid 
disptchfe_objiddisptchfeobjidInternal record number 3 (UNIQUE)
appointmentdisptchfeappointmentProposed date/time of scheduled appointment or commitment 
durationdisptchfedurationExpected amount of time to complete the task 
requested_etadisptchferequested_etaRequested date and time of field engineer's arrival at dispatch site 
appt_confirmdisptchfeappt_confirm0=unconfirmed, 1=confirmed, default=0 
cell_textdisptchfecell_textContains a conatination of locally-selected fields for display by Schedule Tracker. Default is field case.id_number 
case_objidcaseobjidInternal record number 
queue_objidqueueobjidqueue object ID 
wipbin_objidwipbinobjidwipbin object ID 

Joins:

Join FromJoin To
(case).case_currq2queueOUTER (queue).currq2case
(case).case_wip2wipbinOUTER (wipbin).wipbin2case
(case).case_owner2user(user).curr_owner2case
(disptchfe).disptchfe2case(case).case_onsite2disptchfe
My Recent Objects
dfe_case_user      
       
       
Quick Links
act_entry case contact employee
rol_contct site site_view user