All Collections
Reports
Custom Reports: Index of Different Data Sources
Custom Reports: Index of Different Data Sources

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.

Jeffrey Mo avatar
Written by Jeffrey Mo
Updated over a week ago

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

Did this answer your question?