Accrual Balances Import
From sbv.wiki
The accrual balances import adds or updates the accrual balance or starting balance. If you are using the Accrual Validation module, then it creates/updates the accrual balance. If you are using the Accruals module, then it creates/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 |
