GetUnionRates

Retrieve Union Rates

Minor Business Rule

Object Name: N0500015

Parent DLL: CFND

Location: Client/Server

Language: NER

Functional Description
The purpose of this Named ER is to retrieve the union rates.

Technical Specifications

Parameters

Data Item Data Structure DescriptionI/ORequired TableNotes
UNUnionI
MCUOCharge Out Cost CenterI
SHFTShift CodeI
JBCDJob CodeI
JBSTJob StepI
DWKWork DateI
Processing Option 9Zero Billing rateIIf this option is 1, it means to
always use zero billing rates
$$PAYMPay rate multiplierI/O
SEC$Security FlagOThis flag will change to U if the
retrieval is successful
BHRTBase rateO
PHRTRate for A, B, C, D or blankO
SHRTRate if shift rate usedO
PBRTBilling rate for A, B, C, D, or blankO
PPRTPiece RateONot used until B73.2
LFLabor Distribution MultiplierO
WCMPWorkmans Comp CodeO
WETSubclass Workmans Comp CodeO
LMTHLabor Distribution MethodO
SHFTShift code flagO
RCCDRecord TypeI
OHFType of payIR, A, B, C or D

Related Tables

Table Table Description
F069126Union Rates Table

Processing

Use the following hierarchy to search the x-ref (F069126) file.

Keys for F069126UN

MCU
SHFT
JBCD
JBST
DWK

Load the key as shown:

1st Fetch:UN
MCU
SHFT
JBCD
JBST
DWK

If Unsuccessful,
2nd Fetch:UN
MCU
SHFT
blank
blank
DWK

If Unsuccessful,
3rd Fetch:UN
MCU
blank
JBCD
JBST
DWK

If Unsuccessful,
4th Fetch:UN
MCU
blank
Blank
Blank
DWK
If Unsuccessful,
5th FetchUN
blank
SHFT
JBCD
JBST
DWK

If Unsuccessful,
6th FetchUN
blank
SHFT
blank
blank
DWK

If Unsuccessful,
7th FetchUN
blank
Blank
JBCD
JBST
DWK
If Unsuccessful,
8th FetchUN
blank
Blank
Blank
Blank
DWK

The date worked is used to find the first record that matched the first five keys and the date is greater than the effective ending date.  If the first
five keys match and the date worked is greater than or equal to the beginning date (EFTB) and less than or equal to the ending date (EFTE), then the
correct record has been retrieved and $UNN will be set to a 1.  If unsuccessful, $UNN will be set to blanks.

IF YLUN = UN
    AND YLMCU = MCUO
AND YLSHFT = SHFT
AND YLJBCD = JBCD
AND YLJBST = JBST
AND DWK >= YLEFTB
AND DWK <= YLEFTE
SET $SEC = U

Set Parameters to return to the calling program

SET LF = YLLF

SET WCMP = YLWCMP
SET WET = YLWET
SET LMTH = YLLMTH
IF YLSHFT != blanks
SET SHFT = 1
                      ELSE
                                    SET SHFT =  blank
                      END

If the record is payroll processing (RCCD = 1 or 2) always return the PHRT as the base rate. If the OHF is R then the base rate will
be the actual rate. If the OHF is A, B, C or D, the rate from the respective column in the table will be returned. If no rate exists, the
pay ratemultiplier will be applied to the base rate.

IF RCCD = 1
OR RCCD = 2

SET BHRT = YLPHRT

IF HSOHF = R
SET PHRT = YLPHRT
END
IF HSOHF = A
IF YLOH1 != zero
SET PHRT = YLOH1
ELSE
SET PHRT = YLPHRT x $$PAYM
END
END
IF HSOHF = B
IF YLOH2 != zero
SET PHRT = YLOH2
ELSE
SET PHRT = YLPHRT x $$PAYM
END
END
IF HSOHF = C
IF YLOH3 != zero
SET PHRT = YLOH3
ELSE
SET PHRT = YLPHRT x $$PAYM
END
END
IF HSOHF = D
IF YLOH4 != zero
SET PHRT = YLOH4
ELSE
SET PHRT = YLPHRT x $$PAYM
END
END
END

Load billing rates for the recharge records (RCCD = 2 or 3), if processing option 9 not set to use zero billing rates. PBRT is
returned as the base rate and the extended rate for OHF of R. IF the IHF is A, B, C, or D the rate from the respective column is returned. If
the rate is blank in the table, the extended rate is the base rate times the pay rate multiplier.

IF processing option 9 != 1
IF RCCD = 2
OR RCCD = 3
SET PBRT = YLPBRT
IF HSOHF = R
SET OR1 = YLPBRT
IF PDBA != processing option 2 (regular pay code)
SET PBRT = YLPBRT x $$PAYM
END
END
IF HSOHF = A
IF YLOR1 != zero
SET PBRT = YLOR1
ELSE
SET PBRT = YLPBRT x $$PAYM
END
END
IF HSOHF = B
IF YLOR2 != zero
SET PBRT = YLOR2
ELSE
SET PBRT = YLPBRT x $$PAYM
END
END
IF HSOHF = C
IF YLOR3 != zero
SET PBRT = YLOR3
ELSE
SET PBRT = YLPBRT x $$PAYM
END
END
IF HSOHF = D
IF YLOR4 != zero
SET PBRT = YLOR4
ELSE
SET PBRT = YLPBRT x $$PAYM
END
END
END (end recharge logic (RCCD = 2 or 3))
END (end processing option 9 logic(zero billing rates))
ELSE
SET $SEC = blank
END (end processing successful read of table)

Data Structure

DN0500015 - Retrieve the Union Rates

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
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.
szCostCenterChargeout	MCUO	char	NONE	NONE
A value that represents the location in which the employee worked. You can use this value to specify that an employee worked at this location but charged the time to a different business unit. This value is used for deriving rates from the Union Pay Rate table and is used exclusively by the Certified Payroll Register. A value in this field overrides the rates that are set up in the Union Rates table if the table is set up by job or 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 the hourly rate on a timecard. For payroll and time entry: If an employee always works a shift for which a shift rate differential is applicable, enter that shift code on the employee's master record. When you enter the shift on the employee's master record, you do not need to enter the code on the timecard when you enter time. If an employee occasionally works a different shift, you enter the shift code on each applicable timecard to override the default value.
szJobCategory	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 apply that information to the employees who are linked to that job type.
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 type to determine pay rates by job in the Pay Rates table.
jdDtWorkJulian	DWK	JDEDATE	NONE	NONE
The date used as the actual work date or pay-period ending date.
mnMultiplierPayTypeMult	PAYM	MATH_NUMERIC	NONE	NONE
A factor by which the base hourly rate is multiplied to obtain the actual payment hourly rate. For example, you could use 1.5 to designate time-and-one-half for overtime pay. 0 is not a valid multiplier. The default value is 1.00.
cRechargeCode	RCCD	char	NONE	NONE
A code that identifies whether the employee is to be handled through the Recharge processing option for the Payroll Journal Entry program. Valid codes are: 1 Payroll Processing Only 2 Payroll and Recharge Processing 3 Recharge Processing Only After a timecard has been added, you cannot change its record type.
cProcessingOptionZeroRate	EV01	char	NONE	NONE
An option that specifies the type of processing for an event.
cSecurityFlag	EV01	char	NONE	NONE
An option that specifies the type of processing for an event.
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 value in the Employee Master table. In the Employee Master table, this number is the employee's base hourly rate. In the Union Rates table, it is the straight time rate. NOTE: If you change the number of the data display decimal digits for this field, you must also change fields Rate - Base Hourly (BHRT) and Rate - Hourly (SHRT) so that they have exactly the same number of data display decimal digits.
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. The system charges the resulting amount, based on this rate, to the primary distribution account for the timecard. The system also enters an offset to an account that is derived from automatic accounting instructions. This rate does not affect employee payroll. To allow billing rates in time entry, the employee record type must be set to 2 (payroll and recharge processing) or 3 (recharge processing only) with the Employee Payroll program (P0801PRL).
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 file.
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 burden.
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 classifications on your periodic workers' compensation insurance reports.
cFloatCode	WET	char	NONE	NONE
A code that specifies any special circumstances associated with the workers compensation insurance (WCI) code, resulting in multiple rates for the same WCI code due to location or risk, for example. The subclass should remain blank if multiple rates do not exist. Default codes are: Blank There are no special circumstances associated with this code. F There are special circumstances associated with this code.
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 1.0000, so the resulting amount for the flat burden is zero. 1 The flat burden factor is always greater than 1.0000, so the labor costs include a flat burden.
cShiftCodeFlag	EV01	char	NONE	NONE
An option that specifies the type of processing for an event.
mnRtBaseHourly	BHRT	MATH_NUMERIC	NONE	NONE
This is the employee's base hourly rate as retrieved from either the Employee Master or the Union Rates Table. This number would not be modified by multipliers, differentials, etc. It is saved in the time entry file (F0611) for the express purpose of being able to account for premium pay separate from base pay. (See also: HRT, PWRT, BRT) *Important Note* If you change the number of DATA DISPLAY DECIMAL digits for the field "PHRT", "SHRT" you MUST also change this field's data display decimals to be the same number.
mnRateHourlyExtendedW	SHRT	MATH_NUMERIC	NONE	NONE
This is the employee's hourly rate. If applicable, Pay Type Multiplier and Shift Differential values will be added. If you change the value of the data display decimals for this field, you must also change the Hourly Rate (PHRT) and Base Rate (BHRT) fields in Time Entry to have exactly the same data display decimals.
cOvertimeCode	EV01	char	NONE	NONE
An option that specifies the type of processing for an event.
mnJobnumber	JOBS	MATH_NUMERIC	OPT	NONE
The job number (work station ID) which executed the particular job.

Related Functions

None

Related Tables

None