View Name:N_Users
View Number:5430
Group:Configuration
Description:Assembles user, employee, and contact information
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
N_UserIduserobjidUser internal record number 3 (UNIQUE)
N_PassworduserpasswordUser password 
N_FirstNameemployeefirst_nameUser password 
N_LastNameemployeelast_nameUser password 
N_Address1addressaddressLine 1 of address which includes street number, street name, office, building, or suite number, etc 
N_Address2addressaddress_2Line 2 of address which typically includes office, building, or suite number, etc 
N_CityaddresscityThe city for the specified address 
N_StateaddressstateThe state for the specified address 
N_PostalCodeaddresszipcodeThe zip or other postal code for the specified address 
N_CountrycountrynameName of the specific country 
N_TelephoneemployeephoneEmployee's primary phone number which includes area code, number, and extension 
N_TelephoneExtemployeeon_call_hwUsed as a placeholder for the employee's phone extension 
N_FAXemployeefaxEmployee's fax number which includes area code, number, and extension 
N_Emailemployeee_mailEmployee's e-mail address 
N_ModificationDateemployeesite_strt_dateUsed as a placeholder for the employee object's modification date 
N_StatususerstatusUser status; i.e., 0=inactive, 1=active, default=1 
N_EffectiveDateemployeewg_strt_dateDate employee began at current site<office> 
N_UserNameuserlogin_nameUser login name 

Joins:

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