This chapter provides an overview of the Project Costing operational structure and discusses how to:
Create project business units.
Define project options.
Set up other project business unit options.
Note. This chapter contains only part of what you need to know to define the operational structure. Other relevant information is located in the PeopleSoft Enterprise Application Fundamentals 8.9 PeopleBook.
See Also
Defining Financials and Supply Chain Management Common Definitions
A business unit in Project Costing is defined as an operational subset of the organization. Defining business units in this way enables you to plan projects and gather business data around the way that you work, without the constraints of the enterprise's standard accounting procedures for financial posting and reporting. Thus, you can organize information to best facilitate project management, analysis, reporting, and accounting.
To decide how to map the operational business structure in Project Costing, you need to examine how the business functions operationally, or how the work gets done.
After mapping the business structure and determining which tablesets to use, you can create business units. Consider these factors when you determine how many business units to create:
Each project tree is associated with a single project business unit.
If you want to group projects in one tree for summary reporting, all of the projects should be in the same project business unit. You can do consolidated reporting with many business units, but it is easier to use a tree.
Because trees are used for allocations, reporting, analysis, and security, it is important to consider the potential impact of maintaining multiple trees.
A single project business unit can post to as many general ledger business units as necessary, because you specify an integration template for each project.
See Also
Securing Data in Project Costing
To create project business units, use the Project Costing Business Unit Definition component (PC_BU_DEFN).
This section lists a prerequisite and discusses how to define project business units.
You must establish at least one general ledger business unit.
See Also
Understanding General Ledger Business Units and Options
Page Name |
Object Name |
Navigation |
Usage |
BUS_UNIT_TBL_PC |
Set Up Financials/Supply Chain, Business Unit Related, Project Costing, Project Costing Definition, Project Costing Definition |
Create, define, and modify project business units. |
Access the Project Costing Definition page.
Note. Create business unit IDs that are exactly five characters long. Depending on the operating system, performance degradation can occur if business unit IDs have fewer than five characters.
Default SetID |
Enter the default setID from the available values to associate with this business unit. To establish a new setID, enter the same name as the business unit ID that you are creating. The default setID is used to set up tableset sharing by determining the setID that is assigned to each record group for the new business unit. The setID that is assigned to a record group determines which tableset is used to determine valid values for that specific business unit. You can modify the default setID for the record group on the TableSet Control - Record Group page. This field is available in add mode. However, if you create a new project business unit with the same name as an existing business unit in General Ledger or Receivables, the Description field is automatically populated, and the Default SetID field does not appear. Note. Until you create the business unit, you cannot attach the calendar and general ledger business unit to the new business unit. SetIDs are defined on the TableSet Control page in PeopleTools. See Enterprise PeopleTools 8.46 PeopleBook: System and Server Administration. |
Create FS BU (create Financials business unit) |
Click to create the business unit. This button appears only in Add mode. |
Use this group box to define default values that are used for analysis and Program Management scheduling. The system uses these fields to convert all units of measure into hours or days.
Hours Unit of Measure |
Enter the unit of measure that represents hours for the organization. Units of measure are defined on the Units of Measure page. The default value is MHR (Work Hour). |
Days Unit of Measure |
Enter the unit of measure that represents days for the organization. The default value is MDY (Person Day). |
Category Edit Option |
Specify whether category prompt lists display all values that are in the system, or a subset based on dependencies that are established among source types, categories, and subcategories. Available options are: Independnt (independent): All categories that are in the system are available for selection. Project Costing uses the Project Resource Category record (PROJ_CATG_TBL) to populate prompt lists. Override: Categories that are available for selection are restricted by established criteria. Project Costing uses the selected category edit table to populate prompt lists. Related: Categories that are available for selection are restricted by predefined relationships with source types. Project Costing uses the Project Type Category record (PROJ_TYPE_CATVW) to populate prompt lists. You can select the Related option only if the Source Type ChartField is selected on the Standard ChartField Configuration page. If you select Related and Source Type ChartField is inactive, an error message appears when you save the page, indicating that you cannot specify a Category Edit Option of Related because the Source Type ChartField is inactive. Available category edit options are based on the translate values in the Category Edit Options field (CAT_EDIT_OPTION) properties. The default value is Independnt. |
SubCategory Edit Options |
Specify whether subcategory prompt lists display all values that are in the system, or a subset based on dependencies that are established among source types, categories, and subcategories. Values are: Independnt (independent): All subcategories that are in the system are available for selection. Project Costing uses the Project Resource SubCategory record (PROJ_SUBCAT_TBL) to populate prompt lists. Override: Subcategories that are available for selection are restricted by established criteria. Project Costing uses the selected subcategory edit table to populate prompt lists. Related: Subcategories that are available for selection are restricted by predefined relationships with resource category types. Project Costing uses the Project Category SubCategory record (PROJ_CAT_SUB_VW) to populate prompt lists. You can select the Related option only if the Category ChartField is selected on the Standard ChartField Configuration page. If you select Related and the Category ChartField is inactive, an error message appears when you save the page, indicating that you cannot specify a SubCategory Edit Option of Related because the Category ChartField is inactive. Available values are based on the translate values in the SubCategory Edit Options field (SUB_EDIT_OPTION) properties. The default value is Independnt. |
See Also
Processing Multiple Currencies
Understanding General Control Data
Defining and Updating Open Periods and Adjustment Periods
To define project options for business units, use the Project Costing Options component (PC_BUS_UNIT_OPT). Use the Project Costing Business Unit Options component interface (PROJECT_BU_OPTIONS) to load data into the tables for this component.
This section discusses how to:
Define project options for business units.
Define budget plan version analysis types.
Define parameters for copying projects and creating projects from templates.
Define parameters for copying activities, transactions, and analysis groups.
Define parameters for the Delete utility.
Page Name |
Object Name |
Navigation |
Usage |
BUS_UNIT_OPT_PC |
Set Up Financials/Supply Chain, Business Unit Related, Project Costing, Project Costing Options, Project Costing Options |
Establish project-related transaction fields that are required for importing transactions from other PeopleSoft applications. |
|
PC_BUD_VER_HST_CFG |
Set Up Financials/Supply Chain, Business Unit Related, Project Costing, Project Costing Options, Budget Row Versioning |
Enable budget row versioning for the business unit, and define the sequence of analysis types that the system uses to distinguish historical cost and revenue budget plan versions. |
|
PC_CPY_TMPL_PNL1 |
Set Up Financials/Supply Chain, Business Unit Related, Project Costing, Project Costing Options, Copy Template Option 1 |
Specify the project tables that the system copies into a new project from a template. |
|
PC_CPY_TMPL_PNL2 |
Set Up Financials/Supply Chain, Business Unit Related, Project Costing, Project Options, Copy Template Option 2 |
Specify the activity and transaction tables that the system copies into a new project from a template, and define parameters analysis groups. |
|
PC_DEL_PROJ_REC_PG |
Setup Financials/Supply Chain, Business Unit Related, Project Costing, Project Costing Options, Delete Utility Tables tab |
Define the parameters for deleting projects, activities, and transactions for a specified business unit. |
Access the Project Costing Options page.
Use the Project Costing Options page to define required criteria relating to transactions that enter Project Costing from other PeopleSoft applications.
Select the type of data to import from Time and Labor into Project Costing. If you select Time and Labor for Billing, also select a reconciliation method.
You select the analysis types for rows that you import from Time and Labor on the Installation Options - Project Costing Integration page.
Time and Labor Actuals |
Select to import payroll expenses into Project Costing after the close of a payroll period. |
Time and Labor Estimates |
Select to import estimates into Project Costing for the open pay period. |
Time and Labor Contractor |
Select to import contractor time and labor for this business unit after the close of a payroll period. |
Time and Labor for Billing and Reconciliation Method |
Select to create separate time and labor for billing rows after the close of a payroll period as part of estimate processing. Amounts are subject to change. If you select this option, also select from the list of Reconciliation Method options to reconcile the difference between actual time and labor costs with previously entered estimated time and labor costs. Each reconciliation creates a delta row in the Project Transaction table (PROJ_RESOURCE) with the same analysis type as the transaction that you are reconciling. Available options are:
|
Summary Level |
Select the level at which the system summarizes reconciliations. This affects the number of delta rows that are created during the reconciliation process. If the reconciliation method is not Do Not Reconcile, the selection of a summary level is defaulted into the project business unit options at save time with a default value of business unit, project, and activity. At a minimum, if you enable reconciliation, delta transaction rows are grouped by employee ID, business unit, project, and activity, and they cascade down from there. For example, if you summarize by category, then the transaction rows are grouped by employee ID, business unit, project, activity, and category. This field is not available if you select Do Not Reconcile as the reconciliation method for the Time and Labor for Billing option. |
You can manually enter the percent complete for a project and activities, or have the system automatically calculate this value.
Calculation Method |
Select a method to calculate the percent complete component. Available methods are: Amounts: Bases the calculation on budgeted and actual amounts as in this equation: Duration: This option is available only if you use Program Management. Bases the calculation on the number of days that are allotted to complete the activity as in this equation: Manual: Bases the calculation on manual entry of percent complete. Units: Bases the calculation on the number of hours that are allotted to complete the activity as in this equation: Note. If you use Program Management and select a project charging level of Activity Costing Level on the Program Management Options page, the Percent Complete Application Engine process (PC_PERCENT) evaluates only activities in the project charging level that have transactions associated with them. The system ignores planning activities. This affects the percent calculation if you select Units or Amounts as the calculation method. |
Summary Method |
Select a method that the system uses to roll up activity completion percentages to the project. Available methods are:
|
Integration Default Role Values
Default Project Role |
Specify the default project role for the system to use when copying project and activity team members from third-party applications to Project Costing. |
Project Manager Role |
Enter the default project manager role that is assigned to project managers that are added from Grants or Proposal Management, or through a project request. The default project manager role that you define on this page becomes the role that the system assigns to the project manager on the project team. |
Select options in this group box that the Pricing Application Engine process (PC_PRICING) uses when it is triggered by incoming Application Engine processes or through the Add Transactions functionality in Project Costing. Examples of incoming Application Engine processes are the Payables to Project Costing process (PC_AP_TO_PC) and the Time and Labor to Project Costing process (PC_TL_TO_PC). In this case, the Pricing process uses the pricing options that you select on this page for the business unit of each transaction row that it processes. The Pricing process triggers the Limits Application Engine process (CA_LIMIT), which processes the same type of transaction rows (revenue, billing, or both).
Cost |
Select to use this option as a default pricing option for the business unit on the Pricing run control page. You can override this pricing option when you run the process. |
Billing |
Select to use the billing option as a default pricing option for the business unit on the Pricing run control page. You can override this option on the run control page. |
Revenue |
Select to use the revenue option as a default pricing option for the business unit on the Pricing run control page, and as a default processing option on the Limits run control page in Contracts if you run the Limits process manually. You can override this option on the run control pages. The Revenue pricing option enables the Pricing process and Limits process to run exclusively for revenue contract rows. This option is available if you use the Government Contracting feature that is available with Contracts, and you select the Separate Billing and Revenue option in the Installation Options - Contracts page. |
See Understanding Project Costing and Government Contracting Integration.
Specify the fields that are required when you enter transactions for this business unit in PeopleSoft cost feeder applications and directly in Project Costing through the Add Transactions page. Values are Required or Optional.
Note. A project business unit, project, and activity are always required when you enter transactions directly in Project Costing.
If you select Required for Category, or SubCategory input control for any business unit, you cannot inactive those ChartFields on the Standard ChartField Configuration page.
Determine who can charge time, expenses, or both, to a project or activity based on the team membership. Define at what level (business unit level or project level) the decision is made to enforce team restrictions, and to what extent.
Do Not Enforce |
Select to make the team restriction decision at the business unit level for all projects that belong to the business unit. There is no restriction on charging time or expenses to projects, so the Products drop-down list box does not appear when you select this option. You cannot override this option at the project and activity team level. |
Project Team Only |
Select to make the team restriction decision at the business unit level for all projects that belong to the business unit, and restrict the charging of time and expenses to project team members. The Products drop-down list box appears when you select this option. You cannot override this option at the project and activity team level. |
Project and Activity Team |
Select to make the team restriction decision at the business unit level for all projects that belong to the business unit, and restrict the charging of time and expenses to project or activity team members based on the Enforce Team option that you select on the Activity Definitions - Definition page. The Products drop-down list box appears when you select this option. You cannot override this option at the project and activity team level. |
Decide at the Project Level |
Select to defer the decision to restrict charges to the project manager for each project that belongs to the business unit. The project manager uses the Project Costing Definition page to specify the extent to which restrictions are imposed. The Products drop-down list box does not appear when you select this option. |
Available product options are: Exp and TL (Expenses and Time and Labor): Select to allow project and activity team members to charge to the project from both Expenses and Time and Labor. Expenses: Select to allow project and activity team members to charge to the project only from Expenses. Time&Labor: Select to allow project and activity team members to charge to the project only from Time and Labor. |
Note. Time and Labor 8.9 does not enforce project activity team. If you select the Project and Activity Team option, and select the Exp and TL or Time&Labor product option, the system restricts Time and Labor users for projects to which they can charge time. However, Time and Labor users can charge time to any activity on a particular project if they have security access to the project.
Note. Prompt tables are synchronized between the Financial Management Solutions (FMS) and Human Capital Management (HCM) by using the PROJECT_FULLSYNC message in application messaging. If project team enforcement takes place at the business unit level, you must run the PROJECT_FULLSYNC process manually.
To set up reversal amounts for project commitments, select a Commitment Control ledger group, requisition source type, and purchase order source type. The Purchasing Adjustment Application Engine process (PC_POADJUST) uses the Ledger Group field, and Requisition Source Type or Purchase Order Source Type fields, in addition to the purchase order or requisition numbers from the Project Transaction table, to identify rows in the Commitment Control Liquidation table (KK_LIQUIDATION). The process copies the corresponding rows to the Project Transaction table.
Select the Edit Combinations check box to enable ChartField combination editing when integrating with General Ledger.
Waived Facilities and Administrative Calculation
Select either Institution Minus Funded or Sponsor Minus Funded to tell the system how you want to calculate waived and cost-shared facilities and administration amounts. The system uses this option only if you choose to calculate waived or cost shared amounts in the Facilities Admin Options page in Grants.
This group box appears only if you install Grants.
See Establishing F&A and Direct-Cost Cost-Sharing Options.
Budget Item Defaults
Select the revenue budget item that the Distribute Costs to Budgets Application Engine process (PGM_SPREAD) uses as the default budget item when it creates revenue budget rows. The default value is REVEST.
The revenue budget item that you enter on this page appears in the Bill tab in the Resources by Activity page.
Note. To create cost budget rows, the Distribute Costs to Budgets process uses budget items that you specify for each resource row in the Cost tab of the Resources by Activity page.
See Also
Editing ChartField Combinations
Running the Build Combination Data Process
Enterprise PeopleTools 8.46 PeopleBook: PeopleSoft Integration Broker
Access the Budget Row Versioning page.
Note. Before you can define the analysis types and sequences to use to create budget plan versions, you must set up analysis types in the Analysis Types component (PROJ_ANALYSIS_TYPE) to use to distinguish budget rows for particular budget plan versions.
PeopleSoft delivers a series of analysis types and groups that you can use to distinguish historical cost and revenue budget versions.
See Budget Plan Versions.
The system uses two different analysis type sequences to distinguish budget plan versions—one sequence for cost budget plan versions and one for revenue budget plan versions.
After you enter analysis types and save the page, you can append analysis types to the sequence, but you cannot change an existing analysis type or change the sequence order.
You are not required to create an analysis type sequence in ascending alphanumeric order. The system maintains a separate sequence number for each analysis type on this page. Each time that you add an analysis type, the system increments the Sequence Number field (SEQ_NBR) for the budget type (cost or revenue). The Sequence Number field is not visible on the user interface. The system uses the field to determine the next available budget version analysis type when you finalize a project budget plan.
See Also
Maintaining Budget Plan Versions
Access the Copy Template Option 1 page.
This page is used to configure both the Project Copy and Project Templating features. Use this page to specify the tables that contain field values that the system copies into a new project that you create from a template.
For Project Copy, you can select the Allow Project Copy, Allow Activity Copy, and Allow Transaction Copy check boxes to enable this feature at project business unit level. Then you indicate at the project business unit level which records are eligible for copying field values from one project to another.
The Project Templating feature does not use the Allow Project Copy, Allow Activity Copy, or Allow Transaction Copy check boxes to determine if you can create a project from a template. The system makes that determination based on security for project creation. The eligible records that the system uses to create projects and field values from templates are based on the selected records in the Template column.
Allow Project Copy |
Select to include project definitions in a project that you copy from an existing project. The system copies the field values from the tables that are listed in the Project Records grid from the existing project to the new project. |
Allow Activity Copy |
Select to include activity definitions in a new project that you create from an existing project. The system copies the field values from the tables that are listed in the Activity Records grid on the Copy Template 2 page from the existing project to the new project. |
Allow Transactions Copy |
Select to include transactions in a new project that you create from an existing project. The system copies the transactions from the tables that are listed in the Transaction Records grid on the Copy Template 2 page from the existing project to the new project. You cannot copy transactions from one project to another if you use Commitment Control or Projects Budgeting. Therefore, the Allow Transactions Copy check box is not available for selection if Commitment Control is enabled for Project Costing on the Installation Options - Products page. |
Update Project Tree |
Select to insert the new project into a project tree. |
Project Business Unit |
Enter a business unit to use with Copy Record/Temporary Tables function. |
Copy Record/Temporary Tables |
Click to copy record settings of the business unit that is selected in the PC Business Unit field to this template. |
Note. Project Costing delivers standard and temporary Project Records in Business Unit US003, which you can use as a guideline for all Project Records that can be used in the Project Copy and Project Templating features.
Allow Copying |
Select the check box corresponding to the project-level records from which you want to copy field values for an existing project into a new project. Note. You must also select the Allow Project Copy option for the system to copy the selected records and their field values. |
Template |
When you select the Allow Copying check box for a row, the system automatically selects the Template check box if the record is eligible to be copied to create projects from templates. This check box is not editable. This column does not restrict data that is saved in the database tables for a project template. |
This table lists the records and temporary records that are available for performing the project copy and project templating process:
Project Record (Table) |
Temporary Record (Table) |
Used for Project Copy, Project Templating, or Both |
PC_AM_RULE_PRJ |
PC_CPY_PJAM_TAO |
Both |
PC_BUD_ALERT |
PC_CPY_BDAL_TAO |
Both |
PC_BUD_PLAN |
PC_CPY_BUP_TAO |
Both |
PC_PIC_ADD_TBL |
PC_CPY_PICA_TAO |
Copy |
PC_PIC_STUS_TBL |
PC_CPY_PICS_TAO |
Copy |
PC_PROJHEALTH |
PC_CPY_HLTH_TAO |
Both |
PC_SR_DATES |
PC_CPY_SRDT_TAO |
Copy |
PC_SR_FRQS |
PC_CPY_SRFQ_TAO |
Copy |
PGM_ACTION_PLAN |
PC_CPY_RKAP_TAO |
Copy |
PGM_PROJ_RISK |
PC_CPY_RISK_TAO |
Copy |
PGM_RISK_NOTES |
PC_CPY_RKNT_TAO |
Copy |
PGM_RISK_TRIGGR |
PC_CPY_RKTG_TAO |
Copy |
PROJ_APPROVAL |
PC_CPY_PJAP_TAO |
Both |
PROJ_DOCUMENT |
PC_CPY_PDOC_TAO |
Copy |
PROJ_EV_APPROVE |
PC_CPY_EVAP_TAO |
Both |
PROJ_JUSTIFY |
PC_CPY_PJUS_TAO |
Both |
PROJ_LOCATION |
PC_CPY_PLOC_TAO |
Both |
PROJ_TEAM_SCHED |
PC_CPY_TMSC_TAO |
Both |
PROJECT |
PC_CPY_PROJ_TAO |
Both |
PROJECT_DESCR |
PC_CPY_DESC_TAO |
Both |
PROJECT_MGR |
PC_CPY_MGR_TAO |
Both |
PROJECT_SCHED |
PC_CPY_PSCH_TAO |
Both |
PROJECT_STATUS |
PC_CPY_PSTA_TAO |
Both |
PROJECT_TEAM |
PC_CPY_TEAM_TAO |
Both |
PSA_ORGPRJ_DEFN |
PC_CPY_PORG_TAO |
Copy |
Access the Copy Template Option 2 page.
Allow Copying |
Select the check box corresponding to the activity-level records from which you want to copy field values for an existing project into a new project. The system copies the selected records and their field values only if you select the Allow Activity Copy option on the Copy Template 1 page. |
Template |
When you select the Allow Copying check box for a row, the system automatically selects the Template check box if the record is eligible to be copied to create projects from templates. This check box is not editable. |
Analysis Group |
Enter the analysis group that the system uses for mapping analysis types from the template project or activity to the new project or activity. When you copy transaction rows from one project to another, the analysis group indicates which transaction rows to copy. The system copies only those rows with an analysis type that is in the selected analysis group. The Template Copy analysis group (COPY) selects actual cost rows (with an analysis type of ACT) and maps them to total cost budget rows (with an analysis type of BUD). Thus, the system selects ACT rows from the template project and copies them to the new project as BUD rows. PeopleSoft delivers the COPY analysis group as system data; however, you can use any analysis group. |
This table lists the activity record and temporary records that are necessary for performing the copy process:
Activity Record (Table) |
Temporary Record (Table) |
Used for Project Copy, Project Templating, or Both |
PC_AM_RULE_ACT |
PC_CPY_ACAM_TAO |
Both |
PC_BUD_ACTIVITY |
PC_CPY_BDAC_TAO |
Copy |
PC_BUD_ALERT |
PC_CPY_BDAL_TAO |
Both |
PC_BUD_DETAIL |
PC_CPY_BDTL_TAO |
Both |
PC_BUD_ITEM |
PC_CPY_BDIT_TAO |
Both |
PC_DELIVERABLES |
PC_CPY_DELV_TAO |
Both |
PC_PRICE_R_PLAN |
PC_CPY_PRCP_TAO |
Both |
PC_PRICE_RATES |
PC_CPY_ARAT_TAO |
Both |
PGM_ACT_DEP |
PGM_CPY_ATD_TAO |
Both |
PROJ_ACT_DESCR |
PC_CPY_ADES_TAO |
Copy |
PROJ_ACT_LOC |
PC_CPY_ALOC_TAO |
Both |
PROJ_ACT_STATUS |
PC_CPY_ASTA_TAO |
Both |
PROJ_ACT_TEAM |
PC_CPY_ACTM_TAO |
Both |
PROJ_ACTIVITY |
PC_CPY_ACTY_TAO |
Both |
PROJ_QUALITY |
PC_CPY_QUAL_TAO |
Both |
PSA_ORGPRJ_ACT |
PC_CPY_OGAC_TAO |
Copy |
Transaction Record (Table) and Temporary Record (Table) |
The only transaction record that is necessary for performing the copy process is PROJ_RESOURCE. The corresponding temporary record is PROJ_RES_TMP. The system copies the selected records and field values only if you select the Allow Transactions Copy option on the Copy Template 1 page. |
The Project Delete utility provides an effective means of removing projects, activities, and transactions from the database. Before you can use the utility, you must set up utility tables for each business unit that is on the Delete Utility Tables page, which is accessible to managers or power users who have permission to implement the Project Delete utility.
Access the Delete Utility Tables page.
Use this page to set up the system to allow the deletion of:
All or selected transactions based on the project, activity, and analysis group.
All or selected activities based on the project.
A project and all associated project data.
A project node from a specified project tree.
The Project Delete utility does not purge project-related data from feeder systems or modules that interface with Project Costing.
Warning! Give thoughtful consideration to the process of setting up the Project Delete utility. Project deletions are permanent and irreversible.
Additional pages in the Project Costing Options component (PC_BUS_UNIT_OPT) are discussed in business process sections of this PeopleBook. This table lists the additional component pages and provides a link to the discussion:
Project Options Component Page |
Location of Page Discussion |
Microsoft Project |
|
Budget Alerts |
|
Asset Integration Rules |
See Defining Asset Integration Rules for Express Capitalization. See Defining Asset Integration Rules for Manual Capitalization. |
Interest Calculation |