Functional Description
The purpose of this Named ER is to retrieve the shift differential, calculation method, and shift diff calc sequence.
Setup Notes
Technical Specifications
Parameters
Data Item Data Structure DescriptionI/O RequiredTableNotes
SHFT Shift Code I
SHD Shift Differential O
LD Calculation MethodO
CMTH Shift Diff Calc Sequence O?? Which file?? F06116, F069116, etc
MCU Cost Center I
UN Union Code I
DWK Date Worked
Related Tables
Table Table Description
F069116Transaction Parameters
F069246Shift Table
Processing
1.Scrub and edit - Amount - Shift Differential
The shift differential (SHD) is either based on an amount per hour or on a percentage multiplier. The default is amount per hour. Additionally, an
override amount is always an amount per hour as is a shift differential retrieved from the Pay Rates Table. Therefore, move in default of "H" to LD
(Calculation Method) if it is blank.
If there is no shift code (SHFT = Blank) and no override shift differential (SHD = blank) move in values from the pay type file (F069116).
If SHFT /= blank and SHD /= blank and CMTH is blank, move '1' to CMTH.
If there is a Shift code (SHFT /= blank) and SHD = blank, retrieve shift differential from F069246 (Shift Differential Table).
To retrieve the Shift differential, fetch from F069246 using the following hierarchy:
Keys for F069246:SHFT Shift Code
MCU - Business Unit
UN - Union Code
EFTE End Effective Date
Load the key using the following columns:
1st Fetch;SHFT - must match
MCU - must match
UN - must match
DWK any record equal to or greater than
If not successful,
2nd Fetch:SHFT must match
MCU must match
Blanks
DWK - any record equal to or greater than
If not successful,
3rd Fetch:SHFT must match
Blanks
UN must match
DWK - any record equal to or greater than
If not successful,
4th Fetch:SHFT must match
Blanks
Blanks
DWK - any record equal to or greater than
When a fetch is successful, update SHD, CMTH and LD from F069246. If it is unsuccessful, move '0' to SHD, '1' to CMTH and 'H' to LD (default
values).
^
DN050008 - Scrub and Edit Shift Differential
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
cShiftCode | SHFT | char | NONE | NONE |
A user defined code (00/SH) that identifies daily work shifts.
In payroll systems, you can use a shift code to add a percentage or amount to
| ||||
mnAmtShiftDifferential | SHD | MATH_NUMERIC | NONE | NONE |
An additional rate, expressed in dollars or percent, added to an employee's hourly rate, depending on the shift worked. This rate can be
| ||||
cPercentOrAmountCode | LD | char | NONE | NONE |
A code that specifies whether Shift Differential contains an hourly rate or a percentage. Valid values are:
H
The system adds the amount in
| ||||
cShiftDiffCalcSequence | CMTH | char | NONE | NONE |
A code that specifies how the system should calculate shift differential.
1 The pay type multiplier is applied to the shift differential: Gross
| ||||
szCostCenter | MCU | char | NONE | NONE |
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit
| ||||
szUnionCode | UN | char | NONE | NONE |
A user defined code (06/UN) that represents the union or plan in which the employee or group of employees work or participate. | ||||
jdDateEndingEffective | EFTE | JDEDATE | NONE | NONE |
The date on which the item, transaction, or table becomes inactive, or through which you want transactions to appear. This field is used
| ||||
jdDtWorkJulian | DWK | JDEDATE | NONE | NONE |
The date used as the actual work date or pay-period ending date. | ||||
mnJobnumber | JOBS | MATH_NUMERIC | OPT | NONE |
The job number (work station ID) which executed the particular job. |
None |
None |