How do you set up table- sharing in Peoplesoft?
-
Add the field SETID as a key field to each table you want to share and define a set control field
-
Add the BUSINESS_UNIT and SETID fields as keys to the table you want to share
-
Add the field BUSINESS_UNIT as a key field to each table you want to share and define a set control field
-
Add the SETID field as a key to each table you wish to share
-
Add the BUSINESS_UNIT field as a key to each table you wish to share
Table sharing in PeopleSoft requires adding the SETID field as a key to each shared table and defining a set control field to manage data segmentation across different sets. While BUSINESS_UNIT can be used, SETID with set control field is the primary mechanism for table sharing.
In PeopleSoft, table sharing lets multiple business units or entities share rows in the same table by using a SetID as a key. The correct setup is to add SETID as a key field to each table you want to share, and to define a set control field (which determines which SetID applies, based on business unit or another driving field) — this is the standard PeopleSoft Tree/TableSet Sharing mechanism. Options using BUSINESS_UNIT as the shared key field are incorrect because BUSINESS_UNIT is the set control field that maps to a SetID, not the shared key itself — the actual sharing key is SETID. Options omitting the set control field definition are incomplete.