View Name:slv_contct
View Number:113
Group:Customer Mgr
Description:Joins support persons to their office site and the site's address
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
objidemployeeobjidSupport employee internal record number 3 (UNIQUE)
loc_objidsiteobjidSite internal record number 
addr_objidaddressobjidSite address internal record number 
first_nameemployeefirst_nameSuport employee first name 15
last_nameemployeelast_nameSupport employee last name 14
phone_numemployeephoneSupport employee's primary phone number which includes area code, number, and extension 
p_sitesitenameSupport employee site name 
p_site_idsitesite_idSupport employee site ID 
country_codecountrycodeCountry code for site 
addressaddressaddressLine 1 of address which includes street number, street name, office, building, or suite number, etc 
cityaddresscityThe city for the specified address 
stateaddressstateThe state for the specified address 
countrycountrynameCountry name for the specified address 
zipcodeaddresszipcodeThe zip or other postal code for the specified address 

Joins:

Join FromJoin To
(employee).supp_person_off2site(site).support_off2employee
(address).address2country(country).country2address
(site).cust_primaddr2address(address).primary_addr2site
My Recent Objects
slv_contct