Difference between revisions of "Accrual Date Entitlements Import"
From sbv.wiki
m |
|||
(5 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
Adds entries to the [[Accrual Date Entitlements Configuration]]. This provides a fast way to enter the date based accruals, especially when there are many accrual groups. | Adds entries to the [[Accrual Date Entitlements Configuration]]. This provides a fast way to enter the date based accruals, especially when there are many accrual groups. | ||
+ | |||
+ | An accrual date entitlements import is identified by the sheet name or file name containing the words "Accrual Date". | ||
{| class="wikitable" | {| class="wikitable" | ||
Line 6: | Line 8: | ||
! Column Type | ! Column Type | ||
! Identifiers | ! Identifiers | ||
+ | ! Notes | ||
! Required | ! Required | ||
Line 11: | Line 14: | ||
| Accrual Group | | Accrual Group | ||
| Accrual Group | | Accrual Group | ||
+ | | | ||
| Yes | | Yes | ||
Line 16: | Line 20: | ||
| Accrual Pay Type | | Accrual Pay Type | ||
| Accrual Pay Type, Pay Type | | Accrual Pay Type, Pay Type | ||
+ | | | ||
| Yes | | Yes | ||
Line 21: | Line 26: | ||
| Accrual Date Entitlement Type | | Accrual Date Entitlement Type | ||
| Entitlement Type, Date Type | | Entitlement Type, Date Type | ||
+ | | | ||
| Yes | | Yes | ||
|- | |- | ||
− | | | + | | Amount Entitlement |
− | | Days Entitlement | + | | Amount Entitlement, Days Entitlement |
+ | | | ||
| Yes | | Yes | ||
|- | |- | ||
− | | | + | | Amount Type |
− | | Entitlement Days Type, Days Type | + | | Entitlement Amount Type, Amount Type, Entitlement Days Type, Days Type |
+ | | Valid data for this field are: "proportioned", "daily", "holiday", "rounded", "hours" | ||
| No | | No | ||
Line 36: | Line 44: | ||
| Accrual Date | | Accrual Date | ||
| Accrual Date, Date | | Accrual Date, Date | ||
+ | | | ||
| No | | No | ||
Line 41: | Line 50: | ||
| Month Number | | Month Number | ||
| Month Number | | Month Number | ||
+ | | | ||
| No | | No | ||
Line 46: | Line 56: | ||
| Nth Month From Month Number | | Nth Month From Month Number | ||
| Nth From, Nth Month From, Nth Month From Month, Nth Month From Month #, Nth Month From Month Number | | Nth From, Nth Month From, Nth Month From Month, Nth Month From Month #, Nth Month From Month Number | ||
+ | | | ||
| No | | No | ||
Line 51: | Line 62: | ||
| Nth Month To Month Number | | Nth Month To Month Number | ||
| Nth To, Nth Month To, Nth Month To Month, Nth Month To Month #, Nth Month To Month Number | | Nth To, Nth Month To, Nth Month To Month, Nth Month To Month #, Nth Month To Month Number | ||
+ | | | ||
| No | | No | ||
Line 56: | Line 68: | ||
| Employed From Month | | Employed From Month | ||
| From, From Month, Employed From Month | | From, From Month, Employed From Month | ||
+ | | | ||
| No | | No | ||
Line 61: | Line 74: | ||
| Employed To Month | | Employed To Month | ||
| To, To Month, Employed To Month | | To, To Month, Employed To Month | ||
+ | | | ||
| No | | No | ||
Line 66: | Line 80: | ||
| Reason | | Reason | ||
| Reason | | Reason | ||
+ | | | ||
| No | | No | ||
Line 71: | Line 86: | ||
| Note | | Note | ||
| Note | | Note | ||
+ | | | ||
| No | | No | ||
Line 76: | Line 92: | ||
| Minimum Shift Count | | Minimum Shift Count | ||
| Minimum Shift Count | | Minimum Shift Count | ||
+ | | | ||
| No | | No | ||
Line 81: | Line 98: | ||
| Maximum Shift Count | | Maximum Shift Count | ||
| Maximum Shift Count | | Maximum Shift Count | ||
+ | | | ||
| No | | No | ||
Line 86: | Line 104: | ||
| Employed From Date | | Employed From Date | ||
| Employed From Date | | Employed From Date | ||
+ | | | ||
| No | | No | ||
Line 91: | Line 110: | ||
| Employed To Date | | Employed To Date | ||
| Employed To Date | | Employed To Date | ||
+ | | | ||
| No | | No | ||
Line 96: | Line 116: | ||
| Employee Shift Type | | Employee Shift Type | ||
| Employee Shift Type, Shift Type | | Employee Shift Type, Shift Type | ||
+ | | | ||
| No | | No | ||
|} | |} | ||
+ | |||
+ | == See also == | ||
+ | |||
+ | * [[Import]] |
Latest revision as of 17:31, 28 February 2022
Adds entries to the Accrual Date Entitlements Configuration. This provides a fast way to enter the date based accruals, especially when there are many accrual groups.
An accrual date entitlements import is identified by the sheet name or file name containing the words "Accrual Date".
Column Type | Identifiers | Notes | Required |
---|---|---|---|
Accrual Group | Accrual Group | Yes | |
Accrual Pay Type | Accrual Pay Type, Pay Type | Yes | |
Accrual Date Entitlement Type | Entitlement Type, Date Type | Yes | |
Amount Entitlement | Amount Entitlement, Days Entitlement | Yes | |
Amount Type | Entitlement Amount Type, Amount Type, Entitlement Days Type, Days Type | Valid data for this field are: "proportioned", "daily", "holiday", "rounded", "hours" | No |
Accrual Date | Accrual Date, Date | No | |
Month Number | Month Number | No | |
Nth Month From Month Number | Nth From, Nth Month From, Nth Month From Month, Nth Month From Month #, Nth Month From Month Number | No | |
Nth Month To Month Number | Nth To, Nth Month To, Nth Month To Month, Nth Month To Month #, Nth Month To Month Number | No | |
Employed From Month | From, From Month, Employed From Month | No | |
Employed To Month | To, To Month, Employed To Month | No | |
Reason | Reason | No | |
Note | Note | No | |
Minimum Shift Count | Minimum Shift Count | No | |
Maximum Shift Count | Maximum Shift Count | No | |
Employed From Date | Employed From Date | No | |
Employed To Date | Employed To Date | No | |
Employee Shift Type | Employee Shift Type, Shift Type | No |