Populating Time and Labor Tables with PeopleSoft Project Costing Data

Integration between PeopleSoft Project Costing and PeopleSoft Time and Labor requires that information be present in both the Financials database and the HCM database for the system to operate properly.

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 HCM 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 HCM 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.