View Name:user_case_load
View Number:341
Group:Support
Description:Used to determine case load (number of open cases owned) for a user
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
elm_objidcaseobjidCase internal record number 3 (UNIQUE)
user_objiduserobjidUser internal record number 
clarify_stateconditionconditionCode number for condition type 
statusgse_status(gbst_elm)titleName of the item/element status 
case_typegse_cas_type(gbst_elm)titleName of the item/element type 

Joins:

Join FromJoin To
(case).case_owner2user(user).curr_owner2case
(case).case_state2condition(condition).case_condition2case
(case).calltype2gbst_elmgse_cas_type(gbst_elm).call_type2case
(case).casests2gbst_elmgse_status(gbst_elm).case_status2case
My Recent Objects
user_case_load