Tools - Parameter Analysis

Custom Built Tools and Utilities.

Our lengthy experience has taught us many lessons.  We have automated much of our repeated processes and built tools to facilitate our activities.  More efficient. More accurate.

themed object

Oracle Pension Implementation Services

get in touch


Our on-site delivery model results in better knowledge transfer, greater internal ownership and more successful rollout.


Our resources are the best in the business.  Learn more about our key personnel.


We have custom developed, Oracle Pension-specific tools and utilities that facilitate implementation, testing and maintenance.


Describe the photo or the page it links to

Your "What's New" content includes an image that 'AUTO' scales. No need to resize the image, the CSS style sheet will resize the images for you, once rendered in your web page.



Looking for our blog?  We are in the process of re-deploying our website.  Check back soon to get access to all of the Oracle Pension-related information.


training manual

We have recently delivered a comprehensive technical training program to a large commercial customer.  In addition to customized instruction, this program includes extended training manuals, follow-up exercise sets with answer keys, and a custom training database instance loaded with training data.

Parameter Analysis

Within the PeopleSoft Pension Administration product, business rule parameters are the building blocks of the software implementation. Building a parameter hierarchy is the cornerstone to the utility suite.
This populated utility allows a developer to quickly identify where a parameter is used. This is the most valuable tool in the collection. This allows a developer to avoid changing a parameter and having an unintended or negative impact on the system processes. It also allows a developer to find all the places a change needs to be made, or to trace a parameter with a known problem. It can also help you certify that it is safe to delete a parameter.

How does this utility work? The tool provides a process known as the parameter usage explosion. This process searches for all parameter references and stores them in a format accessible by other utility components and as a tree, accessible by the PeopleSoft tree manager. This process can be re-run after parameter updates are made to re-analyze the hierarchy.

Diagram of how the Parameter Hierarchy is populated

Parameters included in this utility

401(a)17 Parameters
Database Aliases
Auto Assign Aliases (Function Result Aliases)
Actuarial Assumption Sets
Active/Inactive Jobs
Action/Reason Codes
Service Break Definitions
Benefit Plans
Custom Statement Aliases
Consolidated Earnings Definition
Consolidated Hours Definition
Consolidated Contributions Definition
COBOL Modifications
Date Conversion Options
Plan Eligibility Definition
Plan Participation Definition
Service Definition
Vesting Definition
Benefit Eligibility Definition
Final Average Earnings Definition
Cash Balance Definition
Employee Accounts Definition
Social Security Definition
Covered Compensation Definition
Early/Late Adjustment Definition
Death Coverage Definition
Benefit Formula Definition
Employee Paid Benefit Definition
Duration Option
Optional Forms Definition
415 Limits Parameter Definition
Date Alias
Duration Alias
Payroll Earnings Code
Factor Aliases
Function Results
Group Definitions
HR Action/Reason Category
Interest Method
Mortality Rates
Order Plans
Payroll Deduction Code
Projection Method
Date Round Option
Status Code Definition
Service Definition - Elapsed Time
Service Definition - Hours Counting
Service Definition - Hours Equivalence
Payroll Special Accumulator
Spouse Eligibility
Service Schedule
Table Lookup Alias
User Code
SQL View

slide up button