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 to be filtered into your report.
There are many different data sources you can choose from, all of which represent different pockets of information.
In order to inform you of all your options, we have 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 to 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 number of hours your employees have used up from their allowed hours
Balance Hours – The number 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
Exceptions:
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 to be 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 a 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 the absence
Break Hours - Number of break hours taken
Break Amount - Amount of hours getting paid for the 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 a given time frame (i.e. 7 days)
Absence Day Count - Number of days absent during a particular time frame
Holiday Hours - Number of holiday hours taken
Holiday Amount - Amount of hours getting paid for the 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
PaidHours:
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
PaidHours:
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 the department assigned
Department – Department assigned
EMPLMAST1 - Employee Rates:
Employee Data Source
Rates:
Start Date - Start date of when they started accumulating that rate
Rate - Rate
EMPR - Employee Profiles
Employee Data Source
Profiles:
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 - The 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
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