Difference between revisions of "Pay Rate Lookup Import"
From sbv.wiki
m |
|||
| (4 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
The pay rate lookup import adds to the [[Pay Rate Lookup Configuration|Pay Rate Lookup]] table. | The pay rate lookup import adds to the [[Pay Rate Lookup Configuration|Pay Rate Lookup]] table. | ||
| − | |||
| − | |||
{| class="wikitable" | {| class="wikitable" | ||
|- | |- | ||
| − | + | ! Column Type | |
| − | + | ! Identifiers | |
| + | ! Notes | ||
| + | ! Required | ||
| − | | | + | |- |
| − | + | | Starting Date | |
| + | | Pay Date, Date | ||
| + | | | ||
| + | | Yes | ||
| + | |- | ||
| + | | Pay Rate | ||
| + | | Pay Rate, Rate | ||
| | | | ||
| − | + | |Yes | |
|- | |- | ||
| − | | | + | | Days Of Week |
| − | Day Of Week | + | | Day Of Week, Days Of Week |
| + | | All Days, Weekdays, Weekend, Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday | ||
| + | | No | ||
| + | |- | ||
| + | | Shift | ||
| + | | Shift | ||
| | | | ||
| − | + | | No | |
| − | | | + | |- |
| − | + | | Labor Levels | |
| + | | The ID or name of the labor level, e.g. Department | ||
| + | | The labor level ID, labor level description or the scheduler ID | ||
| + | | No | ||
|- | |- | ||
| + | | Employed From | ||
| + | | Employed From Date | ||
| | | | ||
| − | + | | No | |
| + | |- | ||
| + | | Employed To | ||
| + | | Employed To Date | ||
| | | | ||
| − | + | | No | |
| − | + | ||
| − | | | + | |
| − | + | ||
|- | |- | ||
| + | | Pay Type | ||
| + | | Pay Type | ||
| | | | ||
| − | + | | No | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
|- | |- | ||
| + | | Min. Shift Count | ||
| + | | Minimum Shift Count | ||
| | | | ||
| − | + | | No | |
| − | + | ||
| − | | | + | |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
|- | |- | ||
| + | | Max. Shift Count | ||
| + | | Maximum Shift Count | ||
| | | | ||
| − | + | | No | |
| − | + | ||
| − | | | + | |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
|- | |- | ||
| + | | Multiplier # | ||
| + | | Pay Rate Multiplier Number | ||
| | | | ||
| − | + | |No | |
| + | |} | ||
| − | + | == See also == | |
| − | + | ||
| − | + | * [[Import]] | |
| − | + | ||
| − | + | ||
| − | + | ||
Latest revision as of 17:50, 28 June 2023
The pay rate lookup import adds to the Pay Rate Lookup table.
| Column Type | Identifiers | Notes | Required |
|---|---|---|---|
| Starting Date | Pay Date, Date | Yes | |
| Pay Rate | Pay Rate, Rate | Yes | |
| Days Of Week | Day Of Week, Days Of Week | All Days, Weekdays, Weekend, Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday | No |
| Shift | Shift | No | |
| Labor Levels | The ID or name of the labor level, e.g. Department | The labor level ID, labor level description or the scheduler ID | No |
| Employed From | Employed From Date | No | |
| Employed To | Employed To Date | No | |
| Pay Type | Pay Type | No | |
| Min. Shift Count | Minimum Shift Count | No | |
| Max. Shift Count | Maximum Shift Count | No | |
| Multiplier # | Pay Rate Multiplier Number | No |
