View Name:subcase_queued_dfe
View Number:392
Group:Customer Mgr
Description:Gets subcase-related dispatches in queues
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
objiduserobjidInternal record number 
shared_persqueueshared_persIndicates whether queue is shared or personal 
disptchfe_objiddisptchfeobjidInternal record number 3 (UNIQUE)
appointmentdisptchfeappointmentProposed date/time of scheduled appointment or commitment 
durationdisptchfedurationExpected amount of time to complete the task in seconds 
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 concatination of locally-selected fields for display by Schedule Tracker. Default is field case.id_number 
subcase_objidsubcaseobjidInternal record number 
conditionconditionconditionCode number for the condition type 

Joins:

Join FromJoin To
(user).supvr_assigned2queue(queue).queue_supvr2user
(subcase).subc_currq2queue(queue).currq2subcase
(subcase).subc_state2condition(condition).subc_conditn2subcase
(disptchfe).disptchfe2subcase(subcase).subcase_onsite2disptchfe
My Recent Objects
subcase_queued_dfe