Difference between revisions of "Accrual Year End Adjustments Import"
From sbv.wiki
(Created page with "The accrual year end adjustment import adds an Accrual Year End Hours Used adjustment that would be added manually in the accrual [ Adjustments] screen. The hours value suppli...") |
|||
| (3 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | The accrual year end adjustment import adds an Accrual Year End Hours Used adjustment that would be added manually in the accrual [ Adjustments] screen. The hours value supplied represents the desired balance as of the date supplied. The adjustment is calculated based on the employee’s accrual balance at the end of the prior accrual period. | + | The accrual year end adjustment import adds an Accrual Year End Hours Used adjustment that would be added manually in the accrual [[Employee_Accruals#Adjustments|Adjustments]] screen. The hours value supplied represents the desired balance as of the date supplied. The adjustment is calculated based on the employee’s accrual balance at the end of the prior accrual period. |
| − | + | An accrual year end adjustments import is identified by the sheet name or file name containing the words "Accrual Year End". | |
{| class="wikitable" | {| class="wikitable" | ||
|- | |- | ||
| − | + | ! Column Type | |
| − | + | ! Identifiers | |
| − | + | ! Notes | |
| − | + | ! Required | |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
|- | |- | ||
| + | | Employee ID | ||
| + | | Employee ID, Emp ID, ID | ||
| | | | ||
| − | + | | Yes | |
| − | + | ||
| − | | | + | |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
|- | |- | ||
| − | | | + | | Pay Date |
| − | Pay Date | + | | Pay Date, Date |
| − | + | | | |
| − | | | + | | Yes |
| − | Pay Date, Date | + | |
| − | + | ||
| − | | | + | |
| − | + | ||
|- | |- | ||
| − | | | + | | Accrual Pay Type / Hours |
| − | 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. | ||
| + | | Yes | ||
| − | | | + | |} |
| − | + | ||
| − | + | == See also == | |
| − | + | ||
| − | + | * [[Import]] | |
Latest revision as of 03:30, 2 May 2016
The accrual year end adjustment import adds an Accrual Year End Hours Used adjustment that would be added manually in the accrual Adjustments screen. The hours value supplied represents the desired balance as of the date supplied. The adjustment is calculated based on the employee’s accrual balance at the end of the prior accrual period.
An accrual year end adjustments import is identified by the sheet name or file name containing the words "Accrual Year End".
| Column Type | Identifiers | Notes | Required |
|---|---|---|---|
| Employee ID | Employee ID, Emp ID, ID | Yes | |
| Pay Date | Pay Date, Date | 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. | Yes |
