View Name:dfe_subcase_user
View Number:394
Group:Resource Mgr
Description:Gets subcase dispatches associated with users. Used by Schedule Tracker form (899)
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
user_objiduserobjidInternal record number 
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 
subcase_objidsubcaseobjidInternal record number 
queue_objidqueueobjidqueue object ID 
wipbin_objidwipbinobjidwipbin object ID 

Joins:

Join FromJoin To
(subcase).subc_currq2queueOUTER (queue).currq2subcase
(subcase).subc_wip2wipbinOUTER (wipbin).wipbin2subcase
(subcase).subc_owner2user(user).curr_owner2subcase
(disptchfe).disptchfe2subcase(subcase).subcase_onsite2disptchfe
My Recent Objects
dfe_subcase_user