View Name:prev_case
View Number:5681
Group:Support
Description:Used by form Prev Cases. This view is used in case_prev_cases_list.jsp
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 
condition_objidconditionobjidCondition internal record number 
gbst_elm_objidgbst_elmobjidGbst_elm internal record number 
id_numbercaseid_numberUnique case number assigned based on auto-numbering definition 
titlecasetitleCase or service call title; summary of case details 
clarify_stateconditionconditionCode number for condition type 
conditionconditiontitleTitle of condition 
statusgbst_elmtitleStatus fo the case 
owneruserlogin_nameUser login name 
creation_timecasecreation_timeThe date and time the case was created 
is_supercasecaseis_supercaseIndicates whether the case is a super or a victim case; i.e., 0=normal or victim case, 1=supercase 

Joins:

Join FromJoin To
(case).casests2gbst_elm(gbst_elm).case_status2case
(case).case_owner2user(user).curr_owner2case
(case).case_state2condition(condition).case_condition2case
My Recent Objects
prev_case