This chapter provides an overview of the various pricing functions in PeopleSoft Project Costing, Variance Pricing, and discusses how to:
Import transactions into PeopleSoft Project Costing.
Define rates for employees, job codes, and project roles.
Define rate set categories, rate sets, and rate plans.
Define tiered pricing.
Run the Pricing Application Engine process.
Run the Variance Pricing process.
View team rates.
This section discusses:
The pricing process.
Installation and business unit pricing options.
Rate sets.
Rate plans.
Contract-specific and standard rates.
Effective-dated rate definitions.
Transactions eligible for pricing and repricing.
Tiered pricing.
Organizational sharing.
Limits processing.
Pricing transactions associated with work orders.
Pricing projects from proposals.
The Pricing Application Engine process (PC_PRICING) calculates transaction costs, overhead, and revenue amounts from source rows, which are transactions that are brought into PeopleSoft Project Costing. Source rows can be directly entered into PeopleSoft Project Costing by using the Add Transactions component, or entered into a feeder system, such as PeopleSoft Expenses, and integrated into Project Costing.
Application Engine processes that bring cost transactions into PeopleSoft Project Costing automatically trigger the Pricing process. Adding transactions on the Add Transactions page also triggers the Pricing process. The process matches the costs with rate sets that specify what target rows to create in the Project Transaction table (PROJ_RESOURCE). Target rows are transactions that are created as a result of pricing the source transaction row. The process uses the rate plan to determine which rate sets to run and in what sequence to run them.
You can create revenue rows from cost transactions if you use the Government Contracting feature of PeopleSoft Contracts, and select a Contracts installation option to separate billing and revenue rows. This enables you to run the Pricing process independently for direct and indirect costs, billing, and revenue. If you do not select the PeopleSoft Contracts installation option to separate billing and revenue rows, then you cannot create a rate set to price for revenue nor can you price transaction rows for revenue.
If you use tiered pricing, the system generates billing rows based on the specified rate set or rate plan, and applies the tiered pricing adjustment percentage to the amount on the target row. If you use organizational sharing and define sharing options and rates, the Pricing process creates sharing rows based on the established rates and exceptions.
Transactions are eligible to price for billing when the project and activity are linked to a rate set or rate plan through PeopleSoft Contracts at the contract line level. For example, assume that a voucher is entered in PeopleSoft Payables for 100 USD. When the Payables to Project Costing Application Engine process (PC_AP_TO_PC) runs, it selects the cost row from the Payables Accounting Entries table (VCHR_ACCTG_LINE) and calls the Pricing process, which creates a billing row from the cost row. When the process completes, two rows appear in the Project Transaction table, a row with an analysis type of ACT (actual cost) and a row with an analysis type of BIL (billable amount), as shown in this table:
Description |
Source |
Analysis Type |
Amount |
Materials |
Payables |
ACT |
100 USD |
Markup 25 percent |
Pricing process |
BIL |
125 USD |
You can also use the Pricing process to cost project transactions that will not be billed. This is made possible by associating a rate set with an activity on the Activity Definitions - Rates page in PeopleSoft Project Costing. As project-related costs are incurred and sent to PeopleSoft Project Costing, the system can determine transaction costs that are associated with the activity based on the rates in the rate set or rate plan. Instead of linking the project and activity to a contract line and rate set in PeopleSoft Contracts for billing purposes, you can link the project and activity to a rate set in PeopleSoft Project Costing for costing purposes.
Additionally, you can use the Pricing process to price unpriced transaction rows or reprice transaction rows that are in the Project Transaction table. You cannot, however, reprice transactions that are in the process of being billed or sent to the general ledger (GL), or that were generated from the same source transaction as another billable row that is in the process of being billed or sent to GL.
Process Flow
The high-level steps that you follow to create cost, billing, and revenue rows by using the Pricing process are:
Determine the elements that contribute to pricing calculations based on your business processes.
For example, do you use rates by employee, project role, or job code? Do you mark up source transaction amounts to create billing rows, or do you use fixed amounts? Do you associate rate sets with project types, projects, activities, or specific contract lines?
Set up installation and business unit options.
(Optional) Set up tiered pricing.
(Optional) Set up rules and exceptions for organizational sharing.
Create rate sets.
Create rate plans.
Associate projects and activities with rate sets or rate plans and contracts.
Price the transactions to create cost, billing, and revenue rows by using feeder systems to automatically trigger the Pricing process.
Review the transactions, make changes to rates, and manually run the Pricing process to reprice rows as necessary.
See Also
Tracking Activity Billing and Project Costing Rates
Integrating with PeopleSoft Contracts and PeopleSoft Billing
Understanding Accounting Distributions
During installation, determine if you want to enable organizational sharing for rate-based contract lines. Other pricing options at the installation level are used when the Pricing process is triggered for the business unit by Application Engine processes from feeder systems, or through the Add Transactions functionality in PeopleSoft Project Costing. For example, because the rates that the Pricing process uses are effective-dated, you can specify the date type (transaction or accounting) that the system uses to determine the rate set or rate plan to use for pricing.
Options that you select at the business unit level are also used when the Pricing process is triggered for the business unit by Application Engine processes from feeder systems, or through the Add Transactions functionality in PeopleSoft Project Costing. Select pricing options of Cost, Billing, or both for the system to use to determine which rows to create. If the Separate Billing and Revenue option is enabled on the Installation Options - Contracts page, you can also select a pricing option of Revenue. By using pricing options, you can tell the system to create costs (indirect and direct), billing, and revenue recognition rows separately. The pricing options that you select for the business unit appear by default as the selected pricing options on the Pricing run control page. You can override the business unit default values when you initiate the Pricing process on the Pricing run control page.
Cost and Bill Rate Restrictions in Program Management
If you use PeopleSoft Program Management, at the business unit level you can restrict the rate types that users can select for cost and bill rates for activity resources. The rate types that you enable for the business unit control the rate options that you can select on the Rate Sets - Target page as follows:
If you enable only the Rates by Employee rate type for the business unit, you cannot select the JBI (Job Code Bill Rate), JCO (Job Code Cost Rate), RBI (Role Bill Rate), or RCO (Role Cost Rate) rate options.
If you enable only the Rates by Job Code rate type for the business unit, you cannot select the EBI (Employee Bill Rate), ECO (Employee Cost Rate), RBI, or RCO rate options.
If you enable only the Rates by Role rate type for the business unit, you cannot select the EBI, ECO, JBI, or JCO rate options.
If you enable only the Custom rate type for the business unit, you cannot select the EBI, ECO, JBI, JCO, RBI, or RCO rate options.
A rate set enables you to create transaction rows when costing, billing, recognizing revenue, or reporting from incoming or existing transactions in the Project Transaction table. Rate sets have two parts:
The source criteria that the Pricing process uses to compare against cost transactions coming in from feeder systems.
The target definition of the cost, billing, or revenue recognition row that the Pricing process creates.
When an incoming cost transaction matches the source criteria, the Pricing process creates a new transaction row for every target row that is defined on the rate set.
For example, you can use multiple criteria on the source page to create billing rows one way for rows with a source type of MATER (material) and another way for a source type of LABOR. The materials can be billed at cost, while the labor is marked up. The billing rows are defined by the target definition (bill MATER rows at cost, mark up LABOR rows using employee rates) and the project ChartFields.
A one-to-many relationship exists between source criteria and target row definitions. One source row, such as a cost transaction or a billing transaction, can create multiple target rows.
You can attach rate sets or rate plans to:
Project types
The system uses the rate set or rate plan that you specify for a project type as the default rate set or rate plan for new projects that you create for that type. You can override the default rate set or rate plan at the project level.
Products
If you associate a rate plan with a product, the system uses the product's rate plan for the contract line on the Contracts Related Projects page.
Contract lines
Rate sets and rate plans can be defined for general use or for a specific contract. Once defined, you can assign the rate set or rate plan to the rate-based contract using the Related Projects page.
Projects
The system uses the rate set or rate plan on the project as the default rate set or rate plan for new activities that you create for that project. You can override the default rate set or rate plan at the activity level.
Activities
The actual Pricing process occurs at the activity level. The association of a rate set or rate plan to an activity is effective-dated.
You specify a rate definition type when you create a rate set. By using rate definition types, the Pricing process can create costs (indirect and direct), price transactions for billing, and price transactions for revenue recognition. Rate definition types control the type of rows that the Pricing process creates by restricting the analysis types that you can select for target rows on the rate set.
For example, when you create a rate set with a cost rate definition type, the system restricts the target rows to analysis types that belong to the actual cost analysis group. The default actual cost analysis group is PSCST (Accounting Costs), which is specified on the Installation Options - Project Costing page along with the actual revenue and billing analysis groups. During implementation you can override the default analysis groups for actual cost, revenue, and billing.
This table lists the rate definition types and analysis types that you can select for target rows:
Rate Definition Type |
Target Row Analysis Types |
Billing |
For target rows, you can select analysis types that belong to the PSWKS (Billing Worksheet Grouping) analysis group. |
Cost |
For target rows, you can select analysis types that belong to the analysis group that is specified in the Actual Cost field on the Installation Options - Project Costing page. The default analysis group is PSCST (Accounting Costs). Note. You can enable variance pricing on rate sets with a cost or cost/billing rate definition type. |
Cost/Billing |
For target rows, you can select analysis types that belong to either:
Note. You can enable variance pricing on rate sets with a cost or cost/billing rate definition type. |
Revenue |
This option is available if you use PeopleSoft Contracts and you select a Contracts installation option to separate billing and revenue rows. For target rows, you can select analysis types that belong to either:
|
Rate set categories are optional. Rate set categories are used to group related rate sets for the Variance Pricing process. If Rate Set Category is selected in the Rate Processing Option field on the Variance Pricing run control page, then all rate sets tat are part of that rate set category and have the Enable Variance check box selected are selected by the Variance Pricing process.
Rate Options
Rate options specify how the Pricing process calculates the rates for the corresponding target rows. For example, you can select a rate option of ECO (Employee Cost Rate) on a target row to use the cost rates that are defined for the employee on the Rates by Employee page. For the ECO rate option, the Pricing process calculates the target amount as the source row transaction quantity × the employee-specific cost rate × the rate set rate amount.
Each rate option is associated with a specific formula that the system uses to calculate the target amount. In the previous example, the source row transaction quantity is the quantity available in the Project Transaction table for the specific row that is being priced. The employee-specific cost rate is the rate that is defined for the employee on the Rates by Employee page. The rate amount on the target row functions as a multiplier for any rate option except the FIX (Fixed Amount) rate option. If you select the FIX rate option, the rate amount functions as the actual rate.
These factors affect the list of rate options that are available for selection:
Some rate options are available only if you integrate with other PeopleSoft applications.
For example, if you use PeopleSoft Maintenance Management, you can select the WBI (Work Order Labor Bill Rate) and WCO (Work Order Labor Cost Rate) rate options to use the work order labor bill and cost rates. If you use PeopleSoft Program Management, you can select the ABI (Activity Resource Bill Rate) and ACO (Activity Resource Cost Rate) rate options to use the activity resource labor rates that appear on the PeopleSoft Program Management Resources by Activity page. If you use PeopleSoft Proposal Management, you can select the AML (Mark Up/Down Labor) and AMN (Mark Up/Down Nonlabor) rate options to use the signed percentage amount in the Labor % and Non-Labor % fields on the Project Definitions - Rates page to determine the markup or markdown value.
If you use PeopleSoft Program Management, the available rate options are also based on the rate types that you specify for the business unit during implementation.
For example, if you restrict cost and bill rate types at the business unit level to only rates by employee, you cannot select the JBI, JCO, RBI, and RCO rate options.
A complete list of rate options that is available for selection on the Rate Sets - Target page is discussed in the business process section of this chapter.
See Defining Rate Set Categories, Rate Sets, and Rate Plans.
A rate plan is a collection of rate sets that the system executes in a specified order. Use rate plans to link rate sets so that priced rows from one rate set are used to create additional priced rows from the next rate set. For example, you can add additional expenses, such as administrative costs or overhead, to cost transactions before they are priced for billing or revenue.
The Pricing process uses the rate plan to determine which rate sets to run and in what sequence to run them. When setting up the rate plan, you can assign rate sets in any combination of rate definition types: billing, costing, cost/billing, and revenue. You can assign the same rate set to multiple rate plans.
Rate plans are similar to rate sets in these ways:
Both can be associated with project types, projects, activities, or contract lines.
Both are effective-dated.
If either a rate set or a rate plan is associated with a project type, it is used as the default rate set or plan for new projects that you create for that type.
If either a rate set or a rate plan is associated with a project, it is used as the default rate set or plan for new activities that you create for that project.
This diagram shows the tables that the system uses to process rate plans:
Tables that the system uses to process rate plans
Source rows that enter PeopleSoft Project Costing from feeder systems are stored in a Project Transaction subrecord (PROJ_RES_TMP) and copied into the PRT_PRICE temporary table.
Basis
A basis is assigned to each rate set in a rate plan and tells the Pricing process what transactions to use to create the target rows for a rate set.
Basis options are:
Original: The system uses the original source transactions to create target rows for the specified rate set.
Target: The system uses the target rows that have been created on this rate plan thus far as the basis for creating the target rows for this rate set.
All: The system uses all of the original sources and all of the previously created target rows on the rate plan to create the target rows for this rate set.
Sequence
When transactions come into PeopleSoft Project Costing from PeopleSoft feeder systems, the Pricing process uses the pricing options that you select for the business unit to tell the system what kind of rows to create from the source transactions. The pricing options correspond to the rate definition types (Billing, Cost, Cost/Billing, or Revenue) that are assigned to rate sets. You can process all rate sets on a rate plan even if the rate sets contain different rate definition types, or you can process a subset of rate sets on a rate plan. When the Pricing process runs for a rate plan, the rate sets are processed for the selected pricing options in the sequence that is defined on the rate plan.
For example, assume that you create a rate plan and attach rate sets to the plan in the order of COST1, BILL1, COST2, BILL2, and REV1. When you run the Pricing process for all three pricing options (Cost, Billing, and Revenue), the system first processes the COST1 rate set, followed by BILL1, COST2, BILL2, and REV1. Because of this processing logic, you should add rate sets to rate plans in the order in which you want them to run.
If you run the Pricing process by using the Pricing run control page, you specify the rate sets to process by selecting pricing options (Cost, Billing, and Revenue) on the run control page. The rate sets are processed in the order that is defined on the rate plan, based on the pricing options that you selected on the run control page.
Example of Using Rate Sets and Rate Plans to Price Transactions
This diagram shows an example of pricing inbound transactions from PeopleSoft Expenses to PeopleSoft Project Costing:
Pricing flow between PeopleSoft Expenses and PeopleSoft Project Costing
As an example of using rate sets on a rate plan to price incoming transactions from time reports in PeopleSoft Expenses, assume that you set up two rate sets. The first rate set has a cost rate definition type and uses incoming time report transactions (rows with a TLX analysis type) to create actual cost transactions (rows with an ACT analysis type) by using the ECO rate option. The ECO rate option multiplies the source row transaction quantity × the employee-specific cost rate × the target row rate amount.
The second rate set has a billing rate definition type and uses the same incoming time report transactions as source rows to create billing transactions (rows with a BIL analysis type) by using the EBI rate option. The EBI rate option multiplies the source row transaction quantity × the employee-specific bill rate × the target row rate amount.
Now set up a rate plan that contains both rate sets. Both rate sets use the original, incoming time report transactions as source rows. After the rate plan processes the rate sets, the Project Transaction table will contain cost transaction rows with an analysis type of ACT, and billing transaction rows with an analysis type of BIL. The transaction amounts on these rows are based on the rate option on the rate set that was current at the time that you ran the Pricing process.
In PeopleSoft Project Costing, you can create rate sets and rate plans that are either contract-specific or standard (general). You can link contract lines to contract-specific or standard rate sets or rate plans. A contract-specific rate plan can contain both standard and contract-specific rate sets. A standard rate plan can contain standard rate sets only.
This table lists the valid combinations of standard and contract-specific rate sets and rate plans that you can attach to activities and contract lines:
Attach at the Activity Level |
Attach at the Contract Line Level |
Standard rate set |
If you attach a standard rate plan to an activity, you cannot attach this activity to a contract line. |
Standard rate plan |
Contract-specific rate set. |
Nothing |
Standard rate set. |
Nothing |
Standard rate plan. |
Nothing |
Contract-specific rate set. |
Nothing |
Contract-specific rate plan. |
You can link an activity that has a rate plan to a contract line. If the contract line is linked to a rate set or contract rates, the system processes the contract line rate set first, followed by the activity rate plan. Thus you can use the resulting target rows from the contract line rate set as source rows for the activity rate plan. Alternatively, you can process the contract line rate set independently of the activity rate plan.
Example of Using Contract-Specific Rate Sets and Activity-Specific Rate Plans
As an example of using a contract line-specific rate set and an activity rate plan, assume that you set up a contract line-specific rate set to create billing rows from time entries for an activity. You also set up an activity rate plan that contains a standard rate set to create indirect labor costs for the project.
The contract line-specific rate set is associated with the contract line on the Related Projects page in PeopleSoft Contracts. This rate set has a billing rate definition type and uses incoming time report transactions to create billing transactions (rows with a BIL analysis type). On the Rate Sets - Target page, the rate option is AMT and the rate set-specific rate amount is 150 USD. The activity is associated with the contract line on the Related Projects page in the PeopleSoft Contracts system. After you enter a time report transaction of 8 work hours for the activity, the Pricing process uses the rate option and rate amount specified on the contract-specific rate set to calculate the target billing transactions (rows with a BIL analysis type) from each incoming time report transaction.
This activity is also associated with a standard rate plan on the Activity Definitions - Rates page. The rate plan contains a standard rate set with a cost rate definition type and a basis of original, which means that the Pricing process uses only the original time entry rows that you import from PeopleSoft Expenses to calculate the target rows. The rate set uses a rate option of ECO, which is the cost rate that is associated with the employee (105 USD in this example), plus a 15 percent markup, to calculate actual overhead cost transactions (rows with an ACT analysis type) from each incoming time report transaction.
This table lists the resulting rows in the Project Transaction table for this example:
Description |
Source |
Quantity |
Analysis Type |
Rate Amount |
Transaction Amount |
Original transaction. |
Time report transaction |
8 work hours |
TLX |
Not applicable |
Not applicable |
Target billing row based on the contract line rate set. |
Pricing process |
8 work hours |
BIL |
150 USD |
1,200 USD (calculated as 8 hours × 150 USD) |
Target cost row based on the activity rate plan. |
Pricing process |
8 work hours |
ACT |
1.15 |
966 USD (calculated as 8 work hours × 1.15 rate amount × 105 USD employee cost rate) |
You assign an effective date to each rate set and rate plan. This action enables you to not only maintain a set of current rate sets and rate plans, but also to set up rate sets and rate plans for anticipated future use, and adjust transactions by using past-dated rate sets and rate plans.
The Pricing process uses the following date criteria to determine which rows are eligible for pricing:
The date type (transaction or accounting) that you specify during implementation.
The effective date of the rate set or plan.
The effective date of the association of the rate set or plan to the activity.
Date Type
You select the transaction or accounting date option in the Pricing/Funds Distribution group box on the Installation Options - Project Costing Integration page.
If you specify the accounting date type, the Pricing process determines the eligible rows by matching the accounting date for each transaction row to the effective date range of the rate set or plan. Alternatively, you can specify the transaction date type for the Pricing process to select rows with a transaction date that matches the effective date range of the rate set or plan.
Effective Date of the Rate Set or Plan
You can price transactions by using a rate set or plan that is no longer current if the rate set or plan is in an active status. In other words, a rate set or plan can contain more than one active, effective-dated row. You establish the effective date when you set up a rate set on the Rate Sets page or set up a rate plan on the Rate Plans page.
Effective Date of Association of the Rate Set or Plan to the Activity
The association of a rate set or rate plan to an activity is effective-dated. The system will not price a row if the row's specified date type (accounting or transaction) is earlier than the effective date of the association of the rate set or plan to the activity. You establish this effective date on the Activity Definitions - Rates page when you use the page to associate the rate set or plan to the activity.
Example of Using Effective-Dated Rate Sets
Assume that you set up a rate set with two active effective dated rows, as shown in this table:
Effective Date |
Source Analysis Type |
Target Rate Option |
Target Rate Amount |
Target Analysis Type |
January 1, 2004 |
TLX (incoming time report) |
AMT (quantity × target rate) |
25.00 USD |
ACT (actual cost transaction) |
January 1, 2005 |
TLX |
AMT |
50.00 USD |
ACT |
The rate set has an effective date of January 1, 2004, and uses incoming time report transactions as source rows. The Pricing process multiplies the time report quantities by a target rate of 25.00 USD to create actual cost transactions from source rows that have an accounting date that occurs between January 1 and December 31, 2004. On January 1, 2005, the target rate increases to 50.00 USD.
Assume that you create the following two source transaction rows:
The first transaction has a transaction date, accounting date, and currency effective date of April 1, 2004. The transaction quantity is 8, which is measured in work hours (MHR).
The second transaction also has a quantity and unit of measure of 8 MHR. The transaction date, accounting date, and currency effective date are June 1, 2005.
Now you run the Pricing process, which uses a target rate of 25.00 USD to calculate the first target row based on the rate set with an effective date of January 1, 2004. The process uses the new target rate of 50.00 USD to calculate the second target row based on the rate set with an effective date of January 1, 2005.
This table lists the target rows that the Pricing process creates for the two source transaction rows:
Accounting Date |
Project |
Activity |
Quantity |
Rate Amount |
Analysis Type |
Transaction Amount |
April 1, 2004 |
PROJ1 |
ACT1 |
8 MHR |
|
TLX |
|
April 1, 2004 |
PROJ1 |
ACT1 |
8 MHR |
25.00 USD |
ACT |
200.00 USD |
June 1, 2005 |
PROJ1 |
ACT1 |
8 MHR |
|
TLX |
|
June 1, 2005 |
PROJ1 |
ACT1 |
8 MHR |
50.00 USD |
ACT |
400.00 USD |
The Pricing process uses not only effective date of rate definitions, but also distribution statuses and system sources to identify transactions that are eligible for processing.
These distribution status fields in the Project Transaction table support rate set and rate plan processing:
Cost distribution status (CST_DISTRIB_STATUS): Indicates if a source row has been priced for costing.
Billing distribution status (BI_DISTRIB_STATUS): Indicates if a source row has been priced for billing.
Revenue distribution status (REV_DISTRIB_STATUS): Indicates if a source row has been priced for revenue recognition.
The revenue distribution status applies only if you use the Government Contracting feature of PeopleSoft Contracts and select a Contracts installation option to separate billing and revenue rows.
General ledger distribution status (GL_DISTRIB_STATUS): Indicates if a transaction row has been interfaced to the general ledger.
Repricing cannot occur on a source row if any target transaction rows have been further processed downstream. If a source row results in multiple target rows, and any of the target rows have been sent to PeopleSoft Billing or PeopleSoft General Ledger, neither row can be repriced. For example, assume that a rate plan specifies that an incoming transaction from PeopleSoft Expenses (with a TLX analysis type) is the source row that will create two rows—a cost row (with a CST analysis type) and a bill row (with a BIL analysis type). If the BIL row has already been sent to PeopleSoft Billing, the system cannot reprice the TLX row, which means that the cost cannot be recalculated.
Transaction rows must have a distribution status of N (new or not distributed) to be included in the Pricing process. To process a transaction row for a cost rate definition type, the cost distribution status must be N for the row. To process a row for a billing rate definition type, the billing distribution status must be N. Similarly, to process a row for a revenue rate definition type, the revenue distribution status must be N.
The possible cost, billing, and revenue distribution status values are:
C: Created (cost and revenue rows only).
D: Distributed; done.
G: Generated (cost and revenue rows only).
I: Ignore; do not process.
N: New; not distributed.
P: Priced (billing rows only).
U: Unbillable/nonbillable (billing rows only).
W: Worksheet, billing calculations are in the Project Costing Billing Worksheet (billing rows only).
If you select the Separate Billing and Revenue option on the Installation Options - Contracts page, the billing distribution status indicates if a transaction row has been priced for billing, and the revenue distribution status indicates if the row has been priced for revenue. These statuses enable you to separately monitor pricing for billing and revenue.
Note. The Process Project Accounting Application Engine process (PSA_ACCTGGL) assigns the G status value to the GL Distribution Status field (GL_DISTRIB_STATUS) for rows that are associated with contracts revenue. The Contracts Load Update Application Engine process (CA_LOAD_UPD) updates the GL Distribution Status value to D for these rows in the Project Transaction table.
System Sources
The Pricing process uses these system sources, in combination with distribution statuses, to identify transactions that are eligible for processing:
PRP: Indicates that a transaction is priced for billing.
PRC: Indicates that a transaction is priced for costing.
PRR: Indicates that a transaction is priced for revenue.
Similar to the Pricing process, the Repricing process considers the pricing options that you select on the Pricing run control page.
You can reprice transactions that:
Have not been billed or sent to GL.
A source row is ineligible for repricing if any of its target transaction rows contain a billing distribution status of W or D, or a GL distribution status of D or G.
Are not linked to an asset.
Have not been sent to PeopleSoft Asset Management.
Have not been used for fee calculations (billing and revenue fee worksheets) in PeopleSoft Contracts.
This rule applies only to government contracts. A transaction with a Contract Fee Status (CA_FEE_STATUS) field value of Generated indicates that it has been used in a fee calculation.
Are not created by the Variance Pricing Application Engine process (PC_VAR_PRICE).
Repricing cannot occur on any transaction rows that are created as a result of the Variance Pricing process.
You can view the distribution statuses of the source transaction row on the Transaction Detail page.
See Also
Maintaining Transaction Information
Tiered pricing enables you to adjust the rate that the system applies to cost transactions during the Pricing process based on quantities that accumulate against a contract line. This type of pricing applies to rate-based, contract line processing only.
Tiered pricing requires the use of transaction identifiers, which are similar in concept to using analysis groups. Transaction identifiers provide users with the flexibility to identify and group project ChartField values and eliminate the need to identify the ChartField values each time they define tiered pricing for a new contract line.
Note. To implement tiered pricing, you must install PeopleSoft Contracts. Contracts with a Government classification, or transaction from Variance Pricing, are not eligible for tiered pricing.
See Also
Use organizational sharing to share costs and revenue between the organization that owns the transaction and the organization that owns the project or activity.
If sharing rules are defined and activated, the Pricing process calls the Sharing Application Engine process (PSA_SHARING) to search for rows that are designated for sharing. A row is eligible for the Sharing process if the organization that owns the project or activity differs from the organization that owns the transaction, an applicable sharing rule exists, and the row does not qualify as an exception to the sharing rules.
Note. Contracts with a Government classification are not eligible for organizational sharing.
When the Pricing process runs as a standalone process, and if you use PeopleSoft Contracts, the Pricing process calls the Apply Limits Application Engine process (CA_LIMIT) for the contract line that is being priced. Use the Pricing run control page to run Pricing as a standalone process. The Pricing process passes run control parameters to the Apply Limits process to create over-the-limit rows for revenue transactions, billing transactions, or both. The revenue option is available only if you select a PeopleSoft Contracts installation option to separate billing and revenue rows.
When the Pricing process is automatically triggered by incoming transactions from feeder systems, the Pricing process also calls the Limits process. The Pricing process uses the selected pricing options (Revenue and Billing) on the Project Costing Options page for the business unit of each row, and it passes those parameters to the Limits process to determine the type of transactions to limit check: revenue, billing, or both.
You can also run the Apply Limits process in PeopleSoft Contracts independently of the Pricing process. Regardless of how the Apply Limits process is called, it evaluates transaction level limits first and then contract line level limits for all pending transactions for each contract line in its scope. Resulting over-the-limit transactions are excluded from revenue recognition and billing, and are not sent to PeopleSoft General Ledger or PeopleSoft Billing, respectively, except for over-the-limit transactions that are created from released retainage, which pass from the billing worksheet directly to the Project Transaction Temporary Billing table (PROJ_RES_TMP_BI) to be inserted into the Project Transaction table.
Because you apply limits at the contract line level, you cannot run the Apply Limits process for specific PeopleSoft Project Costing business units, projects, or activities.
The system limit checks these analysis types:
BIL (Billable Amount)
OLT (Over Limit)
REV (Revenue)
ROL (Revenue Over Limit)
The system uses these analysis groups to process limits:
PSLMT (Limit Processing - Billing)
PSROL (Limit Processing - Revenue)
See Also
PeopleSoft Project Costing tracks the cost of work that is performed against tasks on a work order if you use PeopleSoft Maintenance Management. Transaction costs flow from PeopleSoft Maintenance Management into various PeopleSoft applications such as PeopleSoft Time and Expense, Inventory, Payables, and Purchasing, and from these systems into PeopleSoft Project Costing. PeopleSoft Project Costing also tracks the cost of tools usage by retrieving the actual time that users record for tools on a work order task, and using the time as a basis to calculate the tools usage cost.
The Project Transaction table stores the work order business unit, work order ID, task ID, work order resource type, and work order resource line number for each transaction row for the work order task.
When you set up rate sets for use with work orders, select the WBI and WCO rate options on the Rate Sets - Target page for the Pricing process to use the work order labor bill and cost rates to calculate target rows. Select the TBI and TCO rate options for the Pricing process to use actual time recorded for tools usage in PeopleSoft Maintenance Management, and the tools cost and bill rates from the Technician Workbench - Tools Usage page to calculate target rows.
The high-level steps to set up work order pricing are:
Create rate sets in PeopleSoft Project Costing.
Specify default rate sets for the work order business unit.
Use the default rate set on the work order or specify an alternate rate set.
The system updates activities with new rate sets on the work order.
Run the Pricing process for repricing if you change the default rate set on a work order.
See Also
Integrating with Maintenance Management
Setting Up Rules and Data Related to PeopleSoft Project Costing
If you use PeopleSoft Proposal Management and PeopleSoft Program Management, Proposal Management uses the bill and cost role rates and hours that are captured in the proposal to populate the Resources page and Resources by Activity page in PeopleSoft Program Management. Unadjusted role rates are treated as Project Role rate types and have the rate that was in effect when the role was added to the proposal. Adjusted role rates are treated as Custom rate types.
Rate sets for labor from proposals can use rate options ABI and ACO for labor source transactions. These rate options tell the Pricing process to use the bill and cost rates on the Resources by Activity page in PeopleSoft Program Management to calculate billing and costing amounts for labor source transactions. Use the Resources by Activity page to modify role rates for projects from proposals.
The system obtains nonlabor pricing information from the rate set, and rate plans from the contract lines in PeopleSoft Contracts.
The Pricing process treats resource classes of Asset, Material, and Other as nonlabor resources. Rate sets for nonlabor from proposals use a rate option of NON (Bill at Cost). After the PM Generate process completes, the Pricing process and the Distribute Costs to Budgets Application Engine process (PGM_SPREAD) do not retrieve any information from the PM proposal.
Markups and Markdowns
On the Project Definitions - Rates page for projects that are created from proposals, you can enter a labor or nonlabor adjustment percentage that the system uses to determine a billing markup or markdown row amount. This field appears for projects that are created from proposals in PeopleSoft Proposal Management.
The labor adjustment percentage is used in conjunction with the AML rate option that you select on the Rate Sets - Target page. The AML rate option tells the system to use the signed percentage amount in the Labor % field on the Project Definitions - Rates page to determine the markup or markdown value. The AMN rate option tells the system to use the signed percentage amount in the Non-Labor % field on the Project Definitions - Rates page to determine the markup or markdown value. The Pricing process creates the target transaction values based on the signed percentage of the source transaction rows.
You can create markup and markdown target billing transactions from labor and nonlabor source transactions. You cannot create markup and markdown target costing transactions from labor and nonlabor source transactions.
This section discusses:
Variance pricing.
Variance rates.
Variance pricing setup requirements.
Variance pricing process flow.
Variance pricing statuses.
Example of using effective-dated rate set in variance pricing.
Variance pricing is used to capture and process price variances for a particular set of rates. Variance pricing, or retroactive rate adjustments, are required when contractors retroactively apply new rates to transactions that were previously processed. Transactions that have previously been processed are those that have been billed or sent to the general ledger.
You can apply variance pricing to all contract types and all rate set types. In addition, the Pricing summarization feature can be used, which reduces the number of transaction rows that are processed, in turn reducing the amount of time that it takes to run the Variance Pricing process. The Pricing summarization feature can also be used to reduce the number of transaction rows that result from the Variance Pricing process, which are ultimately posted to the Project Transaction table (PROJ_RESOURCE).
You can enable variance pricing on a standard or contract-specific rate set by selecting the Enable Variance check box. When using this option, you can enter, track, and process variance rates on the Rate Variance History page.
You cannon inactive variance pricing on a rate set if a variance rate exists on one or more target rows in an effective-dated rate set.
Through its integration with Project Costing, Contracts enables you to capture and process any rate changed for indirect costs that are associated with the contract. The rate changes generally impact a certain period of time within the contract. For a transaction to be eligible for variance pricing, at least one of its source or target rows must have been sent to the billing worksheet, passed to PeopleSoft Billing for invoicing, passed to PeopleSoft General Ledger for revenue recognition, sent to Asset Management for capitalization, or have been used for fee calculations.
When rate changes occur, the system verifies whether the transaction rows are eligible to be repriced. If they are, then those transaction rows are repriced by the Pricing engine and are ineligible for variance pricing.
New indirect costs are generated by the system for the difference in the old and new rates, and the new rates are used to calculate indirect costs against any current or future transactions going forward. When a rate change is made to an eligible rate set that is associated with a rate plan, after the new transaction row is created, the system prices the new row using any applicable remaining rate sets contained in the rate plan.
PeopleSoft Project Costing maintains a history of these rate changes for audit and reporting purposes.
To enable the system to calculate a produce transaction rows for rate changes, you must complete the following tasks:
Define a rate set with a rate definition type of Cost, Billing, or Cost/Billing.
Your costing and cost/billing rate sets contain your provisional and forward pricing rates, and enable you to calculate indirect costs. Variance pricing is only applicable to active rates where associated transactions have been billed, recognized as revenue or used for fee calculations for cost-plus contracts lines. Any rate changes that occur are tracked and managed using the rate sets that you define for the contract.
When rate changes are processed by the Variance Pricing process, the system generates transaction rows for the difference between the old indirect cost row and the new indirect cost row, prices the new row, and assigns a system source of PRV (variance pricing), and the analysis type that was defined for the original target costing row.
Select an optional Rate Set Category that indicates that the rate set category can be selected on the Variance Pricing run control page.
Associate the rate set or a rate plan that contains a cost, billing, or cost/billing rate set, to the contract lines.
When a rate change has occurred, select the Enable Variance check box on the rate set and enter the new target rate amount using the history link.
Before entering retroactive rate changes for your contract lines, you must first complete the following steps required by the variance pricing process:
Assign rate-based contract lines to the contract.
(Optional) Create a rate set category that is used during the Variance Pricing process.
Create a standard or contract-specific rate set or rate plan.
Optionally assign a rate set category to the rate set.
Assign the rate set or rate plan to the applicable contract lines.
Enable Variance check box selected. To bill and recognize revenue for contract-related direct and indirect costs, you must create a billing (if not using the cost/billing) and revenue rate set (if you have selected the Separate Billing and Revenue check box on the Installation Options – Contracts page).
Because you can assign only one rate set or rate plan to a rate-based contract line at one time, you will most likely combine your cost, billing, and revenue rate sets onto a rate plan in a manner that meets your pricing needs, and assign the rate plan to your rate-based contract lines.
Note. Rate sets that are eligible for variance pricing cannot have the same field values for analysis type, source type, category, or subcategory for both the source and target definition criteria. At least one value must be different between the source and target row.
Assign active projects and activities to your rate-based contract lines.
Transactions for rate-based contract lines are tracked using projects and activities associated with the contract line, and stored in the PROJ_RESOURCE table.
Set the contract to an active processing status and process transactions.
Transactions that are eligible for variance pricing are project-related transactions associated with rate-based contract lines that are processed through Project Costing. To process transactions for contract and rate-based contract lines you must also define as-incurred billing and revenue plans and assign them to the applicable rate-based contract lines for billing and revenue processing for your transaction.
After a contract has been activated and transactions have been processed, any rate changes that occur over the life of the contract can be applied using the Variance Pricing feature. This feature enables you to apply rate changes as needed by performing the steps described in this process flow diagram:
Variance Pricing process flow
These steps illustrate a high level example of using variance pricing to distribute transactions at a new rate that you previously distributed at a different rate:
Access the active rate set to enter the new rates for the target definition.
Variance rates are generally applied retroactively, over a specified period of time. When accessing the rate set, you must use Correction mode to open the page for the appropriate effective date. To access the Rate Variance History page, navigate to the Target page and enter the new rates for the target definition. Variance rates are tracked and processed using the Rate Variance History page.
Define the variance pricing run control parameters.
The Variance Pricing process selects the data to process based on the criteria that you specify on the Variance Pricing run control page such as business unit, project ID, activity, ID, accounting or transaction date range, contract information, rate set, rate plan, and rate category.
The Variance Pricing process applies this logic:
Selects rate sets based on the parameters specified on the Variance Pricing run control page.
Selects active contracts and projects associated with the rate set specified on the Variance Pricing run control page.
Projects associated with the rate set must be active, and contracts associated with the rate set cannot have a closed processing status.
Perform variance pricing.
The Variance Pricing process performs these steps:
Selects the eligible transactions that match the effective date and source criteria for the rate set.
Eligible transactions include transaction rows that are not eligible for repricing and have a general ledger distribution status (GL_DISTRIB_STATUS) of G (generated) or D (distributed), a billing distribution status (BI_DISTRIB_STATUS) of W (worksheet) or D (distributed), and do not have a system source of PRR (priced for revenue) or PRP (priced for billing). Transactions with an asset management distribution status (AM_DISTRIB_STATUS) of D (distributed) and transactions with a contracts fee status (CA_FEE_STATUS) of 1 (one), where the transaction has been used for billing or revenue fee calculations for cost-plus contract lines, are also eligible for variance pricing, whether or not the actual transaction has been billed or posted to the general ledger for revenue recognition.
Calculates the difference between the old rate and the new rate using this equation:
Variance Amount = (original source) x (new rate) – (original source) x (old rate). This amount may be positive or negative.
Creates the new transaction rows for the difference and posts them to the Project Transaction table (PROJ_RESOURCE).
The new transaction rows are assigned the analysis type assigned to the original target row, stamped with a system source of PRV (variance pricing), assigned a cost, revenue, and billing distribution status of N to enable cost stacking, billing, and revenue recognition to occur for the new transactions, and assigned a general ledger distribution status of C. The accounting date is specified on the run control page and the transaction date is stamped with the source transaction date.
After the variance pricing process is complete, the system posts the new transaction rows one of two locations:
If the Requires Variance Approval check box is selected on the Variance Pricing run control page, then the new transaction rows are posted to a staging table (PC_VP_REVIEW). You must access the Variance Pricing Review page to approve or delete transaction rows prior to sending the approved rows to the Project Transaction table (PROJ_RESOURCE).
If the Requires Variance Approval check box is not selected on the Variance Pricing run control page, then the new transaction rows are posted to the Project Transaction table (PROJ_RESOUCE).
(Optional) Applies standard pricing.
Based on the run control parameters, the Variance Pricing process calls the Pricing engine (PC_PRICING) to apply the new rate to all transaction rows that have been priced, but have not been billed or booked to the general ledger, or that have not been priced. It also prices any transactions that have not been priced, but are eligible for pricing.
Note. When you run the variance pricing process, the system automatically excludes contracts with a processing status of Closed. Additionally, rows created as part of the variance pricing process are not eligible for repricing.
When entering variance pricing rate changes, each row is assigned a status. The statuses are set and controlled by the system and control the type of action or processing that can occur against the variance rate row. The rate target sequence statuses are:
Pending: Appears by default when a new variance rate row is added.
Only one pending rate row may be entered at a time for a target definition. When a variance pricing rate row is in pending status:
The rate field is editable.
The rate cannot be selected and used for pricing.
The rate displays only on the Rate Variance History page and does not appear on the Target page for the rate set.
Active: After the new variance pricing rate is entered, and the Variance Pricing process is run for the rate set, the system updates the status of the new rate to Active.
Only one active rate row may exist at a time for a target definition. When a variance pricing rate row is in active status:
The rate field is display only and cannot be edited.
The new rate is selected and used for pricing by the Variance Pricing and the Pricing processes.
The new rate is displayed on the Target page for the rate set and is associated with a sequence number.
Inactive: After the new variance pricing rate is active, the previous rate row is set to an inactive status by the Variance Pricing process.
Multiple inactive rate rows can exist for a target definition. When a variance pricing rate row is in an inactive status:
The rate field for the inactive row is display only and cannot be edited.
The old rate cannot be selected and used for pricing.
Inactive rates are displayed only on the Rate Variance History page.
The Understanding Pricing Project Costs, Effective-Dated Rate Definitions section, provided an example of using effective-dated rate sets. The example used a rate set with two active effective-dated rows as shown in this table:
Rate Set Rows |
Effective Date |
Source Analysis Type |
Target Rate Option |
Target Rate |
Target Analysis Type |
SET1 Row 1 |
January 1, 2004 |
TLX (incoming time report) |
AMT (quantity x target rate |
25.00 USD |
ACT (actual cost transaction) |
SET1 Row 2 |
January 1, 2005 |
TLX |
AMT |
50.00 USD |
ACT |
In the example, a source transaction row contained a quantity and unit of measure of 8 MHR, with a transaction date, accounting date, and currency effective date of June 1, 2005. The Pricing process created an actual transaction row in the amount of 400.00 USD by using the rate set named SET1 with an effective date of January 1, 2005, and multiplying 8 MHR by a target rate of 50.00 USD.
Now assume that on July 1, 2005 you want to retroactively apply a new rate of 100.00 USD to existing actual transaction rows that were created after January 1, 2005. The target rate that was previously applied to these actual transactions was 50.00 USD, thus the Variance Pricing process needs to apply the net difference of 50.00 USD. You enter the new rate in a pending status on the Rate Variance History page for the SET1 rate set. When you run the Variance Pricing process, the system inactivates the existing active rate and changes the new rate to an active status, as shown in this table:
Rate Set |
Effective Date |
Variance Pricing Row Status |
Target Rate Option |
Target Rate |
SET1 |
January 1, 2005 |
Inactive |
AMT |
50.00 USD |
SET1 |
January 1, 2005 |
Active |
AMT |
100.00 USD |
To run Variance Pricing on the transaction row that was originally priced at a rate of 50.00 USD, select the SET1 rate set with an effective date of January 1, 2005 on the Variance Pricing run control page. The process creates a new row against the original transaction based on the net difference of 50.00 USD. In this example, you select an accounting date of July 1, 2005 on the run control page that the system applies to the new transaction row, as shown in this table:
Accounting Date |
Project |
Activity |
Quantity |
Rate |
Analysis Type |
Amount |
July 1, 2005 |
PROJ1 |
ACT1 |
8 MHR |
50.00 USD |
TLX |
400.00 USD |
The Variance Pricing process ignores transactions that have an accounting date (or specified date type) that are outside of the effective date range of the selected rate set.
Now assume that later you add a new SET1 rate set row with an effective date of July 1, 2006. You discover that you need to calculate pricing variances again on the output rows from the original transaction dated June 1, 2005. Because the system matches the specified date type of the priced costing row to the effective date range of the rate set to determine eligible transactions, you select the rate set effective date of January 1, 2005 for this Variance Pricing run control.
For additional information relating to government contracts and variance pricing, see PeopleSoft Enterprise Contracts for Government Contracting 9.1 PeopleBook, "Performing Variance Pricing"
See Performing Variance Pricing.
Various PeopleSoft Application Engine processes that are specific to feeder system applications send cost transactions to PeopleSoft Project Costing.
This section lists the pages used to bring cost transactions into PeopleSoft Project Costing.
Page Name |
Definition Name |
Navigation |
Usage |
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) to pull data from PeopleSoft Time and Labor into PeopleSoft Project Costing. Note. The billing distribution status of the transaction rows that are imported by using the Time and Labor to Project Costing process is based on the billable indicator in the PeopleSoft Time and Labor system. These transaction rows are sent to the Pricing process with cost and revenue distribution statuses of N. |
|
PC_EX_TO_PC |
Project Costing, Cost Collection, Expenses, Expenses |
Run the Expenses to Project Costing Application Engine process (PC_EX_TO_PC) to pull approved expenses from PeopleSoft Expenses into PeopleSoft Project Costing. Note. In PeopleSoft Expenses, if you specify a billing action of Nonbillable or Internal on a detail time or expense row, the Expenses to Project Costing process creates a transaction row in the Project Transaction table with a billing distribution status of U (unbillable). The system assigns an analysis type to the transaction based on the analysis type that is specified in the Expenses field (for expense rows) or Mobile Time / Expense field (for time rows) on the Installation Options - Project Costing Integration page. When you price the unbillable row, if the target analysis type on the rate set belongs to the PSWKS analysis group, the system deletes the target row and does not post it to the Project Transaction table. |
|
PC_AP_TO_PC |
Project Costing, Cost Collection, Payables, Payables |
Run the Run the Payables to Project Costing Application Engine process (PC_AP_TO_PC) to pull approved vouchers from PeopleSoft Payables into PeopleSoft Project Costing. |
|
PC_IN_TO_PC |
Project Costing, Cost Collection, Inventory, Inventory |
Run the Inventory to Project Costing Application Engine process (PC_IN_TO_PC) to pull fulfilled demand from PeopleSoft Inventory into PeopleSoft Project Costing. |
|
PC_OM_TO_PC |
Project Costing, Cost Collection, Order Management, Order Management |
Run the Order Management to Project Costing Application Engine process (PC_OM_TO_PC) to pull project data from open sales orders into PeopleSoft Project Costing. |
|
PC_PO_TO_PC |
Project Costing, Cost Collection, Purchasing, Purchasing |
Run the Purchasing to Project Costing Application Engine process (PC_PO_TO_PC) to pull purchase order transactions into PeopleSoft Project Costing. |
|
PC_SP_TO_PC |
Project Costing, Cost Collection, Services Procurement, Services Procurement |
Run the Services Procurement to Project Costing Application Engine process (PC_SP_TO_PC) to pull expense transactions into PeopleSoft Project Costing. |
|
PC_WM_TO_PC |
Project Costing, Cost Collection, Maintenance Management, Maintenance Management Tools Usage |
Run the Maintenance Management Tools Usage Application Engine process (PC_WM_TO_PC) to pull work order tools usage transactions into PeopleSoft Project Costing. |
To define rates for employees, job codes, and project roles, use these components:
Use the PC_RATE_EMPL_INTFC component interface to load data into the tables for the PC_RATE_EMPL component.
Use the PC_RATE_JOBC_INTFC component interface to load data into the tables for the PC_RATE_JOBC component.
This section discusses how to define rates by employees, job codes, and project roles.
Page Name |
Definition Name |
Navigation |
Usage |
PC_RATE_EMPL |
Setup Financials/Supply Chain, Product Related, Project Costing, Pricing Structure, Rates by Employee, Rates by Employee |
Define, view, and modify cost and billing rates for the selected employee. Note. The Pricing process uses the PC_RATE_EMPL_VW view to apply employee rates to cost transactions. Rates that you access by using this view are visible on the Rates by Employee page. |
|
PC_RATE_JOBC |
Setup Financials/Supply Chain, Product Related, Project Costing, Pricing Structure, Rates by Job Code, Rates by Job Code |
Define, view, and modify cost and billing rates for a specific job code. Note. The Pricing process references the PC_RATE_JOBC_VW view to apply job code rates to cost transactions. Rates that you access by using this view are visible on the Rates by Job Code page. |
|
PC_RATE_ROLE |
Setup Financials/Supply Chain, Product Related, Project Costing, Pricing Structure, Rates by Role, Rates by Role |
Define, view, and modify cost and billing rates for a specific project role. Note. The Pricing process references the PC_RATE_ROLE_VW view to apply project role rates to cost transactions. Rates that you access by using this view are visible on the Rates by Role page. |
Access the Rates by Role page (Setup Financials/Supply Chain, Product Related, Project Costing, Pricing Structure, Rates by Role, Rates by Role).
Enter the necessary data to define cost and billing rates for a project role.
Unit of Measure |
Enter the unit of measure for which the rate is defined. If a unit of measure conversion is defined, a conversion takes place during processing for transactions that use a different unit of measure. |
Regions
Assign one or more rates to a project role based on different regions by using the Regions grid. The Regions grid appears if you use PeopleSoft Program Management and PeopleSoft Resource Management. Use this feature if you want to price labor differently for roles that are performed on projects at different locations.
These two conditions must exist for you to price labor based on different locations:
In the Bill and Cost tabs in the Resources page and Resources by Activity page in PeopleSoft Program Management, the rate type must be Project Role.
On the Rate Sets - Target page for the rate set that is associated with the activity, the rate option must be ABI (Activity Resource Bill Rate) or ACO (Activity Resource Cost Rate).
If these conditions exist, the Pricing process creates target transaction rows by using the rate that corresponds to the resource's region in the Regions grid on the Rates by Role page.
If you select the RBI (Role Bill Rate) or RCO (Role Cost Rate) rate option on the Rate Sets - Target page, the Pricing process uses the default project role rate that is defined on the Rates by Role page. The process disregards regional rates when you use the RBI or RCO rate option.
You are not required to associate a region with a project role rate. If the role and region combination is not defined on the Rates by Role page, the system uses the default project role rate.
To define rate set categories, rate sets, and rate plans, use these components:
Use the PC_RATE_INTFC component interface to load data into the tables for the PC_RATE component.
This section discusses how to:
Define rate set categories.
Define standard or contract-specific source rows.
Define rate set target rows.
Define standard or contract-specific rate plans.
Page Name |
Definition Name |
Navigation |
Usage |
Rate Set Category |
PC_RATE_CATEGORY |
Setup Financials/Supply Chain, Product Related, Project Costing, Pricing Structure, Rate Set Category |
Define categories that are used to group rate sets. The rate set category can be selected on the Variance Pricing run control page. |
PC_RATE_DTL |
|
Define source criteria that identifies cost transactions from which you want to create target rows. |
|
PC_RATE_DTL_SUB |
Click Copy from Rate Set on the Rate Sets page. |
Copy a rate set to create a new rate set in the same business unit or across business units. |
|
PC_RATE_DTL_LN |
|
Define rate set target criteria to create cost, billing, or revenue rows. |
|
PC_RATE_PLAN |
Setup Financials/Supply Chain, Product Related, Project Costing, Pricing Structure, Rate Plans, Rate Plans |
Combine rate sets so that the target rows from one rate set are used to create additional target rows from the next rate set. |
|
PC_RATE_PLAN_SUB |
Click Copy from Rate Plan on the Rate Plans page. |
Copy a rate plan to create a new rate plan in the same business unit. |
Access the Rate Set Category page (Set Up Financial/Supply Chain, Product Related, Project Costing, Pricing Structure, Rate Set Category).
The rate set category is used on the Variance Pricing run control page, where it can be selected in the Rate Processing Option field. If Rate Set Category is selected in the Rate Processing Option field, then all rate sets that are associated with the rate set category selected in the Rate Category field are selected when the Variance Pricing processes runs.
Access the Rate Sets page (Setup Financials/Supply Chain, Product Related, Project Costing, Pricing Structure, Rate Sets, Rate Sets).
Rate Set |
Enter a rate set identifier. Rate set identifiers are used to run the Variance Pricing Application Engine process (PC_VAR_PRICE) and as selection criteria when setting up a rate plan. This field is required. |
Copy from Rate Set |
Click to access the Enter New Rate Set Keys page to enter the business unit and rate set ID of an existing rate set that you want to copy. Click OK on the Enter New Rate Set Keys page to return to the Rate Sets page with fields populated with data from the existing rate set. The Copy from Rate Set button appears only in add mode. Note. You can copy a standard rate set to another standard rate set. You cannot copy contract-specific rate sets. |
Rate Definition Type |
Select one of the options that determines the type of target rows that the Pricing process will create from this rate set: Billing: Creates billable rows that can be passed to PeopleSoft Billing for invoice generation. Cost: Creates target rows to track and calculate contract, project, and indirect costs. Cost/Billing: Creates cost and billing target rows. Revenue: Creates revenue recognition rows that can be passed to PeopleSoft General Ledger. This option is available if you select the Separate Billing and Revenue option on the Installation Options - Contracts page. Note. The rate definition type can be changed after saving the page. However, the target analysis types must adhere to the selected rate definition type. |
Rate Set Category |
Select a category to which this rate set belongs. If the Enable Variance check box is selected and the rate set category is selected on the Variance Pricing run control page, then the rate set is selected during the Variance Pricing process. |
Enable Variance |
Select to indicate that this rate set can contain variance rates. This option enables you to enter a rate variance on the Rate Variance History page for target rows for the rate set and indicate taht this rate set is eligible for variance pricing. You can activate or inactivate this option until you enter a variance rate on the Rate Variance History page. You cannot deselect this check box if a variance rate exists on one or more target rows. This option is available for all rate definition types. Variance pricing is available for all contract classifications. For additional information about variance pricing, |
Defining Criteria for Incoming Transactions
To set up a rate set, you define criteria that the system uses to identify the source transactions from feeder systems that are priced using this rate set. At a minimum, you must select an analysis type. All other fields may be identified with a wildcard character (%) to select all transactions that are associated with the specified analysis type. Otherwise, populate the additional fields to identify specific transactions that you want the system to select and price using this rate set.
If you selected the Enable Variance option on the Rate Sets page, the source rows in the Define Criteria for Incoming Transactions grid must contain at least one different value for analysis type, source type, category, or subcategory than the target rows in the Define Target Rows grid. If this condition does not exist, when you click the History link on the Rate Sets - Target page to access the Rate Variance History page, a message will appear stating that the rate set definition is not eligible for variance pricing.
Target |
Click the Target link on a source row to define the target criteria that the Pricing process uses to create priced transaction rows. |
Analysis Type |
Enter the analysis type that the system uses to identify the source transactions that are priced using this rate set. |
Source Type |
Enter a source type to limit the transactions selected for pricing to only transactions that are associated with this specific source type. Source types enable you to define a value that identifies a transaction's purpose. You can use source types to track, analyze, and report on transactions. |
Category |
Enter a category to limit the transactions selected for pricing to only transactions that are associated with this specific category. Categories enable you to further define source types to better track the types of costs that are incurred against the project and activities. |
Subcategory |
Enter a subcategory to limit the transactions selected for pricing to only transactions that are associated with this specific subcategory. Subcategories enable you to further define categories to better track the types of costs that are incurred against the project and activities. |
Project Role |
Enter a project role to limit the transactions selected for pricing to only transactions that are associated with this project role. |
Job Code |
Enter a job code to limit the transactions selected for pricing to only transactions that are associated with this job code. |
Time Reporting Code |
Enter a time reporting code to limit the transactions selected for pricing to only transactions that are associated with this time reporting code. |
Employee ID |
Enter an employee ID to limit the transactions selected for pricing to only transactions that are associated with this employee. |
Unit of Measure |
Enter a unit of measure to limit the transactions selected for pricing to only transactions associated with this unit of measure. |
Currency |
Enter a currency code to limit the transactions selected for pricing to only transactions in this currency. |
General Ledger Business Unit |
Enter a GL business unit to limit the transactions selected for pricing to only transactions that are associated with this GL business unit. |
Account |
Enter an account code to limit the transactions selected for pricing to only transactions that are associated with this account code. Account codes classify the nature of a transaction. |
Alternate Account |
Enter an alternate account to limit the transactions selected for pricing to only transactions that are associated with this alternate account. Alternate accounts classify the nature of a transaction for regulatory authorities. Use it for statutory accounting. |
Operating Unit |
Enter an operating unit to limit the transactions selected for pricing to only transactions that are associated with this operating unit. Operating units can indicate a location. |
Fund Code |
Enter a fund code to limit the transactions selected for pricing to only transactions that are associated with this fund code. Fund codes are the primary structural units of education and government accounting. |
Department |
Enter a department to limit the transactions selected for pricing to only transactions that are associated with this department. Use departments to track information according to a divisional breakdown of your organization. Departments can indicate who is responsible for, or affected by, a transaction. |
Program Code |
Enter a program code to limit the transactions selected for pricing to only transactions that are associated with this program code. Program codes track revenue and expenditures for programs within or across your organizations. Program codes can identify groups of related activities, cost centers, revenue centers, responsibility centers, and academic programs. |
Class Field |
Enter a class field to limit the transactions selected for pricing to only transactions that are associated with this class field. Class fields can identify specific appropriations. |
Budget Reference |
Enter a budget reference value to limit the transactions selected for pricing to only transactions that are associated with this budget reference value. Budget references can identify unique budgets, when individual budgets share budget keys and overlapping budget periods. |
Product |
Enter a product to limit the transactions selected for pricing to only transactions that are associated with this product. The product ChartField captures additional information that is useful for profitability and cash flow analysis by product sold or manufactured. |
Affiliate |
Enter an affiliate code to limit the transactions selected for pricing to only transactions that are associated with this affiliate code. Affiliate codes are used to map transactions between business units when you use a single interunit account. |
Fund Affiliate |
Enter a fund affiliate code to limit the transactions selected for pricing to only transactions that are associated with this fund affiliate code. Use fund affiliate codes to correlate transactions between funds when you use a single intraunit account. |
Operating Unit Affiliate |
Enter an operating unit affiliate to limit the transactions selected for pricing to only transactions that are associated with this operating unit affiliate. Use operating unit affiliates to correlate transactions between operating units when you use a single intraunit account. |
Access the Rate Sets - Target page (Setup Financials/Supply Chain, Product Related, Project Costing, Pricing Structure, Rate Sets, Target).
Note. The system supports the use of wildcards (the percent symbol) but does not support the use of partial wildcards (alphanumeric characters in combination with the percent symbol).
The ChartField values that you define for the source row on the Rate Sets page appears on the Rate Sets - Target page for reference.
You can associate each source row with multiple target rows.
Variance Pricing
For variance pricing, on the Rate Sets – Target page you define the target rates that the system uses to calculate indirect costs, and access the Rate Variance History page to enter new rates for the target rows. The rate that is the most current and active rate is used to price the target row. You maintain variance pricing rates on the Rate Variance History page.
The Sequence Number and History columns appear in the Define Target Rows grid when you activate the Enable Variance option on the Rate Sets page.
Access the Rate Plans page (Setup Financials/Supply Chain, Product Related, Project Costing, Pricing Structure, Rate Plans, Rate Plans).
Rate Plan Type |
Select the rate plan type for this rate plan. Available values are: Standard: Select to create a rate plan that is generally available for pricing any contract line associated with any contract type. Note. Selecting the standard rate plan type automatically populates the Rate Set Type field as Standard. You cannot overwrite this value. Contract: Select to create a rate plan that is used to price a particular contract line. By selecting the contract rate plan type, you can select standard or contract rate set types on the rate plan and create a rate plan that meets the specific need of your contract line by combining contract-specific and standard pricing rates. |
Copy from Rate Plan |
Click to access the Enter New Rate Plan Keys page, where you can copy an existing rate plan to create a new rate plan in the same business unit.
Note. You can copy a standard rate plan to another standard
rate plan. You cannot copy contract-specific rate plans. |
Rate Set Type |
Displays the rate set type (Contract or Standard) from the rate set. For a contract rate plan, enter a rate set type of Contract or Standard for each rate set that you want to add to the rate plan. If you select Contract as the rate set type, you must select a rate set that is associated with the same contract line as the rate plan. For a standard rate plan, the system automatically populates the Rate Set Type field as Standard, and this value cannot be overridden. You can select only standard rate sets for a standard rate plan. |
Rate Set |
Select the rate set to include in your rate plan. You can select rate sets that are defined and active as of the effective date of the rate plan. Enter rate sets the in the order that you want the Pricing process to price the rows. Rate sets are processed in the order that you enter on this page, and only if they have a rate definition type that corresponds to the pricing options that you select on the Pricing run control page. A rate set can appear only once in a rate plan. |
Basis |
Select the basis that tells the Pricing process what source transactions to use to create the target rows for the rate set. Available options are: Original: The system uses the original source transactions to create target rows for the specified rate set. Target: The system uses the target rows that have been created on this rate plan thus far as the basis for creating the target rows for this rate set. All: The system uses all of the original source rows and all of the previously created target rows on the rate plan to create target rows for this rate set. |
Rate Definition Type |
Displays the rate definition type (Billing, Cost, Cost/Billing, or Revenue) from the rate set. The Pricing process can price transactions for costs, billing, revenue, or any combination based on the options that you select on the Pricing run control page. |
Review Rate Set |
Click the rate set description to access the Rate Sets page and view or modify the rate set. |
This section discusses how to:
Enter price variances.
Run the Variance Pricing process.
Review results from the Variance Pricing process.
Page Name |
Definition Name |
Navigation |
Usage |
Rate Variance History |
PC_VP_HISTORY |
Set Up Financials/Supply Chain, Product Related, Project Costing, Pricing Structure, Rate Sets, Target Click the History link on the Rate Sets – Target page. |
View and enter variance price rates. |
Variance Pricing |
PC_VAR_PRICING |
Project Costing, Utilities, Variance Pricing |
Run the Variance Pricing process on selected rate sets. |
Variance Pricing Review |
PC_VP_REVIEW |
Project Costing, Utilities, Variance Pricing Review |
Approve or delete rows before they are inserted in the project transaction table (PROJ_RESOURCE). |
Access the Rate Variance History page (Set Up Financials/Supply Chain, Product Related, Project Costing, Pricing Structure, Rate Sets, Target. Click the History link on the Rate Sets – Target page).
Access the Variance Pricing page (Project Costing, Utilities, Variance Pricing).
Use this page to run the Variance Pricing process for:
All rate sets that have Enable Variance selected on the Rate Sets page.
Target variance rate amounts with a pending status.
Contracts with an open or pending processing status.
Contracts, projects, and activities that use the rate definition on this run control page.
Note. To avoid generating duplicate transactions when multiple users are processing Variance Pricing, it is recommended that users select the Requires Variance Approval check box. This allows an opportunity to review the Variance Pricing transactions before sending them to the Project Costing transaction table.
Option |
Select All, Business Unit, Business Unit/Project, or Business Unit/Project/Activity. The selection in this field determines whether the Business Unit, Project, and Activity fields appear on the page. |
Date Option |
Select All, Accounting Date, or Transaction Date. The selection in this field determine the field used to determine the date ranges of the source transactions. |
Rate Processing Option |
Select Rate Category, Rate Plan, or Rate Set. The selection in this field determines whether the Rate Category, Rate Plan, and Rate Set fields appear on the page and whether the Effective Date field is enabled. If Rate Category or Rate Set is selected in this field, then all rate sets (within a rate plan) that are associated with the selected rate set, or rate category, will be processed by the Variance Pricing process. |
Rate Category, Rate Plan, or Rate Set |
Depending on the selection in the Rate Processing Option field, this field label will display Rate Category, Rate Plan, or Rate Set. All active rate categories, plans, and sets that have a rate set with the Enable Variance option selected are available for selection. Select the value for which you want to run variance pricing. The system evaluates transaction from all open contracts, projects and activities that are associated with the selected option. |
Effective Date |
Select the effective date of the option selected in the Rate Set or Rate Plan field. Available options are based on the effective dated rows that are defined on rate plan or rate set page. The Variance Pricing process uses the rate amounts from the selected effective date, in conjunction with the source transaction date. If this field is left blank, then all effective dated rate changes are processed. |
Variance Pricing Option |
Select Correction or Normal. This option determines the system source that is applied to the target rows when running the Variance Pricing process. Select Correction to indicate that the process should use the same system source that the Pricing process uses. This option should be used when you want the Variance Pricing rows to appear to be regular pricing rows. Select Normal to indicate that the system uses PRV for all rows. |
Description |
Enter a description that is applied to the new transaction rows that the Variance Pricing process creates for this run control. If left blank, then the description is not overwritten. Leave the field blank to use the rate target description. If you do not enter a description and there is no rate target description, then no description appears on the new rows that are created. |
Accounting Date Option |
Select the accounting date to apply to transactions that the Variance Pricing process creates. Options are:
|
Requires Variance Approval |
Select to indicate that Variance Pricing rows are not immediately inserted into the project transactions table (PROJ_RESOURCE). If selected, transactions are written to the variance pricing review table (PC_VP_REVIEW) and you must approve or delete the transactions using the Variance Pricing Review page. After approving selected transaction on the Variance Pricing Review page, you must click the Process Transactions button (on the Variance Pricing Review page) to send the approved transactions to PROJ_RESOURCE. If not selected, transactions are written directly to the project transactions table (PROJ_RESOURCE). |
Purge Existing Pending Approval |
This field is available only when the Requires Variance Approval option is selected. Select to indicate that the Variance Pricing process should delete all existing rows that are currently in the variance pricing review staging table (PC_VP_REVIEW) before inserting new rows. If not selected, then old rows are not deleted from the review table and you could potentially have duplicating rows, depending on your run control options. |
Run Pricing/ Repricing |
Select to indicate that the Pricing process should automatically run after the Variance Pricing rows have been created. If selected, then all other fields in the Pricing Options group box are available. If not selected, then the Pricing process is not automatically run after the Variance Pricing process. |
Reprice Rows |
This field is available only when the Run Pricing/Repricing option is selected. Select to indicate that the Pricing process should reprice rows after the Variance Pricing process completes. |
Price Unpriced Rows |
This field is available only when the Run Pricing/Repricing option is selected. Select to indicate that the Pricing process should price unpriced rows after the Variance Pricing process completes. |
Recalculate Tiered Pricing |
This field is available only when the Run Pricing/Repricing option is selected. Select to indicate that the Pricing process should recalculate tiered pricing after the Variance Pricing process completes. |
Cost, Billing, and Revenue |
This field is available only when the Run Pricing/Repricing option is selected. Select to indicate that the Pricing process should use the selected rate type when running after the Variance Pricing process completes. If the Separate Billing and Revenue option is selected on the Installation Options - Contracts page, then all three check boxes are available. Otherwise, only Billing and Cost are available. |
Note. To avoid overlapping processes from running at the same time, only one Variance Pricing process, using the same parameters in these fields, can run at the same time: Business Unit, Project, Activity, and Rate Processing Option.
The Variance Pricing process completes these steps:
Updates the target variance rate sequence row to active
Updates the rate amount and sequence number on the Rate Sets - Target page with the new active target variance row.
Prices rows eligible for Variance Pricing based on the new rate amount.
Creates new transaction rows with the system option selected in the Variance Pricing Option field.
(Optional) Reprices rows eligible for repricing based on the new rate amount and prices any new, unbilled, or unbooked transactions using the new rate.
Repricing cannot occur on any transaction rows that are created as a result of Variance Pricing.
Access the Variance Pricing Review page (Project Costing, Utilities, Variance Pricing Review).
Transactions appear on this page if you selected the Requires Variance Approval check box on the Variance Pricing run control page. The transactions are stored in a staging table called PC_VP_REVIEW.
Use this page to approve or delete transaction rows prior to inserting them into the project transaction table (PROJ_RESOURCE).
Selection Parameters
In the Selection Parameters section, the link to the right of the field, such as Activity, Analysis Type, and so on, allow you to select multiple values. The maximum number of values that can be selected for a field is 20.
For Activity, Analysis Type, Source Type, Category, and Subcategory, a single value (selected directly from the Variance Pricing Review page) takes precedence if you also click the link and select multiple values from the Select page.
Variance Pricing Detail
Approval Status |
Select Approved or Delete to indicate the action to which the system should take when you click the Process Transactions button. |
Process Transactions |
Click to process the transaction that have Approved or Delete in the Approval Status field. Approved rows will continue to be processed through the Variance Pricing process and inserted into the project transaction table (PROJ_RESOURCE). Delete rows are deleted from the PC_VP_REVIEW table. However, if you rerun the Variance Pricing process using the same parameters, then rows that were previously deleted may reappear on this page. Rows with no value in the Approval Status field remain in the variance pricing review table (PC_VP_REVIEW). However, if you rerun the Variance Pricing process with the same run control parameters, duplicate rows are added to the variance pricing review table. This is because Variance Pricing does not take the rows that are in the review table into account when generating variance rows. |
This section discusses how to define transaction identifiers.
Page Name |
Definition Name |
Navigation |
Usage |
PC_TRANS_IDENTIFY |
Set Up Financials/Supply Chain, Product Related, Project Costing, Transaction Options, Transaction Identifiers, Transaction Identifiers |
Define transaction identifiers for use in the Tiered Pricing feature. |
|
PC_TIER_TEMPLATE |
Set Up Financials/Supply Chain, Product Related, Contracts, Templates, Tiered Pricing Templates, Tiered Pricing Template |
Define a tiered pricing template that facilitates defining tiered pricing for contract lines. Note. You define tiered pricing templates in the PeopleSoft Contracts system. |
Access the Transaction Identifiers page (Set Up Financials/Supply Chain, Product Related, Project Costing, Transaction Options, Transaction Identifiers, Transaction Identifiers).
This section discusses how to price transaction rows by manually initiating the Pricing process.
Page Name |
Definition Name |
Navigation |
Usage |
PC_PRICING |
Project Costing, Utilities, Pricing, Pricing |
Run the Pricing process to price or reprice transactions. |
Access the Pricing page (Project Costing, Utilities, Pricing, Pricing).
Transaction Detail |
Click to access the Transaction List page to view the transactions. |
Application Options
Reprice Rows |
Select to reprice transactions in the Project Transaction table. You can reprice transactions that have not been sent to GL, have not been billed or sent to PeopleSoft Asset Management, are not linked to an asset, or have not been used for fee calculations in PeopleSoft Contracts. When you reprice rows, the Pricing process calls the Tiered Pricing, Limits, and Sharing processes, in that order. Note. If a cost row generated one or more billing or revenue rows and if any of the rows in the process exist on billing or revenue fee worksheets, none of the other rows that are associated with the original cost row are eligible for repricing. |
Price Unpriced Rows |
Select to price unpriced cost rows in the Project Transaction table that were not previously priced by the Pricing process. Note. You cannot select this option to run the Pricing process if any source transaction row on the run control has been priced for any combination of cost, billing, or revenue. You can, however, select the Reprice Rows option as these source transaction rows are eligible for repricing. |
Select to recalculate quantities that are eligible for tiered pricing if the original tiered pricing agreements change. When you select this option, the system selects the Reprice Rows option because repricing is required to recalculate tiered pricing inception-to-date amounts. Transactions that are already processed by PeopleSoft Billing or PeopleSoft General Ledger are not repriced or adjusted using a different tiered pricing adjustment; however, quantities from the source rows will be included in the correct tier so that the inception-to-date amount reflects these quantities. |
|
Pricing Options |
Select Cost (indirect and direct), Billing, Revenue, or any combination, to tell the system what kind of rows to create from the source transactions. The pricing options correspond to the rate definition types that are assigned to rate sets. The Revenue option is available if you use the Government Contracting feature of PeopleSoft Contracts and select the Contracts installation option to separate billing and revenue rows. Otherwise, the Revenue option is not available for selection. If you choose a run control option of Business Unit, Business Unit/Project, or Business Unit/Project/Activity, the options that appear by default in the Pricing Options group box are based on the pricing options that are selected for the business unit. You can override the business unit default pricing options on the run control page. |
Contract |
Enter a contract ID, if applicable, to provide additional transaction search criteria. |
Contracts Business Unit |
Enter a contract business unit, if applicable, to provide additional transaction search criteria. |
Sold to Customer |
Enter a contract sold to customer, if applicable, to provide additional transaction search criteria. |
Contract Classification |
Enter a contract classification, if applicable, to provide additional transaction search criteria. |
When you use the Pricing page to price or reprice transactions for activities that are associated with fixed fee contract lines, do not enter any contract related information in the Application Options group box. Activities associated with fixed fee contract lines are treated as Project Costing related pricing; therefore, entering contract related information prevents the system from picking up fixed fee data for pricing.
Note. This run control page is used to process transactions from all contract classifications. If you want to initiate the Pricing process for a specific set of contracts, such as government contracts, you must enter search criteria such as project, activity, contract classification, and so on, to identify the transactions to include in this run control.
The Project Team and Activity Team Rate Sheets provide visibility to the standard rates that are associated with each team member. Project managers can select a view to display standard rates by employee, job code, or role.
Note. When the Pricing process prices cost transactions, the rate set dictates which, if any, of the standard rates are used and whether any markup or adjustment is applied to the standard rate.
This section discusses how to:
View project team rates.
View activity team rates.
Page Name |
Definition Name |
Navigation |
Usage |
PC_TEAM_RATES |
Project Costing, Project Definitions, Team, Team Click the Team Rates link on the Project Definitions - Team page. |
View team roles, job codes, project availability dates, and cost and bill rates by employee, project role, and job code for project team members. |
|
PC_ACT_TEAM_RATES |
Project Costing, Activity Definitions, Team, Team Click the Activity Team Rates link on the Activity Definitions - Team page. |
View the cost and bill rates for activity team members by employee, job code, or role. |
See Also
Understanding Pricing Project Costs
Access the Project Team Standard Rate Sheet page (click the Team Rates link on the Project Definitions - Team page).
Project team members appear on this page if you defined a project team role for the member.
View Rates by |
Select Employee, Job Code, or Role to view different project team rates. |
Cost Rate and Bill Rate |
Displays the cost and bill rates associated with the team member and the option that you select in the View Rates by field. The system converts these rates as necessary to the currency of the business unit. |
See Also
Staffing Project and Activity Teams
Access the Activity Team Standard Rate Sheet page (click the Activity Team Rates link on the Activity Definitions - Team page).
View Rates by |
Select Employee, Job Code, or Role to view different activity team rates. |
Cost Rate and Bill Rate |
Displays the cost and bill rates associated with the activity team member and the option that you select in the View Rates by field. The system converts these rates as necessary to the currency of the business unit. |
See Also
Scheduling and Managing Resources