View Name:cas_secure
View Number:303
Group:WebSupport
Description:View which supports case level security in WebSupport
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
contact_objidcontactobjidContact internal record number 
role_objidcontact_roleobjidContact_role internal record number 3 (UNIQUE)
site_objidsiteobjidSite internal record number 
case_objidcaseobjidCase internal record number 
first_namecontactfirst_nameContact first name 
last_namecontactlast_nameContact last name 
phonecontactphoneContact phone number which includes area code, number, and extension 
role_namecontact_rolerole_nameRole name 
primary_sitecontact_roleprimary_siteIndicates the site where the contact is located 
site_idsitesite_idSite ID number assigned according to auto-numbering definition 
site_namesitenameSite name 
case_titlecasetitleCase or service call title; summary of case details 
case_idcaseid_numberUnique case number assigned based on auto-numbering definition 
creation_timecasecreation_timeThe date and time the case was created 

Joins:

Join FromJoin To
(case).case_reporter2site(site).cust_loc2case
(contact_role).contact_role2site(site).site2contact_role
(contact_role).contact_role2contact(contact).contact2contact_role
My Recent Objects
cas_secure