Difference between revisions of "Accrual Balances Import"
From sbv.wiki
(Created page with "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. ...") |
m |
||
(9 intermediate revisions by 4 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". | |
{| class="wikitable" | {| class="wikitable" | ||
|- | |- | ||
− | + | ! 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 |
− | + | ||
− | + | ||
− | | | + | |
− | + | ||
|} | |} | ||
− | + | == See also == | |
− | + | * [[Import]] | |
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + |
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 |