View Name:web_usrlst
View Number:5165
Group:WebSupport
Description:Used internally to select all the Users associated with Web Users
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
objidweb_userobjidWeb User internal record number 3 (UNIQUE)
login_nameweb_userlogin_nameWeb User login name 
passwordweb_userpasswordWeb User password 
passwd_chgweb_userpasswd_chgDate/Time password was last changed; supports password expiration 
web_usr_statusweb_userstatusStatus of Web User 1=Active, 0=Inactive 
user_objiduserobjidUser internal record number 
usr_login_nameuserlogin_nameUser login name 
user_statususerstatusUser status; i.e., 0=inactive, 1=active, default=1 
emp_objidemployeeobjidEmployee internal record number 
emp_first_nameemployeefirst_nameEmployee last name 
emp_last_nameemployeelast_nameEmployee first name 
emp_phoneemployeephoneEmployee phone number 
class_nameprivclassclass_namePrivilage class name 
CS_allowedprivclassCS_allowedIndicates if a ClearSupport license can be checked out 
CQ_allowedprivclassCQ_allowedIndicates if a ClearQuality license can be checked out 

Joins:

Join FromJoin To
(user).user_access2privclass(privclass).priv_access2user
(employee).employee2user(user).user2employee
(web_user).web_user2user(user).user2web_user
My Recent Objects
web_usrlst