What is tableset sharing?

What is tableset sharing? Explain.

In PeopleSoft we have mainly 2 types of primary buckets for tables: Control tables and transaction tables. Control tables store information related to the org structure of the company and all business rules. Transaction tables store data of employees for daily ongoing business activities. Control tables are mostly driven by SETID. SETID is a high level key that is used to identify a group of rows called table set. SETID is tied to a business unit which is an organizational entity that can maintain its own transaction data. So through the use of SETID, we can expose data from one business unit to the other or keep it restricted to the business unit as applicable. In order to do this, all the control tables are divided into record groups. So when a business unit is created, a row is entered in table set control component for that business unit and for each record group, the SETID for the business unit is defaulted. This is called table set sharing. Based on this setup, when a user goes to transaction page like job data and tries to lookup control table related fields like job or department, user will see those values which are tied to the SETID that users BU is tied to in the table set control setup.
In order to setup a state what is the minimal setup requirement?
In order to setup a state, at a minimum, the country has to be setup....
What are the different action types in PeopleSoft?
Action types are used to access data within the system based on the user and/or the level of security. The four action types available are:...
Different delivered security sets
The different security sets are: - Department, People with jobs, People without jobs, US federal people with jobs, Recruiting job openings and template based hire....
Post your comment