SET ID , BUSINESS UNIT , Transaction table and control table

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.

Control Tables

Control tables store information that is used to process and validate the day-to-day business activities (transactions) users perform with PeopleSoft HRMS applications.

The information stored in control tables is common and shared across an organization, for example, master lists of customers, vendors, applications, items, or charts of accounts. By storing this shared information in a central location, control tables help to reduce data redundancy, maintain data integrity, and ensure that users have access to the same basic information.

The information stored in control tables is generally static and is updated only when fundamental changes occur to business policies, organizational structures, or processing rules.

Note. Control tables are tables that include the SETID key field (setID). As you set up control tables, you’ll notice that it is the setID that enables control table information to be shared across business units.

Few control tables in ps hrms:PAY_PRIOR_ALL,PS_DEPT_TBL

Transaction Tables

Transaction tables store information about the day-to-day business activities (transactions) users perform with PeopleSoft HRMS applications.

The information stored in transaction tables often changes and is updated more frequently than the information stored in control tables.

Few Transaction  tables in ps hrms: PS_HISTORY,PS_HUP_WORK

Note. Transaction tables are tables that include the BUSINESS_UNIT field (which may or may not be used as a key field).