Difference between revisions of "Accrual Adjustment Import"
From sbv.wiki
(Created page with "Coming soon...") |
|||
| (2 intermediate revisions by one user not shown) | |||
| Line 1: | Line 1: | ||
| − | + | 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". | ||
| + | |||
| + | {| 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". | ||
| + | | Yes | ||
| + | |||
| + | |- | ||
| + | | Pay Date | ||
| + | | Date, Pay Date | ||
| + | | | ||
| + | | Yes | ||
| + | |||
| + | |- | ||
| + | | Adjustment Type | ||
| + | | Type | ||
| + | | Values for this column could be any of these 4 adjustment types with the necessary identifier in quotes. Starting-Balance: "balance", Hours Earned: "earned", Hours Used: "used" and Maximum Balance: "maximum". | ||
| + | | Yes | ||
| + | |||
| + | |- | ||
| + | | Note | ||
| + | | Note | ||
| + | | | ||
| + | | No | ||
| + | |||
| + | |} | ||
| + | == See also == | ||
| + | |||
| + | * [[Import]] | ||
Latest revision as of 15:49, 4 January 2021
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 these 4 adjustment types with the necessary identifier in quotes. Starting-Balance: "balance", Hours Earned: "earned", Hours Used: "used" and Maximum Balance: "maximum". | Yes |
| Note | Note | No |
