Difference between revisions of "Accrual Balances Import"
From sbv.wiki
Line 18: | Line 18: | ||
|- | |- | ||
| Accrual Pay Type / Hours | | Accrual Pay Type / Hours | ||
− | | Accrual Pay Type ID | + | | ''Accrual Pay Type'' ID |
| The column header identifies the accrual pay type. The data in each row represents the starting balance for the accrual pay type. To import into Bank 2, add a " 2" to the column header, e.g. "SICK 2". To import unreleased balances add " Unreleased" to the column header, e.g. "SICK 2 Unreleased". | | The column header identifies the accrual pay type. The data in each row represents the starting balance for the accrual pay type. To import into Bank 2, add a " 2" to the column header, e.g. "SICK 2". To import unreleased balances add " Unreleased" to the column header, e.g. "SICK 2 Unreleased". | ||
| Yes | | Yes |
Revision as of 23:31, 21 May 2019
The accrual balances import adds or updates the accrual balance or starting balance. If you are using the Accrual Validation module, then it adds/updates the accrual balance. If you are using the Accruals module, then it adds/updates the starting balance. If there is already a record for the employee (for the same accrual pay type), then it will update the date and the hours on that record. Otherwise, a new record is added.
An accrual balances import is identified by the sheet name or file name containing the words "Accrual Balances".
Column Type | Identifiers | Notes | Required |
---|---|---|---|
Employee ID | Employee ID, Emp ID, ID | This is used to uniquely identify the employee. With a multi-facility configuration you must also provide the Facility column. | Yes |
Accrual Pay Type / Hours | Accrual Pay Type ID | The column header identifies the accrual pay type. The data in each row represents the starting balance for the accrual pay type. To import into Bank 2, add a " 2" to the column header, e.g. "SICK 2". To import unreleased balances add " Unreleased" to the column header, e.g. "SICK 2 Unreleased". | Yes |
Pay Date | Date, Pay Date | If the pay date column is not supplied, then the pay date will be the date following the end date of the latest closed pay period. | No |