SmartFusion Modules > Payroll > Maintenance > Special Maintenance > Time and Attendance Systems > Kronos Import/Export

Recent Changes:  
6.244 - When importing into Temp Pay, the Pay Rate number of decimals will now pull from the "Number of decimals for pay rate" system setting on Page3 of the Payroll System File.

Introduction

This screen will export payroll information to a file so Kronos can read it in. It will also read in payroll information from Kronos to SmartFusion.

Fields

• Export path
• Export lookup table to Kronos
• Export SmartFusion to Kronos
  • Enter accrual date for leave
• Import into temporary pay from Kronos
  • Enter filename
  • Zero regular pay
  • Exceptions
  • Disable deductions
  • Disable direct deposit
  • Disable 2nd direct deposit
  • Disable additional tax
  • Combine hours / pay

Export Lookup Table Layout

CSV delimited with headers
The filename is wagerate.csv

• cidnum (pay type + employee number + FL account number)
• ypayrate
• ydfltrate

Export File Layout

Export Payroll

CSV delimited with headers
The filename is import.csv

• cfirst | varchar(25)
• clast | varchar(25)
• cssn | varchar(11)
• cemail | varchar(50)
• dhire | datetime
• caddress | varchar(35)
• ccity | varchar(20)
• cstate | varchar(2)
• czip | varchar(10)
• cphone | varchar(14)
• clabor | varchar(40)
• cpayrule | varchar(1)
• cstatus | varchar(1)
• deffective | datetime
• ccat | varchar(6)
• ccatdesc | varchar(25)
• yhrdaily | money
• dchange | datetime
• dinactpr | datetime
• cdept | varchar(6)
• cdeptdesc | varchar(25)

Export Leave

CSV delimited with headers
The filename is leave.csv

• creqcode | varchar(1)
• cempid | varchar(11)
• caccrcode | varchar(6)
• cpostdate | varchar(1)
• cposttime | varchar(1)
• deffect | datetime
• yamount | money
• cprobamt | varchar(1)
• cuser | varchar(1)

Import File Layout

CSV delimited with no headers