View Name:wap_case_info
View Number:5462
Group:Wireless Access
Description:
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
objidcaseobjidCase internal record number 3 (UNIQUE)
id_numbercaseid_numberUnique case number assigned based on auto-numbering definition 
titlecasetitleCase or service call title; summary of case details 
conditionconditionconditionThe condition of the case 
wipbin_titlewipbintitleName of the case's wipbin 
queue_titlequeuetitleName of the case's queue 
login_namee(user)login_nameDatabase login of the user 
originator_phonef(employee)phonePhone number of the case originator 
owner_phoneh(employee)phonePhone number of the case owner 
case_typea(gbst_elm)titleCall type of case: This is a Clarify-defined pop up list 
case_priorityb(gbst_elm)titleResponse priority of case: This is a Clarify-defined pop up list 
case_severityc(gbst_elm)titleResponse severity of case: This is a Clarify-defined pop up list 
instance_namesite_partinstance_nameName of the part instance the case is about 
contract_typecontracttypeThe specific nature of the contract-standard. This is a user-defined pop up list with default name of CONTRACT_TYPE 
site_namesitenameName of the site reporting the case 
site_idsitesite_idUnique identifier of the site reporting the case 
addressaddressaddressLine 1 of site address which includes street number, street name, office, building, or suite number, etc 
address_2addressaddress_2Line 2 of the site address which typically includes office, building, or suite number, etc 
cityaddresscityThe city for the specified address 
stateaddressstateThe state for the specified address 
zip_codeaddresszipcodeThe state for the specified address 
first_namecontactfirst_nameFirst name of the case contact 
last_namecontactlast_nameLast name of the case contact 
contact_phonecontactphonePhone number of the case contact 

Joins:

Join FromJoin To
(case).case_wip2wipbin(wipbin).wipbin2case
(case).case_currq2queueOUTER (queue).currq2case
(case).case_state2condition(condition).case_condition2case
(case).case_reporter2site(site).cust_loc2case
(case).case2address(address).address2case
(case).entitlement2contractOUTER (contract).contract2case
(case).case_prod2site_partOUTER (site_part).site_part2case
(case).case_reporter2contact(contact).caller2case
(case).calltype2gbst_elma(gbst_elm).call_type2case
(case).respprty2gbst_elmb(gbst_elm).resp_priority2case
(case).respsvrty2gbst_elmc(gbst_elm).resp_severity2case
(case).case_originator2usere(user).originator2case
f(employee).employee2usere(user).user2employee
(case).case_owner2userg(user).curr_owner2case
h(employee).employee2userg(user).user2employee
My Recent Objects
wap_case_info