Importable Payroll Fields

Summary

This topic lists the fields that you can import into Payroll and explains how PayGlobal treats fields that are not supplied with a import value. Such non-supplied values are:

Not included in the record format specification
- or -
Included in the record format specification, but have a null value.


Field	Format	Treatment of Null Values
EmployeeCode	Char 12	Mandatory
AllowanceCode	Char 12	Mandatory
Quantity	Double	Mandatory
DateFrom	Date	Pay period start date
DateTo	Date	Pay period end date
CostCentreCode	Char 12	Standard payroll cost centre logic determines the cost centre.
JobCode	Char 12	Blank if a null value is supplied.
If the value is not null, then PayGlobal checks whether the job already exists in the database: If the job already exists, then PayGlobal uses its associated cost centre code (if present) instead of the cost centre code in the import record. If the job does not already exist, and Append unknown Job codes = "Yes", then the PayGlobal creates the job in the Payroll system.
AwardCode	Char 12	Defaults to blank.
PositionCode	Char 12	Defaults to blank. If this field is blank when you process the pay, then PayGlobal populates it with the employee's default position.
JobCode	Char 12	Optional - Imported only if Edit Job codes = "Yes".
WAPCode	Char 12	Optional - Will be added only if Company Settings \| Transactions tab \| Edit WAP Codes = "Yes".
RateCode	Char 12	Defaults to the rate code specified in the allowance.
RateAmount	Double	Standard payroll rate logic determines the default rate amount.
Factor	Double	Standard payroll factor logic determines the default factor.
TotalAmount	Double	Defaults to Quantity * Rate Amount * Factor.
Recalculate	Boolean	Defaults to True.
ReasonCode	Char 12	Defaults to the reason code specified in the corresponding allowance.
Rank	Char 2	Defaults to blank.
Text	Char 250	Defaults to blank.
ReduceQuantity	Double (max of 999.99)	Defaults to the Quantity value if a null value is supplied.
LeaveEndDate	Date	PayGlobal consolidates leave transactions to determine the leave end date.