|
|
|
Payroll | Payroll Import Types | Details tab | Import Type field
Summary |
Payroll transactions obtained directly from Workforce Management. This format does not use files as a data source for importing. |
Field Number |
Field Name |
Format |
Comment |
1 |
Employee Code |
Char 12 |
Mandatory |
2 |
Pay Type |
Char 12 |
Allowance Code: Mandatory |
3 |
Quantity |
Double - rounds to 2 decimal places |
Mandatory |
4 |
Rate Amount |
Double - rounds to 4 decimal places |
Optional - If supplied, then PayGlobal forces the rate code to be the first override rate. |
5 |
Total Amount |
Double - rounds to 2 decimal places |
Optional - If "Calculate in Payroll" is Yes, then this amount will be overwritten by the standard PayGlobal transaciton total amount calculation. |
6 |
Date From |
Date |
Transaction Start Date: Optional - Passed as GMT time |
7 |
Date To |
Date |
Transaction End Date: Optional - Passed as GMT time |
8 |
Holiday Start Date |
Date |
Optional - The date that the leave transaction started. If supplied, passed as GMT time. |
9 |
Cost Centre Code |
Char 12 |
Optional |
10 |
Calculate in Payroll |
Logical - Y/N |
Optional - defaults to false if not supplied. If false, then PayGlobal forces the rate code to be the first override rate. If true, then the Rate Amount and Total Amount are both set to zero and PayGlobal will calculate these during pay processing according to the rules active at the time. |
Consolidation of transactions |
When importing from Workforce Management transactions will be consolidated for allowances where the Payroll consolidate transactions is set to "Yes" Transactions will consolidated into a single transaction based on grouping the following fields
The Quantity and Total Amount for the consolidated transaction will set to the sum across the transaction group with the Date From being set to the minimum Date From and the Date To being set to the maximum Date To Note: Pay Type in the import data from Workforce Management matches to Allowance Code within PayGlobal |
Days worked transactions |
When importing from Workforce Management it may be necessary to create days worked transactions for the employees. This can be set up using the Import WFM tab within Company Settings |
Notes |
|
|
|
|
