View Name:qry_scasev
View Number:5170
Group:Support
Description:Used by form Cases Window (420, 776) and New Case (421, 775)
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
elm_objidcaseobjidCase internal record number 3 (UNIQUE)
id_numbercaseid_numberUnique case number assigned based on auto-numbering definition 4
ownerowner(user)login_nameUser login name 12
statusgse_status(gbst_elm)titleStatus of the case 8
titlecasetitleCase or service call title; summary of case details 2
site_namesitenameName of the reporting site 
first_namecontactfirst_nameContact first name 
last_namecontactlast_nameContact last name 
is_supercasecaseis_supercaseFlag if the case is a super case 

Joins:

Join FromJoin To
(case).case_owner2userowner(user).curr_owner2case
(case).case_reporter2site(site).cust_loc2case
(case).case_reporter2contact(contact).caller2case
(case).casests2gbst_elmgse_status(gbst_elm).case_status2case
My Recent Objects
qry_scasev