Fairbank Group - Cranmore & Jiminy (Checkwriters)

Overview

Payroll System	Checkwriters
Files Used	Wages - Punches Incentives Timekeeping - Used by Jiminy for GDR when Paid Activity paycode = GDR
Transfer Method	Manual
Days to Include	7 days
Header Row	Wages - Yes Incentives - No Timekeeping - 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

• The Timekeeping file is used for uploading GDR hours for Jiminy to top instructors up to a minimun daily rate.

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	Yes	If Paycode = GDR redirect Pay from Wage file to Timekeeping file	Earning Code
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

Timekeeping File Format

payroll system field/column name	flaik source field name
Employee Code	Employee Profile -> PayrollID
Transaction Date	Lesson Date
Earning Code	Paid Activity -> Paycodes -> Pay code
Cost Center 1
Cost Center 2
Cost Center 3	Paid Activity -> Business Structure -> Export business structure name
Cost Center 4
Cost Center 5
Shift Code
Job Code	Paid Activity -> Jobcodes -> Job Code
Hours	Totaly Hours of GDR type pay for that employee for that day
Date/Time In
Date/Time Out
Override State
Notes