Exporting CSV Files from this Application to ADP PC/Payroll For Windows
The CloudSuite Industrial external payroll interface (EPI) exports Paydata records to the ADP PC/Payroll for Windows system. Before exporting payroll-related data, the data must be generated through the standard CloudSuite Industrial payroll system to create payroll transaction records (prtrx) for each employee.
The Generate Payroll activity summarizes:
- Direct and indirect job labor transactions
- Data collection time and attendance transactions
- HR sick and vacation attendance records
- Payroll hours and sales commissions
The activity stores the payroll data in the CloudSuite Industrial Payroll Transaction table (prtx records). Each payroll transaction record includes all the hours worked by the employee. Data includes regular, overtime, double-time, holiday pay, sick leave and vacation hours for non-salaried employees.
You can use the Generate Payroll activity to limit payroll transactions to:
- Those satisfying a range of employees or departments
- Transactions falling within a specified date range
- Employees with certain types of pay frequencies, or
- Only certain types of employees.
After the transactions are generated, they can be viewed on the Payroll Log Hours for Pay Period form.
The Export Payroll Information to EPI form establishes the CloudSuite Industrial payroll transaction information to be exported via the external payroll interface.
Here you can define the starting and ending department and/or starting and ending payroll data to be exported.
Paydata Record File Layout
This is a comma-separated values file.
ADP PC/Payroll for Windows
Field | Data Type | Format | Comment |
---|---|---|---|
Co Code | Alphanumeric? | X(3) | Entered on the form |
Batch ID | Integer | >>>>>>> | Employee Number if numeric, otherwise 0. Numbers from 000001-000050 are reserved in the ADP software product. A valid employee number in ADP ranges from 000051 through 999999. Because of this limitation, the payroll transaction records of employees whose numbers fall outside this range or whose numbers contain alphabetic characters are not processed. CloudSuite Industrial automatically adds leading zeros to employee numbers that are less than six digits. The CloudSuite Industrial Employee Number must correspond exactly to the ADP Employee File Number; otherwise the record is not processed. |
File # | Integer | >>>>>>> | Same as Batch ID |
Reg. Hours | Decimal | zzzzzz9.99 | Employee Regular Hours |
Overtime Hours | Decimal | zzzzzz9.99 | Employee Overtime Hours |
Hours 3 Code | Alphanumeric | X(1) | Other Hours type - values:
"D" Doubletime
"H" Holiday "S" Sick "Z" Other |
Hours 3 Amount | Decimal | zzzzzz9.99 | Number of hours for corresponding code |
Temp Rate | Decimal | zzzzzz9.99 | Employee Pay Rate |
Shift | Alphanumeric | X(3) | Included if "Process Shift" check box is selected on the form. |