Tableset Sharing

Tableset Sharing

Use tableset sharing to filter prompt table choices based on business rules. In PeopleSoft applications, a large percentage of the tables are keyed with one of two fields:

• Business Unit is the key field for transaction tables.
  
• SetID is the key field for control tables. 

In tableset sharing, a single table can offer different values based on underlying business rules. The prompt table values will have SetID as a high-level key. That key is used to direct data to the appropriate business unit.