Pages

Showing posts with label TableSet Sharing. Show all posts
Showing posts with label TableSet Sharing. Show all posts

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.