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
|
|
|
|
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 Azure Login |
This displays the date the employee last logged in with Azure |
|
|
|
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.
|
|
|
|