Defining Task Reporting Requirements

This chapter gives an overview of task reporting functionality and discusses how to:

Click to jump to parent topicUnderstanding Task Reporting Requirements

With Time and Labor, you can track time at the level of task detail your organization requires and allocate costs accordingly. We use the term task to refer to a set of attributes of reported time, such as department, product, or project, that more precisely identify how or where time was spent.

You can specify the types of task information you want to capture for each time reporter. For example, you may want sales staff to account for their time by customer and product; project managers to account for their time by project and activity; and administrative staff to report their time without task detail. Task templates, task profiles, and taskgroups are the tools that make this possible.

Taskgroups serve another important function: they are the means by which you assign default time reporting templates to time reporters. So, even if you’re not interested in capturing task data for time reporters, you need to create taskgroups and assign a taskgroup to each time reporter.

See Also

Creating Time Reporting Templates

Click to jump to top of pageClick to jump to parent topicUnderstanding Task Functionality

Task reporting is a subset of time reporting. Specify the types of information you want to collect from time reporters by creating time reporting templates described in the Reporting Time section of this book. You specify the task-related data you want to collect by designating the use of either a task profile or a task template on the time reporting template.

Click to jump to top of pageClick to jump to parent topicUnderstanding Task Reporting Tools

You will use a group of task oriented tools to define your organization’s task reporting requirements:

Task Entities

In Time and Labor, a task represents work assigned to a time reporter, and is represented by a combination of task entities.

Task entities, also called task elements, are the specific types of task data you can capture when time is reported: customer, task, product, project, activity, company, combo code, department, business unit, job code, position number, location code, and up to five user-defined categories. Additional task entities are available if you’re using Project Costing with Time and Labor.

Task Template

Task templates control the task fields that appear on the time reporting pages. They also control what task data your time collection devices (TCDs) collect from time reporters. You select the task entities you want the members of a taskgroup to report their time to—company, department, or project, for example—through the task template. You also identify whether each type of information is required or optional.

Task Profile

Task profiles enable you to select task values for the task entities defined on your task template. You select the values for each task entity that’s defined on a task template. For example:

Project: PS Payroll

Activity: Sales

Department: Marketing

Business Unit: USA

You also specify how reported time is to be allocated across tasks: by percentage, quantity, or equally.

You can create multiple task profiles from the same task template.

When time is entered or generated for a time reporter who uses task profile reporting, the system refers to the task profile to determine which task values to assign or allocate − limiting the data the time reporter needs to enter.

Note. Task profiles provide one way to supply values for task entities. Time reporters can also positively report task values if they use task template reporting, rather than task profile reporting.

Taskgroup

A taskgroup identifies the valid, default time reporting templates, task template, and task profile(s) for time reporters with the same task reporting requirements. Each time reporter must be associated with one taskgroup, but the taskgroup assignment can be overridden when reporting time.

To summarize:

The following diagram represents the relationships between time reporters, taskgroups, task templates, and task profiles.

Relationship between time reporters, task profiles, task templates, and taskgroups

Click to jump to top of pageClick to jump to parent topicUnderstanding Types of Task Reporting

Time and Labor supports two types of task reporting:

If you do not capture task data for some or all time reporters, you can use the nontask templates delivered with Time and Labor.

Default Reporting

You can designate which task profile applies to a time reporter on more than one page. The system uses the following hierarchy to determine which task profile to use.

Note. Time and Labor enables you to override a time reporter’s taskgroup when entering time. Taskgroup overrides, also referred to as taskgroup borrowing, enable time reporters to report time using the task profiles or task elements associated with the borrowed taskgroup.

See Also

Creating Time Reporting Templates

Defining Taskgroups

Click to jump to top of pageClick to jump to parent topicUnderstanding How to Create Task Values in Time and Labor

For each type of task data you want to track in Time and Labor, you must set up an underlying task prompt table that defines the set of valid values that users can enter when reporting time or that the system retrieves when generating time. Some of these underlying tables are defined in Time and Labor; other tables are created in Human Resources Management, Project Costing, and PeopleSoft Enterprise Performance Management.

This section discusses where the values for each task-related prompt table are defined.

Understanding Where Prompt Tables are Defined

This table shows which PeopleSoft application you use to define task data used by Time and Labor. Notice that a few of the task elements (activity, projects, and business unit) can be defined in more than one application.

Application

Fields

HR Task Elements

Company

Business Unit HR

Location

Department ID

Jobcode

Position Number

Time and Labor Elements

Customer

Task

TL Product

TL Project

TL Activity

General Ledger Elements

Combo Code

Note. You can view the active and inactive ChartFields by expanding the ChartFields section of the Standard ChartField Configuration.

Performance Management Elements

Business Unit PF

Activity FS

Project Costing Elements

PC Business Unit

Project ID

Activity

Resource Type

Resource Category

Resource Subcategory

The following table lists where each set of task-related values is stored and tells you how to navigate to the pages where values are defined. For some task entities, this information depends on whether you’re using PeopleSoft Financials (Project Costing and/or Enterprise Performance Management) and if you’re using commitment accounting functionality. Values defined in PeopleSoft Financials can be viewed in Time and Labor, but can only be added or deleted in the application in which they are created.

Task Element

Table

Navigation

Company

COMPANY_TBL

Set Up HRMS, Foundation Tables, Organization, Company

HR Business Unit

BUS_UNIT_TBL_HR

Set Up HRMS, Foundation Tables, Organization, Business Unit

Location

TL_LOCATION_VW

Set Up HRMS, Foundation Tables, Organization, Location

Task values are based on setID for HR business unit.

Department ID

TL_DEPT_TBL_VW

Set Up HRMS, Foundation Tables, Organization, Departments

Not applicable when using commitment accounting. Task values are based on setID for HR business unit.

Jobcode

TL_JOBCODE_VW

Set Up HRMS, Foundation Tables, Job Attributes, Job Code Table

Task values are based on setID for HR business unit.

Position Number

POSITION_DATA

Organizational Development, Position Management, Maintain Positions/Budgets, Add/Update Position Info

Product

TL_PRODUCT_TBL

Set Up HRMS, Product Related, Time and Labor, Task Elements, Product

Not applicable if combo code is enabled and product is an active ChartField

Customer

TL_CUSTOMER

Set Up HRMS, Product Related, Time and Labor, Task Elements, Customer

Combo Code

TL_ACCTCD_BU_VW

Set Up HRMS, Common Definitions, ChartField Configuration, ChartField Transaction Table

Business Unit PC

TL_BUS_CA_PC_VW

Set Up HRMS, Common Definitions, ChartField Configuration, ChartField Values

Used only if Project Costing is installed and commitment accounting is used. Choices are restricted to business units that are compatible with the project ID from the Account Code table.

The links are only available if the PC ChartFields are active. This applies to PC BU, Project (PC), Activity (PC), Resource Type, Resource Category, and Resource Subcategory.

 

BUS_UNIT_PC_VW

Same as above without commitment accounting.

Business Unit PF

BUS_UNIT_TBL_PF

Set Up HRMS, Product Related, Time and Labor, Task Elements, Business Unit PF

Used only when Performance Management is installed and Project Costing is not.

Project

PROJ_TEAM_DVW

Set Up HRMS, Common Definitions, ChartField Configuration, ChartField Values

Used when Project Costing installed, combo code is not enabled or project is not an activated ChartField, and team membership is enforced for all projects as designated on the business unit PC. Users can select only active projects to which time reporter is assigned.

 

TL_PROJ_PC_VW

Same as above except used when team membership is not enforced. User can choose any projects within the business unit.

 

TL_PROJECT

Set Up HRMS, Product Related, Time and Labor, Task Elements, Project

Used when Project Costing is not installed and project is not an active ChartField..

Activity

TL_PROJ_ACTV_VW

Set Up HRMS, Common Definitions, ChartField Configuration, ChartField Values

Used when Project Costing is installed. Choices are restricted to active activities.

 

TI_FS_ACTV_VW

Set Up HRMS, Product Related, Time and Labor, Task Elements, Activity ID

Used when Performance Management is installed and Project Costing is not. Choices are restricted to active activities.

 

TL_ACTIVITY

Set Up HRMS, Product Related, Time and Labor, Task Elements, Activity ID

Used when neither Project Costing nor Performance Management is installed. Choices are restricted to active activities.

Resource Type

TL_PROJ_RTYPE_V

Set Up HRMS, Common Definitions, ChartField Configuration, ChartField Values

Used only when Project Costing is installed.

Resource Category

TL_PROJ_CATG_V2

Set Up HRMS, Common Definitions, ChartField Configuration, ChartField Values

Used only when Project Costing is installed. If the resource category is related to resource type as defined on the Business Unit PC field.

 

TL_PROJ_CATG_VW

Same as above, except table used when the resource category is not related to the resource type as defined on the Business Unit PC field.

Resource Subcategory

TL_PROJ_SUB_V2

Set Up HRMS, Common Definitions, ChartField Configuration, ChartField Values

Used only when Project Costing installed. Table used when the resource subcategory is related to the resource category as defined on the Business Unit PC field.

 

TL_PROJ_SUB_V

Same as above, except table used when the resource subcategory not related to the resource category as defined on the Business Unit PC field.

Task

TL_TASK

Set Up HRMS, Product Related, Time and Labor, Task Elements, Task

User Fields 1 - 5

TL_USER_FIELD_1-5

Set Up HRMS, Product Related, Time and Labor, Task Elements, User Field1-5

Note. If you are not using Project Costing or Performance Management with Time and Labor, you may want to define your PeopleSoft security so that users see only the applicable menu items. See the Enterprise PeopleTools PeopleBook: Security Administration for more information.

Click to jump to top of pageClick to jump to parent topicUsing ChartFields in Time and Labor

This section provides a brief overview of ChartFields and discusses the:

ChartFields are fields used to report General Ledger charts of accounts with transactional data. These accounts determine the logging of transactions and the tracking of information for General Ledger purposes. ChartFields enable you to report up to 21 chart of accounts when entering transactional data. Both Commitment Accounting and Non-Commitment Accounting customers can utilize the ChartField functionality for their business processes.

Configuration and Integration

You can configure and activate all or a subset of the 21 ChartFields using the Standard ChartField Configuration page. The Standard ChartField Configuration page enables you to activate, change the order of display, relabel the fields, and change the field length displayed for individual ChartFields.

If you integrate your HCM database with PeopleSoft General Ledger (GL), then you also set up the Standard ChartField Configuration that is owned by PeopleSoft Financial Management Systems (FMS). This configuration is defined and sent to HCM via Integration Broker. Any changes must be made directly in the FMS database and then sent to HCM.

If the HCM database is not integrated with PeopleSoft General Ledger, but you still want to enter ChartField values, then the Standard ChartField Configuration is accessible and can be updated directly. This may be used to capture chart of account values to send to a third party GL application or to just capture these details for HCM purposes. No matter where the configuration is entered, once you press the Apply button and the application engine runs, the pages displaying ChartFields will reflect the configured display.

See Setting Up and Working with ChartFields and ChartField Combinations.

Impact on Task Template

After you press the Apply button on the Standard ChartField Configuration page, the impact to Time and Labor (TL) begins with the task template. The task template reflects the activated ChartField values when combo code is an enabled field. For example, if the Standard ChartField Configuration has activated GL account, department and project, and the application engine (using the Apply button) has been run, then the enabling of combo code field on the task template also enables the GL account, department and project as individual ChartField values.

When the system enables the combo code on the task template, the HR business unit is also enabled. The reason is in order to validate the combination of individual ChartField values, associated with a new or existing combo code, a GL business unit is required. HR business units are mapped to GL business units through the GL/HR Business Unit Mapping page (Setup HRMS, Common Definitions, ChartField Configuration, GL/HR Business Unit Mapping). With this mapping, when a HR business unit is reported then the GL business unit can be derived and validation performed. If a HR business unit is not mapped to a GL business unit, the system displays an error message. This error message is triggered online, at the point of validation, or during validation in the Submit Time application process.

The TL Product, TL Project,and TL Activity fields can be enabled on the task template depending on the Standard ChartField Configuration and the integration with PS/Projects and PS/EPM. The chart below describes when the fields are available and when they are not.

PRODUCT

TL_Product Available

Combo Code is enabled and Product is an active ChartField.

N

Combo Code enabled and Product is an inactive ChartField.

Y

Combo Code is not enabled.

Y

 

PROJECT

TL_Project Available

Combo Code is enabled and Project is an active ChartField. Integrate with PS/Projects is either enabled or NOT enabled

N

Combo Code enabled and Project is an inactive ChartField. Integrate with PS/Projects is enabled.

N

Combo Code enabled and Project is an inactive ChartField. Integrate with PS/Projects is NOT enabled.

Y

Combo Code is not enabled and Integrate with PS/Projects is enabled.

N

 

ACTIVITY

TL_ACTIVITY Available

PS/Project installed

N

PS/EPM installed

N

PS/EPM and PS/Projects are not installed

Y

Impact on Time Reporting Pages

In Time and Labor, the system prepopulates the HR business unit on the transaction pages based on the User ID and the default HR business unit from the JOB record. This value can be overwritten to reflect the user preference when entering transactional details, but to ensure that a HR business unit is reflected for combo code validation, the system performs the prepopulation process.

Task reporting, on transaction rows, is driven by the taskgroup selected (either through default or borrowing). When reporting time you have the option of entering or selecting the Combo Code on the page or using the ChartFields link to search for ChartField combinations or add new ChartField combinations.

See Setting Up and Working with ChartFields and ChartField Combinations.

Chartfield Storage on Reported Time and Task Profile

Reported time (TL_RPTD_TBL) and the task profile (TL_TSKPRF_DETL) only store the combo code, they do not store the values for individual chartfields.

ChartField Storage on Payable Time

Payable Time table (TL_PAYABLE_TIME) stores both the combo code and individual ChartField values because ChartField integration with Global Payroll and Payroll for North America are handled differently.

Time and Labor Validation Options

On the Time and Labor Installation page there are three options for ChartField validation.

Sync Message

This option sends a message with ChartField data to FMS and receives a response of valid or not.

Table Validation

This option uses the Valid Combo Table to allow or deny a combination of individual ChartField values.

None

This options allows you to turn off validation for Time and Labor transactions.

Note. If you set the validation option to None, then only individual ChartField values will be validated and not the combination. If a combo code is generated without an associated GL Account, and this combo code is used in the integration with Payroll for North America, the associated transaction will fail when sent to General Ledger. In this case users that are integrating with Payroll for North America should always enter a GL_Account value even if the validation option is set to None.

GL Account is a required field when sending transactional data to General Ledger from any feeder system. Validations performed using Integration Broker or the Table Validation always require you to enter a GL Account value (at minimum).

Click to jump to top of pageClick to jump to parent topicUnderstanding Task Reporting with PeopleSoft Financials

PeopleSoft Financials enables task reporting in the following areas:

Project Costing

When you integrate Time and Labor with Project Costing, you have additional options for tracking time at the task level. You can track time by business unit, by the projects and activities defined in Project Costing, and by resource type, resource category, and resource subcategory. Valid values for these task entities come directly from Project Costing through Integration Broker and can be viewed through the ChartField Value page.

See Also

Integrating with PeopleSoft Financials and Enterprise Performance Management

Click to jump to top of pageClick to jump to parent topicUnderstanding the Sequence for Defining Task Functionality

This flowchart illustrates the sequence of steps necessary to define your task reporting requirements. We discuss each of these steps briefly in this section.

Defining Task Functionality steps

To define task reporting requirements for your organization:

  1. Create time reporting templates.

    Use the Time Reporting Template page to create templates for elapsed time and punch time reporting. On the template, select the Task Profile or Task Template check box to indicate the type of task reporting for which the template is designed. You must create time reporting templates before you can create taskgroups.

  2. Create task templates.

    Use the Task Template page to select the task entities that you want to appear on the time reporting pages or that you want your time collection devices (TCDs) to capture from time reporters.

    You can create task templates before or after you create values for task entities.

  3. Create values for task entities (optional).

    If you want employees to report time by customer, product, activity, task, project, and/or up to five user-defined task categories, define the set of valid values that can be used for time reporting. For example, if you want to account for time by customer, set up a code for each customer.

    If Project Costing is integrated with Time and Labor, the Project Costing application uses Integration Broker technology to publish the valid values for additional task entities.

  4. Create task profiles.

    Use the Task Profile page to select the values for the task entities you selected on the task template. Also indicate whether time is to be allocated across tasks equally, allocated by percentage, or allocated by quantity.

  5. Create taskgroups.

    Use the Taskgroup page to identify the default time reporting templates, task template, and task profile(s) that are valid for time reporters with the same task reporting requirements.

    Before you can define taskgroups, you must create time reporting templates for elapsed and punch time reporting.

  6. Assign taskgroup and task profiles.

Note. Before you begin to define task templates, task profiles, and taskgroups, spend some time analyzing your organization’s task-reporting requirements. Determine which time reporters share the same or similar reporting requirements, perhaps based on the kind of work they perform, and what those specific requirements are. One taskgroup can include both elapsed and punch-time employees—employees and non-employees—as long as the same task entities apply to everyone in the taskgroup.

See Also

Entering and Maintaining Time Reporter Data

Using Time Collection Devices

Click to jump to parent topicCreating Task Templates

To create task templates, use the Task Template (TL_TSKPRF_TMPLATE) component.

Use task templates to select the types of task information you want taskgroup members to provide when reporting time.

For example, if a group of time reporters does project work, such as developing software, you might want to create a task template that captures the project and product they're working on, the department, and individual tasks. If you're creating a task template for a group of account managers, you may want to include customer, company, department, and account code. Each task template should represent a distinct set of task-related elements.

A task template must be assigned to each taskgroup. You can assign the same task template to more than one taskgroup or you can create a separate task template for each taskgroup. The task template assigned to a taskgroup controls which task profiles you can associate with the taskgroup.

See Also

Referential Integrity

Click to jump to top of pageClick to jump to parent topicPage Used to Create Task Templates

Page Name

Definition Name

Navigation

Usage

Task Template

TL_TSKPRF_TMPLATE

Set Up HRMS, Product Related, Time and Labor, Task Configurations, Task Template, Task Template

Select the types of task-related data you want a group of employees to report their time to such as company, business unit, department.

Click to jump to top of pageClick to jump to parent topicCreating a Task Template

Access the Task Template page (Set Up HRMS, Product Related, Time and Labor, Task Configurations, Task Template, Task Template).

Task Template ID

This field displays the name of the task template.

Commitment Accounting

This is a display field. When selected, it indicates that your organization uses commitment accounting. In addition, the Combo Code field is enabled, and the Product and Project ID fields are unavailable.

Note. A task template that is defined for commitment accounting can only be attached to taskgroups set up for commitment accounting.

Production Environment

Displays the setting from the TL Installation page. When the environment is specified as a Production Environment you cannot remove a task element previously marked as required, or add a previously unused element required.

Used by Taskgroup(s)

This is a display field. When selected, it indicates that the task template has been assigned to a taskgroup and the modifications you can make to the template are limited.

If the system has been configured to use referential integrity (the Referential Integrity option on the Time and Labor Installation page is selected) you can add optional fields to the template and change required fields to optional.

If the system is not using referential integrity, you can make any changes to the template except change the commitment accounting option.

General Ledger

Displays the setting from the Installation page.

Project Costing

Displays the setting from the Installation table. Impacts whether Project Costing fields are presented on the page.

Interface with PS EPM

Displays the setting from the TL Installation page.

In the HR Task Elements, Time & Labor Elements, Performance Mgmt Element, and General Ledger Elements group boxes, select each type of task data you want time reporters associated with this taskgroup to report. For each field you choose, select either Required, Optional, or Not Used in the drop-down list to the right.

If your organization uses commitment accounting, Project Costing (PS/Projects) or Enterprise Performance Management (PS/EPM), some of the task fields may be selected automatically or made unavailable. The field descriptions below indicate when each field is available and the corresponding default values for selected fields.

HR Task Elements

Company

Always available.

Business Unit HR

Selected automatically when you select Location, Department ID, Jobcode or Combo Code. If you make any of these fields required, Business Unit HR is also required.

The Business Unit HR is required to derive the GL Business Unit for validation of combo code.

Location

Always available. Location is dependent on Business Unit HR. When you select Location, the system automatically selects Business Unit HR with the same default value.

Department ID

Not available when using commitment accounting. (Time and Labor automatically determines the correct HR department based on the combo code.) Department ID is dependent on Business Unit HR. When you select Department ID, the system automatically selects Business Unit HR with the same default value.

Jobcode

Always available. Jobcode is dependent on Business Unit HR. When you select Jobcode, the system automatically selects Business Unit HR with the same default value.

Position Number

Available only if using the Position Management feature and you have selected either Full or Partial on the HR Core Installation table.

Performance Mgmt Element

Business Unit PF

Available only when Interface with PS/EPM is selected on the Time and Labor Installation page.

Activity FS

Controlled by the setting for Business Unit PF.

Time and Labor Elements

Customer

Always available.

Task

Always available.

TL Product

Available if Product is not an active ChartField or if combo code is not selected.

TL_Project

Mutually exclusive with PC Project when Project Costing is installed. Mutually exclusive with Combo Code if Project is an active ChartField.

TL Activity

Mutually exclusive with EPM Elements if Performance Management is installed. Mutually exclusive with Project fields if Project Costing is installed. Mutually exclusive with Combo Code if Project Costing fields are active ChartFields.

User Field 1 to 5

Always available.

General Ledger Elements

Combo Code

Automatically selected as an enabled field when commitment accounting is in use. In all other cases, Combo Code is available.

Project Costing Elements

PC Business Unit

Available only when Project Costing is selected on the Installation page. In this case, the system automatically selects PC Business Unit and defaults to Optional, though you can change it to Not Used. Exceptions are as follows:

If you make Resource Type, Resource Category, or Resource Subcategory a Required field, PC Business Unit, Project ID and Activity ID become Required fields.

Activity ID

Activity is controlled by and inherits the setting from PC Business Unit.

Resource Type

Available only when the PC Business Unit field is selected.

Note. The dependencies between Resource Type, Resource Category, and Resource Subcategory check boxes are dynamic.

Resource Category

Available only when the Business Unit PC field is selected.

Resource Subcategory

Available only when the Business Unit PC field is selected.

Modifying a Task Template

Once you save a task template, the types of changes you can make to it depend on whether the template has been associated with a taskgroup and/or if the system has referential integrity selected on the Time and Labor Installation page. The table below shows the restrictions that are in place to enforce referential integrity.

Referential Integrity?

Template Assigned to Taskgroup?

Changes Permitted

Yes

Yes

You can add optional fields and change required fields to optional.

If you unintentionally included or excluded task entities when creating the task template, you can create a new template and change the task template assignment on the Taskgroup page. Changing the template will trigger referential integrity if time has already been reported for the taskgroup.

Yes

No

All changes are permitted.

No

Yes

All changes are permitted, with the exception of changing the commitment accounting option. Changes may trigger referential integrity.

No

No

All changes are permitted.

See Also

Using Time and Labor with Commitment Accounting

Click to jump to parent topicUploading ChartField Combinations

The Upload ChartField Combinations feature enables you to insert data into Combo Code task elements. The system loads the contents of a file that contains combination code information into the ACCT_CD_TBL_TMP temporary table. Then use the TL_ACCT_CD Application Engine program to read the temporary table, validate the data, and insert the data into the ACCT_CD_TBL and ACCT_CD_TBL_GL tables. The system generates two reports: an upload summary report and a detail report that lists any bypassed records, and the reason for discarding the records.

The data file must be a comma-separated value (CSV) file with the chartfield information for each combination code listed in a specific order. If you do not use all of the available chartfields in a specific combination code, you should leave the unused columns empty and keep the formatted sequence of chartfields. The following table lists each chartfield name in the correct order for the data file, and provides a brief description of the contents of each column of chartfield information:

ChartField Label

Description

General Ledger Unit

Enter the General Ledger Business Unit for each combination code in this column of the data file. For example: BUXYZ

Combination Code

Enter an optional name for each combination code in this column of the data file. For example: NEW COMBO ABC

Description

Enter an optional description of each chartfield combination in this column of the data file.

Account

Enter the Account ChartField account information for each combination code in this column of the data file. For example: 123456-88

Department

Enter the Department ChartField information for each combination code in this column of the data file. For example: DEPT X

Business Unit PC

Enter the Project Costing Business Unit ChartField information for each combination code in this column of the data file. For example: BUABC

Project ID

Enter the Project Identification ChartField information for each combination code in this column of the data file. For example: LOAD CFS

Activity ID

Enter the Activity ChartField information for each combination code in this column of the data file. Activities are the specific tasks that make up a project. For example: VIEW SAMPLE

Resource Type

Enter the Source Type ChartField information for each combination code in this column of the data file. Source types identify the purpose or origin of a transaction.

Resource Category

Enter the Category ChartField information for each combination code in this column of the data file. Use categories to further define source types.

Resource Sub-Category

Enter Subcategory ChartField information for each combination code in this column of the data file. Use subcategories to further define categories.

Product

Enter Product ChartField information for each combination code in this column of the data file. The Product ChartField captures additional information useful for profitability and cash flow analysis by product sold or manufactured.

Fund Code

Enter Fund Code ChartField information for each combination code in this column of the data file. Fund Codes are the primary structural units of Education and Government accounting.

Program Code

Enter Program Code ChartField information for each combination code in this column of the data file. Program codes can be used to identify groups of related activities, cost centers, revenue centers, responsibility centers and academic programs.

Class Field

Enter Class Field ChartField information for each combination code in this column of the data file. Can be used to identify specific appropriations.

Affiliate

Enter Affiliate ChartField information for each combination code in this column of the data file. Affiliate is used to map transactions between Business units when using a single interunit account.

Operating Unit

Enter Operating Unit ChartField information for each combination code in this column of the data file. Operating Unit can be used to indicate a location, such as a distribution warehouse or a sales center.

Alternate Account

Enter Alternate Account ChartField information for each combination code in this column of the data file. Alternate accounts classify the nature of a transaction for regulatory authorities.

Budget Reference

Enter Budget Reference ChartField information for each combination code in this column of the data file. Use budget references to identify unique budgets, when individual budgets share budget keys and overlapping budget periods.

Chartfield 1

Enter customizable ChartField information for each combination code in this column of the data file. Generic expansion ChartFields can be configured for use, hidden, or deleted

Chartfield 2

Enter customizable ChartField information for each combination code in this column of the data file. Generic expansion ChartFields can be configured for use, hidden, or deleted

Chartfield 3

Enter customizable ChartField information for each combination code in this column of the data file. Generic expansion ChartFields can be configured for use, hidden, or deleted

Fund Affiliate

Enter Fund Affiliate ChartField information for each combination code in this column of the data file. Use fund affiliates to correlate transactions between funds when using a single intraunit account.

Operating Unit Affiliate

Enter Operating Unit Affiliate ChartField information for each combination code in this column of the data file. Use operating unit affiliates to correlate transactions between Operating Units when using a single intraunit account.

Important! The order of the fields in the file is fixed and independent of the configured order of chartfields according to the Standard Configuration.

Click to jump to top of pageClick to jump to parent topicPage Used to Upload ChartField Combinations

Page Name

Definition Name

Navigation

Usage

Upload ChartField Combinations

TL_CF_RUNCTL

Set Up HRMS, Product Related, Time and Labor, Task Elements, Upload ChartField Combinations

Upload chartfield date into Combo Code task elements.

Click to jump to top of pageClick to jump to parent topicUploading ChartField Combinations

Access the Upload ChartField Combinations page (Set Up HRMS, Product Related, Time and Labor, Task Elements, Upload ChartField Combinations).

Select File

Click to select a file that contains chartfield information that you want to insert into Combo Code task elements. The data file must be a CSV file with the chartfield information for each combination code listed in a specific order. After you select a file, a link appears next to the Select File button indicating the name of the file you want to upload. Click on the link to manually verify the data you are about to upload to the system.

File Requirements

Click this link to open the ChartField File Requirements page. This page displays the required order of combo code information in a CSV file that you want to upload to the system.

Upload File Content

Click to load the contents of the select CSV-formatted file into the ACCT_CD_TBL_TMP temporary table.

File Content Uploaded

Indicates whether or not a file with combo code information has been uploaded to the system.

Run

Click to start the TL_ACCT_CD Application Engine program. This process validates the data and writes the information for each valid row into the ACCT_CD_TBL.

Transaction Table Updated

Indicates that the process has completed and that the data from the file has been uploaded to the ACCT_CD_TBL. It does not reflect whether all entries from the file were valid or if any were discarded by the process. Review the process logs for full details.

Use the links in the Review group box to view the status of the TL_ACCT_CD process and to locate the Summary Report.csv and the Transaction Detail.csv report files. The system creates these reports as the process completes. The Summary Report.csv file indicates the status of each row of data from the uploaded file. The Transaction Detail.csv report file shows the status of each row of data, including the reason for failure for any row.

Click to jump to parent topicDefining and Viewing Task Values in Time and Labor

To define or view task values, use the Customer (CUSTOMER), Task (TASK), Product (PRODUCT1), Project (PROJECT1), Activity ID (ACTIVITY_ID), and User Field 1 (TL_USER_FLD1_PNLG) components. Use the CUSTOMER, TASK, PRODUCT1, PROJECT1, ACTIVITY_ID, and TL_USER_FLD1_PNLG component interfaces to load data into the respective tables for these components.

As noted earlier, task values for Time and Labor prompt tables can be defined in Time and Labor as well as in Human Resources, Project Costing, and Performance Management. In the following sections we discuss:

Click to jump to top of pageClick to jump to parent topicPages Used to Define and View TL Entities

Page Name

Definition Name

Navigation

Usage

Customer

TL_CUSTOMER

Set Up HRMS, Product Related, Time and Labor, Task Elements, Customer, Customer

Use the Customer page to create and view codes for customers. For example, employees such as account managers may need to account for their time based on the customers with whom they spend it.

Task

TL_TASK

Set Up HRMS, Product Related, Time and Labor, Task Elements, Task, Task

Use the Task page to create and view codes for specific tasks. For example, employees such as software developers may need to account for their time based on the tasks (coding, meetings and so on) they perform.

Product

TL_PRODUCT_TBL

Set Up HRMS, Product Related, Time and Labor, Task Elements, Product, Product

Use the Product page to create and view codes for products. For example, employees such as software developers may need to account for their time based on the products they spend time developing.

Project

TL_PROJECT

Set Up HRMS, Product Related, Time and Labor, Task Elements, Project, Project

If you’re using Time and Labor without Project Costing, use the Project page to create and view codes for projects.

Activity

TL_ACTIVITY

Set Up HRMS, Product Related, Time and Labor, Task Elements, Activity, Activity

If you are using Time and Labor without Project Costing or Performance Management, use the Activity page to establish codes for activity IDs.

User Field 1

TL_USER_FIELD#_PNL, where # equals 1, 2, 3, 4, or 5

Set Up HRMS, Product Related, Time and Labor, Task Elements, User Field 1, User Field 1

Use the User Fields page to create your custom task-reporting elements.

Click to jump to top of pageClick to jump to parent topicCreating and Viewing Codes for Project Costing

Access the Project page (Set Up HRMS, Product Related, Time and Labor, Task Elements, Project, Project).

The page you use to create project codes depends on whether Project Costing is integrated with Time and Labor:

Click to jump to top of pageClick to jump to parent topicCreating and Viewing Activity ID Codes

Access the Activity page (Set Up HRMS, Product Related, Time and Labor, Task Elements, Activity, Activity).

The page you use to create activity codes depends on whether Project Costing and/or Performance Management are integrated with Time and Labor.

Click to jump to top of pageClick to jump to parent topicCreating and Viewing User Fields

Access the User Field 1-5 page (Set Up HRMS, Product Related, Time and Labor, Task Elements, User Field 1, User Field 1).

If you'd like to report time against task elements that are not delivered with Time and Labor, you can define values for up to five user fields. The maximum length varies by user field:

Note. If you want to re-label the user fields, see the instruction in your PeopleTools PeopleBook.

Note. When values are entered in user fields, the Time Administration process attempts to process the entries in the user-definable elements.

Click to jump to parent topicDisplaying Task Codes Defined in Project Costing and Performance Management

To display task codes for Project Costing and Performance Management, use the PC Business Unit (TL_BUS_UNIT_TBL_PC), PC Project (PROJECT1_PC), PC Activity ID (PC_PROJ_ACTIVITY), Resource Type (PROJ_RES_TYPE), Resource Category (PROJ_CATG_DEFN), Resource Sub-Category (PROJ_SUBCAT_DEFN), Business Unit PF (TL_BUS_UNIT_TBL_PF), and FS Activity (FS_ACTIVITY_TBL) components.

Prompt tables defined in Project Costing and/or Performance Management are available to Time and Labor through our Publish and Subscribe technology. If you’re using Project Costing or Performance Management, you can view the prompt values in Time and Labor but not change them. To add or delete values, you must update the appropriate Project Costing or Performance Management page.

See Also

Integrating with PeopleSoft Financials and Enterprise Performance Management

Click to jump to top of pageClick to jump to parent topicPages Used to Display Task Codes in Project Costing and Enterprise Performance Management

Page Name

Definition Name

Navigation

Usage

View Business Unit PC

HMCF_PROJ_BUS_UNIT

Set Up HRMS, Common Definitions, ChartField Configuration, ChartField Values, PC Business Unit

Display business unit criteria defined through Project Costing.

PC Project Descr (PC Project Description)

HMCF_PROJECT_PC

Set Up HRMS, Common Definitions, ChartField Configuration, ChartField Values, Project, PC Projet Descr

Display project codes defined through Project Costing.

PC Project Team

HMCF_PROJECT_TEAM

Set Up HRMS, Common Definitions, ChartField Configuration, ChartField Values, Project, PC Project Team

Display project information created through Project Costing.

PC Activity ID

HMCF_PROJ_ACT

Set Up HRMS, Common Definitions, ChartField Configuration, ChartField Values, Activity

View the activity codes defined in Project Costing.

Resource Type

HMCF_PROJ_RSRCE

Set Up HRMS, Common Definitions, ChartField Configuration, ChartField Values, Source Type

View resource type codes defined in Project Costing,

Resource Category

HMCF_PROJ_CATG

Set Up HRMS, Common Definitions, ChartField Configuration, ChartField Values, Category

View resource category codes defined in Project Costing,

Resource Sub-Category

HMCF_PROJ_SUBCAT

Set Up HRMS, Common Definitions, ChartField Configuration, ChartField Values, Subcategory

View resource subcategory codes defined in Project Costing,

View Business Unit PF

TL_BUS_UNIT_TBL_PF

Set Up HRMS, Product Related, Time and Labor, Task Elements, Business Unit PF, View Business Unit PF

View business unit codes defined in Performance Management.

View FS Activity

FS_ACTVITY_TBL1

Set Up HRMS, Product Related, Time and Labor, Task Elements, FS Activity, View FS Activity

View activity codes defined in Performance Management.

Click to jump to top of pageClick to jump to parent topicDisplaying Business Unit Information

Access the PC Business Unit page (Set Up HRMS, Common Definitions, ChartField Configuration, ChartField Values, PC Business Unit).

The PC Business Unit pages display business unit information defined in Project Costing, if this application is installed.

See Also

PeopleSoft Enterprise Project Costing PeopleBook

Click to jump to top of pageClick to jump to parent topicDisplaying Project Codes

Access the PC Project Descr page (Set Up HRMS, Common Definitions, ChartField Configuration, ChartField Values, Project, PC Projet Descr).

See Also

PeopleSoft Enterprise Project Costing PeopleBook

Click to jump to top of pageClick to jump to parent topicDisplaying Project Information on the Team Members Page

Access the PC Project Team page (Set Up HRMS, Common Definitions, ChartField Configuration, ChartField Values, Project, PC Project Team).

See Also

PeopleSoft Enterprise Project Costing PeopleBook

Click to jump to top of pageClick to jump to parent topicDisplaying Resource Type Codes

Access the Resource Type page (Set Up HRMS, Common Definitions, ChartField Configuration, ChartField Values, Source Type).

Resource type codes are applicable only if you are using Project Costing. You can use the Resource Type page to view any resource codes defined in Project Costing but not to update them.

See Also

PeopleSoft Enterprise Project Costing PeopleBook

Click to jump to top of pageClick to jump to parent topicDisplaying Resource Category Codes

Access the View Project Resource Category page (Set Up HRMS, Product Related, Time and Labor, Task Elements, Resource Category, View Project Resource Category).

Resource category codes are applicable only if you’re using Project Costing. You can use the Resource Category page to view any resource category codes defined in Project Costing.

See Also

PeopleSoft Project Costing PeopleBook

Click to jump to top of pageClick to jump to parent topicDisplaying Business Unit Codes

Access the Business Unit PF page (Set Up HRMS, Product Related, Time and Labor, Task Elements, Business Unit PF, View Business Unit PF).

Business Unit PF codes are applicable only if you are using Performance Management and you are not using People Soft Project Costing. You can use the Business Unit PF page to view any business units defined in Enterprise Performance Management but not to update them.

See Also

PeopleSoft Enterprise ePerformance PeopleBook

Click to jump to parent topicCreating Task Profiles

To create task profiles, use the Task Profile (TL_TASK_PROFILE) component. Use the TL_TASK_PROFILE component interface to load data into the tables for this component.

Task profiles enable you to specify default values for the task elements on the task template. You select the specific companies, departments, projects, and other tasks to which you want to allocate a person’s reported time. You also specify how to distribute reported time across tasks: by quantity, by percentage, or by distributing time equally across all tasks.

General rules for task profiles are as follows:

Click to jump to top of pageClick to jump to parent topicPage Used to Create Task Profiles

Page Name

Definition Name

Navigation

Usage

Task Profile

TL_TASK_PROFILE

Set Up HRMS, Product Related, Time and Labor, Task Configurations, Task Profile, Task Profile

Define task profiles.

Use this page to select values for the task entities you selected on the task template. Also indicate whether time is to be allocated across tasks equally, allocated by percentage, or allocated by quantity.

Click to jump to top of pageClick to jump to parent topicCreating Task Profiles

Access the Task Profile page (Set Up HRMS, Product Related, Time and Labor, Task Configurations, Task Profile, Task Profile).

Task Template ID

Select the task template associated with this task profile. If you are not interested in task-level reporting, you can select the value PS Non Task in this field.

Send to TCD

Select this check box if you want to make the profile available to one or more time collection device (TCD). (You must also select the Send Task Profiles option on the TCD Type Definition page. The Taskgroup field on the TCD Setup page determines which profiles are sent to the TCD.)

Warning! If you clear the task profile detail, you may invalidate any validated and paid time that has been reported using this task profile.

Allocation Type

Time and labor can be reported in quantities of hours, units, or amounts. Define how you want the reported quantity to be allocated to tasks. (Each task is represented by a row of task entities on the Allocation Detail tabs.)

Allocation by Quantity

Select to enter a quantity (hours, units, or amount) for each task. The system will convert the number you enter into a percentage, based on the total quantity you enter for all tasks. This option is similar to the Allocation by Percentage option, but rather than entering a percentage you enter a number that the system converts to a percentage.

Allocation by Percentage

Select this option to specify the percentage of hours, units or amounts the system should allocate to each reported task.

Allocation Equally All Tasks

Select this option to automatically allocate hours, units, or amounts equally among all the tasks you report. The system determines the allocation when time is reported or created.

Allocation Detail

Insert a row for each task (that is, the combination of task-related entities) to which you want to allocate time. For example, specify that 50 percent of a time reporter’s time will be allocated to the product, customer, and task identified on the first row, and 50 percent of the time will be reported to the combination of tasks reported on the second row.

Note. The template you select in the Task Template ID field determines the tabs and fields that appear in the Allocation Detail section of this page.

Allocation Amount (allocation amount)

The number you enter in this field depends on the option you selected in the Allocation Type field.

If you selected the Allocation by Quantity option, enter the number the system should use to determine how to allocate the reported quantity (hours, units, or amount) to the task row you’re about to define. The system will convert the number into an allocation percentage.

For example, say you enter 2 on the first task row and 6 on the second task row. When time reporters enter their time, the system will automatically assign 2/8 (or 25%) of the reported time to the first set of tasks and 6/8 (or 75%) of the reported time to the second set of tasks.

If you selected the Allocation by Percentage option, enter the percentage of hours, units, or amounts that should be allocated to the task row you’re about to define.

If you selected the Allocation Equally All Tasks option, the Allocation Amt field doesn’t appear. The system will automatically distribute the reported quantity equally across all task rows.

Select the appropriate value for each of the task-related fields in the row. The system will dynamically adjust the prompt tables for some fields based on commitment accounting and the presence of other PeopleSoft applications.

The following table lists all tabs that can appear on the Task Profile page, along with all fields that can appear on each tab.

Tab Name

Fields

HR / TL Fields

Company, Business Unit, Location, HR Department, Jobcode, and Position Number, Customer, Task, TL Activity.

ChartFields

Combo code, and related ChartFields.

PC / EPM Fields

PC Business Unit, Project/Grant, Activity ID, Resource Type, Resource Category, Resource Subcategory, Business Unit PF, Activity FS depending on which Financials and Performance Management products are integrated with Time and Labor.

User Fields

User Field 1, User Field 2, User Field 3, User Field 4, User Field 5.

See Also

Using Time Collection Devices

Defining and Viewing Task Values in Time and Labor

Understanding Integration

Click to jump to parent topicDefining Taskgroups

To define taskgroups, use the Taskgroup (TASKGROUP) component. Use the TASKGROUP component interface to load data into the tables for this component.

A taskgroup represents a group of time reporters with similar time and task reporting requirements. Taskgroups identify the default time reporting template, task template, and task profiles that are valid for members of the taskgroup. The task template you link to the taskgroup determines which task profiles you can attach.

Every time reporter must be associated with a valid taskgroup. You assign an individual to a Taskgroup using the Create Time Reporter Data page or Maintain Time Reporter Data page.

Creating a Taskgroup for Non-task Reporting

To simplify the set up required for non-task reporting, Time and Labor is delivered with a taskgroup, task template, and task profile, each named PSNONTASK.

If you’re not interested in collecting task data, you can create a taskgroup and select PSNONTASK for both the task template and the default task profile. Then select the time reporting templates that identify the additional time elements you’re interested in.

Modifying a Taskgroup

Once you save a taskgroup, you cannot change the commitment accounting option. You can change the time reporting templates, the task template ID, and inactivate task profiles associated with the taskgroup; however, these changes will trigger the Referential Integrity process when you run Time Administration.

See Also

Defining and Viewing Task Values in Time and Labor

Referential Integrity

Click to jump to top of pageClick to jump to parent topicPage Used to Define Taskgroups

Page Name

Definition Name

Navigation

Usage

Taskgroup

TL_TASKGROUP_TBL

Set Up HRMS, Product Related, Time and Labor, Task Configuration, Taskgroup, Taskgroup

Define taskgroups.

Click to jump to top of pageClick to jump to parent topicDefining a Taskgroup

Access the Taskgroup page (Set Up HRMS, Product Related, Time and Labor, Task Configuration, Taskgroup, Taskgroup).

Status

The status of the taskgroup appears in this field. If you change the status to Inactive, and the taskgroup is already assigned to time reporters, you will not be able to inactivate the effective-dated row.

Commitment Accounting

Select this check box if your organization uses commitment accounting for this taskgroup. Selecting this option restricts the task templates you can select from in the Task Template ID field.

Note. Once you save the taskgroup, you cannot change the commitment accounting option.

Clear Task Profile Detail

Click this button if you’ve already attached task profiles to this taskgroup (in the Valid Task Profiles group box) and now want to change the task template ID.

If you’re in update or correction mode, the system will change the status of all task profiles listed in the Task Profile ID grid to Inactive. When you add new task profiles, the inactive profiles will be displayed after the active profiles when you access the page after saving the data.

The Referential Integrity process will be triggered, if the system has the Referential Integrity option on the Time and Labor Installation page selected, when you click the Clear Task Profile Detail button.

Task Template ID

Specify the task template you want to associate with this taskgroup. This is a required field. If you selected the Commitment Accounting check box on this page, the prompt table will list only those task templates defined for commitment accounting. The template you select will determine which task profiles you can attach to this taskgroup.

If you’re not using task reporting, select PSNONTASK.

Default Task Profile

This field displays the name of the task profile that has been selected as the default for this taskgroup. (You select the default using the Task Profile ID grid.)

During the Time Administration process, the system will use this task profile if you have not selected a task profile ID on the time reporter’s Create Time Reporter Data page or Maintain Time Reporter Data page.

Time Reporting Template ID

Both Elapsed and Punch are required fields. Use these fields to specify which time reporting templates apply to members of this taskgroup.

Elapsed Reporting Template

Select the time reporting template for reporting elapsed time. This is a required field.

If a time reporting template for elapsed time doesn’t apply to the time reporters who will be assigned to this taskgroup, select PSELP_NONE from the prompt table.

Punch Reporting Template

Select the time reporting template employees in this taskgroup are to use when reporting punch time. This is a required field.

Select PSPCH_NONE from the prompt table if a time reporting template for punched time doesn’t apply to the time reporters who will be assigned to this taskgroup, for example, elapsed time reporters who will never need to enter punch time.

Valid Task Profiles

Use the grid to attach one or more task profiles to the taskgroup. You will also select the default task profile for members of the taskgroup.

Task Profile ID

Select the default task profile(s) you want to associate with this taskgroup. The prompt table lists only those task profiles created with the template you selected in the Task Template ID field.

During the Time Administration process, the system will use the default task profile if you have not selected a task profile ID on the time reporter’s Create Time Reporter Data page or Maintain Time Reporter Data page.

Description

The description of the taskgroup you selected in the Task Profile ID field automatically displays here.

Status

When you add a task profile ID to the grid, the status automatically defaults to Active. The status changes to Inactive if you change the task template. You cannot delete a task profile ID from the grid; however, you can change the status to Inactive.

Set As Default

You must select one task profile as the default for the taskgroup. This is the profile the system will use for any taskgroup members who don’t have their own individual task profile defined on the Create Time Reporter Data page. Select this check box if you want this task profile to be the default profile.