View Name:appt_empl_user
View Number:396
Group:Resource Mgr
Description:View of employee information. Used by form Schedule Tracker (899)
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
employeeemployeeobjidEmployee unique object ID 3 (UNIQUE)
first_nameemployeefirst_nameEmployee first name 15
last_nameemployeelast_nameEmployee last name 14
user_iduserobjidEmployee user ID 
statususerstatusUser status; i.e., 0=inactive, 1=active, default=1 
employee_noemployeeemployee_noThe employee ID number 
work_groupemployeework_groupWork group to which employee belongs 
regionsiteregionRegion to which the site belongs 
districtsitedistrictDistrict to which the site belongs 
cityaddresscityEmployee site city 
stateaddressstateEmployee site state 

Joins:

Join FromJoin To
(employee).employee2user(user).user2employee
(employee).supp_person_off2site(site).support_off2employee
(site).cust_primaddr2address(address).primary_addr2site
My Recent Objects
appt_empl_user