You are here: Ajera Help (A-Z) > inquiries > inquiry descriptions > Employee inquiry

Employee inquiry

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

Tracking personnel benefits

One way you may want to use this inquiry is to track direct personnel benefits as a percent of gross payroll or as a percent of project cost.

Add these columns to the inquiry:

DPE % General
DPE % Project

Note:

To get an accurate picture of your employer-paid benefits, set up fringes.

After you process payroll, Ajera calculates amounts for the columns as follows:

Column	Calculation
DPE % General	[(Employer Tax + Fringe Amount) / Gross Payroll] * 100
DPE % Project	[(Employer Tax + Fringe Amount) / Direct Project Cost] * 100

Predefined columns

You can add predefined columns to this inquiry. These columns are available:

General info

Employee Key

Name

Status

First Name

Middle Name

Last Name

Title

Target Billable

DPE % General

DPE % Project

Note:

When adding the DPE % General or DPE % Project column, a Date Range field appears (with the Range Prompt already selected) on the Properties for Column on Inquiry window. Leave Range Prompt selected. On the inquiry, the words All Dates appear in blue underlined text under the name of the inquiry. Click the All Dates text to enter the date range for calculating DPE%.

Is Timesheet Entered

Note:

When adding this column, a Date Range field appears (with the Cutoff Prompt option already selected) on the Properties for Column on Inquiry window. Leave Cutoff Prompt selected. On the inquiry, the words All Dates appear in blue underlined text under the name of the inquiry. Click the All Dates text to enter a timesheet ending date. A check mark then appears in the column to indicate which employees entered timesheets for that date.

Employee Type Key

Employee Type

Department Key

Department

Company Key (multi-company only)

Company Name (multi-company only)

Supervisor Key

Supervisor

Is Principal

Is Supervisor

Is Project Manager

Is Accounting