user_id | user | objid | Employee user ID | 3 (UNIQUE) |
employee | employee | objid | Employee unique object 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 | |
login_name | user | login_name | Employee login name | |
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 | |