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. ...") |
|||
| 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 adds/updates the accrual balance. If you are using the Accruals module, then it adds/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. | 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. If you are using the Accruals module, then it adds/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. | ||
| − | |||
| − | |||
{| class="wikitable" | {| class="wikitable" | ||
|- | |- | ||
| − | + | ! Column Type | |
| − | + | ! Identifiers | |
| − | + | ! Notes | |
| − | + | ! Required | |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
|- | |- | ||
| + | | Employee ID | ||
| + | | Employee ID, Emp ID, ID | ||
| | | | ||
| − | + | | Yes | |
| − | + | ||
| − | | | + | |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
|- | |- | ||
| − | | | + | | 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 | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
|- | |- | ||
| − | | | + | | 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 | |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | 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. | + | |
|} | |} | ||
Revision as of 18:35, 8 June 2015
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. If you are using the Accruals module, then it adds/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.
| Column Type | Identifiers | Notes | Required |
|---|---|---|---|
| Employee ID | Employee ID, Emp ID, ID | 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 |
| 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 |
