Show/Hide All

The following preconfigured payroll import jobs are included with your software to help you import payroll data into your system. Before using the import jobs in Import Job Maintenance, they must be imported using Job Import. For more information, see Import Preconfigured Payroll Import Jobs.

Note Records with zero-amount lines can be created in the Payroll Data Entry file if the regular hours portion of the import record is equal to 0 (zero). To remove these records during the payroll tax calculation, select the Remove Earnings Lines with Zero Amount check box in Payroll Options.

 PR_ADP

The PR_ADP import job is configured to import delimited files and to be used with the SDF format from the ADP Paydata software.

 

Field Name	Operation	Column	Column Definition
Department No	Replace	Column 2	Substring 1 for length 2
Employee No	Replace	Column 2	Substring 3 for length 7
Department Code	Replace	Column 2	Position 1 for length 2
Hours Recpt Amt	Replace	Column 4	Regular hours
Temp05	Replace	Column 5	Overtime hours
Temp06	Replace	Column 6	Doubletime hours
Temp07	Replace	Column 7	Sick hours
Temp08	Replace	Column 8	Vacation hours
Earnings Code	Runtime		Default value: 01 Regular earnings code
Temp01	Runtime		Default value: 02 Overtime earnings code
Temp02	Runtime		Default value: 03 Doubletime earnings code
Temp03	Runtime		Default value: 07 Sick earnings code
Temp04	Runtime		Default value: 10 Vacation earnings code
Check Bank Code	Runtime		Default value: A

 

 

 PR_FORMAT_2

The PR_FORMAT_2 import job is configured to import ASCII files with a fixed field format and a job number.

 

Field Name	Operation	Position	Position Definition
Department No	Replace	Position 1
Employee No	Replace	Position 3
Earnings Code	Replace	Position 10
Department Code	Replace	Position 1
Job Number	Replace	Position 19
Cost Code	Replace	Position 26
Temp01	Replace	Position 12	Hours Recpt Amt
Check Bank Code	Runtime		Default value: A

 

 

 PR_KRONOS

The PR_KRONOS import job is configured to import ASCII files in the Time Bank and Kronos Connect format. The department number is part of the import file for this format. When using this job, special processing will occur; the values in the source file will be evaluated in the following order:

 

1. The program determines if the record contains a valid earnings code. If a valid earnings code is found, it will be processed as such.

2. If the source is not a valid earnings code, then the system determines if it contains a valid deduction code. If no valid deduction code is found; the record is rejected. If a valid deduction is found, the following occurs:

3. If the record has an value for hours, the value is ignored.

4. If the record has a value in the earnings/deduction amount field, the amount is imported as the deduction amount. If the record does not have an earnings/deduction amount value, the deduction amount is calculated as if it is manually entered in Payroll Data Entry.

Note When the message appears asking if you want to perform automatic deductions, if you click Recalc All, automatic deductions will be recalculated for all employees regardless of whether they have a record in the current import; any previously calculated automatic deduction amounts will be removed.  

 

Field Name	Operation	Position	Position Definition
Department No	Replace	Position 3
Employee No	Replace	Position 5
Department Code	Replace	Position 50
Temp08	Replace	Position 109	State Code
Temp09	Replace	Position 79	Labor Dist Code
Work Comp Code	Replace	Position 102
Temp01	Replace	Position 15	Regular Hours
Temp15	Replace	Position 69	Job Number
Temp16	Replace	Position 92	Cost Code
Temp10	Replace	Position 60	Rate
Deduction Code	Replace	Position 1
Temp02	Replace	Position 22	Overtime Hours
Temp07	Runtime		Default value: 02 Earnings code
Temp03	Replace	Position 29	Hours earnings code defined in Temp04
Temp04	Replace	Position 36	Hours earnings code
Temp05	Replace	Position 39	Earnings or deduction amount
Temp06	Replace	Position 47	Earnings or deduction code related to amount in Temp05
Temp14	Runtime		Importing deductions? Default value: Y
Check Bank Code	Runtime		Default value: A

 

 

 PR_KRONOS_NO_DP

The PR_KRONOS_NO_DP import job is configured to import ASCII files in the Time Bank and Kronos Connect format. The department number is not part of the import file for this format. When using this job, special processing will occur; the values in the source file will be evaluated in the following order:

 

1. The program determines if the record contains a valid earnings code. If a valid earnings code is found, it will be processed as such.

2. If the source is not a valid earnings code, then the system determines if it contains a valid deduction code. If no valid deduction code is found; the record is rejected. If a valid deduction is found, the following occurs:

3. If the record has an value for hours, the value is ignored.

4. If the record has a value in the earnings/deduction amount field, the amount is imported as the deduction amount. If the record does not have an earnings/deduction amount value, the deduction amount is calculated as if it is manually entered in Payroll Data Entry.

Note When the message appears asking if you want to perform automatic deductions, if you click Recalc All, automatic deductions will be recalculated for all employees regardless of whether they have a record in the current import; any previously calculated automatic deduction amounts will be removed.  

 

Field Name	Operation	Position	Position Definition
Employee No	Replace	Position 3
Department Code	Replace	Position 50
Temp08	Replace	Position 109	State Code
Temp09	Replace	Position 79	Labor Dist Code
Work Comp Code	Replace	Position 102
Temp01	Replace	Position 15	Regular Hours
Temp15	Replace	Position 69	Job Number
Temp16	Replace	Position 92	Cost Code
Temp10	Replace	Position 60	Rate
Deduction Code	Replace	Position 1
Temp02	Replace	Position 22	Overtime Hours
Temp07	Runtime		Default value: 02 Earnings code
Temp03	Replace	Position 29	Hours earnings code defined in Temp04
Temp04	Replace	Position 36	Hours earnings code
Temp05	Replace	Position 39	Earnings or deduction amount
Temp06	Replace	Position 47	Earnings or deduction code related to amount in Temp05
Temp14	Runtime		Importing deductions? Default value: Y
Check Bank Code	Runtime		Default value: A

 

 PR_TIMETRAK

The PR_TIMETRAK import job is configured to import ASCII files in the TimeTrak version 8.0 format.

 

Field Name	Operation	Position	Position Definition
Department No	Replace	Position 1
Employee No	Replace	Position 3
Earnings Code	Replace	Position 78
Department Code	Replace	Position 48
Temp02	Replace	Position 94	Hours Recpt Amt
Temp01	Replace	Position 85	Rate
Check Bank Code	Runtime		Default value: A

 

 

For more information, see:

ASCII Text Files

Delimited Files