Understanding PeopleSoft Grants Implementation
Before you can use PeopleSoft Grants, you must establish the basic information that the system uses in its processing. Most of the implementation procedures are onetime sequences of data entry that provide the system with core information about the institution, professional researchers, and sponsors.
This topic discusses:
PeopleSoft Grants ChartFields.
Commitment control setup steps for PeopleSoft Grants.
Journal Generator setup for PeopleSoft Grants processing.
System-delivered budget items.
Consortium budget item usage.
Activity types.
Analysis types and groups.
Resource types, categories, subcategories, and groups.
Transactions.
Accounting rules.
Integration templates.
Award and project controls.
Locations.
Products.
Billing cycle date ranges.
PeopleSoft Grants delivers these charts of accounts:
Fund
Department
Program
Class
Account
Budget Period
Project/Grant
Statistical Code
Affiliate
Scenario
Note: Configurations to ChartFields require supporting modifications to the PeopleSoft Grants F&A (Facilities and Administration) application engine process (GMFACS), which calculates overhead based on PeopleSoft Project Costing transactions.
This table provides information about these ChartFields:
ChartField Name |
Size |
Valid Values Table |
Required |
Definition |
Reusable |
---|---|---|---|---|---|
Fund FUND_CODE |
5 |
FUND_TBL |
No |
Identifies the fiscal and accounting entity that is established to segregate financial resources. |
Yes |
Department DEPTID |
10 |
DEPARTMENT _TBL |
No |
Indicates who is responsible for or affected by the transaction. |
Yes |
Program PROGRAM_CODE |
5 |
PRGRAM_TBL |
No |
Captures additional information that is used for program accounting. |
Yes |
Class CLASS_FLD |
5 |
CLASS_TBL |
No |
Captures additional information to suit the institution. |
Yes |
Account ACCOUNT |
6 |
GL_ACCOUNT_TBL |
Yes |
Classifies the nature of the transaction. |
Yes |
Budget Period BUDGET_PERIOD |
4 |
BUDGET_PERIOD |
Yes |
Identifies the period of the transaction. |
No |
Project/Grant PROJECT_ID |
15 |
PROJECT_HEADER |
No |
Captures additional information that is used for projects and grants accounting. |
No |
Statistics Code STATISTICS_CODE |
3 |
STAT_TBL |
No |
Captures statistical information, such as full-time equivalents. |
Yes |
Affiliate AFFILIATE |
5 |
AFFILIATE_VW |
No |
Designates a business unit that is used for interunit accounting. |
No |
Scenario SCENARIO |
5 |
SCENARIO_VW |
No |
Identifies which budget version to use. |
No |
You have flexibility in establishing the business unit structure within PeopleSoft Grants. Institution-specific needs drive business-unit structure requirements, so you need to decide which options to use for setting up the business units during implementation.
This table explains the basic steps that you may want to follow to set up commitment control options for PeopleSoft Grants. This list is not a comprehensive procedure for setting up commitment control options.
You can find a more detailed and thorough explanation of the steps in the documentation referenced in the Additional Documentation column of the table:
Step |
Navigation Path |
Additional Documentation |
---|---|---|
Select Grants under the Enable Commitment Control section on the Installed Products page. |
|
|
Define detail ledgers. |
|
|
Define ledger groups. |
|
|
Create parent expense budgets and parent revenue budgets for revenue offset. |
|
|
Specify the ChartFields and calendar that will be used to identify the parent budgets for each RuleSet. |
|
|
Set up excluded account types for the parent budgets. |
|
|
Create child expense budgets and child revenue budgets for revenue offset. |
|
|
Specify the ChartFields and calendar that will be used to identify child budgets for each RuleSet. |
|
|
Set up excluded account types for the child budgets. |
|
|
Associate parent and child revenue budgets. |
|
|
Enter budget journal header information for the parent revenue budget. |
|
|
Enter the transaction lines that make up the journal. |
|
|
Enter budget journal header information for the child revenue budget. |
|
|
Enter the transaction lines that make up the journal. |
|
|
Attach the ledger group to a business unit. |
|
|
Post budget journals to the budget. Click the Finalize button to send the budget to the Project Resource table (PROJ_RESOURCE). |
|
|
Check the budget. |
|
|
Run the F&A process. |
|
See Processing Facilities and Administration Costs and Adjustments. |
The Journal Generator is a program that takes accounting entries from PeopleSoft Grants and formats them into journal entries. The journal entries are then transferred to the appropriate ledger in PeopleSoft General Ledger.
PeopleSoft Grants and PeopleSoft Contracts deliver two accounting entry definitions that the system uses for this process. You cannot edit these definitions:
Accounting Entry Definitions |
Description |
---|---|
GMDEFN |
The system refers to this definition to create journal entries originating from the PeopleSoft Grants F&A process. |
CAPCDEFN |
The system refers to this definition to create journal entries originating from the PeopleSoft Contracts. |
PeopleSoft Grants and PeopleSoft Contracts also deliver two sample journal entry templates that the system uses to summarize accounting entries and creates journals.
Journal Entry Templates |
Description |
---|---|
GM_FA |
The system refers to this journal entry template to summarize accounting entries and creates journals for F&A revenue. |
CA_GM |
The system refers to this journal entry template to summarize accounting entries and creates journals for general award transaction revenue that is stored in the Project Resource table (PROJ_RESOURCE). |
To book revenue to PeopleSoft General Ledger, you must run a series of application engine processes. These processes refer to the delivered Accounting Entry Definition pages to identify accounting entry layouts—specifically, it uses the record and field names to extract data from the Contracts and Projects Accounting Line table (CA_ACCTG_LN_PC) for creating the journal header and lines. Journal Generator then takes these accounting entries and, using the Journal Generator Templates, creates the accounting entries that are booked to PeopleSoft General Ledger.
Sponsoring agencies define the budget items that you are required to use in proposals. The system stores these budget items in a control table with an effective date and status. After you establish budget items in the control table, you can map them to sponsors so that when you prepare a proposal budget for a sponsor, only the mapped items appear in the prompt table.
Note: The system displays all budget items if budget items are not specifically defined for a sponsor. After you define any budget item for a specific sponsor, you can (and must) specifically define all allowable budget items for the sponsor. For form mapping reasons, you want to use the budget items as they are reflected in the following table when the National Institutes of Health (NIH) is the sponsor.
PeopleSoft delivers these budget items:
Value |
Description |
Form |
Form Page |
Sponsor |
---|---|---|---|---|
PERSON |
Personnel — Salary & Benefits |
PHS 398 |
DD |
NIH |
FIXFEE |
Fixed Fee — SBIR/STTR Only |
PHS 398 |
DD, EE |
NIH |
CONSLT |
Consultant Services (Both) |
|
|
NIH |
EQUIP |
Equipment |
|
|
NIH |
SUPL |
Supplies |
|
|
NIH |
TRAVEL |
Travel |
|
|
NIH |
DOTRAV |
Domestic Travel (Map to Travel) |
|
|
NIH |
FOTRAV |
Foreign Travel (Map to Travel) |
|
|
NIH |
INPATI |
In-Patient |
|
|
NIH |
OTPATI |
Out-Patient |
|
|
NIH |
RENO |
Alterations and Renovations |
|
|
NIH |
OTHER |
Other Expenses |
|
|
NIH |
SUB < 25 |
Sub-award Direct < $25,000 |
|
|
NIH |
SUB > 25 |
Sub-award Direct > $25,000 |
|
|
NIH |
SUB <25 F |
Sub-award F&A < $25,000 |
|
|
NIH |
SUB >25 F |
Sub-award F&A > $25,000 |
|
|
NIH |
STPOTH |
Stipends Other |
|
|
NIH |
STPOST |
Stipends — Post Doctoral |
|
|
NIH |
STPPRE |
Stipends Pre-Doctoral |
|
|
NIH |
TUITIO |
Tuition |
|
|
NIH |
TRNTRV |
Trainee Travel |
|
|
NIH |
TRNEXP |
Training-Related Expenses |
|
|
NIH |
Note: PeopleSoft Grants delivers the values in the preceding table as system data. The values map specifically to proposal forms, so you should not modify them.
The budget items SUB<25, SUB>25, SUB<25F, and SUB>25F support the system calculation of the proposal F&A where subrecipient funding is involved. F&A will only be computed on the first 25,000 USD. Multiple budget items exist for subrecipients as these are necessary to provide the needed information in printing subrecipient details on the sponsor forms as well as to correctly compute the F&A.
A primary institution is limited to recovering indirect costs that are related to consortium expenditures for a base amount not to exceed 25,000 USD.
To calculate indirect cost recovery, include the SUB<25 and SUB>25 categories in the organization-defined F&A base types. You should include SUB<25 and SUB>25 in the F&A base types that you use to calculate indirect cost recovery (TDC = Total Direct Cost).
Example 1:
You have established a consortium agreement with a subrecipient for a total of 20,000 USD. Of this amount, 15,000 USD represents direct costs and 5,000 USD represents indirect costs that were incurred by the subrecipient. The primary institution has an indirect cost recovery rate of 50 percent.
PeopleSoft recommends the usage outlined in this table:
Budget Item |
Amount or Percent |
---|---|
SUB<25 |
15,000 |
SUB<25F |
5,000 |
Institution F&A Base Amount |
20,000 |
Institution F&A Rate |
50 percent |
Total Institution Recoverable Costs |
10,000 |
This usage maps to form PHS 398, page HH. Consortium and contractual costs are:
Direct Costs = 15,000 USD.
Indirect Costs = 5,000 USD.
Example 2:
You have established a consortium agreement with a subrecipient for a total of 100,000 USD. Of this amount, 60,000 USD represents direct costs and 40,000 USD represents indirect costs that were incurred by the subrecipient. The primary institution has an indirect cost recovery rate of 50 percent. You can complete this transaction in two ways.
Here is the first way:
Budget Item |
Amount or Percent |
---|---|
SUB<25 |
25,000 |
SUB<25F |
0 |
SUB>25 |
35,000 |
SUB>25F |
25,000 |
Institution F&A Base Amount |
25,000 |
Institution F&A Rate |
50 percent |
Total Institution Recoverable Costs |
12,500 |
Here is the second way:
Budget Item |
Amount or Percent |
---|---|
SUB<25 |
15,000 |
SUB<25F |
10,000 |
SUB>25 |
45,000 |
SUB>25F |
30,000 |
Institution F&A Base Amount |
25,000 |
Institution F&A Rate |
50 percent |
Total Institution Recoverable Costs |
12,500 |
This usage maps to PHS 398 Page HH. Consortium and contractual costs are:
Direct Costs = 60,000 USD.
Indirect Costs = 40,000 USD.
All projects that you create contain activities. Activity types are the labels that identify and group projects in PeopleSoft Grants. If you assign activity types consistently throughout the PeopleSoft Grants system, you can analyze and report on all similar activities across all projects institution wide.
To set up activity types, define the types of activities by which you want to identify and group projects in the PeopleSoft Grants system.
Instructions for setting up activity types appear in the PeopleSoft Project Costing documentation.
Each award is composed, at the most basic level, of resource transactions. Resources contain the quantity and amounts that are associated with each transaction and all of the identifying information that accompanies those costs.
You assign analysis types to individual resources to identify the different types of transactions in PeopleSoft Grants, such as estimated costs, budgeted costs, actual costs, and billed costs.
Multiple resources may be created as a transaction moves through the system.
For example, you may budget 1,000 USD for labor for a project. The actual cost of labor might be 1,500 USD. You may bill for that labor at 1,500 USD. The result would be three resource transactions that recorded the same labor resource as it moved from stage to stage through an award. See the example in the following table:
Analysis Type |
Resource Type |
Amount |
---|---|---|
BUD |
LABOR |
$1,000.00 |
ACT |
LABOR |
$1,500.00 |
BILL |
LABOR |
$1,500.00 |
PeopleSoft Grants delivers the following values as system data. Do not modify them.
CFA (Cost Sharing F&A).
SCH (Scheduled Bill Lines).
SFA (Sponsor F&A).
OFA (Revenue Offset Lines).
WFA (Waived F&A).
To set up analysis types and groups:
Enter descriptions of analysis types (for example, scheduled bill lines).
Create analysis groups.
Enter comments about an analysis group.
Instructions for setting up analysis types and groups appear in the PeopleSoft Project Costing documentation.
Resources in PeopleSoft Grants enable you to track, analyze, and report on all costs, both actual and planned, in awards. Assign resource types to individual resources to identify the purpose of individual transactions.
Resource types can be as general or as specific as you want, depending on your needs. For example, you can create a resource type of Personnel to track total personnel costs in your awards, or you can create resource types of Full-time Labor and Consultant Labor to track overtime and standard labor separately.
Resource categories and resource subcategories enable you to identify resources at a more detailed level.
Thoroughly map out the needs of the organization using resource types, resource categories, resource subcategories, and resource groups before you actually create them.
Resource Types
The following resource types are necessary for the resource groups, reports, and processes that are delivered with PeopleSoft Grants for PeopleSoft Grants to function properly. If you do not implement these resource types, you must configure the features that use them:
AFUDC (AFUDC interest)
DIRCT (direct costs)
LABOR (labor)
MATER (materials)
OVER (overhead)
Resource Groups
The following resource groups are necessary for certain award analyses and processes that are delivered with PeopleSoft Grants for PeopleSoft Grants to function properly. If you do not use the resource types that are delivered with PeopleSoft Grants, you must configure these resource groups or create new ones to be used with the features that use them:
ITEMS (inventory items)
LABOR (total labor)
MATER (total material)
To establish resource types, categories, subcategories, and groups:
Define resource types.
Create resource categories.
Create resource subcategories.
Combine multiple resource types for award analysis and billing.
Add descriptions to resource groups.
Relationships
Resource types, resource categories, and resource subcategories provide you with the flexibility to identify resources in specific ways. In addition, PeopleSoft Grants enables you to define relationships between these fields to control data entry and reduce errors.
You can set relationships between:
Resource types and resource categories.
Resource categories and resource subcategories.
Note: Setting relationships between resource types, categories, and subcategories is optional.
Setup Rules
These rules apply to defining relationships between resource types, categories, and subcategories:
If a resource type and a resource category are related, then when that specific resource type is entered into a resource transaction, you can enter only those resource categories for which a relationship has been defined for that resource transaction.
For example, if you have a resource transaction with a resource type of Labor, you can enter only a resource category that you have defined as relating to labor. The same is true for relationships between resource categories and resource subcategories.
If you don't establish relationships, then the resource category or subcategory that you can enter are not limited.
If you set up relationships between resource types, categories, and subcategories, you must adjust the PeopleSoft Grants business unit definition to account for the dynamic edit tables that the system uses to enforce the relationships.
The relationships can be one-to-one or one-to-many.
You can also relate multiple resource categories to a single resource type or a single resource category to a single resource type.
To relate resource types, categories, and subcategories:
Define relationships between resource types and resource categories.
Define relationships between resource categories and resource subcategories.
Instructions on establishing and relating resource types, categories, and subcategories appear in the PeopleSoft Project Costing documentation.
PeopleSoft Grants uses transaction types (for example, adjustments) and transaction codes to regulate specific kinds of transactions and to define accounting rules.
The system uses accounting rules to translate resource transactions into PeopleSoft General Ledger entries. Transaction types are the foundation of accounting rules. Defining transaction types in a separate table saves time and reduces errors when you define accounting rules.
Standard transactions are transactions that involve moving money from one account to another within the same general ledger business unit. Intercompany transactions involve moving money from an account in one general ledger business unit to an account in another general ledger business unit. Additional transaction lines are required for intercompany (or institution) transactions.
To define transactions:
Define the transaction types that you want to use in accounting rules.
Define transaction codes that you use in accounting rules.
Define accounting rules.
Instructions for setting up transactions appear in the PeopleSoft Project Costing documentation.
You define standard accounting entries or rules for project-based transactions based on a combination of business units, contracts, project types, activities, analysis types, ChartFields, project transaction types, and project transaction codes.
These rules are necessary to process accounting information from project transactions. You can minimize the rules by using a wild card in all the fields except PC Business Unit (projects business unit) and Resource GL Bus Unit (resource general ledger business unit). You can make accounting rules more specific by using additional fields on the page.
For example, a timesheet entry may need pricing for a billable row (analysis type = BIL) and a cost row (analysis type = CST). These two rows may require different accounting entries using two accounting rules: one for BIL, and one for CST. You can copy accounting rules to the various business unit combinations that are defined in the framework by clicking the Copy Accounting Entries To link on the Accounting Rules page and entering the new header criteria.
Instructions for setting up accounting rules appear in the PeopleSoft Project Costing documentation.
Integration templates define the integration between PeopleSoft Grants, PeopleSoft Project Costing, and PeopleSoft General Ledger. Before you can begin to track awards and the costs that are associated with awards, you must define integration templates. They also establish the business units that PeopleSoft Grants assigns to transactions by default.
Assign each new award an integration template.
For example, if the institution has an aerospace research center and an astronomy department, set up a general ledger business unit for each department. Then, set up two integration templates, one for each business unit.
PeopleSoft Grants also uses integration templates to restrict access to general ledger business units. You can post resource transactions for an award only to a general ledger business unit that is specified in the integration template that is assigned to that award.
Note: If you want to prevent users from adding resource transactions to an award, select an integration template for which you have defined no general ledger business units.
Each award must be assigned an integration template.
To set up integration templates:
Define the integration template by selecting
Identify the default business units in PeopleSoft Purchasing and PeopleSoft Asset Management that interact with the awards process in PeopleSoft Grants.
Select
Define the general ledger business unit or units for each integration template.
Select
Instructions for setting up integration templates appear in the PeopleSoft Project Costing documentation.
Here is how award and project controls work in PeopleSoft Grants:
Project types are labels for grouping projects within awards.
Setting up project types and assigning them to awards enables you to analyze all projects of a certain type in relation to one another.
Activity types are the labels that identify an activity in PeopleSoft Grants.
If you assign activity types consistently throughout PeopleSoft Grants, you can analyze and report on all similar activities across all awards institution wide. All awards that you create will contain activities.
Status types are one-character, alphanumeric identifiers that you use to track changes in the status of awards and activities.
You also use status types for defining award events, which are the actual changes in status that require approval. Use the Status Types page to set control actions to limit transactions coming into PeopleSoft Grants from cost feeder applications.
Phase types are used to identify what phase of the award a date can represent when you enter dates in award schedule.
For example, if you create a phase type of cleanup, you can enter a begin cleanup date and an end cleanup date in the award schedule, and track time that is spent specifically on cleanup.
Award events represent a change in the status of an award, a project, or an activity.
For example, a change in the status of a project or an activity from proposed to approved can be defined as an award event that requires approval. An award event can be a change in status between two consecutive status types such as proposed and approved, or two nonconsecutive status types such as proposed and closed. Award events can be an important part of workflow if you have set up workflow within PeopleSoft Grants.
Work breakdown structure is a hierarchical structure that you can use at the activity level to aid in reporting and analyzing similar activities throughout the institution.
The work breakdown structure typically includes several levels, and you can use it to roll up detail values from lower levels. For example, you may want to roll up details about all clinical research for all awards within a business unit for outcome comparisons. Because only a subset of work breakdown structure elements is typically used for a given award, you use Tree Manager to define the tree that contains valid work breakdown structure elements for an award. Each activity that you then add to that award can be associated only with the work breakdown structure elements on that tree.
To establish award and project controls:
Create project types.
Create activity types.
Define the status types that you want to use for awards and activities.
Identify what phase of the award is represented when dates are entered in the award schedule.
Define an award event.
Enter work breakdown structure values.
Instructions for setting up award and project controls appear in the PeopleSoft Project Costing documentation.
When working with proposals and awards, you can specify the address information for each project within a research proposal as well as information about where the research for a project will be conducted. This information maps to Page BB of form PHS 398 as performance sites.
You might also need to specify multiple research performance sites for each activity. Before you can specify the research location information, you must define your locations on the Location Code control table. Select
During implementation, make sure that all of the facilities that you are using to perform research are defined in your PeopleSoft system.
To set up the products that are used for billing purposes, use the Product Definition pages. On these pages, you define the products and services that you use on the contract lines.
For PeopleSoft Grants, you must first set up a product on the Product - Definition page and then select a price type of Rate and a revenue method of As Incurred on the Product - Contracts Options page.
Instructions for defining products appear in the PeopleSoft Contracts and the PeopleSoft Order to Cash Common Information documentation.
The Bill Cycle Schedule page enables you to establish date ranges for a cycle ID. For example, if the cycle ID were monthly, you would define a range of dates for the beginning and end of each month: 01/01/2002 and 01/31/2002; 02/01/2002 and 02/28/2002; and so on.
These values are used in the billing process to indicate the from and to date range that the system sends to the billing header records. Each time the billing process runs, PeopleSoft Grants retrieves the dates based on the maximum date of the "to date" that is less than or equal to the system date.
Instructions for setting up billing cycle date ranges appear in the PeopleSoft Billing documentation.