View Name:af_case_list
View Number:5688
Group:Support
Description:Used iSupport2.0 for case listing. Used in case_list.jsp
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
elm_objidvictimcase(case)objidCase internal record number 3 (UNIQUE)
cond_objidconditionobjidCondition internal record number 
owner_objidowner(user)objidUser internal record number 
gse_objidgse_status(gbst_elm)objidGbst_elm internal record number 
id_numbervictimcase(case)id_numberUnique case number assigned based on auto-numbering definition 4
ownerowner(user)login_nameUser login name 12
conditionconditiontitleCondition of the case 7
statusgse_status(gbst_elm)titleStatus of the case 8
titlevictimcase(case)titleCase or service call title; summary of case details 2
creation_timevictimcase(case)creation_timeThe date and time the case was created 1
alt_phone_numvictimcase(case)alt_phone_numThe alternate phone number for the contact 
phone_numvictimcase(case)phone_numThe primary phone number for the contact; copied from contact object 
distvictimcase(case)distUsed by ELINK to indicate extrnal creation source of case 
is_supercasevictimcase(case)is_supercaseFlag if the case is a super case 
supercase_numsupercase(case)id_numberUnique case number if it is related to a super case 

Joins:

Join FromJoin To
victimcase(case).case_owner2userowner(user).curr_owner2case
victimcase(case).case_state2condition(condition).case_condition2case
victimcase(case).casests2gbst_elmgse_status(gbst_elm).case_status2case
victimcase(case).case_victim2caseOUTER supercase(case).super2case
My Recent Objects
af_case_list