Fairbank Group - Cranmore & Jiminy (Checkwriters)

Overview

Payroll System	Checkwriters
Files Used	Wages Only &: Incentives
Transfer Method	Manual
Days to Include	7 days
Header Row	No

Unique Requirements

• If no hourly wage is defined in Employee Profile or if hourly Wage is $0 please generate the punch anyway (some timekeeping types don't generate a punch if there is no wage dollar amount entered)

• Cranmore will use the Jobcode field and Jiminy will not, so it will always be blank for Jiminy and will not be enabled in their UI

UI/flaik Fields Used

FIELDS TO ENABLE		flaik (Column/Field to Pull from in flaik)	Checkwriters (Column/Field to Push To)
Paid Activity -> Jobcode	YES	Paid Activity -> Jobcodes -> Job Code (TBA for Jiminy)	Job Code
Paid Activity -> Paycode	NO
Paid Activity -> Business Structure	YES	Paid Activity -> Business Structure -> Export business structure name	Cost Center 3
Incentive -> Paycode	YES	Incentive -> Paycodes -> Pay Code	Code

Wages File Format

payroll system field/column name	flaik source field name
Employee Code	Employee Profile -> PayrollID
Transaction Date	Start Date Time of Paid Activity
Punch Time	Start Date Time of Paid Activity
Cost Center 1	Not Used
Cost Center 2	Not Used
Cost Center 3	Paid Activity -> Business Structure -> Export business structure name
Cost Center 4	Not Used
Cost Center 5	Not Used
Job Code	Paid Activity -> Jobcodes -> Job Code
Shift Code	Not Used
Time Code	Not Used
Code1	Not Used
Code1 Value	Not Used
Code2	Not Used
Code2 Value	Not Used
Code3	Not Used
Code3 Value	Not Used
Code4	Not Used
Code4 Value	Not Used
Status	Paid Activity -> If Start Time then Clockin, If End Time then ClockOut
Transaction Note	Not Used

Incentives File Format

payroll system field/column name	flaik source field name
Employee ID	Employee Profile -> PayrollID
Name	Last Name, First Name
DET	Hardcode to "E"
Code	Incentive -> Paycode
Hours	Not Used
Rate	Not Used
Amount	Amount (Dollars)
JobCode	Paid Activity -> Jobcodes -> Job Code
CC3	Paid Activity -> Business Structure -> Export business structure name