This chapter contains these topics:
After you enter employee information, you can enter instructions that apply to your employees, depending on the needs of your company and employees.
The information you enter provides instructions to the system and your department about how to process individual employees or groups of employees for reporting or payment purposes.
From Payroll Master (G07), choose Employee Information From Employee Information (G0711), choose Labor Distribution
You enter labor distribution instructions for individual employees to allocate time worked to multiple general ledger accounts. You can enter labor distribution instructions for hourly and salaried employees.
Labor distribution instructions simplify time entry. If you enter distribution instructions for an employee who is not set up for autopay, you can retrieve the instructions when you manually enter timecards. The system uses the labor distribution instructions you enter when it creates timecards for autopay employees.
Use labor distribution instructions to:
Distribute time to multiple general ledger accounts
Distribute time by either percentage or number of hours
Set effective dates for distributions
Create a template for time entry
Specify job type information when using multiple jobs
Override position ID and AAI accounts for an employee
If you set up Enhanced Subledger Accounting, you can view and change these values. See Work with Enhanced Subledger Accounting in the JD Edwards World General Accounting I Guide for more information.
To enter labor distribution instructions
Complete the following fields:
Employee Number
Percent or Hours
Pay Type
Account Number
Complete the following optional field:
Hours / %
Access the detail area to enter override values.
If an employee has multiple jobs, complete the following fields:
Job Type
Job Step
Home Business Unit
Optionally, choose Toggle display formats/ESA (F2) to view or change the values in the Enhanced Subledgers 1-4 or Enhanced Subledger Types 1-4 fields.
Field | Explanation |
---|---|
Percent or Hours | This field represents the method of distribution used for employee labor (either percentage or hours). Valid codes are:
% – Percentage (must equal to 100%) H – Hours Form-specific information If you enter H for hours in this field, you must enter a valid pay type in the Pay Type field and a general ledger account number in the Account Number field. You can, however, leave the number of hours blank, retrieve the distribution instruction during time entry, and enter the number of hours there. |
Pay | A code to define the type of pay, deduction, benefit, or accrual.
Pay types are numbered from 1 to 999. Deductions and benefits are numbered from 1000 to 9999. |
Account Number | A field that identifies an account in the general ledger. You can use one of the following formats for account numbers:
The first character of the account indicates the format of the account number. You define the account format in the General Accounting Constants program. |
Hours Worked | The number of hours associated with each transaction.
When you enter labor distribution with the hours method, this field can be blank. You must make an entry when using the percent method. Form-specific information When used in conjunction with the employee labor distribution instructions for an individual employee, you can use this field to enter a percentage. To account for all hours that an employee worked during the pay period, the sum of the percentages defined on all labor instruction entries must equal 100% for each job type, job step and home business unit. The system converts the percentages to hours when it copies the labor instruction records into actual time entry (timecard) records. |
Enhanced Subledger 1- 4 | This is a 10 character identification that represents a category or group of data. This ID is used to create sublists of values or data for validations. |
Enhanced Subledger Types 1- 4 | A user defined code (16/E1 through 16/E4)) that is used with the associated Enhanced Subledger field (ABR1 through ABR4) to identify the Enhanced Subledger field type and how the system will perform the Enhanced Subledger editing. The second line of the description on the User Defined Codes form controls how the system validates entries in the Enhanced Subledger field. This is either hard-coded (edits against a file as described in the second line of the description) or user defined.
User defined examples include: A Alphanumeric field, do not edit N Numeric field, right justify and zero fill C Alphanumeric field, right justify and blank fill |
Topic | Description |
---|---|
Workers compensation code | The processing options indicate where to find the workers compensation code. |
Multiple active jobs | Labor distribution is used to override position ID accounts or AAIs both in the multiple job and single job environment. The percentage of each job must total to 100% if the percent method is used. Home business unit, position ID, job type, and job step specify which job is being entered. If you are using multiple jobs, these fields must match an active job in the Employee Multiple Job table (F060118).
See also Section 6.1, "Entering Employee Multiple Job Information" |
Functionality for the Time Accounting system | The following fields are not applicable to Time Accounting:
|
Deductions represent dollar amounts withheld from an employee's earnings (excluding taxes). Benefits and accruals represent amounts that the company funds for additional employee compensation. You set up benefits to calculate dollar amounts, such as health care insurance. You set up accruals to calculate hours, such as vacation and sick time.
Working with deductions, benefits, and accruals (DBAs) includes:
Assigning DBAs
Reviewing DBAs
To simplify the handling of DBAs among employees, you can combine DBAs into groups of similar benefits that fit groups of employees with common characteristics. By using benefit groups, you can avoid keying identical lists of DBAs for each employee. The system refers to these groups of DBAs as Union or Group codes.
You can use DBA instructions to define exceptions to union and group codes. Although you can use this form to define all DBAs for an employee, maintaining the lists requires considerable effort. For this reason, JD Edwards World recommends that you define the majority of an employee's DBAs in a union or group code, and that you use DBA Instructions only for exceptions. You can override a DBA in a union or group code on the DBA instructions, as well as add DBAs to an employee record.
If you use the Human Resources Benefits Administration system, you also have Benefit Group codes. The system displays Benefit Group codes assigned to an employee on Employee DBA Instructions.
After you set up your DBA specifications, you can assign them. You can assign DBAs at four levels.
The following levels represent the DBA hierarchy:
One-time overrides in Time Entry
Employee instructions
Group plans
DBA setup
The following graphic represents the DBA hierarchy.
After you assign DBAs, the system calculates them during the payroll process according to the following search sequence:
One-time DBA override in Time Entry
Employee DBA instructions
Union or group plan
DBA setup
From Payroll Master (G07), choose Employee Information From Employee Information (G0711), choose DBA Instructions
You assign DBA instructions at the employee level to define and maintain DBAs unique to an individual employee. DBAs assigned at the employee level override DBA amounts or rates defined at the group or DBA setup level, unless it is a table method DBA.
The information you enter in the DBA instructions represents the third level of DBA assignment, the employee level.
When you assign DBA instructions at the employee level, you can:
Enter exceptions by employee for a group of DBAs
Specify overrides for amounts, dates, and limitations
Set up start and stop dates for a DBA
View expired or cleared transactions
Figure 4-3 Employee DBA Instructions screen
Complete the following fields:
Employee Number
DBA Code
Complete the following optional fields:
Amount or Rate Level 1
Date Pay Starts
Date Pay Stops
Generate A/P Voucher (GV)
Payee Number
Access the detail area.
Figure 4-4 Employee DBA Instructions (Detail) screen
Review the default information and, if necessary, enter override information.
If you are assigning a DBA that applies only to the secondary job, complete the following fields:
Business Unit (MCU)
Position ID (Pos)
Job Type
Job Step
When you enter a deduction number set up for garnishment, levy, loan, or child support deduction, the system displays the Wage Attachment Window.
Figure 4-5 Wage Attachment Window screen
Topic | Description |
---|---|
Overriding the group DBA | If an employee does not qualify for a DBA in a union or group, you can indicate that the employee does not receive the benefit by entering a Y (yes) in the Z (zero) field. The system overrides the amount in the Amount/Rate field with a zero amount. |
Declining balance | In order to enter an amount due during DBA setup, you must set up deductions with the declining balance indicator set to Y (yes). Both the indicator and the amount are on the DBA Additional Information window. |
On the Wage Attachment Window, complete the following optional field:
Case/Loan Number
Choose the Continue function.
Field | Explanation |
---|---|
Level 1 | The value in this field is either a percentage, a monetary amount, or an hourly rate, depending on where it is used:
|
Start | The date that an employee may begin participating in the company's benefit plans or may be included in payroll processing.
You can also use this field to provide a beginning date for seasonal employees or for employees who work only part of the year (such as a teacher who works only nine months of the year). Form-specific information Enter the date an instruction starts, for example, the date the system should start a deduction. The start date must be less than or equal to the timecard date. To start a DBA at the beginning of a pay cycle, make the start date equal to the first day of the pay cycle. For example, if the pay cycle runs from 10/01 to 10/15, start the DBA on 10/01. If both the start and stop dates are within the pay period from and through dates, even if the stop date is not less than the timecard date, the system will not calculate the DBA. For a flat amount DBA, the system calculates the full DBA for any timecard that falls within the DBA start and stop dates. For DBAs that calculate from a basis amount, such as a percentage rate DBA, the system includes only those timecards that fall within the DBA start and stop dates in the basis of calculation. |
Stop | The date that an employee's pay stops. This date is used to provide for employees who are seasonal or for employees who work only part of the year (such as a teacher who works only nine months of the year). See also data item PSDT.
It may also be the date that a deduction, benefit, or instruction stops. Form-specific information The stop date must be less than the timecard date. To stop a DBA before the next pay cycle, make the stop date one day prior to the first day of the next pay cycle. For example, if the pay cycle runs from 10/01 through 10/15, set the DBA stop date as 9/30. If both the start and stop dates are within the pay period from and through dates, even if the stop date is not less than the timecard date, the system will not calculate the DBA. For a flat amount DBA, the system calculates the full DBA for any timecard that falls within the DBA start and stop dates. For DBAs that calculate from a basis amount, such as a percentage rate DBA, the system includes only those timecards that fall within the DBA start and stop dates in the basis of calculation. |
G V | A code used to determine whether the system should generate a voucher for the DBA, tax, or wage attachment during the final update phase of the payroll processing cycle. Valid codes are:
N – No, do not generate a voucher Y – Yes, generate a voucher |
Payee No | The Address Book number for the supplier who receives the final payment.
In Benefits Administration, this is the Address Book number of the company that issues the plan and receives premium payments for it. For Wage Attachments, Payee is the Address Book number of the agency, company, individual, or court who is to receive the payment of the check. |
Topic | Description |
---|---|
Overriding the group DBA | If an employee does not qualify for a DBA in a union or group, you can indicate that the employee does not receive the benefit by entering a Y (yes) in the Z (zero) field. The system overrides the amount in the Amount/Rate field with a zero amount. |
Declining balance | In order to enter an amount due during DBA setup, you must set up deductions with the declining balance indicator set to Y (yes). Both the indicator and the amount are on the DBA Additional Information window. |
From Payroll Master (G07), choose Employee Information From Employee Information (G0711), choose DBA Instructions
For any employee you can review:
All the assigned DBAs
All the required DBAs
All parts of a group or union plan
DBAs unique to an employee
On DBA Instructions
Field | Explanation |
---|---|
File Code | Code used to select a specific file that should be used for Employee DBA Overview Inquiry (P06087). If a value is specified, only information from that file will be displayed. Valid values are:
E – Employee Pay Instructions (F06106) U – Union Benefits Master (F069106) D – Deduction/Benefit Specs (F069116) |
From Payroll Master (G07), choose Employee Information From Employee Information (G0711), choose Auto Deposit Instructions
You can define any of three methods of payment for each employee:
Check
Automatic deposit
Cash
You enter automatic deposit instructions for any employee who wants all or part of each payment deposited directly into a bank account.
You can perform the following additional functions:
Set up a combination of automatic deposit, check, or cash payment
Set up multiple bank accounts for an employee
Start and stop automatic deposits by period
Start and stop automatic deposits by date
Set up a remainder code to automatically process any money remaining when employees select different ways to distribute a payment
Set up the processing options that provide the originating bank number, service class code, and standard entry class
If you need to process payments using the International Automated Clearing House (ACH) Transaction (IAT) format, see Working with IAT and Magnetic Tapes in the JD Edwards World U.S. Payroll II Guide
To enter automatic deposit instructions
Figure 4-7 Auto Deposit Instructions screen
Complete the following fields:
Employee Number
Bank Account
Bank Transit Number
Method Code (MC)
Amount or Percent
The system supplies values for the following fields:
Prenote Flag
Transaction Code
Figure 4-8 Auto Deposit Instructions (Detail) screen
Review the values supplied by the system for the following fields:
Full/Partial Code
Pre Notification Code
Deduction Period Codes 1-5
Field | Explanation |
---|---|
Bank Account | The employee's unique account number at the financial institution. You can obtain the number from the MICR line of a voided check or a deposit slip from the employee's account. You must include dash cue symbols in the field. However, they are recorded in a translated mode as a hyphen (-). You can also obtain account numbers from other sources, such as passbooks or debit cards. When transcribing information, left justify and enter only numbers (0 through 9), alphabetic (A through Z), and hyphens (-). If less than 17 characters are required, leave the unused spaces blank. Spaces left within the depositor's account number will be ignored when the paperless entry is prepared. For example, 0123 4 56789 will appear as 0123456789 in the entry record, and 0123-4 56789 will appear as 0123-456789.
If you change this number, the system automatically prenotes the employee's auto deposit record again. Note: The Financial Organization Account Number (FOA#) is used as the company's unique bank account number rather than the employee's unique bank account number in the following tables: F06560 - Bank Reconciliation - Issue Table F06561 - Bank Reconciliation - Paid Table |
Bank Trnst No | The transit routing number used to identify the financial organization in which the employee maintains an account. These numbers can be obtained from the employee's check or deposit slip. They are located between the MICR colons (:) at the bottom of the check. If nine digits are not present, the employee's financial organization must be contacted to obtain the correct nine-digit code.
If you change this number for an employee, the system prenotes the employee's auto deposit record again. Form-specific information Bank might refer to this number as the ABA or routing number. |
M C | An employee can in a variety of ways split up net pay. This code specifies the method(s) in which a segment is to be computed:
A – A specific amount is to be deposited. % – A percentage of net pay is to be deposited. You must enter a whole number. Do not use decimals. C – A specific amount is to be generated as a payroll check. P – A specific amount is to be generated as cash. R – The remainder of the net pay, after % and/or specific amount segments are processed, is to be deposited in the bank. This is the default. Q – The remainder of the net pay, after % and/or specific amount segments are processed, is to be generated as cash. D – The remainder of the net pay, after % and/or specific amount segments are processed, is to be generated as a payroll check. You can have only one R, Q, or D instruction per employee. Note: Even if you have only one line, you must designate a remainder record as the last instruction. This code identifies how to distribute any money left over from rounding. You can only use R, Q, or D as the remainder record. You cannot use the Distribution Start Date and Stop Date fields for remainder records. |
Amount or Rate | The value in this field is either a percentage, a monetary amount, or an hourly rate, depending on where it is used:
Form-specific information For auto deposit instructions using a percentage method, enter whole numbers. Do not use decimals. |
Prenote Flag | A code that lets you test the deposit instructions for one pay period before actually processing a deposit. Adding an employee to this form automatically activates this person in the automated deposit system. The system prenotes this employee in the next applicable payroll run to test the auto deposit instructions you have set up before actually depositing a check. In the prenote test, the system creates a no-dollar entry for this employee and sends it to the employee's bank account. In addition, the employee receives a check for this amount. After the test, the system changes this field to N. To repeat this test, enter P in this field.
If you leave this field blank, the system uses the default value of P. You cannot use this field for Canadian employees. |
Tr Cd | A code used to distinguish various types of bank accounts, for example, checking, savings, or credit union. Currently the following codes have been assigned:
Demand Account Credits 20 - Reserved 21 - Credit entry to return automated deposit 22 - Automated Deposit Savings Account Credits 30 - Reserved 31 - Credit entry to return automated deposit 32 - Automated Deposit Demand Account Debits 25 - Reserved 26 - Debit entry to return automated payment 27 - Automated Payment Savings Account Debits 35 - Reserved 36 - Debit entry to return automated payment 37 - Automated Payment Note: If you leave this field blank, the system uses the default value of 22. |
Full/Partial Code | This code only applies to method code A (see BDM). If there is not enough net pay remaining to process the amount specified in the amount/percentage field, a value of "P" in this field specifies that a partial amount can be generated for the bank and account specified for the segment. A value of "F" specifies that if the full amount cannot be generated, the segment is ignored.
If you leave this field blank, the system uses F as the default value. |
Pre Note Trans Cd | A code used to distinguish various types of debit and credit non-dollar prenotification transactions that must precede the first actual automated paperless transaction with dollars for an employee.
Demand Account Credits 23 – Prenotification of Credit Authorization 24 – Prenotification of Credit/Mailed Authorization Savings Account Credits 33 – Prenotification of Credit Authorization 34 – Prenotification of Credit/Mailed Authorization Debits are not currently handled by this Payroll system. Automatic prenoting is only done one time. Therefore, if your bank requires multiple prenote cycles, you can manually set the transaction code (TCOD) for this record to a prenote code and leave it that way for as long as necessary. |
Period 1-5 | These period fields represent the five possible payroll periods in a month. They are used to control which period within the month a specific type of earnings may be paid or which deductions, benefits or accruals may be calculated. |