IC Field Payroll Overview
Field Payroll Overview
Insight Center collects hours/mileage and drive time from Field Reps during their daily activities. After it is posted it is exported using an IC report, imported to GAMs for payroll pre-processing before being exported from GAMs and uploaded to ADP to pay the reps. Below is a workflow of overall process. Below the diagram are details about the flow tasks.
Workflow
![]()
Insight Center collects:
- In store hours
- Admin hours
- Mileage
- Drive Time hours
- Course Hours
- Additional payroll
Hours and Mileage detail is transmitted to GAMs using an IC Payroll Export report that exported from IC and is uploaded to GAMs
GAMs processes the Payroll file, combines that data with Pay Rates that are received from Snowflake, performs payroll and overtime calculations and outputs a file that can then be uploaded to ADP.
ADP is the source of truth for employees and their pay rates. This data is extracted from ADP and stored in Snowflake for use in other downstream systems.
Snowflake is our data warehouse system, housing a variety of data from various systems along with the integrations to keep that data up to date. It is the waypoint along which employee information is stored.
Payroll Types and Administration
Call Form In store and Admin hours
Call form in store and admin time represent the regular hours a rep enters for normal store visits. In store time is collected as time in and out values. Admin time is collected as a number of minutes. These hours are collected via mobile and web entry.
Further details in this article: Call Form Hours Entry
Mileage and drive time
Mileage and drive represent the miles driven and the amount of time spent driving as part of a reps work day. It is calculated at the end of the day when the rep submits their mileage for the day. Both mileage and drive time are calculated using Microsoft Bing maps using the route the rep drove during the day based on their entered visits.
Further details in this article: Mileage and Drive Time Calculation and Rules include smoothing and minimum wage rules
Mobile Mileage Entry
Commute and Mileage
Team Mileage Setup
Course Hours
Course hours represent time spent taking required Engage Center courses. These hours are imported from Engage Center throughout the day and is available for editing via the Work Detail.
Further details in this article: Engage Center Course Hours
Additional Payroll
Additional Payroll is used for anything nor covered above, bonuses and commissions are just two of the things that can be added. This is done via an upload on the Work Review screen.
Further details in this article: Work Review
Reviewing and Verifying Payroll
Field teams use the Work Review and Work Detail screens in Insight Center to review and verify payroll for field reps. This is also where the teams can upload Additional Payroll and post the teams hours so they are available for payroll to pull.
Work Review
Work Detail
Payroll Export
Payroll collected in Insight Center is exported once every pay period using the GAMSEmployeePayImport report found in the reporting section of the system under the Payroll team. This report is what is provided to GAMs for further processing.
Further details in this article: GAMs Payroll Export
Payroll Processing - GAMs
The payroll file is transmitted to GAMs for processing.
In addition to the payroll file there are other data feeds required to process payroll, these feeds are listed here: GAMs Data Integrations with IC/ADP