Custom Reports: Index of Different Data Sources

Last Updated: Feb 03, 2017 11:30AM EST
While we have standard reports built into our Reports tab, you can also use our custom report feature to build your own report. In order to create a report that is useful for your needs, you’ll have to select which data you want filtered into your report. There are many different data sources you can choose from, all which represent different pockets of information.

We've created a breakdown of all the data sources you have to choose from and what each report field means:
Employee (EMCust - Employee Custom): All the data sources that hold employee information will include the Employee Custom data source. It holds a standard list of employee data fields you can select to add into your custom report to differentiate data. We will define each field here and direct you back to this explanation whenever we note a data source that includes this list (10 out of 13 of the data sources include it).

LastFirst - Last name, first name
Employee Number - Employee number
Status - Active or terminated
Pay Group - Pay group assigned
Location - Location they work at
Job - Job
Position - Position
Job Title - Job Title
Clock Number - Clock number they're enrolled with on the clock 
Hire Date - Hire date
PayType - Hourly or salary
SSN - Social Security Number
First Name - First name
Middle - Middle initial
LastName - Last name
Department – Department
*After “Department” if you have other cost center levels they will be displayed here
FirstLast - First name, last name
Address1 - Address Street Number, Street Name, PO Box
Address2 -  Apartment, Floor, Suite, Bldg # or more specific information to supplement Address1
City - City
State - State
Zip Code - Zip Code
Phone - Phone number
Email - Email address
Date of Birth - Date of birth
Gender - Gender
ClockStatus - In or Out
Standard Hours - The hours the employee is standard to work 
Termination Date - Termination Date
Task - Task 

EARequests - Employee Absence Requests:

Employee Data Source
Absence Requests:

Code – The code (i.e. VA)
Description – The description (i.e. Vacation)
Date - Desired date requested off
Reason – Note/Reason requested off 
Hours - Hours requested off
Minutes - Minutes requested off
EMAccrual1 - Employee Active PTO Requests and EMAccruals - Employee PTO Accruals
The difference between Employee Active PTO Requests and Employee PTO Accruals is that Active PTO Requests display the last active record of an employee’s accrual and Employee PTO Accruals shows your employees’ entire history of accruals.
Employee Data Source
PTO Accruals:
Accrual Code - The codes assigned to your accrual policies (i.e. SK)
Accrual Description - The description of your accrual policies (i. e. Sick)
Balance As Of Date – The amount of time off remaining that they can use as of the date you run the report
Allowed Hours -  Current allowance of hours your employee has
Used Hours - The amount of hours your employees have used up from their allowed hours
Balance Hours – The amount of hours your employee has remaining
Pending Hours – Hours that are not available as of yet pending to be accrued
Last Accrual Date - Last time your employees accrued PTO (i.e. quarterly, Jan 1st, etc.) 
Last Rollover Date - Last date for rolling over leftover PTO
Last Pending Moved - Last time the employee had pending hours that were moved to balance/allowed bucket 

EMEX - Exceptions
Employee Data Source

Code - The code (i.e. MP) 
Description - The description (i.e. Missed Punch)
Severity - Low, Medium, or High 
Reviewed - Supervisor or admin has reviewed the exception and checked it off
Message - The details included in the "More Info" field of the exception within the time card
Date - Date the exception occurred
Actual Time In - Actual time in
Actual Time Out - Actual time out
Rounded Time In - If rounding policy in place, the rounded time in
Rounded Time Out - If rounding policy in place, the rounded time out 
Hours - Total hours for each in and out

EMPH - Paid Hours
Employee Number - Employee number
Date Worked - Date worked
Code - Earning code (i.e. RG for regular) 
LastFirst - Last name, first name
Hours – Amount of hours they're getting paid for
Amount – Amount being paid
Department Punched - Department they punched into
*Additional cost center levels shown based on your company’s setup
JobPunch - Job they punched into
TaskPunch - Task they punched into
Short Description - The short description of the earning code
Description – Earning description
Department Punched Description - The full description of the department they punched into
*Additional cost center levels shown based on your company’s setup
Department - The department they belong to 
Job - Job they were on
PayGroup – Pay group assigned to
Do Not Export to Payroll - Do not export to payroll (i.e. salaried employees who punch in but you don't want exported to payroll)
JobDescription Punch -  If there’s a description for the job
TaskDescription Punch – If there’s a description for the task
Time In - Time in 
Time Out - Time out
Job Title - Job title
Task - Job task

* Both Paid Hours and Paid Hours Sum are row-based reports categorized by earning codes like RG, OT, etc. However, the way each report organizes and displays the time data is different. Paid Hours reflects every pair of punches (for every in and out pair of punches, there is a separate record shown). Paid Hours Sum reflects the total hours for the date range you are running. 

EMPH2 - Paid Hours Sum
Employee Data Source
Paid Hours: 

EarningCode - Earning code (i.e. OT)
Short Description - Short description of the earning code (i.e. OT)
Earning Description - Long description of the earning code (i.e. Overtime only after certain amount of hours)
Hours - Amount of hours that they get for that earning code
Amount - Amount of hours getting paid for, according to that earning code 

EMPH1 - Paid Hours Crosstab By Type 
Employee Data Source
Paid Hours:

Worked Hours - Number of hours worked
Worked Amount - Amount of hours getting paid for work 
Overtime Hours - Number of overtime hours worked
Overtime Amount - Amount of hours getting paid for overtime
Premium Hours - Number of premium hours worked (night differentials, weekend differentials, etc.)
Premium Amount - Amount of hours getting paid for premium 
Misc Hours - Number of miscellaneous hours worked 
Misc Amount - Amount of hours getting paid for miscellaneous 
Rate – Amount earned per hour
Absence Hours – Number of hours absent
Absence Amount - Amount of hours getting paid for absence
Break Hours - Number of break hours taken
Break Amount - Amount of hours getting paid for break 
Meal Hours - Number of meal hours taken
Meal Amount - Amount of hours getting paid for meals
Worked Day Count - Number of days worked during given time frame (i.e. 7 days)
Absence Day Count - Number of days absent during particular time frame
Holiday Hours  - Number of holiday hours taken
Holiday Amount - Amount of hours getting paid for holiday

* Crosstab by Type vs. Paid Hours by Earning
In Crosstab by type, the report breaks the data down by the 7 earning types that exist in FingerCheck: break, premium, miscellaneous, meal, overtime, holiday, and comp time. Each column will show a different earning type. For Paid hours by Earning, you manually enter the earning codes you want to see. So for instance Hours_ OT, Hours_RG.

EMPH3 - Paid Hours by Earning
Employee Number – Employee Number
Hours_Code – You will manually replace the word “code” with the actual earning code you would like to see, so for example you might enter Hours_RG, Hours_OT, etc.
Amount_Code - Amount being paid
LastFirst – Last name, first name
Department - Department
SSN – Social security number
BaseRate – Base rate

* For Paid Hours by Earning by Job, you would manually enter the earning codes you want to see again, but can now break the total down by job and department.

EMPH4 - Paid Hours by Earning by Job 
Employee Number – Employee Number
Hours_Code – Earning code, such as Hours_RG or Hours_OT
Amount_Code - Amount being paid
SSN – Social security number
LastFirst – Last name, first name
JobPunch – Job punched for
Job Description Punch – Description of job punched for
Task Punch – Task punched for
Task Description Punch – Description of task punched for
Department Punched – Department punched for
Department Description – Description of department assigned
Department – Department assigned

EMPLMAST1 - Employee Rates:
Employee Data Source

Start Date - Start date of when they started accumulating that rate
Rate - Rate 

EMPR - Employee Profiles
Employee Data Source

Master Profile - Default profile for employees that hold employee policies
Schedule Policy - Schedule policy being used for their profile
Pay Schedule - How often they get paid
Holiday Policy - Holiday policy being used for their profile
Premium Policy - Premium policy being used for that profile

EMPSCH2 - Schedules vs Actual
Employee Data Source
Employee Schedule:

Date – Date worked
Actual Hours - Actual hours worked
Scheduled Hours - Hours scheduled to work
Actual TimeIn - Actual time punching in
Actual TimeOut - Actual time punching out
Rounded TimeIn - Rounded time punching in
Rounded TimeOut - Rounded time punching out
Schedule TimeIn - Time scheduled to come in
Schedule TimeOut - Time scheduled to leave

ERequests - Employee Requests 
Employee Data Source
Employee Requests:

Code - The code of absent request requesting (i.e. SK for Sick)
Request Status - Whether their request is pending, approved, or denied

Payroll1 - Payroll Checks
Employee Data Source
Payroll Checks:
Check Date
Check Number
Department Check
Department Check Description
Sub Department Check
Sub Department Check Description
DirectDeposit Amount
Gross Amount
JobCheck Description
Net Check Amount
Net Pay
Period Begin
Period End 
TaskCheck Description
Total Deductions
Total Earnings
Total EE Taxes
Total ER Taxes
Total Hours
Total Taxes
Voucher Number

Payroll2 - Payroll Check Details 
Employee Data Source
Payroll Check Detail

Check Date
Check Number

Code Type
Direct Deposit Amount 
Entry Type
Exempt Wages
Gross Amount
Job Code
Job Description
Memo Only 
Net Check Amount
Period Begin
Period End
Record Type
Short Description
Subject Wages
Taxable Wages
Total Hours
Voucher Number 

Payroll3 - Payroll Details Cross Tabs
Employee Info 
Check Info

TCDetail - Time Card Detail 
Employee Data Source
DateWorked – Date worked
TimeIn – Time in
TimeOut – Time they left
Hours – Total amount of hours
Department Punched – The department code
FirstName – First name
MiddleInitial – Middle initial
LastName – Last name
LastFirst – Last name, first name
Clock Number – Employee clock number
In Note – Note for in punch
Out Note – Note for out punch
In Details – Details for in punch
Out Details – Details for out punch
Department – Actual department employee belongs to
*Additional cost center levels shown based on your company’s setup
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
Invalid characters found