What is TableSet sharing in PeopleSoft?
TableSet sharing is used in PeopleSoft to share configuration data among various institutions, business units, regulatory regions, and so forth. It is manifested in Prompt Tables that reference the underlying configuration records used in TableSet sharing (i.e. the records that include SetID as one of its key fields).
Table of Contents
What is TableSet in PeopleSoft?
TableSet controls associate business units with record groups and setIDs. Each business unit has its own TableSet control, which is stored on the TableSet Record Group Control table. You can associate a setID for each individual record group to a business unit.

What is a business unit in PeopleSoft?
A business unit (BU) is a required PeopleSoft configuration item that drives security, ledger set-up, and processing. SFS implemented multiple BUs to support the State as a whole, and each agency’s and defined entity’s book of record requirement. Generally, each agency as defined by law has its own BU.
How do I set up a new business unit in PeopleSoft?
Let’s create a channel manual general ledger for business unit TST one go to general ledger journals journal entry create/update journal entries enter business unit TST.
What is record group in PeopleSoft?

A Record Group is a group of related records, keyed by SetID, which define the valid values for one or more fields in PeopleSoft. Related values are keyed with/under a single Record Group. For example, Record Group FS_02 defines edit tables related to Calendars.
What is set control field in PeopleSoft?
A SetID is a key field used to identify set of records (Data Sets) in control tables. Below is a snapshot of department control table DEPT_TBL. In the example shown above, there are four data sets (Record Sets) grouped by the keys in the department table – SHARE, X00, Y00, Z00.
What is Setid?
The Setid is the means by which sets of values are given an identifier. The Setid is generally the topmost key of any table in a PeopleSoft application that does not hold transactions. Setids are managed at the table level (or, actually, at the group of table level).
How do I create a group ID in PeopleSoft?
Creating a group in PeopleSoft HCM involves three steps: Define the population that belongs to the group. Set up group security. Refine dates and other application-specific parameters in individual PeopleSoft applications (if necessary).
What is group build in PeopleSoft?
If you have a shared HR service center model, you can define your organization’s HR representatives and define the employees they serve. The PeopleSoft Group Build function enables you to use simple or advanced criteria to determine the employees assigned to each HR business partner.
What is PeopleSoft security?
PeopleSoft software provides security features, including components and PeopleTools applications, to ensure that your sensitive application data, such as employee salaries, performance reviews, or home addresses, does not fall into the wrong hands.
What is PeopleSoft permission list?
Permission lists are the building blocks of user security authorizations. You typically create permission lists before you create user profiles and roles. When defining permission lists, however, consider the roles and user profiles with which you will use them.
What is primary permission list in PeopleSoft?
PeopleSoft Security Hierarchy
Primary permission lists typically control row level security. For example, in HCM, primary permission lists are used to control access to departments. Row level security gives specific users access to specific data.
How do I give permission to CI in PeopleSoft?
From the PeopleSoft menu tree, navigate to PeopleTools > Security > Permissions & Roles > Permission Lists. Search for the ALLPAGES permission list link. The Permission List component is displayed. Set Full Access for each method of the component interfaces added in the previous step.
What is row level security in PeopleSoft?
Row-Level (Data Permission) Security Views
Using PeopleSoft row-level security views enables you to restrict users from seeing certain rows of data. You can restrict data by: User, by using the OPRID field. Primary permission list, by using the OPRCLASS field.
What is Psoprdefn?
Description. PSOPRDEFN. Stores all operators (users) in the PeopleSoft system. Also stores their employee ID (EMPLID), encrypted password, primary permission list, default navigator home page, process profile permission list and row security permission list.
What is PeopleSoft Psauthitem?
The table PSAUTHITEM is what determines which permission lists have access to what PeopleTools through menus. So you need to know the menu associated with each of the PeopleTools applications: PeopleTools Application.
How do I delete a permission list in PeopleSoft?
Select PeopleTools > Security > Permissions & Roles > Delete Permission Lists. On the search page, locate and select the permission list that you want to delete. The Delete Permission List page appears. Click Delete Permission List.
What is Row Level Data?
Row-Level Security, or RLS, is a security mechanism that limits the records in a SQL Server table based on the current user’s authorization context. This type of security means that the data from the tables are presented based on the user’s identity and the records to which the user has access.
What is row security in PeopleSoft?
Using PeopleSoft row-level security views enables you to restrict users from seeing certain rows of data. You can restrict data by: User, by using the OPRID field. Primary permission list, by using the OPRCLASS field. Row security permission list, by using the ROWSECCLASS field.
What is entitlement table?
This table stores the parsed entitlements of various provisioning policies in the IBM® Security Identity Manager system. This table does not have a primary key constraint.
What is row level access?
Row-Level Security enables you to use group membership or execution context to control access to rows in a database table. Row-Level Security (RLS) simplifies the design and coding of security in your application.
What is entitlement data?
An entitlement is a data structure that contains externalized policy information. An entitlement is policy data or capabilities that is formatted in a way that is usable by a specific application.
What is the difference between role and entitlement?
Roles are a form of digital identity, associated with permissions related to specific applications, defining what the member of the Role can or cannot do with their access. These application specific permissions are referred to as Entitlements, which provide a specific set of privileges, within a specific application.
What is an entitlement table?
What is RBAC and ABAC?
RBAC grants or rejects access based on the requesting user’s role within a company. ABAC takes into account various pre-configured attributes or characteristics, which can be related to the user, and/or the environment, and/or the accessed resource.