View Name:sfa_user_v
View Number:5351
Group:Sales Mgr
Description:Displays contact and employee team members. Used by form Generic LookUp non-modal(20000), Generic LookUp modal (40000), and Select Territory Team (356)
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
objiduserobjidUser internal record number 3 (UNIQUE)
empl_objidemployeeobjidEmployee internal record number 
con_objidcontactobjidContact internal record number 
user_nameuserlogin_nameUser's login name 
empl_first_nameemployeefirst_nameIf the user is an employee, the employee's first name 
empl_last_nameemployeelast_nameIf the user is an employee, the employee's last name 
empl_phoneemployeephoneIf the user is an employee, the employee's phone number 
con_first_namecontactfirst_nameIf the user is a contact, the contact's first name 
con_last_namecontactlast_nameIf the user is a contact, the contact's last name 
con_phonecontactphoneIf the user is a contact, the contact's phone number 

Joins:

Join FromJoin To
OUTER (employee).employee2user(user).user2employee
OUTER (contact).caller2user(user).employees2contact
My Recent Objects
sfa_user_v