---
title: "Employees Table"
canonical: "https://help.agiloft.com/space/A2508SD/134060735/Employees+Table"
format: markdown
---
The Employees table stores information about your employees. Employee records control KB access and permissions as they contain user login details as well as their assigned roles, groups, and teams. Employee records also store contact information and job details like working hours, hire date, and employment status.

# Use Case

Employee records can be created in a variety of ways:

- A user with permission to create Employee records can create them in either the People table or the Employee table directly.
- Via sync with Active Directory or LDAP. The first time a user logs in using one of those authentication methods, an Employee record is generated for them.
- From a [SAML provider](https://agiloft-public.atlassian.net/wiki/spaces/HELP/pages/43715776), such as Okta, when they first log into the system.
- [Imported](https://wiki.agiloft.com/display/HELP/Importing+Record+Data) from an Excel or .csv spreadsheet.

Once an employee is given access to the system, their user information can be modified in a variety of ways:

- An admin user can make changes to their record and deactivate their access or update their information.
- A sync with LDAP or AD or subsequent login with SAML.
- Scheduled import/updates from another backend system.
- The user may modify any fields they are allowed to edit by clicking on My Profile in the Home section of the left pane.

> 📝 It's a best practice to develop your own procedure for deactivating Employee records when an employee is terminated. We don't recommend deleting user records. For more information, see [Deactivating Users](https://agiloft-public.atlassian.net/wiki/spaces/HELP/pages/43717058) in the Help Guide.

![Example Employee record](media://a1cf8cc7-d5df-4874-aa3b-879c67179d92)

# Fields

In addition to the [standard fields](https://agiloft-public.atlassian.net/wiki/spaces/A2508SD/pages/134054074/Table+Concepts#standard_fields), the out-of-the-box Employees table includes the following fields.

| **Field Label** | **Data Type** | **Description** |
| --- | --- | --- |
| Activity History | Related Table: Tasks | A list of the related tasks the employee has worked on. |
| Adobe Sign Sender | Choice:<br>- Yes
- No | Indicates whether the employee is an Adobe Sign user. The default value is No. If set to Yes, the employee is activated as an Adobe Sign user so they can send agreements. |
| Adobe Sign Sending Account | EMail | If the user is an Adobe Sign Sender, this field contains a copy of the email address from the Email field. |
| Annual Sales Quota | Currency | This field lists the annual sales quota the user should meet. |
| Approval Source | Choice:<br>- Approval Template
- Document Management
- Ad Hoc Approval | Lists the source of the approvals the user is assigned to. |
| Backup Person  
Backup Person ID | Link to selected fields from other table: People | Defines an employee who can fill in for the user if they are away. |
| Button: Deactivate Employee | Action button | Deactivates the employee by setting their Employment Status to Inactive, resetting their password, and removing their email address as well as all groups, roles, and teams from their record. For more information, see [Deactivating Users](https://agiloft-public.atlassian.net/wiki/spaces/HELP/pages/43717058) in the Help Guide. |
| Button: Export to Outlook | Action button | If the system is configured to integrate with Outlook, this button can be used to export a user's information to Outlook. For details on the integration, see [Agiloft Contract Assistant for Outlook](https://agiloft-public.atlassian.net/wiki/spaces/HELP/pages/43719056). |
| Button: Grant Access to Adobe Sign | Action button | Grants the user access to Adobe Sign and triggers a rule that sets the Adobe Sign User field to Yes and copies the email address from the Email field to the Adobe Sign Sending Account field. |
| Cell Phone | Telephone/Fax | Mobile phone number for the employee. |
| City  
Location Company ID  
Location Company Name  
Country  
Location ID  
Location Name  
Location Type  
State / Province  
Street Address  
Street Address 2  
Zip or Postal Code | Link to selected fields from other table: Locations | Identifies the location of the company the employee works for. |
| Comments | Text | Any notes to add to the employee record. |
| Company Account Rep  
Company  
Company Roles  
Fax  
Company Goods/Services ID(s)  
Company ID  
Region  
Company Status  
Company Phone | Link to selected fields from other table: Companies | Displays additional company information. |
| Completed Tasks/Activities | Related Table: Tasks | Lists the tasks the user has completed. |
| Contact History | History | Shows the history of Employee record modifications for this user. |
| Contact Owner | Link to single field from multiple tables: People | Specifies the person responsible for the record. Defaults to the record creator. |
| Contact Table (choice) | Choice:<br>- External User
- Employee
- Person |  |
| Contract Request Source ID | Link to selected fields from other table: My Contract Requests | Stores the source ID of the linked Contract Request. Used to determine whether certain rules should run. |
| Create Supplier Profile | Choice:<br>- Yes
- No | Indicates whether to create a Supplier Profile record for this user. |
| Current Roles | Link to single field from other table: Roles | The roles assigned to the user. |
| Department Manager  
Department  
Department ID | Link to selected fields from other table: Departments | Identifies the employee's department manager and ID. |
| Direct Phone | Telephone/Fax | The work phone number for the employee. |
| DN | Short Text | The domain for the LDAP server if the user is an LDAP user. |
| Email | EMail | The employee's email address. |
| Employees Managed | Related Table: Employees | A list of the employees for whom this employee is their manager. |
| Employment Status | Choice:<br>- Active
- Inactive | Indicates whether the employee is currently employed at the company. |
| Ends Work at | Time | The time of day the employee stops working. |
| First Name | Short Text | The employee's first name. |
| Full Name | Compound | The full name of the employee. |
| Group | Link to single field from other table: Groups | Groups the employee is a member of. |
| Groups to Retain | Link to single field from other table: Roles | Stores the list of groups to retain if a role is removed for the user. |
| Hire Date | Date | The employee's hire date. |
| Home City | Short Text | The city the employee lives in. |
| Home Phone | Telephone/Fax | The employee's phone number. |
| Home Street Address | Short Text | The home address for the employee. |
| Home US State | Choice:   
AK, AL, AR, AZ, CA, CO, CT, DC, DE, FL, GA, GU, HI, IA, ID, IL, IN, KS, KY, LA, MA, MD, ME, MI, MN, MO, MS, MT, NC, ND, NE, NH, NJ, NM, NV, NY, OH, OK, OR, PA, PR, RI, SC, SD, TN, TX, UT, VA, VI, VT, WA, WI, WV, WY, N/A | The state the employee lives in. |
| Home Zip Code | Short Text | The zip code for the address. |
| Last Name | Short Text | The employee's surname. |
| LDAP User | Choice:<br>- Yes
- No | Indicates whether the user accesses Agiloft via LDAP authentication. |
| Login | Short Text | The username for accessing Agiloft with a standard username/password. |
| Management Diagram | Relationship Diagram Field | A diagram showing the organization the employee is in. |
| Manager Backup  
Manager Email  
Manager Name  
Manager ID | Link to selected fields from other table: People | Identifies a manager who can act as the employee's backup manager. |
| Monthly Sales Quota | Currency | The monthly sales quota for the employee. |
| My Approvals | Related Table: Approvals | Lists any Approvals where the user is the approver. |
| My Managed Contracts | Related Table: Contracts | Lists any Contracts where the user is the Contract Manager. |
| My Requested Contracts | Related Table: Contracts | Lists any Contracts where the user is the requester. |
| My Tasks and Obligations | Related Table: Tasks | Lists any Tasks where the user is the assignee. |
| Name (Login) | Short Text | Used to display the user's name and login on the History tab. |
| Name and Email | Compound | Used to display the user's name and email on the History tab. |
| Number of Staff Groups | Calculation on Multiple Linked Records | Lists the number of power user groups the user is in. |
| Open Tasks/Activities | Related Table: Tasks | Lists any open Tasks. |
| Opt Out | Multi-Choice:  
Do not email me | Allows the user to opt out of receiving emails from the system. |
| Password | Password | The employee's password. |
| Password Reset Date | Date/Time | The date on which to force the employee to change their password. |
| Picture | Image with Versioning | A picture of the employee. |
| Preferred Interface | Choice:<br>- Based on Permission
- EUI | For power users who log in with SSO, this field can be used to direct them to the End User Interface (EUI) instead of the Power User Interface.<br>- When set to Based on Permission, power users are logged in to the Power User Interface when they log in with SSO. This is the default value.
- When EUI, power users are logged in to the EUI when they log in with SSO.<br>> ℹ️ This setting only applies when the user logs in to Agiloft with SSO. |
| Primary Signature  
Primary Signature ID  
Primary Signature Name | Link to selected fields from other table: Signatures | These fields identify the default signature for use in email templates. |
| Primary Team | Link to single field from other table: Teams | The Primary Team for the user. |
| Pronouns | Text | The employee's preferred pronouns. |
| Role Group  
Role Team  
Role ID  
Role Description  
Update Role  
Role Uses Assigned License | Link to selected fields from other table: Roles | These fields display information about the chosen role if a new role is selected in the Update Role field. |
| Role ID for Preferred Interface  
Role Preferred Interface | Link to selected fields from other table: Roles | These fields are used to determine the user's preferred interface when Preferred Interface is set to Based on Permissions. |
| Role Update Notes | Append Only Text | Optional notes about the reason for the role update. |
| Role Uses Assigned License ID  
Roles Use Assigned License | Link to selected fields from other table: Roles | Indicates whether the role the user is assigned uses an assigned license. |
| Save and Continue | Action button | Allows you to save updates to the record and then continue updating it. |
| Sent Login | Choice:<br>- Yes
- No | Indicates whether the user was sent their login information. |
| Signatures | Link to selected fields from other table: Signatures | Lists email signatures for the user. |
| Skype Login | Short Text | The user's Skype username. |
| Source Contract ID  
Source Contract Party Type | Link to selected fields from other table: Contracts | Used to link the employee to a Contract. |
| SSO Authentication Method | Choice:<br>- STANDARD
- CAS
- SAML20
- OAUTH20 | This system-managed field lists the authentication method the employee used the last time they logged in to Agiloft. It's reset each time a user logs in. For system-generated hotlinks, this value controls which login URL the user receives in email, the standard username/password login URL or the SSO login URL.<br>- When STANDARD, email hotlinks for this user go to `login.jsp`.
- When CAS, email hotlinks for this user go to `cas-login`.
- When SAML20, email hotlinks for this user go to `samlssologin.jsp`.
- When OAUTH20, email hotlinks for this user go to `oauth20sso`. |
| Starts Work at | Time | The time of day the employee starts working. |
| Teams | Link to single field from other table: Teams | The teams the user belongs to. |
| Termination Date | Date | The date employment ended. |
| Title | Short Text | The job title for the employee. |
| Twitter Screen Name | Short Text | The employee's X name. |
| Twitter User ID | Integer | The employee's X user ID. |
| Type of Update | Choice:<br>- Add
- Remove | Determines whether to add or remove the selected role from the list of current roles. |
| User time zone | Choice:  
To view the choices, go to **Setup Employees** and click the Fields tab. Edit the User time zone field, and click Edit Choice List on the General tab. | The time zone for the user. |
| Work Status | Choice:<br>- Working
- On Vacation | Indicates whether the user is working or on vacation. |

You may notice that the Employees table also includes several legacy fields that aren't included in the layout by default. These legacy fields support modules that aren't typically enabled, like Matter Management, Sales and Marketing, and Service Desk: Actions Taken, All Document IDs Converted, Assets, Buying Stage, Change Requests Submitted, Contact Type(s), Created from Lead ID, Document Reviewer Team, Email Clicks from Outbound Emails, Email Pager, Email Status, Key Requirements, Last Document ID, Lead Created Via, Lead Source, Next Action, Next Action Due, Opportunities, Quotes, Rating, Reference as of, Related To, Sales Rep, Service Requests, Source for Template Conversion, Status, Successful Quotes, Supported User, Type of Contact, and Use as Reference.

# Automation

This section describes the rules that are implemented for the out-of-the-box Employees table. For details about rule configuration options, see [Rules](https://agiloft-public.atlassian.net/wiki/spaces/HELP/pages/43714473) in the Help Guide.

- **(Disabled) Edit: Handle Changes to Adobe Sign Sender value (web, API)**: This rule is disabled by default. If enabled, it runs when an Employee record is edited. If the Adobe Sign User field is Yes, it copies the email address from the Email field to the Adobe Sign Sending Account field and activates the employee as an Adobe Sign user. If Adobe Sign User is set to No, it deactivates the employee as an Adobe Sign user.
- **Create: Create Adobe Sign user (web, API)**: This rule runs when an Employee record is created. It finds records where Adobe Sign User field is Yes and performs the following actions:
  - Copies the user's Email value to the Adobe Sign Sender Email field if it's empty.
  - Activates the user as an Adobe Sign user.
- **Edit: Approval Record Creation (web, API)**: This rule runs when a record is edited. It finds records where the Last Document ID Text field was changed and the Add Document IDs Converted field doesn't contain the updated value and performs the following actions:
  - Creates an Approval record for the Last Document ID and assigns the employee as the Approver.
  - Appends Last Document ID Text to the All Document IDs Converted field's value.
- **TB Demo Data Update: Update date fields by one month each month so reports have data**: This time-based rule runs every 1 month at 12:00 am to update date fields for Demo Data records so they stay current.
- **Edit: Update Preferred Interface (web, API)**: This rule runs when an Employee record is edited. It finds records where the Role Preferred Interface value doesn't match the Preferred Interface value and updates the Preferred Interface field with the value from Role Preferred Interface.

# Ownership

Employee records are owned by the user with a login that matches the Login field of the record.