Difference between revisions of "Accrual Balances Import"
From sbv.wiki
m |
|||
Line 19: | Line 19: | ||
| 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. | + | | 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 22:06, 29 March 2018
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. Note the distinction with the clock ID, SSN, and Payroll ID fields is the “_”. 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 |