Difference between revisions of "Accrual Date Entitlements Import"
From sbv.wiki
m |
m |
||
Line 8: | Line 8: | ||
! Column Type | ! Column Type | ||
! Identifiers | ! Identifiers | ||
+ | ! Notes | ||
! Required | ! Required | ||
Line 13: | Line 14: | ||
| Accrual Group | | Accrual Group | ||
| Accrual Group | | Accrual Group | ||
+ | | | ||
| Yes | | Yes | ||
Line 18: | Line 20: | ||
| Accrual Pay Type | | Accrual Pay Type | ||
| Accrual Pay Type, Pay Type | | Accrual Pay Type, Pay Type | ||
+ | | | ||
| Yes | | Yes | ||
Line 23: | Line 26: | ||
| Accrual Date Entitlement Type | | Accrual Date Entitlement Type | ||
| Entitlement Type, Date Type | | Entitlement Type, Date Type | ||
+ | | | ||
| Yes | | Yes | ||
Line 28: | Line 32: | ||
| Amount Entitlement | | Amount Entitlement | ||
| Amount Entitlement, Days Entitlement | | Amount Entitlement, Days Entitlement | ||
+ | | | ||
| Yes | | Yes | ||
Line 33: | Line 38: | ||
| Amount Type | | Amount Type | ||
| Entitlement Amount Type, Amount Type, Entitlement Days Type, Days Type | | Entitlement Amount Type, Amount Type, Entitlement Days Type, Days Type | ||
+ | | | ||
| No | | No | ||
Line 38: | Line 44: | ||
| Accrual Date | | Accrual Date | ||
| Accrual Date, Date | | Accrual Date, Date | ||
+ | | | ||
| No | | No | ||
Line 43: | Line 50: | ||
| Month Number | | Month Number | ||
| Month Number | | Month Number | ||
+ | | | ||
| No | | No | ||
Line 48: | 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 53: | 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 58: | Line 68: | ||
| Employed From Month | | Employed From Month | ||
| From, From Month, Employed From Month | | From, From Month, Employed From Month | ||
+ | | | ||
| No | | No | ||
Line 63: | Line 74: | ||
| Employed To Month | | Employed To Month | ||
| To, To Month, Employed To Month | | To, To Month, Employed To Month | ||
+ | | | ||
| No | | No | ||
Line 68: | Line 80: | ||
| Reason | | Reason | ||
| Reason | | Reason | ||
+ | | | ||
| No | | No | ||
Line 73: | Line 86: | ||
| Note | | Note | ||
| Note | | Note | ||
+ | | | ||
| No | | No | ||
Line 78: | Line 92: | ||
| Minimum Shift Count | | Minimum Shift Count | ||
| Minimum Shift Count | | Minimum Shift Count | ||
+ | | | ||
| No | | No | ||
Line 83: | Line 98: | ||
| Maximum Shift Count | | Maximum Shift Count | ||
| Maximum Shift Count | | Maximum Shift Count | ||
+ | | | ||
| No | | No | ||
Line 88: | Line 104: | ||
| Employed From Date | | Employed From Date | ||
| Employed From Date | | Employed From Date | ||
+ | | | ||
| No | | No | ||
Line 93: | Line 110: | ||
| Employed To Date | | Employed To Date | ||
| Employed To Date | | Employed To Date | ||
+ | | | ||
| No | | No | ||
Line 98: | Line 116: | ||
| Employee Shift Type | | Employee Shift Type | ||
| Employee Shift Type, Shift Type | | Employee Shift Type, Shift Type | ||
+ | | | ||
| No | | No | ||
Revision as of 17:16, 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 | 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 |