GAMs Payroll Export
GAMs Payroll Export
GAMs Payroll Export is the report in IC that contains all of the payroll data that IC has collected for a selected pay period. This report is then sent to the GAMs system to be processed and then sent further to ADP to generate pay checks.
Report Details
Filters
- Pay Period
- Single selection drop down for which pay period timeframe
- Team(s)
- Displays a list of active IC Teams with the word Posted next to the name if that team has posted for the selected pay period.
- This filter does not affect the data pulled in the report, it is used to indicate to the person running the report whether the teams are posted.
- Country
- Multi-select list of countries to pull for payroll
- Report type
- Regular or Terminated
- Regular only pulls verified hours
- Terminated pulls hours that have not been verified yet
- All/Current/Late
- Filters the report for
- All pay - the default, anything coded for the pay period is pulled
- Current - only things coded to the pay period where the date is within the pay period is pulled
- Late - only things coded to the pay period where the date is before the pay period is pulled
- Employee File #s
- Employee ID's to search for or exclude
Columns
Columns returned and their meaning
TimeCard sheet
- First Name
- First name of the employee
- Middle Name
- Middle name of the employee
- Last Name
- Last name of the employee
- Time Card Prefix
- A single character designator for the kind of payroll the line represents
- M - represents mileage and drive time
- T - represents training time (Engage Center)
- V - represents store visits
- Shift#/TimeCardID
- Unique identifier of the particular row of payroll
- EmployeeID
- LocationID
- Unique identifier of the location work was performed, set to 0 when location cannot be reported
- ProjectID
- Job code as assigned by Client Service for the work
- DateOfVisit
- StartTime
- start time of work where available
- EndTime
- end time of work where available
- LunchStart
- break start time that occurred during a shift
- LunchEnd
- break end time that occurred during a shift
- WorkedHrs
- calculated hours worked from time in/outs
- RateType
- The ADP Rate Type being used to pay this work
- TravelHrs
- TravelMiles
- TravelMiles$
- Mileage converted to dollars to be paid out
- TrainingHrs
- Time spent on training courses
- DriveTimeRateType
- Drive time rate to pay for drive time
- All codes start with DT and may be at the state rate or municipality
- AdminHrs
- Admin time recorded as part of a visit
- StoreState
- The state the work location is located
- StorePostalCode
- The postal code the work location is located
- TeamID
- The ID of the IC team the work was performed for
- TeamName
- The name of the IC team the work was performed for
- PositionTypeName
- The position type the employee was while performing the work
AdditionalPayroll sheet
- AdditionalPayrollID
- Unique identifier for this additional pay
- EmployeeFileNumber
- JobCode
- PayrollAmount
- Amount in dollars to be paid
- PayrollCode
- Type of additional payroll being paid out, options are:
- ATO - Auto allowance
- BON - Bonus
- COM - Commission
- DRT - Drive Time
- MLG - Mileage
- HoursAmount
- Number of hours the payroll amount represents for Drive Time
- WorkDate
- Date additional pay is being applied to
Report Rules
General Rules
These general rules govern how the report operates
- Only non-Time and Attendance employees are processed
- Person must be a BDS employee
- Payroll must be verified
- Job codes are assigned by account team for work type
- Payroll is for selected pay period
In Store/Admin Hours
- Visit must be marked complete
- Visit must contain hours
- Employee country in selected countries
- Rate Type determined by
- Position type of rep or
- Override set up by account team in billing
Mileage
- Rate type: 9
- Mileage rate either
- Set to State rate for Break Fix
- Most states set $0.35/mile
- DC, IA, MN, MT, ND, NH, SD set $0.67/mile
- Set to $0.67/mile for all other teams
- Except for CA, MA and IL that are all paid out at $0.70/mile
- Canadian mileage payout calculated using this formula:
- Miles x 1.609 (convert to km) x $0.70/km
- Mileage smoothed across jobs (see [Mileage and Drive Time])
Drive Time
- Rate type: 9
- Combined on same line as mileage
- Drive time smoothed across jobs (see [Mileage and Drive Time])
- Drive Time Reference code pre-calculated on drive time submittal
Course Time
- Rate Type: 1
- Required courses only
Additional Payroll
- Additional payroll can be exported for all employees, regardless time entry system