SET IDs and Tableset Sharing

The SETID is a delivered PeopleSoft table used to label and identify Tablesets. Setids allow Business Units the option of sharing or decentralizing data in the control tables.

1. First a SETID is created and then you can create a Business Unit and link the setID to it.
2. Set ID always needs to be assigned to the Business unit.
3. The setID determines which values in various control tables a business unit has access to. For example, you have created a business unit called ABC, the system required you enter a setID. In this case you can enter DEF as the setID for the business unit - ABC.
4. In PeopleSoft, a Business Unit is an Operation area of an Organization.
5. A business unit is an organizational entity which maintains its own transaction data. Once you define business unit, you will have control tables data that would represent for that business unit.

SET IDs are setup and used to enable Tableset sharing among various control tables like: Department and Location.

A TableSet is a group of rows in a control table that is identified by the same high-level key. A setID is a high-level key that identifies a TableSet. Tablesets and SetIDs are devices that enable you to share - or restrict - information across business units.

For example, with TableSets and SetIDs you can centralize redundant information such a country codes while keeping information such as departments and job codes decentralized. The goal of TableSets and SetIDs is to minimize data redundancy and maintain data consistency.