This chapter gives an overview of task reporting functionality and discusses how to:
Create task templates.
Upload ChartField Combinations.
Define and view task values in Time and Labor.
Display task codes defined in PeopleSoft Project Costing and PeopleSoft Performance Management.
Create task profiles.
Define taskgroups.
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
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.
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:
Each time reporter is assigned to a taskgroup.
Each taskgroup is linked to a task template that identifies the types of task information the taskgroup members can report.
Each taskgroup also specifies one or more task profiles that taskgroup members can use.
Taskgroup members can report time through the use of task profiles or can report time to the individual task entities that are defined on a task template.
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
Time and Labor supports two types of task reporting:
Task profile reporting.
When a time reporter uses task profile reporting (in essence an automatic allocation), he simply reports the quantity of time worked—the system automatically determines the task entities to which time is reported and how much time is allocated to each task, based on the person's task profile. Task profile reporting is appropriate for time reporters who perform the same sets of tasks, where cost allocation is static. For example, assume a time reporter is assigned to a taskgroup that is associated with the following task profiles: Filing, Drafting, Sorting, and Etching. Each task profile represents a different set of task entities and allocations. The time reporter can use any of these task profiles to enter time, or can "borrow" a taskgroup to which he is not assigned and use the task profiles associated with that taskgroup as well. So, if our time reporter uses the Etching profile to enter 8 hours, and the profile specifies that 25% of the reported time goes to polishing and 75% of the reported time goes to buffing, the system will automatically allocate 2 hours to polishing and 6 hours to buffing.
Task template reporting.
Use task template reporting to report time to the task entities you selected when defining the task template. Task template reporting is appropriate for time reporters who spend varied amounts of time on functions that require different cost allocations. For example, create a template called Sales, and select Customer, Product, and Task as the task entities, then use the Sales template to report the following information: 8 hours for Customer A, Product B, and Task C.
If you do not capture task data for some or all time reporters, you can use the nontask templates delivered with Time and Labor.
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.
The task profile entered on a time reporting page, if any, always take precedence.
The task profile directly assigned to the time reporter on the Create Time Reporter Data page or Maintain Time Reporter Data page has second priority.
The default task profile assigned to the time reporter's taskgroup on the Taskgroup page is used only when the system finds no other.
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
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 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 PeopleTools 8.52: Security Administration PeopleBook for more information.
This section provides a brief overview of ChartFields and discusses the:
Configuration and integration.
Impact on task templates.
Impact on time reporting pages.
ChartField storage in reported time and task profile.
ChartField storage in payable time.
Time and Labor validation options.
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).
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
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:
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.
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.
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.
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.
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.
Assign taskgroup and task profiles.
Assign a taskgroup to each time reporter via the Create Time Reporter Data page or Maintain Time Reporter Data page. You can also assign a task profile to each time reporter. The task profile you select will take precedence over the default task profile assigned to the time reporter's taskgroup.
If you're using time collection devices, assign the appropriate taskgroups to each TCD via the TCD Setup page. The taskgroup determines what profiles and templates will be available to send to the TCD. You can also specify whether to send task profiles, task templates, and/or task values to the TCD.
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
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
Page Name |
Definition Name |
Navigation |
Usage |
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. |
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
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.
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. |
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.
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:
Time and Labor pages used to define task values.
Time and Labor is delivered with empty prompt tables for the following task values: Customer, Task, Product, Project, Activity, and up to five user-defined fields.
How to create valid values using Time and Labor pages.
How to view the values defined in Project Costing and Performance Management.
Page Name |
Definition Name |
Navigation |
Usage |
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
TL_USER_FIELD1_PNL TL_USER_FIELD2_PNL TL_USER_FIELD3_PNL TL_USER_FIELD4_PNL TL_USER_FIELD5_PNL |
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. |
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:
If you're using Time and Labor without Project Costing, use the Project page to create project codes.
If you're using Project Costing, define project codes in the Project Costing application. You can then use the PC Project Descr page in Time and Labor to view the codes but not to change them.
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.
If you're using Time and Labor without Project Costing or Performance Management, use the Activity page to create activity codes.
If you're using Project Costing, you define activity codes in that application. You can then use the PC Activity pages in Time and Labor to view the codes but not to change them.
If you're using Performance Management (without Project Costing) you define activity codes in the Enterprise Performance Management application. You can then use the View FS Activity page in Time and Labor to view the codes but not to change them.
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:
User Field 1: 10 alphanumeric characters.
User Field 2: 10 alphanumeric characters.
User Field 3: 15 alphanumeric characters.
User Field 4: 20 alphanumeric characters.
User Field 5: 20 alphanumeric characters.
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.
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
Page Name |
Definition Name |
Navigation |
Usage |
HMCF_PROJ_BUS_UNIT |
Set Up HRMS, Common Definitions, ChartField Configuration, ChartField Values, PC Business Unit |
Display business unit criteria defined through Project Costing. |
|
HMCF_PROJECT_PC |
Set Up HRMS, Common Definitions, ChartField Configuration, ChartField Values, Project, PC Projet Descr |
Display project codes defined through Project Costing. |
|
HMCF_PROJECT_TEAM |
Set Up HRMS, Common Definitions, ChartField Configuration, ChartField Values, Project, PC Project Team |
Display project information created through Project Costing. |
|
HMCF_PROJ_ACT |
Set Up HRMS, Common Definitions, ChartField Configuration, ChartField Values, Activity |
View the activity codes defined in Project Costing. |
|
HMCF_PROJ_RSRCE |
Set Up HRMS, Common Definitions, ChartField Configuration, ChartField Values, Source Type |
View resource type codes defined in Project Costing, |
|
HMCF_PROJ_CATG |
Set Up HRMS, Common Definitions, ChartField Configuration, ChartField Values, Category |
View resource category codes defined in Project Costing, |
|
HMCF_PROJ_SUBCAT |
Set Up HRMS, Common Definitions, ChartField Configuration, ChartField Values, Subcategory |
View resource subcategory codes defined in Project Costing, |
|
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. |
|
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. |
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 Project Costing PeopleBook
Access the PC Project Descr page (Set Up HRMS, Common Definitions, ChartField Configuration, ChartField Values, Project, PC Projet Descr).
See Also
PeopleSoft Project Costing PeopleBook
Access the PC Project Team page (Set Up HRMS, Common Definitions, ChartField Configuration, ChartField Values, Project, PC Project Team).
See Also
PeopleSoft Project Costing PeopleBook
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 Project Costing PeopleBook
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
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 ePerformance PeopleBook
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:
You can create multiple task profiles from the same task template.
You can assign multiple task profiles to a taskgroup; however, all of the profiles must be based on the same template that's linked to the taskgroup.
Task profiles are optional. If you do not want to use this functionality, you can attach the predefined Nontask task profile to the taskgroup you will assign to time reporters who are exempt from task profile reporting.
Page Name |
Definition Name |
Navigation |
Usage |
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. |
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. |
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
Defining and Viewing Task Values in Time and Labor
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
Page Name |
Definition Name |
Navigation |
Usage |
TL_TASKGROUP_TBL |
Set Up HRMS, Product Related, Time and Labor, Task Configuration, Taskgroup, Taskgroup |
Define taskgroups. |
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. |