Functional Description
The purpose of this Named ER is to retrieve the occupational rates.
Setup Notes
Technical Specifications
Parameters
Data Item Data Structure DescriptionI/ORequired TableNotes
AN8Employee NumberI
MCUOCharge Out Cost CenterI
UNUnionI
JBCDJob CodeI
JBSTJob StepI
DWKWork DateI
SEC$Security FlagOThis flag will change to U if the retrieval is
successful
BHRTBase rateO
PBRTBilling RateO
PPRTPiece RateONot used until B73.2
RCCDRecord TypeI
Related Tables
Table Table Description
F060146Occupational Rates Table
Processing
Use the following hierarchy to search the x-ref (F060146) file.
Keys for F060146AN8
UN
JBCD
JBST
DWK
1st Fetch:AN8
MCU
UN
JBCD
JBST
DWK
If Unsuccessful,
2nd Fetch:AN8
MCU
UN
JBCD
blank
DWK
If Unsuccessful,
3rd Fetch:AN8
MCU
UN
blank
blank
DWK
If Unsuccessful,
4th Fetch:AN8
MCU
blank
JBCD
JBST
DWK
If Unsuccessful,
5th FetchAN8
MCU
blank
JBCD
blank
DWK
If Unsuccessful,
6th FetchAN8
MCU
blank
blank
blank
DWK
If Unsuccessful,
7th FetchAN8
blank
UN
JBCD
JBST
DWK
If Unsuccessful,
8th FetchAN8
blank
UN
JBCD
Blank
DWK
If Unsuccessful,
9th FetchAN8
blank
UN
blank
blank
DWK
If Unsuccessful,
10th FetchAN8
blank
blank
JBCD
JBST
DWK
If Unsuccessful,
11th FetchAN8
blank
blank
JBCD
Blank
DWK
If Unsuccessful,
12th FetchAN8
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 $OCC will be set to a 1. If unsuccessful, $OCC will be set to blanks.
IF JIAN8 = AN8
AND JIMCU = MCUO
AND JIUN = UN
AND JIJBCD = JBCD
AND JIJBST = JBST
AND DWK >= JIEFTB
AND DWK <= JIEFTE
SET SEC$ = O
Set Parameters to return to the calling program.
IF RCCD = 1
OR RCCD = 2
OR RCCD = 3
SET PBRT = JIPBRT
END (end recharge logic (RCCD = 2 or 3))
^
DN0500016 - Retrieve the Occupational Rates
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
mnAddressNumber | AN8 | MATH_NUMERIC | NONE | NONE |
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
| ||||
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
| ||||
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. | ||||
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
| ||||
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
| ||||
jdDtWorkJulian | DWK | JDEDATE | NONE | NONE |
The date used as the actual work date or pay-period ending date. | ||||
cSecurityFlag | 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
| ||||
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.
| ||||
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
| ||||
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
| ||||
mnJobnumber | JOBS | MATH_NUMERIC | OPT | NONE |
The job number (work station ID) which executed the particular job. |
None |
None |