SmartFusion Modules > Payroll > Maintenance > Special Maintenance > Time and Attendance Systems > Import EMMA to Temp Pay

Recent Changes:  
6.244 - 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 allow for import/exporting of Payroll Temp Pay files to and from the EMMA system.

Fields

  • Import EMMA (Checkbox)
    • Enter filename
  • Export standard information (Checkbox)
    • Export path

Import File Layout

CSV delimited without headers

  • Col1 = SSN as String
  • Col2 = PayType as String
  • Col3 = PayRate as Decimal (Number of decimal places will be rounded based on the system setting on Payroll System Settings Page 3)
  • Col4 = Hours as Decimal
  • Col5 = PayDate as Date
  • Col6 = Account as String
  • Col7 = PayNote as String
  • Col8 = WorkHours as Decimal

Export File Layout

CSV delimited with headers
The filename defaults to TimeAndAttendanceInfo.csv after selecting the file path, but can be changed if needed.

  • Col1 = EmployeeID
  • Col2 = FirstName
  • Col3 = LastName
  • Col4 = Address
  • Col5 = City
  • Col6 = State
  • Col7 = Zip
  • Col8 = Department
  • Col9 = DepartmentDescription
  • Col10 = Class
  • Col11 = ClassDescription
  • Col12 = Category
  • Col13 = CategoryDescription
  • Col14 = SalaryClass
  • Col15 = SalaryClassDescription
  • Col16 = Location
  • Col17 = LocationDescription
  • Col18 = PayPeriod
  • Col19 = PayPeriodDescription
  • Col20 = PayType
  • Col21 = PayTypeDescription
  • Col22 = PayRate
  • Col23 = SalaryPayRate
  • Col24 = DailyRate
  • Col25 = FTE
  • Col26 = LaborGLAccount
  • Col27 = LeaveCode
  • Col28 = LeaveDescription
  • Col29 = LeaveBalance
  • Col30 = DateTerminated
  • Col31 = Status
  • Col32 = DailyHoursWorked
  • Col33 = DateOfBirth
  • Col34 = DateHired
  • Col35 = SSN
  • Col36 = PartialSSN
  • Col37 = ExemptStatus