SET ID & Table set sharing

Control Tables

> Control Tables are the tables where we store organizational data.

> Control Tables serve as core foundation tables for your organizations's human resources system.

Example :  PS_COUNTRY_TBL

               PS_EARNINGS_TBL

                

 note : The data in the control tables does not change very often .

Transaction Tables 

> Transaction tables store day to day transactions.

> When ever you are adding persons , maintaining job data i.e you are writing to Transaction tables.

> These tables are more frequently updated.

 Example : PS_JOB

               PS_NAMES

               PS_PERSONAL_DATA

Business Unit

> Its a part of an Organization,Institution

> Generally division of Business Units will be done according to business rules,locations.

> All the Business Units in different location will share the part of information from the control tables i.e Table Set

Table Set

> People Tools Enable you to share the data in control tables threw Table Sets

> It enables to select different prompt values for different fields , Data coming from the same source i.e same control table

here same control table offering diff prompt values for different business units

Set Id

> Set Id is a 5 character high level key

> When ever we want to share our table information we will add Set Id to that particular table

Record Groups

> Group of control tables that you want to share with Business Units are known as Record Groups.