Peoplesoft HCM Business Unit, SetID, TableSet

This Peoplesoft HCM tutorial explains Business Unit, SetID, TableSet.

Peoplesoft HCM Business Unit, SetID, TableSet

SetID

If you look at the Table fields through Query Manager, you will find many Peoplesoft Tables contain SetID field. Tables that have SetID field include Location, Jobcode, Department, Salary Admin Plan, Employee Class, etc.

SetID is a grouping for Business Unit in order to restrict or grant access to data within a table. If SetID contains only one Business Unit, the SetID is called Physical SetID. If more than one Business Unit, it is called Logical SetID.

When you create a Business Unit, you can assign a default SetID.

tableset_control_3

By creating different SetID, when an employee from U.S. Business Unit selects a location from Prompt Box, only the U.S. locations are available for selection. When an employee of U.K. Business Unit selects location, only U.K. locations are available. It is also possible to create another SetID so that both U.S. and U.K. employees can choose all locations.

Business Unit

According to official definition:

An operational subset of an organization. Business units can be independent legal entities, or organizations that need to segregate their financial data for accounting purposes, or operational centers that segregate their operations for management purposes.

Simply put, it is up to the company to define Business Unit.

TableSet Control

You can also select SetID for Business Unit in TableSet Control

tableset_control_2

TableSet

Tablesets are rows of data in different Tables of the same SetID.

In the below example, each color is a TableSet.

tableset_01

Setup sequence of foundation tables in the implementation

1) Company

2) TableSet ID

3) Business Unit

4) TableSet Control

5) Business Unit Options Default

6) Location Code

7) Department

Outbound References

http://docs.oracle.com/cd/E13053_01/hr9pbr1_website_master/eng/psbooks/hhaf/book.htm?File=hhaf/htm/hhaf04.htm#d0e1605

Wyman W
Wyman is a Business Analyst based in Hong Kong, specialized in creating custom Function and Sub solutions, and is proficient in report automation with Access.

He is also a:
- Microsoft Most Valuable Professional (Excel)
- Microsoft Community Contributor
- Microsoft Office Specialist
- Microsoft Specialist
- Microsoft Technical Associate
- Microsoft Certified Professional
- IBM SPSS Specialist

Leave a Reply

Your email address will not be published. Required fields are marked *