Employee Base

Use this base to see general information, and payroll and billing information for employees.

Available Columns Description Date Range Available Chartable Links to Page
General Information
Address 1 The first line in the main address for the employee      
Address 2

The second line in the main address for the employee

Examples: suite number, building number

     
Address 3 The third line in the main address for the employee      
Address

The first line in the main address for the employee

Example: street address

     
Allow Expense Entry Indicates the employee can enter expense reports      
City The city name in the main address for the employee      
Company Credit Card 1 The credit card the employee can use in expense reports     Bank Account
Company Credit Card 2 The credit card the employee can use in expense reports     Bank Account
Company Credit Card 3 The credit card the employee can use in expense reports     Bank Account
Company Credit Card 4 The credit card the employee can use in expense reports     Bank Account
Company Credit Card 5 The credit card the employee can use in expense reports     Bank Account
Company Credit Card 6 The credit card the employee can use in expense reports     Bank Account
Company Name The name of the company associated with the employee     Company
Contact 1 Information Information about the contact people associated with the employee     Contact
Contact 1 Text

Text about the contact people associated with the employee

     Contact
Contact 2 Information Information about the contact people associated with the employee     Contact
Contact 2 Text

Text about the contact people associated with the employee

     Contact
Contact 3 Information Information about the contact people associated with the employee     Contact
Contact 3 Text

Text about the contact people associated with the employee

     Contact
Contact 4 Information Information about the contact people associated with the employee     Contact
Contact 4 Text

Text about the contact people associated with the employee

     Contact
Contact 5 Information Information about the contact people associated with the employee     Contact
Contact 5 Text

Text about the contact people associated with the employee

     Contact
Country The country name for the employee      
CRM Client ID The client ID associated with the employee in CRM      
Department Name The name of the department associated with the employee     Department
Email The email address for the employee      
Employee Type The client type associated with the employee     Employee Type
Fax Text The fax number for the employee      
Fax A description of the fax number for the employee      
Gender The gender of the employee      
Has Credit Card Indicates the employee has at least one active credit card      
Is Accounting Indicates the employee is marked as accounting manager in their employee setup      
Is Marketing Contact Indicates if the employee is the marketing contact      
Is Principal Indicates if the employee is the principal      
Is Project Manager Indicates if the employee is the project manager      
Is Salary Indicates if the employee is salaried      
Is Supervisor Indicates if the employee is the supervisor      
Is Timesheet Entered Indicates the employee has entered a timesheet in Ajera X    
Mailing Address 1

The first line in the mailing address for the employee

Example: street address

     
Mailing Address 2

The second line in the mailing address for the employee

Examples: suite number, building number

     
Mailing Address 3 The third line in the mailing address for the employee      
Mailing Address The first line in the mailing address for the employee      
Mailing City The city name in the mailing address for the employee      
Mailing Country The country name in the mailing address for the employee      
Mailing State The state name in the mailing address for the employee      
Mailing ZIP The ZIP code in the mailing address for the employee      
Notes Any notes about the employee      
Phone 1 Number The primary phone number for the employee      
Phone 1 Text

A description of the primary phone number for the employee

Examples: Office, Cell

     
Phone 2 Number The secondary phone number for the employee      
Phone 2 Text

A description of the secondary phone number for the employee

Example: Home

     
Phone 3 Number The tertiary phone number for the employee      
Phone 3 Text A description of the tertiary phone number for the employee      
Phone Numbers The phone numbers for the employee      
Roles The security roles assigned to this employee      
State The state name in the main address for the employee      
Status

The status of the employee

Examples: Active, Inactive

     
Successful Microsoft Entra ID Login This indicates if the employee has successfully logged in with Microsoft Entra ID      
Timesheet Daily Details Enabled This indicates if Timesheet Daily Details is enabled in Setup > Employees.      
Title The job title of the employee      
Website The website URL associated with the employee      
ZIP The ZIP code in the main address for the employee      
People
Contact 1 Name The names of the contact people associated with the employee     Contact
Contact 2 Name The names of the contact people associated with the employee     Contact
Contact 3 Name The names of the contact people associated with the employee     Contact
Contact 4 Name The names of the contact people associated with the employee     Contact
Contact 5 Name The names of the contact people associated with the employee     Contact
Contact 6 Name The names of the contact people associated with the employee     Contact
Contact 7 Name The names of the contact people associated with the employee     Contact
Contact 8 Name The names of the contact people associated with the employee     Contact
Contact 9 Name The names of the contact people associated with the employee     Contact
Contact 10 Name The names of the contact people associated with the employee     Contact
Contact 11 Name The names of the contact people associated with the employee     Contact
Contact 12 Name The names of the contact people associated with the employee     Contact
Contact 13 Name The names of the contact people associated with the employee     Contact
Contact 14 Name The names of the contact people associated with the employee     Contact
Contact 15 Name The names of the contact people associated with the employee     Contact
Contact 16 Name The names of the contact people associated with the employee     Contact
Contact 17 Name The names of the contact people associated with the employee     Contact
Contact 18 Name The names of the contact people associated with the employee     Contact
Contact 19 Name The names of the contact people associated with the employee     Contact
Contact 20 Name The names of the contact people associated with the employee     Contact
First Name The first name of the employee     Employee
Last Name The last name of the employee     Employee
Middle Name The middle name of the employee     Employee
Name The first name and last name of the employee     Employee
Supervisor The name of the employee's supervisor     Employee
Dates
Date Born The birth date of the employee      
Date Hired The employee's date of hire      
Date Rehired If the employee was rehired, the rehire date      
Date Terminated

If the employee was terminated, the termination date

If this field contains a date, the employee is automatically given a status of Inactive unless the Date Rehired field contains a date later than the date terminated.

      
Last Microsoft Entra ID Login This displays the date the employee last logged in with Microsoft Entra ID      
Last Password Change This displays the date the employee's password was last changed      
Hours/Units
Accrual Hours The total number of hours accrued for the employee X X  
Billed Hours The total number of hours billed to the employee X X  
Hours Worked The total number of hours worked by this employee X X  
Premium 1 Hours Worked The total premium 1 hours charged to this employee X X  
Premium 2 Hours Worked The total premium 1 hours charged to this employee X X  
Premium 3 Hours Worked The total premium 1 hours charged to this employee X X  
Regular Hours Worked The total regular hours worked by this employee X X  
Resource Hours The total number of resource hours entered to projects for the employee   X  
Scheduled Hours The total number of scheduled project hours for the employee X X  
WIP Hours Total WIP hours X X  
Written off Hours Total written off hours X X  
Dollars
Billed Labor The amount of labor billed to the employee X X  
Cost Labor + Premium Burdened The cost amount of the phase + the premium cost+ the overhead amount X X  
Cost Labor + Premium

The cost amount of the phase + the premium cost

This does not include any markups.

X X  
Cost Labor Burdened The cost amount of the labor for the phase + the premium cost X X  
Cost Labor The cost amount of the labor for the phase X X  
DPE % General Direct Personnel Expense non project related X    
DPE % Project Direct Personnel Expense project related X    
Payroll Cost Labor Burdened

The payroll cost of labor for the employee with overhead and DPE costs included

Payroll cost is the total sum of money to be paid out to employees at a given time.

X X  
Payroll Cost Labor

The payroll cost of labor for the employee without overhead and DPE costs

Payroll cost is the total sum of money to be paid out to employees at a given time.

X X  
Premium Cost The cost amount of representing the increase to the employee's pay to reflect pay for hours entered as premium time (such as overtime and double time) for the phase X X  
Resource Cost The cost amount of the resource time assigned to this employee   X  
Resource Fee The fee amount of the resource time assigned to this employee   X  
Scheduled Dollars The amount of dollars scheduled to the project X X  
Spent Labor The amount of labor performed by the employee at the billing rates X X  
Target Billable The target billable percent entered on the employee   X  
WIP Labor The amount of work-in-progress (WIP) for labor for the employee X X  
Written off Labor The amount of write-off for labor for the employee X X  
Keys
Ajera Employee Key in Mapping Table The database identifier of the Ajera employee key in the CRM mapping table      
Company Credit Card 1 Key The database identifier of the first credit card associated with the employee     Bank Account
Company Credit Card 2 Key The database identifier of the first credit card associated with the employee     Bank Account
Company Credit Card 3 Key The database identifier of the first credit card associated with the employee     Bank Account
Company Credit Card 4 Key The database identifier of the first credit card associated with the employee     Bank Account
Company Credit Card 5 Key The database identifier of the first credit card associated with the employee     Bank Account
Company Credit Card 6 Key The database identifier of the first credit card associated with the employee     Bank Account
Company Key The database identifier of the company associated with the employee     Company
Contact 1 Key The database identifier of the contact associated with the employee     Contact
Contact 2 Key The database identifier of the contact associated with the employee     Contact
Contact 3 Key The database identifier of the contact associated with the employee     Contact
Contact 4 Key The database identifier of the contact associated with the employee     Contact
Contact 5 Key The database identifier of the contact associated with the employee     Contact
Contact 6 Key The database identifier of the contact associated with the employee     Contact
Contact 7 Key The database identifier of the contact associated with the employee     Contact
Contact 8 Key The database identifier of the contact associated with the employee     Contact
Contact 9 Key The database identifier of the contact associated with the employee     Contact
Contact 11 Key The database identifier of the contact associated with the employee     Contact
Contact 12 Key The database identifier of the contact associated with the employee     Contact
Contact 13 Key The database identifier of the contact associated with the employee     Contact
Contact 14 Key The database identifier of the contact associated with the employee     Contact
Contact 15 Key The database identifier of the contact associated with the employee     Contact
Contact 16 Key The database identifier of the contact associated with the employee     Contact
Contact 17 Key The database identifier of the contact associated with the employee     Contact
Contact 18 Key The database identifier of the contact associated with the employee     Contact
Contact 19 Key The database identifier of the contact associated with the employee     Contact
Contact 20 Key The database identifier of the contact associated with the employee     Contact
Department Key The database identifier of the department associated with the employee     Department
Employee Key The database identifier of the employee     Employee
Employee Type Key The database identifier of the Employee type associated with the employee     Employee Type
Supervisor Key The database identifier of the supervisor associated with the employee     Employee
Talent Key The database identifier associated with the Talent integration      
Action
Delete CRM Mapping

Deletes the selected employee from the CRM mapping table.

For more information , see Maintaining the CRM Mapping Table.

      
Gantt

unavailable in ajeraCore Select to add the Gantt chart to your table widget.