employee | employee | objid | Employee unique object ID | 3 (UNIQUE) |
location_id | site | objid | Employee site location | |
address_id | address | objid | Employee site address ID | |
first_name | employee | first_name | Employee first name | 15 |
last_name | employee | last_name | Employee last name | 14 |
phone_num | employee | phone | Employee site phone number | |
p_site | site | name | Employee's parent site | |
p_site_id | site | site_id | Employee's parent site ID | |
p_site_type | site | type | Employee's parent site type | |
country_code | country | code | Employee site country code | |
address | address | address | Employee site address | |
city | address | city | Employee site city | |
state | address | state | Employee site state | |
country | country | name | Employee site country | |
zipcode | address | zipcode | Employee site zip or other postal code code | |
login_name | user | login_name | Employee login name | |
user_id | user | objid | Employee user ID | |
status | user | status | User status; i.e., 0=inactive, 1=active, default=1 | |
acting_super | employee | acting_supvr | Is employee a supervisor? | |
available | employee | available | Employee availability | |
avail_note | employee | avail_note | Employee availability notes | |
allow_proxy | employee | allow_proxy | Indicates if the employee can allow another employee to switch to him/her | |
printer | employee | printer | Employee's preferred printer name | |
labor_rate | employee | labor_rate | Employee's hourly labor rate | |
node_id | user | node_id | Base36 string representation of Node ID. Used by distribution engine | |
work_group | employee | work_group | | |
x_modify_stmp | employee | x_modify_stmp | The date and time when change fields were last updated | |
windows_login | user | x_windows_login_name | Used for Windows Authentication to map a {domain}\{username} to a Clarify user | |