Working with System Data Regulation in HRMS

This chapter provides an overview of PeopleSoft HRMS system data regulation, lists prerequisites, and discusses how to:

Click to jump to parent topicUnderstanding PeopleSoft HRMS System Data Regulation

As companies grow larger and more complex, they often need to collect the same type of data across many locations. PeopleSoft business units and setIDs enable you to organize businesses into logical units other than companies and departments and to define how organizational data is shared among these units.

PeopleSoft HRMS system data is regulated through the use of business units, tablesets and setIDs, and tableset sharing. Business units are logical devices that enable you to implement PeopleSoft HRMS based on how your business is organized. Tablesets, setIDs, and tableset sharing are organizational devices that enable you to share – or restrict – the information stored in your HRMS system across business units:

Business Unit

A logical organizational entity.

SetID

A high-level key on many control tables.

TableSet

Set of rows on a control table, grouped by setID, that is available to specific business units.

Click to jump to top of pageClick to jump to parent topicComponents Used to Set Up Business Units and SetIDs

Once you’ve developed your business unit map, use the following components to set up business units and setIDs and to define system defaults based on permission lists or business units:

Component

Location

TableSet IDs component (SETID_TABLE)

PeopleTools, Utilities, Administration, TableSetIDs

Business Unit component (HR_BUSINESS_UNIT)

See Defining Business Units.

Set Up HRMS, Foundation Tables, Organization, Business Unit

Record Groups component (REC_GROUP_TABLE)

PeopleTools, Utilities, Administration, Record Group

Org Defaults by Permission List component (OPR_DEF_TBL_HR)

See Setting Up Primary Permission List Preferences.

Set Up HRMS, Foundation Tables, Organization, Org Defaults by Permission Lst

Business Unit Options Defaults component (BUS_UNIT_OPT_HR)

See Setting Business Unit Defaults.

Set Up HRMS, Foundation Tables, Organization, Business Unit Options Defaults

TableSet Control component (SET_CNTRL_TABLE1)

PeopleTools, Utilities, Administration, TableSet Control

Click to jump to parent topicPrerequisites

Before you implement PeopleSoft HRMS, take a close look at how your business operates and analyze how you want to map your organization’s business structures, practices, and procedures.

You can set up business units and tableset IDs before or after setting up the Installation Table component (INSTALLATION_TBL) and entering companies on the Company component (COMPANY_TABLE). However, you should set up the Installation Table component and Company component before continuing on to the TableSet Control component, Business Unit Options Defaults component, and Org Defaults by Permission List component.

Click to jump to parent topicWorking with Business Units

This section provides an overview of business units and discusses how to determine your business unit structure.

Click to jump to top of pageClick to jump to parent topicUnderstanding Business Units

Business units are logical units that you create to track and report specific business information. Business units have no predetermined restrictions or requirements; they are a flexible structuring device that enable you to implement PeopleSoft HRMS based on how your business is organized.

Business units share processing rules and you can create them at any level of the organization that makes sense and that reflect the needs of your internal human resources departments. If you use the same processing rules across the organization, it may make sense to have a single business unit; if you use different rules in different companies, countries, or functional areas, you may choose to create multiple business units.

Because PeopleSoft HRMS doesn’t offer any predetermined definition for a business unit (as it does for a department and a company), you can implement this organizational level in your PeopleSoft HRMS applications to reflect your own enterprise’s structure. You can share business units across any combination of PeopleSoft Enterprise HRMS, Financials, Manufacturing, and Distribution applications or define them in just one PeopleSoft Enterprise application.

Note. For PeopleSoft HRMS, you must establish at least one business unit.

You have complete control over how you define business units in your PeopleSoft HRMS system, as well as how you use them to facilitate the handling of data in your data organization. For example, you could set up a business unit for each legal entity in your organization, all to be processed by a central human resources department that interfaces with and manages each business unit’s information, workers, and processes. Alternatively, you could set up one business unit for each company, location, or branch office in your enterprise, enabling each unit to manage its own human resources information independently, while sharing data with a central, parent business unit.

While each business unit maintains its own human resources information, your organization can maintain a single, centralized database, reducing the effort of maintaining redundant information for each business unit. More importantly, you can produce reports across business units, enabling you to see the big picture and to compare the finest details.

Centralized data enables analysis and reporting across business units

See Also

Control Tables, Transaction Tables and Prompt Tables

Click to jump to top of pageClick to jump to parent topicDetermining Your Business Unit Structure

Business units offer a flexible structuring device through which you can implement PeopleSoft HRMS based on the way your business is organized. In some organizations, the correspondence between existing structures and the business model is obvious. In other cases, it may take some careful thought and analysis to determine how to set up the business units to best reflect your organizational structure and to best use the exceptional power and capabilities of PeopleSoft HRMS. When deciding how to establish business units for your PeopleSoft HRMS implementation, keep the following points in mind:

Work closely with your PeopleSoft implementation partner early in your design to determine how best to define the business units for your PeopleSoft HRMS system. Every organization has different requirements, and it's not possible to cover all the variables that you might encounter. However, once you’ve identified your business unit structures and made a tentative decision about how many business units you’ll need, take a step back and ask the following questions:

Possible Business Unit Structures

How you define a business unit depends on your industry, statutory requirements, regulatory reporting demands, or how you’ve organized operating responsibilities. Consider the following scenarios:

You can also use a combination of all of these methods, or any other entity or entities that makes sense for your organization. You can have as many business units as you need, although the more business units you establish, the more information you need to maintain. You do, however, need to have at least one business unit in the system.

Business units can represent branches, regions, subsidiaries, functional areas.

Implementing Business Units

While you can implement one business unit for your entire organization, establishing multiple business units can offer important reporting and data control options. Multiple businesses units enable you to:

Note. If you implement PeopleSoft Enterprise Benefits Administration, you can define eligibility rules that determine workers’ benefits eligibility based on their business unit affiliation.

Click to jump to parent topicWorking with TableSets

This section provides overviews of tablesets and discusses how to:

Click to jump to top of pageClick to jump to parent topicUnderstanding Tablesets

To work with tablesets, you need to be able to distinguish between tablesets, setIDs, and tableset sharing:

tableset

A set of data rows in a control table that is identified by the same highlevel key.

setID

The highlevel key that identifies a set of data rows. There are two types of setIDs:

  • Physical SetIDs

    The setID of a business unit (BUSINESS_UNIT = SETID). The rows of data in a physical setID have a one to one relationship with the business unit.

  • Logical SetID

    A logical setID that is generic and determined by business rules other than business unit. Logical setIDs enable you to share rows of data across multiple business units.

tableset sharing

Sharing rows of data in a tableset across business units or limiting rows to a single business unit.

Note. The terms tableset and setID are sometimes used interchangeably. In many cases, this is correct, but it can cause some confusion.

You can define as many tablesets as you like, but the more you create, the more complex tableset sharing becomes. Some organizations need only one tableset.

Note. For PeopleSoft HRMS, you must create at least one tableset and setID.

You always have the same number of setIDs as you have tablesets. For example, the following diagram shows four control tables. Each color represents a setID, and all rows with the same color represent a tableset, for a total of five tablesets:

Tablesets are rows of data identified by a setID.

PeopleSoft Enterprise Human Resources control tables that are keyed according to setID include the:

Tableset Sharing

Tableset sharing enables you to share some or all of your control table data from business unit to business unit, instead of having to enter the same data multiple times. The key to sharing that information is determining which rows of data can be shared across business units, which should be shared across some business units but not others, and which should be restricted.

For example, you can centralize redundant information such as country codes in a setID that is shared while keeping information such as departments and job codes decentralized amongst different setIDs. The goal of tableset sharing is to minimize data redundancy, maintain data consistency, and reduce system maintenance tasks.

Tablesets form the building blocks of your HRMS system. You populate the individual tables in the tableset according to your particular business rules or processing options. You can also mix and match tablesets by updating tableset assignments for a business unit using the TableSet Control component (SETID_TABLE).

You aren’t required to share all tables in a tableset. With PeopleSoft HRMS, you can share any combination of tables with any number of business units, according to your needs. Use the TableSet Control page to identify which data should be shared and how it should be shared for each business unit.

This diagram shows how one tableset is shared across all three business units in an organization for one group of records and, for another group of records, each business unit uses it’s own setID. For the third group of records, one table set is shared for two business units but the third uses the values in another setID:

Table sets can be shared across business units or unique to business units.

See Enterprise PeopleTools PeopleBook: Server Tools

Record Groups and Tableset Sharing

For the purpose of tableset sharing, control tables are divided into record groups. A record group is a set of control tables and views that use the same group of setIDs in the same manner.

Record groups serve two purposes:

A record group can contain a single table or many tables and views. You can update or modify which tables and views are included in each record group by using the Record Group component.

Business Units and SetIDs

When you create a business unit, you must assign to it a setID. You have two options:

Regardless of which option you choose, when you save the business unit the system creates a record in the Tableset Control component for the business unit, populated with every record group in the system, and associates with each record group the setID you selected for the business unit. You can change the setID assignment in the TableSet Control component.

This diagram shows the relationship between setIDs and business units and illustrates the record the system creates for the business unit in the TableSet Control component. You can change some or all of the setID assignments in this component.

Tableset controls determine which tableset a business unit uses for which record group.

Click to jump to top of pageClick to jump to parent topicSetting Up TableSet Sharing

Setting up tableset sharing is easy. Use tableset controls to make data available across business units or restrict to certain business units. Before you set up tableset controls, create:

When you create and save a business unit, the system creates a record in the TableSet Control component for the business unit (the Set Control Value) and populates the setID for each record group with the setID you selected for the business unit. If you want the business unit to have access to the rows in other setIDs for certain record groups, change the default setID to the appropriate setID. This means that a lot of tableset sharing set up is done for you behind the scenes.

Click to jump to top of pageClick to jump to parent topicControlling Data Sets

The system filters the field options available to the user in the transaction components based on the tableset controls you set up. For example, when a user is creating a job data record for a new worker and selects the drop down list for the Job Code field, the system filters the available options be determining the following:

  1. What business unit is this job data record in?

    USA

  2. What table controls data for this field?

    JOBCODE_TBL

  3. What record group is that table in?

    HR_02

  4. What SetID is assigned that record group for this business unit?

    SHARE

  5. What rows in the control table are keyed by that setID?

    The system makes available to the user only the rows keyed by the USA setID.

This diagram shows the tableset controls for the USA business unit and illustrates how the system determines which job code values to display for that business unit:

Tableset sharing process

If the user were accessing a field table that was in record group HR_01, the system would display the values keyed by the setID USA. The data the system makes available depends on the setID specified in the TableSet Control component for the record group containing the table the user is accessing.

Click to jump to top of pageClick to jump to parent topicReferencing Multiple SetIDs

Occasionally, some pages have references to two setIDs. It’s important to understand how the Page Processor works through such a situation when you’re working with setID functionality. This will help you to understand how the system is making decisions about default values in the data record.

Two scenarios exist in PeopleSoft HRMS where a table that is keyed by one setID also has fields that prompt onto another setID table:

Scenario 1: A Control Table with Multiple SetIDs, but No Defaults Based on Those SetIDs

An example of a control table that has multiple setIDs is the Departments component (DEPARTMENT_TBL). The record for the component, DEPT_TBL, has two setIDs: the setID for the department and the setID for the department’s location. The setID for the location prompt comes from the LOCATION_TBL record.

Department Profile page

In a situation where there are two setIDs for a prompt, you can set up the component so that the system makes available in the Location field:

Making all locations available may cause problems if a user creates a department with a location in a setID that is not used by any business unit with access to the department’s setID. Making only one location setID available could cause problems if business units with access to the department’s setID use different location setIDs.

For example, an organization has the following tableset controls set up for its four business units use for the DEPT and LOCATION record groups:

Business Units:

PDEV

EURO

ASIA

RUSS

Record Groups:

DEPT

USA

EURO

USA

EURO

LOCATION

USA

EURO

ASIA

RUSS

Note. Set up tableset controls on the Tableset Controls component.

If you limited the location setID to the set ID of the department, you would not be able to set up departments with a valid location for the ASIA and RUSS business units. If you made all locations in all setIDs available, you run the risk of users creating a department in setID USA with a location in setID EURO.

To limit the locations available to a department, while still accommodating the different tablesharing arrangements, you could limit the location setIDs to USA and ASIA when the department setID is USA and to RUSS and EURO when the department setID is EURO.

Scenario 2: A Transaction Table with Multiple SetIDs Controlling Defaults Across the Transaction Record

An example of a transaction table that has multiple setIDs controlling defaults across the record is the Job Data component (JOB_DATA).

When you create a job data record for someone, you select a business unit on the Work Location page (JOB_DATA1). The system uses the business unit’s tableset controls to determine which values to make available in other fields on the component and when to use established defaults.

The system only displays departments that are in the setID selected for the business unit and defaults in the department’s location only if the location is in a valid setID for the business unit. Locations have associated salary plans, and the system defaults in the location’s salary plan only if the salary plan is in a valid setID for the business unit. If a default value is not in a valid setID for the selected business unit, the system leaves the field blank and the user selects a value from the options in the valid setID.

For example, on the Job Data component, select the business unit. The system references the tableset controls for that business unit to determine the valid setIDs for many of the fields on the component:

Select the business unit, which determines the valid setIDs for many fields on the page.

Select the department. The system only makes available departments in the DEPT setID selected for this business unit:

The system only displays values in the setID selected for this field’s prompt table for this business unit.

The system checks to see if the setID of the location associated with the selected department is valid for this business unit. If yes, the system enters the default location in the Location field. If not, the system leaves the Location field blank:

The system only enters the default value if it is in a valid setID for this business unit.

The system checks to see if the setID of the salary plan associated with this location is valid for this business unit:

The system does not enter the default value if the value’s setID is not valid for the business unit.

Select a Salary Plan that is valid for the business unit:

You can only select a value with a valid setID.

Note. Many of the setID driven control tables enable you to review which business units have access to the selected setID so that, as you set up your control values, you can confirm that they will be available to the appropriate business units.

Click to jump to parent topicWorking with Permissions Lists and System Defaults

This section discusses how to:

Click to jump to top of pageClick to jump to parent topicLinking to Permission Lists

PeopleSoft security is based on building blocks called permission lists. Permission lists grant users access to applications, functionality, menus, data, and so on. Most permission lists are grouped into roles and the roles are granted to users. However, there are four permission lists that control specific aspects of the application that are assigned directly to the user profiles.

One of these permission lists, the primary permission list, determines which default values the system enters for the user (among other things). On the Org Defaults by Permission List component (OPR_DEF_TBL_HR) set up primary permission lists with:

When a user logs onto the system, the system references the user’s primary permission list to determine which settings to apply and which values to enter as defaults on components that support primary permission list defaulting. This helps to ensure that users are entering the right information for the kind of work that they do.

Note. Not all components use the defaults from the primary permission list.

Warning! Not associating system users with permission lists can result in serious data errors in PeopleSoft Human Resources.

See Also

Setting Up and Administering HRMS Security

Enterprise PeopleTools PeopleBook: Security Administration

Click to jump to top of pageClick to jump to parent topicDefining Business Unit HR Defaults

When users access an HCM component, the system populates some of the fields, such as business unit, company, and country using the values you associated with the user’s primary permission list. You can also associate default values with setIDs on the Business Unit Options Default page (BUS_UNIT_OPT_HR).

Using the tableset controls and business unit default options you set up, the system determines the default values to enter in select fields on the transaction component. The system uses these defaults only on components where the system identifies the business unit field as a source for default values.

To set up business unit defaulting:

  1. On the Tableset Control – Record Group page (SET_CNTRL_TABLE1), select the setID that controls business unit defaulting for this business unit.

    This enables you to share defaulting rules across business units.

  2. Enter the setID’s default values on the Business Unit Options Default component.

When a user accesses a component that is driven by business unit defaults and selects a business unit, the system determines which setID drives defaulting for that business unit on the Tableset Control – Record Group page. The system references the Business Unit Options Default component to retrieve the default values you set up for the selected setID and then enters those values in the transaction component. This diagram illustrates this process:

The system determines the defaults for a selected business unit by referencing the tableset controls and the business unit default options.

Note. The record group containing the Business Units Options Default record (BUS_UNIT_OPT_HR) is HR_06.

Setting up business unit defaults on the Business Unit Options Default page makes sense when you have multiple business units that share the same kind of defaults; but shared defaults are not readily organized by permission list.

Click to jump to top of pageClick to jump to parent topicDetermining System Default Values

Most of the page-level defaults in the PeopleSoft HRMS system are based on the primary permission list as opposed to business unit. Business unit defaulting generally only occurs on components that are driven by the business unit or that use EmplID as a high-level key.

This table lists the four most common scenarios in which the system must determine which default values to use, either the defaults that you defined on the Business Unit Options Default component or on the Org Defaults by Permission List component:

On the Component

How the System Determines Defaults

Select a business unit.

The system enters the default values from the Business Unit Default Options component.

Select an EmplID value, but no business unit value.

The system determines the person’s business unit by checking the person's JOB record for that EmplID/ERN combination and then enters the default values from the Business Unit Default Options component.

The component does not have either the Business Unit or EmplID fields.

The system enters the default values from the Org Defaults by Permission List component.

The component uses a setID without an associated business unit or EmplID value. (This is the situation on most setup and control components, such as the Location and Department components.)

The system enters the default values from the Org Defaults by Permission List component.

Warning! The paradigm above isn’t strictly followed in the system and should be used as a guideline only. Actual defaulting at the page level is governed primarily by page functionality.

Note. Some degree of flexibility has been incorporated for exceptions to those pages that don’t fall into either of these categories.

See Also

Enterprise PeopleTools PeopleBook: Security Administration

Enterprise PeopleTools PeopleBook: Data Administration Tools