Difference between revisions of "Accrual Adjustment Import"
From sbv.wiki
m |
|||
Line 31: | Line 31: | ||
| Adjustment Type | | Adjustment Type | ||
| Type | | Type | ||
− | | Values for this column could be any of the | + | | Values for this column could be any of the 3 adjustment types, Starting-Balance: "Balance", Hours-Earned: "Earned" and Hours-Used: "Used". |
| Yes | | Yes | ||
Revision as of 13:39, 5 July 2018
The accrual adjustment import adds an adjustment to the accrual balance.
An accrual adjustment import is identified by the sheet name or file name containing the words "Accrual Adjustment".
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". | Yes |
Pay Date | Date, Pay Date | Yes | |
Adjustment Type | Type | Values for this column could be any of the 3 adjustment types, Starting-Balance: "Balance", Hours-Earned: "Earned" and Hours-Used: "Used". | Yes |
Note | Note | No |