PeopleSoft HCM Setup tables

Business units, tablesets and setIDs

PeopleSoft regulates HRMS system data through the use of business units, tablesets, and setIDs.

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.

• You must define at least one business unit. The BUSINESS_UNIT field is included on all transaction tables.

Tablesets and SetIDs

• 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 as country codes while keeping information such as departments and job codes decentralized. The overall goal of tablesets and setIDs is to minimize data redundancy, maintain data consistency, and reduce system maintenance tasks.
• You must define at least one tableset/setID. The SETID key field is included on all control tables.