8 Setting Up Contract-Specific Labor Categories

This chapter contains the following topics:

8.1 Understanding Contract-Specific Labor Categories

Contract-specific labor categories are job types that you set up for project and government contract accounting (PGCA) contracts so that when you enter transactions to record time that employees worked on the contract, the system validates whether the labor category on the transaction is valid for the contract. You use contract-specific labor categories in situations such as these:

  • You are performing work that is part of a contract with the U.S. federal government, and the contract terms state that you must use contract-specific labor categories.

  • You want to maintain an additional set of job types to use as external job titles for a contract.

Contract-specific labor categories can apply to both internal labor and subcontract labor. You record time for internal labor in the JD Edwards EnterpriseOne Time and Labor system, and you record time for subcontracted labor in the JD Edwards EnterpriseOne Subcontract Management and JD Edwards EnterpriseOne Procurement systems.

Depending on how the contract is structured, you can specify at the contract, invoice, or the funding levels that labor categories are required. For example, contract terms might state at the contract level that labor categories are not required but that a funding level for the contract does require them.

You use the Contract Specific Labor Categories program (P52G20) to enter labor categories for the contract. The P52G20 program enables you to set up labor categories by contract, invoice, funding level, or by business unit. After you set up the labor categories, you also use the P52G20 program to set up cross-references for them. Cross-references determine which labor category the system should assign based on the information that you enter on the transaction.

You must set up a default labor category in the Billing Constants program (P48091) for the system to use if it cannot find the correct labor category to assign to a transaction.

The system stores labor categories in the Contract Specific Labor Categories table (F52G20).

8.2 Understanding Setup for Contract-Specific Labor Categories

To use labor categories with a PGCA contract, you must first set up the applicable fields on the contract. You use these check boxes on the Billing/Revenue tab in the Create/Edit Project and Government Contracts program (P52G01M) to specify that the contract requires labor categories, and whether the categories apply to subcontract labor:

  • Contract Labor Categories

  • Subcontract As Labor

If you select the Contract Labor Categories check box, then the system requires that you enter valid labor categories on transactions that you enter for the contract. You must also enter hours on transactions for the contract. If you select the Subcontract As Labor check box, the system considers subcontracted labor transactions to be labor transactions, and it applies the same requirements for hours and valid labor categories to the subcontract labor transactions.


Note:

For subcontracts, you enter hours in the Service Quantity and Service UoM (service unit of measure) fields.

In addition to the settings for the check boxes, the system also uses automatic accounting instructions (AAIs) to determine whether the account number on the transaction is an employee labor or subcontract labor account. Therefore, you must set up these AAI ranges to specify which object accounts are used for employee labor and subcontract labor:

  • LAxx

    Identifies the account as an employee labor account.

  • SLxx

    Identifies the account as a subcontract labor account.

This table describes how the system determines whether the labor category that you enter must be valid:

Contract Labor Categories (CLCA) Subcontract As Labor (SUBLAB) Object Account Job Type Hours (timecards) or Service Quantity (subcontracts) Result
Selected Selected Employee Labor Required Required The job type must be a valid contract-specific labor category for the contract.
Selected Selected Subcontract Labor Required Required The job type must be a valid contract-specific labor category for the contract.
Selected Selected Non-labor Optional Optional If you enter a job type, the job type must be a valid contract-specific labor category for the contract.
Selected Cleared Employee Labor Required Required The job type must be a valid contract-specific labor category for the contract.
Selected Cleared Subcontract Labor Optional Optional If you enter a job type, the job type must be a valid contract-specific labor category for the contract.
Selected Cleared Non-labor Optional Optional If you enter a job type, the job type must be a valid contract-specific labor category for the contract.
Cleared Selected Employee Labor Optional Required If you enter a job type, the job type must be valid in UDC table 06/G.
Cleared Selected Subcontract Labor Optional Required If you enter a job type, the job type must be valid in UDC table 06/G.
Cleared Selected Non-labor Optional Optional If you enter a job type, the job type must be valid in UDC table 06/G.
Cleared Selected Any object account Optional Optional If you enter a job type, the job type must be valid in UDC table 06/G.

In addition to selecting the check boxes on the contract master that apply to labor categories and setting up AAIs for labor categories, you must also perform setup tasks that are specific to the JD Edwards EnterpriseOne Time and Labor and JD Edwards EnterpriseOne Subcontract Management applications.

See Processing Timecards Using Contract-Specific Labor Categories.

See Entering Contract-Specific Labor Categories for Subcontract Management.

8.3 Understanding Cross-References for Labor Categories

After you set up labor categories, you also use the P52G20 program to set up cross-references for them. Cross-references for labor categories enable you to define a set of rules that determines which labor category to assign when a user enters a transaction, such as a time card. The user can enter the labor category, and the system validates that it is the correct one, or the user can leave the Contract Labor Category field blank, and the system populates the field with the correct labor category.

For example, if you set up labor category 55PM for project manager and then you set up a cross-reference for 55PM using address book number 6002, when employee 6002 enters a time card, the system uses the cross-reference to determine that the time card should contain labor category 55PM. If the user leaves the Contract Labor Category field blank, the system populates it with 55PM. If the user overrides 55PM to a different labor category, the system validates it to determine whether it is a valid labor category for the contract.

You can set up cross-references to be either generic or specific, depending on your business needs. In addition to address book numbers, you can set up labor category cross-references using any combination of this information:

  • Job step

  • Home business unit

  • Cost pool

  • Range of object accounts

  • Range of subsidiaries

This table describes the first level of the hierarchical search that the system uses to determine the correct labor category to assign to a transaction:

Search Level Job Funding Level Invoice Level Contract Level
First X      
Second   X    
Third     X  
Fourth       X

Within each of the search levels in the preceding table, if it locates a labor category, the system then searches for a more specific cross-reference for the labor category. This table describes how the system determines whether a more specific cross-reference exists:

Search Level Address Number (AN8) Job Step (JBST) Home Business Unit (HMCU) Cost Pool (RP12)
First X X X  
Second X X   X
Third X   X  
Fourth X     X
Fifth X X    
Sixth X      
Seventh   X X  
Eighth   X   X
Ninth   X    
Tenth     X  
Eleventh       X
Twelfth        

Within each of the search levels in the preceding table, if it locates a labor category, the system then searches for a more specific cross-reference for the labor category. This table describes how the system determines if a more specific cross-reference exists:

Search Level Object (OBJ) Subsidiary (SUB)
First X X
Second X  
Third   X
Fourth    

The system stores labor category cross-references in the Contract Specific Labor Category Cross Reference table (F52G21).

8.4 Entering Contract-Specific Labor Categories

This section discusses how to:

  • Set up a contract-specific labor category.

  • Set up a labor category cross-reference.

8.4.1 Prerequisites

Before you set up labor categories:

8.4.2 Forms Used to Set Up Contract-Specific Labor Categories

Form Name Form ID Navigation Usage
Work With Contract Specific Labor Categories W52G20G Daily Processing-Project and Government Contract Accounting (G5215), Contract Specific Labor Categories Review contract-specific labor categories.
Labor Category Revisions W52G20C Click Add on the Work With Contract Specific Labor Categories form. Set up a contract-specific labor category.
Contract Specific Labor Categories - Delete Confirmation W52G20D Click Delete on the Work With Contract Specific Labor Categories form. Confirm the deletion of labor categories.
Global Labor Category View W52G20H Select the Global Labor Category View link on the Work With Contract Specific Labor Categories form. View labor categories for all contracts and business units.
Global Labor Categories X-Ref View W52G20I Select the Global X-Ref View link on the Work With Contract Specific Labor Categories form. View cross-references for labor categories for all contracts and business units.
Labor Category X-Ref Revisions W52G20B Select a labor category and click Edit X-Ref on the Labor Category Revisions form. Set up a labor category cross-reference.

Note: You must save a labor category before you can create a cross-reference for it.


8.4.3 Setting Up a Contract-Specific Labor Category

Access the Labor Category Revisions form.

Figure 8-1 Labor Category Revisions form (1 of 2)

Description of Figure 8-1 follows
Description of "Figure 8-1 Labor Category Revisions form (1 of 2)"

Figure 8-2 Labor Category Revisions form (2 of 2)

Description of Figure 8-2 follows
Description of "Figure 8-2 Labor Category Revisions form (2 of 2)"

Contract No. or Business Unit

Enter either a contract number or a business unit, depending on the level at which the labor categories are valid. For example, if the labor categories apply to all invoice and funding levels attached to the contract, enter the contract number for the contract level. If the labor categories apply to only a specific business unit within a funding level, enter the business unit number.

Job Type

Enter a code to represent the labor category for the contract. You can enter up to six alphanumeric characters.

Elig Ovr (eligibility overrides)

Specify an eligibility code to override the account and billing line eligibility codes for transactions for this labor category. Values are:

Blank: No overrides exist for this labor category.

0: The labor category is eligible for invoicing and revenue recognition.

1: The labor category is eligible for invoicing only.

2: The labor category is eligible for revenue recognition only.

3: The labor category is non-billable.

4: The labor category is eligible for cost only.

If you enter a value in this field, the system overrides the account and billing line eligibility codes for transactions for this labor category with the code that you enter.

The system assigns eligibility codes to workfile transactions based on the Billable (Y/N) field in the Account Master table (F0901) and the Journal Generation Control field that you set up in the Billing Constants program (P48091).

These values are hard-coded, and the system stores them in UDC table 52/EL.

Labor Type

Select a value from UDC table 52G/LT.

Fee Calculated

Specify whether the system should calculate a fee for transactions that you enter for this labor category.

See Labor Category Method.

LOE Hours (level of effort hours)

If you entered 1 in the Fee Calculated field, specify the maximum number of hours up to which the system will calculate fees. For example, if you enter 1000, the system continues to calculate fees for transactions entered for the labor category until the total number of hours for the labor category reaches 1000. When calculating fees, the system uses the LOE hours for all labor categories for a contract.

See LOE at Labor Category Method.

Fee Rate Type

Specify the method for calculating fees. Values are:

1: Amount per hour

2: Percent

These values are hard-coded, and the system stores them in UDC table 52G/FT.

Fee Rate

Enter either a percentage or a rate per unit, depending on the value that you specify in the Fee Rate Type field.

8.4.4 Setting Up a Labor Category Cross-Reference

Access the Labor Category X-Ref Revisions form.

Figure 8-3 Labor Category X-Ref Revisions form

Description of Figure 8-3 follows
Description of "Figure 8-3 Labor Category X-Ref Revisions form"

Complete any of the fields on this form. For each cross-reference, you can complete as many or as few of the fields as your business needs require.

Job Type

Enter the labor category for which you want to create a cross-reference.

Begin Date and Ending Date

Enter a range of dates for which the cross-reference is effective.

Address Number

Enter the address book number of the consultant or subcontracted labor employee that you want to associate with the labor category.

Home Business Unit

Enter the home business unit number for which you want to create a cross-reference.

Job Step

Enter the job step for which you want to create a cross-reference.

Pool Grp Cde (pool group code)

Enter the pool grouping code for which you want to create a cross-reference.

Obj From (object from) and Obj Thru (object through)

Enter a range of object accounts for which you want to create a cross-reference.

Sub From (subsidiary from) and Sub Thru (subsidiary through)

Enter a range of subsidiaries for which you want to create a cross-reference.