View Name:empl_user
View Number:55
Group:Resource Mgr
Description:View of employee information. Used by forms Assign (443), Parts Used (690), Select Employees (702) Campaign Mgr (11950), Console-Sales (12000)
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
employeeemployeeobjidEmployee unique object ID 3 (UNIQUE)
location_idsiteobjidEmployee site location 
address_idaddressobjidEmployee site address ID 
first_nameemployeefirst_nameEmployee first name 15
last_nameemployeelast_nameEmployee last name 14
phone_numemployeephoneEmployee site phone number 
p_sitesitenameEmployee's parent site 
p_site_idsitesite_idEmployee's parent site ID 
p_site_typesitetypeEmployee's parent site type 
country_codecountrycodeEmployee site country code 
addressaddressaddressEmployee site address 
cityaddresscityEmployee site city 
stateaddressstateEmployee site state 
countrycountrynameEmployee site country 
zipcodeaddresszipcodeEmployee site zip or other postal code code 
login_nameuserlogin_nameEmployee login name 
user_iduserobjidEmployee user ID 
statususerstatusUser status; i.e., 0=inactive, 1=active, default=1 
acting_superemployeeacting_supvrIs employee a supervisor? 
availableemployeeavailableEmployee availability 
avail_noteemployeeavail_noteEmployee availability notes 
allow_proxyemployeeallow_proxyIndicates if the employee can allow another employee to switch to him/her 
printeremployeeprinterEmployee's preferred printer name 
labor_rateemployeelabor_rateEmployee's hourly labor rate 
node_idusernode_idBase36 string representation of Node ID. Used by distribution engine 
work_groupemployeework_group 
x_modify_stmpemployeex_modify_stmpThe date and time when change fields were last updated 
windows_loginuserx_windows_login_nameUsed for Windows Authentication to map a {domain}\{username} to a Clarify user 

Joins:

Join FromJoin To
(employee).supp_person_off2site(site).support_off2employee
(employee).employee2user(user).user2employee
(address).address2country(country).country2address
(site).cust_primaddr2address(address).primary_addr2site
My Recent Objects
empl_user