View Name:servicecase
View Number:5222
Group:Customer Mgr
Description:Selects Cases related to communication services
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
contact_objidcontactobjidContact internal record number 
elm_objidcaseobjidCase internal record number 3 (UNIQUE)
clarify_stateconditionconditionCode number for condition type 
id_numbercaseid_numberUnique case number assigned based on auto-numbering definition 4
titlecasetitleCase or service call title; summary of case details 2
ageconditionwipbin_timeDate and time task was accepted into WIPbin 
conditionconditiontitleTitle of condition 
statusgbst_elmtitleStatus of the case 
last_namecontactlast_nameContact last name 14
first_namecontactfirst_nameContact first name 15
creation_timecasecreation_timeThe date and time the case was created 1
prodpart_objidproduct_part(site_part)objidProduct site part internal record number 
prod_serialproduct_part(site_part)serial_noInstalled product serial number 
svcpart_objidservice_part(site_part)objidProduct site part internal record number 
is_supercasecaseis_supercaseFlag if the case is a super case 
role_objidprt_prt_roleobjidInteral record number of prt_prt_role 

Joins:

Join FromJoin To
(case).case_state2condition(condition).case_condition2case
(prt_prt_role).role_for2site_partservice_part(site_part).role_for2prt_prt_role
(prt_prt_role).player2site_partproduct_part(site_part).player2prt_prt_role
(case).case_prod2site_partservice_part(site_part).site_part2case
(case).case_reporter2contact(contact).caller2case
(case).casests2gbst_elm(gbst_elm).case_status2case
My Recent Objects
servicecase