Functional Description
The purpose of the Named ER is to retrieve the pay rate record (F069126) using a hierarchy. There are 8 levels in the
hierarchy.
1 2 3 4 5 6 7 8
Union x x x x x x x x
BU x x x x
Shift x x x x
Job Type x x x x
Job Step x x x x
The server returns a return code of 1 if the pay rate table record is found.
Setup Notes
Note: The returned value of the required parameters (namely, Union, Shift, Job Type, Job Step and Business Unit) may
not be the same as the passed values, as the returned values reflect the values from the actual pay rate table record
retrieved based on the hierarchy.
Technical Specifications
Parameters
Data Item Data Structure DescriptionI/ORequiredTableNotes
UNUnion CodeI/OYF069126Input and Output.
MCUBusiness UnitI/OYF069126Input and Output..
SHFTShift CodeI/OYF069126Input and Output.
JBCDJob TypeI/OYF069126Input and Output..
JBSTJob StepI/OYF069126Input and Output..
EFTOEffective DateINIf Effective date is not passed in, today's
date is used.
PHRTHourly RateONF069126
PBRTBilling RateONF069126
LFLabor Distr. MultiplierONF069126
LMTHLabor Distr. MethodONF069126
PPRTPiecework RateONF069126
WAGDWage Decision NumberONF069126
OH1Overtime RateONF069126
OH2Double Time RateONF069126
OH3Triple Time RateONF069126
OH4Holiday RateONF069126
OBJObject AccountONF069126
WCMPWorker Comp CodeONF069126
OR1Billing Overtime RateONF069126
OR2Billing Double Time RateONF069126
OR3Billing Triple Time RateONF069126
OR4Billing Holiday RateONF069126
B2RTBurden RateONF069126
OU1Overtime Burden Rate 2ONF069126
OU2DoubleTime Burden Rate2ONF069126
OU3Triple Time Burden Rate2
OU4Holiday Burden Rate 2ONF069126
OT1Overtime RateONF069126
OT2Double Time RateONF069126
OT3Triple Time RateONF069126
OT4Holiday RateONF069126
BDRTRecharge Burden RateONF069126
WETWorker Comp-SubclassONF069126
RBOBRecharge Burden ObjectONF069126
RBO2Recharge Burden Object2ONF069126
EFTBBeginning Effective dateONF069126
EFTEEnding Effective dateONF069126
EV01Return CodeONReturn code =1 = Pay rate found ; Return code = 0
= rate not found.
Related Tables
Table Table Description
F069126Pay Rate (Union) Table
Processing
1. Save all the original values of parameters passed in variables:
PassedUnion = BF Union
PassedBU= BF BU
PassedJobType= BF Job Type
PassedJobStep= BF Job Step
PassedShift= BF Shift Code
2. If effective date (EFTO) is not passed in, EFTO = Today's Date
3. Initialize variables:
Return Code (EV01) = '0'
Hierarchy Number Variable = 1
4. While the Hierarchy Number Variable <9 and Return code <> 1 (rate not found),
a. SearchFlag = '0'
b. If Hierarchy Number Variable =1,
Search Flag = '1'
End
c. If Hierarchy Number Variable = 2,
BF Job Type = ' '
BF Job Step = ' '
If PassedJobType <> Blank or PassedJobStep <> Blank,
Search Flag = '1'
End
d. If Hierarchy Number Variable = 3,
BF Shift = ' '
BF Job Type = PassedJobType
BF Job Step = PassedJobStep
If PassedShift <> Blank, Search Flag = '1'
End
e. If Hierarchy Number Variable = 4,
BF Job Type = ' '
BF Job Step = ' '
If PassedShift <> Blank,
If PassedJobType <> Blank or PassedJobStep <> Blank,
SearchFlag = '1'
End
f. If Hierarchy Number Variable=5,
BF BU = ' '
BF Shift = PassedShift
BF Job Type = PassedJobType
BF Job Step = PassedJobStep
If PassedBU <> Blank, SearchFlag = '1'
End
g. If Hierarchy Number = 6,
BF Job Type = ' '
BF Job Step = ' '
If PassedBU <> Blank,
If PassedJobType <> Blank or PassedJobStep <> Blank,
SearchFlag = '1'
End
h. If Hierarchy Number Variable = 7,
BF Shift = ' '
BF Job Type = PassedJobType
BF Job Step = PassedJobStep
If PassedBU <> Blank AND PassedShift <> Blank,
SearchFlag = '1'
End
i. If Hierarchy Number Variable = 8,
BF Job Type = ' '
BF Job Step = ' '
If PassedBU <> Blank AND PassedShift <> Blank,
If PassedJobType <> Blank or PassedJobStep <> Blank,
SearchFlag = '1'
End
preset by the hierarchy number variable.
effective date <= end effective date,
l. If return code <>1 (record not found), increment hierarchy number variable by 1.
EndWhile // Hierarchy number variable Loop //
5. If NO pay rate record is found after hierarchy search is over, restore the original passed values back to BF
parameters and initialize the output parameters.
DN0800027 - Pay Rate Table Server
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
szUnion | 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. | ||||
szBusinessUnit | 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
| ||||
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
| ||||
szJobType | JBCD | char | NONE | NONE |
A user defined code (07/G) that defines the jobs within your organization. You can associate pay and benefit information with a job type and
| ||||
szJobStep | JBST | char | NONE | NONE |
A user defined code (07/GS) that designates a specific level within a particular job type. The system uses this code in conjunction with job
| ||||
jdEffectiveDate | EFTO | JDEDATE | NONE | NONE |
A future date when all changes will take effect or the date when the changes went into effect. If you do not enter a date in this field, the system
| ||||
mnRtHourly | PHRT | MATH_NUMERIC | NONE | NONE |
The employee's hourly rate, which is retrieved during time entry. If you enter a rate in this field on any other form, that rate can override the
| ||||
mnRtDistributionOrBill | PBRT | MATH_NUMERIC | NONE | NONE |
A number that specifies the rate that the system uses to bill for labor services. This rate is often referred to as the billing or recharge rate.
| ||||
mnLaborLoadingFactor | LF | MATH_NUMERIC | NONE | NONE |
A multiplier to load direct labor costs with burden. For example, a factor of 1.32 would load every dollar of labor cost with 32 cents worth of
| ||||
cLaborLoadingMethod | LMTH | char | NONE | NONE |
Controls whether the labor costs include a flat burden for payroll taxes and benefits. Valid values are:
0 The flat burden factor is always
| ||||
mnRtPiecework | PPRT | MATH_NUMERIC | NONE | NONE |
The rate paid for the type of component (piece) produced. If you enter a rate in this field, this rate overrides the rate in the Employee Master
| ||||
szWageDecisionNumber | WAGD | char | NONE | NONE |
This code is used to reference the government Wage Decision that the contract pay rates fall under. | ||||
mnRateOvertime | OH1 | MATH_NUMERIC | NONE | NONE |
The rate of pay for "regular" overtime. | ||||
mnRateDoubleTime | OH2 | MATH_NUMERIC | NONE | NONE |
The rate of pay for "double" overtime. | ||||
mnRateTripleTime | OH3 | MATH_NUMERIC | NONE | NONE |
The rate of pay for "triple" time. | ||||
mnRateHoliday | OH4 | MATH_NUMERIC | NONE | NONE |
The rate of pay for "holiday" overtime. | ||||
szObjectAccount | OBJ | char | NONE | NONE |
The portion of a general ledger account that refers to the division of the Cost Code (for example, labor, materials, and equipment) into
| ||||
szWorkersCompInsurCode | WCMP | char | NONE | NONE |
A user defined code (00/W) that represents a workers' compensation insurance (WCI) code. This code should correspond to the
| ||||
mnRateOvertimeBilling | OR1 | MATH_NUMERIC | NONE | NONE |
This is the employee's recharge overtime hourly rate as retrieved, entered or calculated during time entry. | ||||
mnRateDoubleTimeBilling | OR2 | MATH_NUMERIC | NONE | NONE |
This is the employee's recharge doubletime hourly rate as retrieved, entered or calculated during time entry. | ||||
mnRateTripleTimeBilling | OR3 | MATH_NUMERIC | NONE | NONE |
This is the employee's recharge triple time hourly rate as retrieved, entered or calculated during time entry. | ||||
mnRateHolidayBilling | OR4 | MATH_NUMERIC | NONE | NONE |
This is the employee's recharge holiday hourly rate as retrieved, entered or calculated during time entry. | ||||
mnRateBurden | B2RT | MATH_NUMERIC | NONE | NONE |
The rate to be applied to the 'variable' portion of burden. | ||||
mnRateOvertimeBurden2 | OU1 | MATH_NUMERIC | NONE | NONE |
The burden rate for "regular" overtime. | ||||
mnRateDoubleBurden2 | OU2 | MATH_NUMERIC | NONE | NONE |
The burden rate for "double" time. | ||||
mnRateTripleTimeBurden2 | OU3 | MATH_NUMERIC | NONE | NONE |
The burden rate for "triple" time. | ||||
mnRateHolidayBurden2 | OU4 | MATH_NUMERIC | NONE | NONE |
The burden rate for "holiday" time. | ||||
mnRateOvertime1 | OT1 | MATH_NUMERIC | NONE | NONE |
The rate of billing for "regular" overtime. | ||||
mnRateDoubleTime1 | OT2 | MATH_NUMERIC | NONE | NONE |
The rate of billing for "double" time. | ||||
mnRateTripleTime1 | OT3 | MATH_NUMERIC | NONE | NONE |
The rate of billing for "triple" time. | ||||
mnRateHoliday1 | OT4 | MATH_NUMERIC | NONE | NONE |
The rate of billing for "holiday" time. | ||||
mnRateBillingBurden | BDRT | MATH_NUMERIC | NONE | NONE |
An hourly rate to be used when charging 'burden' associated with the actual billing (recharge) amounts. | ||||
cFloatCode | WET | char | NONE | NONE |
A code that specifies any special circumstances associated with the workers compensation insurance (WCI) code, resulting in multiple
| ||||
szRechargeBurdenObject | RBOB | char | NONE | NONE |
Burden Object Account - Recharge | ||||
szRechargeBurdenObject2 | RBO2 | char | NONE | NONE |
Burden Object Account - Recharge 2 | ||||
jdDateBeginningEffective | EFTB | JDEDATE | NONE | NONE |
The date that an address, item, transaction, or table record becomes active. The meaning of this field differs, depending on the program.
| ||||
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
| ||||
cReturnCode | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. |
None |
None |