This chapter provides an overview of the integration process with PeopleSoft Time and Labor and discusses how to:
Set up integration with PeopleSoft Time and Labor.
Populate PeopleSoft Time and Labor tables with PeopleSoft Project Costing data.
Review and load data to PeopleSoft Project Costing tables.
See Also
PeopleSoft Enterprise Time and Labor PeopleBook
PeopleSoft Project Costing, which is in the Financials database, integrates with PeopleSoft Time and Labor, which is in the Human Resources Management System (HRMS) database, to bring estimated gross labor costs and distributed, actual labor costs into PeopleSoft Project Costing.
To enable data transfer during a payroll period, PeopleSoft Time and Labor uses an estimation process that links to PeopleSoft Enterprise Payroll to summarize hours and labor expenses. After the close of a payroll period, PeopleSoft Time and Labor distributes payroll expenses to the Payable Time table (TL_PAYABLE_TIME). The transaction rows that have a value for project business unit, project ID, and activity ID are brought into PeopleSoft Project Costing using enterprise integration points (EIPs).
To maintain integrity between the Financials and HRMS databases, necessary data from each database is extracted to staging tables that are set up identically in each database. The staging tables are available to the integrating application.
This section discusses:
Events that trigger PeopleSoft Time and Labor to send time to PeopleSoft Project Costing.
Types of labor costs that PeopleSoft Time and Labor calculates.
Controlling transactions sent to PeopleSoft Project Costing.
PeopleSoft Time and Labor for Billing.
Enterprise Integration Points used in PeopleSoft Time and Labor integration.
Integration setup steps.
You can send both estimated and actual time and cost data to PeopleSoft Project Costing from PeopleSoft Time and Labor.
Estimated payable time is published to PeopleSoft Project Costing when:
PeopleSoft Time and Labor receives a request from PeopleSoft Project Costing in the form of an application message from the Financials database.
In response, PeopleSoft Time and Labor automatically publishes estimated time for payable time records that have a payable status of Estimate, Needs Approval, Approved, Sent, Rejected, and Taken.
You run the Publish Estimated Payable Time Application Engine process (TL_PUB_TM_AE) in PeopleSoft Time and Labor to publish estimated time for payable time records.
The system uses the ESTIMATED_TIME_BATCH_ADD application message to send estimated payable time to PeopleSoft Project Costing.
Actual payable time is published to PeopleSoft Project Costing when:
You run the Publish Actual Payable Time Application Engine process (TL_PY_PUB_TM) in PeopleSoft Time and Labor to publish closed payable time records that will not be run through the Labor Distribution process.
The system uses the ACTUAL_TIME_ADD application message.
You use one of the payable time approval pages in PeopleSoft Time and Labor to close payable time for time reporters whose time is not sent to payroll, or to close payable time for a time reporting code that is not sent to payroll.
The payable time record statuses are Closed and No Pay. The system uses the ACTUAL_TIME_ADD application message.
You make adjustments to time entries using the Adjust Paid Time page.
The payable time record status is Closed. The system uses the ACTUAL_TIME_ADD application message.
Payroll processes are completed for payable time record statuses of Closed, Paid - Labor Distributed, or Paid - Labor Diluted.
The system uses the ACTUAL_TIME_BATCH_ADD application message.
Important! If you activate the Don't Publish
to Project Costing option for certain time reporting codes
(TRCs), and the transactions that are associated with those TRCs are used
for costing, a discrepancy may occur between the costs that you track in PeopleSoft
Project Costing and the costs that you bill to customers.
Total costs in the general ledger system do not equal the total costs
in PeopleSoft Project Costing. The reason is because PeopleSoft Enterprise
Payroll sends PeopleSoft General Ledger all direct labor and employer-paid
burden (indirect costs), such as taxes, deductions, benefits, and so on. PeopleSoft
Time and Labor sends Project Costing only direct labor costs.
These two types of labor costs—gross estimated amounts and labor distribution amounts—are calculated in PeopleSoft Time and Labor:
Gross Estimated Amounts: These are estimated labor costs.
Estimated gross amounts are automatically calculated for every instance of payable time. These amounts can be picked up anytime during a payroll period and passed to PeopleSoft Project Costing as time and labor accrual costs.
This option is automatically selected when you select the Interface with PS/Projects option on the PeopleSoft Time and Labor TL Installation page.
Labor Distribution Amounts: Actual costs are calculated by your payroll system and returned to PeopleSoft Time and Labor after the completion of a pay run.
PeopleSoft Project Costing considers all payable time that it receives to be additions to previously received time. PeopleSoft Time and Labor sends offsets in rare cases when there is updated actual time.
Note. Contractors are usually not paid through the payroll system. If the Send to Payroll option is not selected in PeopleSoft Time and Labor, estimated gross amounts are not brought into PeopleSoft Project Costing for contractors. Depending on how your system is set up, labor-distributed costs could come into PeopleSoft Project Costing as vouchers from PeopleSoft Payables.
You can prevent PeopleSoft Time and Labor from sending transactions associated with specific TRCs to PeopleSoft Project Costing.
Important! If you deselect the Publish to Projects option for certain TRCs and the transactions that are associated with those TRCs contain project information, a discrepancy occurs in the project information between PeopleSoft Time and Labor and PeopleSoft Project Costing.
This section discusses using billing estimates with out and with time and labor summarization.
Using Billing Estimates without Time and Labor Summarization
PeopleSoft Project Costing can use either actual amounts or estimates for billing purposes.
Using estimates for Billing is indicated by selecting the Time and Labor for Billing check box on the Project Costing Options page. Estimates are subject to change in PeopleSoft Time and Labor until payroll costs are distributed. If rate adjustments or additional payments occur that were not originally recorded in the PeopleSoft Time and Labor system, they can be adjusted and published to PeopleSoft Project Costing as actual amounts.
When the actual paid amount is processed, the system replaces PeopleSoft Time and Labor billing rows from estimate processing that have not been billed. Changes to labor rows between actual processing and estimate processing can be any combination of the following:
Time can be charged to a different project or activity key ChartField.
For changes to a different project or activity key field, the original row from estimate processing is reversed.
Time can be charged to a different source type, category, or subcategory non-key ChartField.
For changes to source type, category, or subcategory non-key fields, original rows from estimate processing are reversed and an adjustment is created.
Quantity or amount charged to a project can be different.
For changes to quantity or amount, including fractional changes, delta rows are created. At the business unit level, you can have different criteria for creating delta rows that are based on changes to quantity only, amount only, or changes to both quantity and amount.
In some cases a large number of delta rows may be created. For example, if a business unit is set up for delta to amount, fractional changes may create many delta rows. In such cases, you may summarize delta rows at the business unit level.
Using Billing Estimates with Time and Labor Summarization
When using billing estimates with Time and Labor summarization all estimates, regardless of being billed or not billed, are reversed when Project Costing receives actual payroll expenses. When the Time and Labor Integration process (PC_TL_TO_PC) processes actual payroll expenses the system creates:
New estimated rows (TLB) that are used in Billing.
New actual rows (PAY).
PeopleSoft Project Costing uses these application messages to integrate Financials application tables with HRMS application tables:
Messages |
Integration Point Name |
Publisher |
BUS_UNIT_PC_SYNC BUS_UNIT_PC_FULLSYNC |
BUSINESS UNIT TABLE PC |
Project Costing |
PROJECT_SYNC PROJECT_FULLSYNC |
PROJECT TABLE |
Project Costing |
PROJECT_ACTIVITY_SYNC PROJECT_ACTIVITY_FULLSYNC |
PROJECT ACTIVITIES |
Project Costing |
PROJ_ACTIVITY_STATUS_SYNC PROJ_ACTIVITY_STATUS_FULLSYNC |
PROJECT ACTIVITY STATUS |
Project Costing |
RESOURCE_TYPE_SYNC RESOURCE_TYPE_FULLSYNC |
PROJECT RESOURCE TYPE |
Project Costing |
RES_TYPE_CAT_LINK_SYNC RES_TYPE_CAT_LINK_FULLSYNC |
PROJECT TYPE-TO-CATEGORY LINK |
Project Costing |
RES_CAT_SUB_CAT_LINK_SYNC RES_CAT_SUB_CAT_LINK_FULLSYNC |
PROJECT CATEGORY-TO-SUBCATEGORY LINK |
Project Costing |
RESOURCE_CAT_SYNC RESOURCE_CAT_FULLSYNC |
PROJECT RESOURCE CATEGORY |
Project Costing |
RESOURCE_SUB_CAT_SYNC RESOURCE_SUB_CAT_FULLSYNC |
PROJECT RESOURCE SUBCATEGORY |
Project Costing |
PROJECT_TEAM_SYNC PROJECT_TEAM_FULLSYNC |
PROJECT TEAM |
Project Costing |
PROJECT_STATUS_DEFN_SYNC PROJECT_STATUS_DEFN_FULLSYNC |
PROJECT STATUS DEFINITION |
Project Costing |
PROJECT_STATUS_SYNC PROJECT_STATUS_FULLSYNC |
PROJECT STATUS |
Project Costing |
UOM_SYNC UOM_FULLSYNC |
UNIT OF MEASURE |
Financials to HCM |
BUS_UNIT_FS_SYNC BUS_UNIT_FS_FULLSYNC |
BUSINESS UNIT TABLE FS |
Financials to HCM |
TIME_REPORTING_CODE_SYNC TIME_REPORTING_CODE_FULLSYNC |
TIME REPORTING CODES |
Time and Labor |
ACTUAL_TIME_ADD ACTUAL_TIME_BATCH_ADD |
T&L ACTUAL TIME |
Time and Labor |
ESTIMATED_TIME_BATCH_ADD |
T&L ESTIMATED TIME |
Time and Labor |
TBLSET_CONTROL_INITIALIZE SETID_INITIALIZE |
TABLE SET CONTROL |
Financials to HCM |
ESTIMATE_FORECAST_TIME_REQUEST Publish Batch Program: PC_TL_TO_PC Subscribe Batch Program: TL_PUB_TM_AE |
ESTIMATE & FORECAST TIME REQUEST |
Project Costing |
Note. To research the technical details of any integration point used by PeopleSoft applications, refer to the online Interactive Services Repository found on Oracle's My Oracle Support website.
To enable the TBLSET_CONTROL_INITIALIZE service operation to publish between two databases, you must set up message chunking for the operation by record group. This process is described in these set of steps:
Identify the record groups that exist in both databases
Create a chunking rule for each record group and then add the chunking definition to the subscribing nodes of the group.
Enter the chunking rule you created to the full table publish rules definition for the TBLSET_CONTROL_INITIALIZE service operation.
If you are publishing to one node, this setup is sufficient; however, if you are publishing to multiple nodes, you need to add routing PeopleCode to the channel.
See See "Using the Publish Utility", Message Chunking, PeopleSoft Enterprise FSCM 9.1 PeopleBook: Integration Interfaces
To integrate PeopleSoft Time and Labor with PeopleSoft Project Costing:
Activate EIPs used in PeopleSoft Time and Labor integration.
Select analysis types for PeopleSoft Time and Labor integration.
Select PeopleSoft Time and Labor options for PeopleSoft Project Costing integration.
Select PeopleSoft Project Costing options for PeopleSoft Time and Labor integration.
Retrieve units of measure in PeopleSoft Time and Labor from PeopleSoft Project Costing.
Ensure that you have set up as a time reporter in PeopleSoft Time and Labor each person who reports time to projects.
Populate the task entity prompt tables with values defined in PeopleSoft Project Costing.
Set up task templates and task profiles that include project-related task entities.
You will complete some of these steps in PeopleSoft Time and Labor.
See Also
PeopleSoft Enterprise Time and Labor PeopleBook, "Integrating with PeopleSoft Financials and Enterprise Performance Management"
This section discusses how to:
Activate the EIPs used in PeopleSoft Time and Labor integration.
Select analysis types for PeopleSoft Time and Labor integration.
Select PeopleSoft Time and Labor options for PeopleSoft Project Costing integration.
Select PeopleSoft Project Costing options for PeopleSoft Time and Labor integration
Page Name |
Definition Name |
Navigation |
Usage |
INSTALLATION_PCINT |
Set Up Financials/Supply Chain, Install, Installation Options, Project Costing Integration |
Select analysis types for transactions from PeopleSoft Time and Labor. |
|
TL_INSTALLATION |
Set Up HRMS, Install, Product and Country Specific, Time and Labor Installation, TL Installation |
Configure options in PeopleSoft Time and Labor to integrate with PeopleSoft Project Costing. Note. You access this page through the HRMS database. |
|
BUS_UNIT_OPT_PC |
Set Up Financials/Supply Chain, Business Unit Related, Project Costing, Project Costing Options |
Specify options in the Time and Labor Interface group box to integrate with PeopleSoft Time and Labor. |
The necessary application messages that must be activated are listed in the EIPs Used in PeopleSoft Time and Labor Integration section of this chapter. Detailed instructions for activating application messages are found in the PeopleSoft Enterprise Components for FSCM PeopleBook.
Access the Installation Options - Project Costing Integration page (Set Up Financials/Supply Chain, Install, Installation Options, Project Costing Integration).
Default analysis types for each inbound integration point are delivered with the PeopleSoft Project Costing system and specified on this page. You can override the default analysis types.
These are the default analysis types that are delivered for integration with PeopleSoft Time and Labor:
Time/Labor Actuals |
PAY: Indicates Payroll expenses that are brought into PeopleSoft Project Costing after the close of a payroll period. |
Time/Labor No Pay Actual |
NPY: Indicates hours that are entered into PeopleSoft Time and Labor with a time reporting code of BOH (bill but no pay). When brought into PeopleSoft Project Costing, two rows are created:
The system does not pay that person for those hours, and does bill the time for those hours. |
Contractor Time/Labor |
TLC: Indicates separate cost rows that are created after the close of a payroll period. |
Time/Labor Estimates |
TLA: Indicates estimate rows that are brought into PeopleSoft Project Costing for the open pay period. |
Time/Labor Billing Estimate |
TLB: Indicates TLB rows that are created as part of estimate processing to facilitate billing from estimates. Amounts are subject to change. TLB rows are also created after the close of a payroll period. |
Note. If hours or units are reported in the Quantity field, the system uses the following basic formula to estimate gross: (TL_QUANTITY) x (COMPRATE + FACTOR_RATE_ADJ) x (FACTOR_MULT). No formula is used to estimate gross if a dollar amount is reported.
See PeopleSoft Enterprise Time and Labor PeopleBook, "Understanding the Batch Process in Time Administration," Step 12: Performing Rounding, Task Distribution and Estimated Gross.
Time and Labor Integration
Load Time Automatically |
Select for PeopleSoft Time and Labor to publish time and labor actuals PAY rows to the Project Transaction table (PROJ_RESOURCE) as soon as payroll is complete. Transaction rows are sent to PeopleSoft Project Costing if:
If you do not select Load Time Automatically, you must schedule a process to load data into the Project Transaction table from staging tables. |
Note. Actuals are loaded automatically. Estimates are requested.
See Also
Types of Labor Costs that Time and Labor Calculates
Access the TL Installation (Time and Labor Installation) page to set up your HRMS database to integrate with PeopleSoft Project Costing (Set Up HRMS, Install, Product and Country Specific, Time and Labor Installation, TL Installation).
Interface with PS/Projects (Interface with PeopleSoft Enterprise Project Costing) |
Select this option, and the system automatically selects the Calculate Estimated Gross check box that tells the system to calculate the estimated costs associated with payable time when you run the Time Administration process. |
See PeopleSoft Enterprise Time and Labor PeopleBook, "Setting Up Basic Tables," Setting Up System Defaults and Loading Dates.
Access the Project Costing Options page to set up PeopleSoft Project Costing options for PeopleSoft Time and Labor integration (Set Up Financials/Supply Chain, Business Unit Related, Project Costing, Project Costing Options).
See Also
Integration between PeopleSoft Project Costing and PeopleSoft Time and Labor requires that information be present in both the Financials database and the HRMS database for the system to operate properly.
This section discusses how to:
View project prompt tables in PeopleSoft Time and Labor that are populated by PeopleSoft Project Costing.
Set up taskgroups and workgroups.
Populate PeopleSoft Project Costing tables with employee data.
These tables in PeopleSoft Time and Labor are populated by integration with PeopleSoft Project Costing:
PC Business Unit (BUS_UNIT_TBL_PC)
Operational Projects (PROJECT)
Project Activities (PROJ_ACTIVITY)
Project Resource Type (PROJ_RES_TYPE)
Project Resource Category (PROJ_CATG_TBL)
Project Resource SubCategory (PROJ_SUBCAT_TBL)
Project Team Member (PROJECT_TEAM)
You can view, but not modify, these tables in PeopleSoft Time and Labor. The PeopleSoft Time and Labor system receives the units of measure table and tableset control tables that contain setID synchronization from PeopleSoft Project Costing.
The system uses application messaging to synchronize prompt tables between the Financials and HRMS databases.
After you populate project prompt tables, you set up task profile templates, task profiles, taskgroups, and workgroups in PeopleSoft Time and Labor to track time for the projects, activities, business units, resource types, resource categories, and resource subcategories in PeopleSoft Project Costing.
Important! You must set up a task profile template in PeopleSoft Time and Labor that contains valid values for these fields: Project Costing Business Unit (BUSINESS_UNIT_PC), Project ID (PROJECT_ID), Activity ID (ACTIVITY_ID), Source Type (RESOURCE_TYPE), Category (RESOURCE_CATEGORY), and Subcategory (RESOURCE_SUB_CAT).
Regular employees and contractors are hired in HRMS and entered as time and labor employees and contractors. Tables in PeopleSoft Project Costing are populated with employee data from your human resources system using EIPs.
See Also
This section discusses how to:
Review and edit time and labor data.
Load data into PeopleSoft Project Costing tables.
Page Name |
Definition Name |
Navigation |
Usage |
INTFC_PROJ_TL_01 |
Project Costing, Review Costs, Time and Labor Interface, Time and Labor Interface |
Review data that is moved from the HRMS database to the Project Time and Labor Interface staging tables in the Financials database before it is loaded into the Project Transaction table. |
|
PC_TL_TO_PC |
Project Costing, Cost Collection, Time and Labor, Time and Labor |
Run the Time and Labor to Project Costing Application Engine process (PC_TL_TO_PC) that moves time and labor data from the Project Time and Labor Interface staging tables into the Project Transaction table. |
|
PROJECT_EXPRESSG |
Project Costing, Transaction Definitions, Transaction List, Transaction List |
View PeopleSoft Time and Labor data in the Project Transaction table. |
Access the Time and Labor Interface page (Project Costing, Review Costs, Time and Labor Interface, Time and Labor Interface).
Make any necessary adjustments to transactions brought over from PeopleSoft Time and Labor before moving them to the Project Transaction table.
Department |
Department ID from PeopleSoft Time and Labor. |
Transaction Date |
Date for which work was reported in PeopleSoft Time and Labor. |
Accounting Date |
Pay period ending date. |
Time Reporting Code |
Element of compensation or group of several elements in which the system collects labor data, hours, amounts, or units worked. |
Quantity |
Number of hours worked. This field is blank if it is not applicable based on your PeopleSoft Time and Labor setup. |
Transaction Currency |
Currency in which the labor transaction is reported. This value is maintained in the Foreign Currency field. |
Transaction Amount |
Transaction amount that reflects estimated or actual labor cost. When actual cost processing occurs, the multicurrency engine converts this amount to the project business unit amount based on the project business unit's base currency. |
Access the Time and Labor page (Project Costing, Cost Collection, Time and Labor, Time and Labor).
Use this page to select the processing option, and click Run to initiate the Time and Labor to Project Costing process.
Load time from flat file |
Select to import time data from a flat file. If selected, the Flat File group box appears. Select Estimates to load data from the flat file into the Project Time and Labor Interface estimates staging table (INTFC_PROJ_EST). Select Actuals to load data from the flat file into the Project Time and Labor Interface actuals staging table (INTFC_PROJ_ACT). Enter the flat file name and its directory path in the File Name field. |
Process Actuals |
Select to process all actuals. This option moves PeopleSoft Time and Labor data from the Project Time and Labor Interface actuals staging table into the Project Transaction table. |
Request Estimates |
Select to request all estimates data to be sent from the Project Time and Labor Interface estimates staging table into the Project Transaction table. |
Note. Labor amounts that differ from the business unit currency are converted during the integration process if the appropriate exchange rates are set up.
This process reads from the flat file and loads time to the same interface tables that are used to integrate with the PeopleSoft Time and Labor system. Two file layout objects are provided for this feature:
PROJ_ACTUAL_TIME
PROJ_ESTIMATED_TIME
Before running the process from the run control page, be sure that the order of time data fields in the flat file matches the order of fields in the delivered file layout definitions on a one-to-one basis. If it does not, change the order of the data fields in either the flat file or the file layout definition.
The process supports comma-separated, value files (*.csv).
Billing for Labor Transactions
When the Project Transaction table is populated with labor data, the estimated gross rows are identified with an analysis type of TLA. Each transaction ID on these rows has an A suffix. Identical rows are also created with an analysis type of TLB and a transaction ID suffix of B for billing purposes.
A subsequent run of the process, to extract estimated gross rows from PeopleSoft Time and Labor, deletes all TLA rows. In addition, it replaces TLB rows that have not created unbilled billing rows that have been billed, which is indicated by a billing distribution status of W (worksheet) or D (done), with the updated estimated gross amounts.
See Also
Integrating with PeopleSoft Contracts and PeopleSoft Billing
Processing Multiple Currencies
Enterprise PeopleTools PeopleBook: PeopleSoft Process Scheduler