Difference between revisions of "Accrual Balances Import"
From sbv.wiki
m |
|||
(2 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
− | The accrual balances import adds or updates the accrual balance or starting balance. If you are using the Accrual Validation module, then it | + | 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". | An accrual balances import is identified by the sheet name or file name containing the words "Accrual Balances". | ||
Line 13: | Line 13: | ||
| Employee ID | | Employee ID | ||
| Employee ID, Emp ID, ID | | Employee ID, Emp ID, ID | ||
− | | This is used to uniquely identify the employee | + | | This is used to uniquely identify the employee. With a multi-facility configuration you must also provide the Facility column. |
| Yes | | Yes | ||
|- | |- | ||
| 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 |
Latest revision as of 20:48, 19 February 2021
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 |