Difference between revisions of "Accrual Adjustment Import"
From sbv.wiki
(Created page with "Coming soon...") |
|||
| 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 the 5 adjustment types: "Starting Balance", "Hours Earned", "Hours Used", "Year End Hours Earned" and "Year End Hours Used". | ||
| + | | Yes | ||
| + | |||
| + | |- | ||
| + | | Note | ||
| + | | Note | ||
| + | | | ||
| + | | No | ||
| + | |||
| + | |} | ||
| + | == See also == | ||
| + | |||
| + | * [[Import]] | ||
Revision as of 21:14, 4 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 5 adjustment types: "Starting Balance", "Hours Earned", "Hours Used", "Year End Hours Earned" and "Year End Hours Used". | Yes |
| Note | Note | No |
