Summary

Comma-separated format.

Null values should contain no data between commas.

As of PayGlobal version 4.20, the first row of files exported to this format will have just two fields, containing a version number (representing the version of the file format specification) and a code representing the source of the file. The remaining rows will have different field definitions based on the version.

Field Number

Field Name

Format

Comment

1

EmployeeCode

Char 12

Mandatory

2

AllowanceCode

Char 12

Mandatory

3

Quantity

Double - Rounds to 2 decimal places

Mandatory

4

Reduce Quantity

999.99

Optional - Stored in cargo field

5

RateCode

Char 12

Optional

6

RateAmount

Double - Rounds to 4 decimal places

Optional

7

Factor

Double - Rounds to 4 decimal places

Optional

8

TotalAmount

Double - Rounds to 2 decimal places

Optional

9

Recalculate

Logical - Y/N

Optional

10

ReasonCode

Char 12

Optional

11

DateFrom

Date - yyyymmdd

Mandatory

12

DateTo

Date - yyyymmdd

Mandatory

13

AwardCode

Char 12

Optional

14

CostCentreCode

Char 12

Optional

15

JobCode

Char 12

Optional - Will be added only if Company Settings | Transactions tab | Edit Job Codes = "Yes".

16

WAPCode

Char 12

Optional - Will be added only if Company Settings | Transactions tab | Edit WAP Codes = "Yes".

17

Text

Char 250

Optional

18

Version Specific - see below

Version Specific - see below

Version Specific - see below

19

Multi-use field based on Allowance.

Holiday Start Date (Annual Leave)

OR

Absence Start Date (LWOP)

Date - yyyymmdd

Optional

Annual Leave - The date that the leave transaction started.

LWOP - The date the employee's absence began.

20

Lump Sum E Derived Tax Year End Date

Date - yyyymmdd

Optional - The date must meet the following requirements:

1. It must be prior to the pay sequences period YTD end date.

2. It must be a valid period YTD end date.

3. The allowance code must be of the tax override type "Lump sum in arrears".

21

Weeks Absent

Char 5

(Value must be >= -9.99 and <= 99.99)

If value exceeds the above then Weeks Absent will be set to 0.00 on the transaction after import.

If consolidation is enabled and occurs, and value exceeds the above, then Weeks Absent will be set to 0.00 on the transaction after import.

Optional

Only used for transactions where:

• Allowance Type = A. Allowance, H. Hourly, C. ACC, V. Leave Credit Paid, R. Salary and S. Sick/Special Leave.
• Paying = No
• Show Weeks Absent = Yes

   

Field Number

Field Name

Format

Comment

18

PositionCode

Char 12

Optional - Will be added only if Company Settings | Payroll | Processing | Transactions tab | Edit Position Codes = "Yes".

Field Number

Field Name

Format

Comment

18

TARecalculate

Logical Y/N

The state of the recalculate flag as it was when the transaction was still in T&A.