Sharing Trees

To share trees as well as tables and views, complete Tableset Controls 2 in the same way that you did Tableset Controls 1. For example, if PST and CCB want to share one department tree for organizational security and VNB another, you assign the appropriate setID for each value.

Defining Tableset Controls for Trees

To define tableset controls for trees:

  1. Select PeopleTools, and then Utilities, and then Administration, and then TableSet Control in PeopleSoft Pure Internet Architecture.

  2. Enter the name of the set control value for which you want to assign a tableset on the search page.

    For example, we use Company as our set control field, and PST, CCB, and VNB are values that we want to add to the Company table.

    Because you already assigned a default setID in Tableset Controls 1, the system displays the default setID that you assigned to this field value. If you create another tableset for sharing trees, you can change this value.

  3. Specify the tree name.

    Click the prompt button next to the Tree Name field for a list of only the tree definitions with the same set control field (which has SavePostChange PeopleCode that recognizes it as a tableset control field).

    This prompt list comes from a SQL view of tree definitions with those set control fields that have not already been associated with a tree group.

  4. In each tree row, specify the appropriate setID.

  5. Save your changes.

Viewing All Record Definitions Associated With a Set Control

You can view all record definitions that are associated with a set control on the Record Group tab of the TableSet Controls page.

Example of Set Controls

After you set up and define all of your set controls, you can see the results by looking at pages on which you reference codes that are stored in a shared table. For example, on Administer Workforce, Use, Job Data 1 and 2 pages, Account Code is an optional field that is edited against the ACCT_CODE_TBL. In this component, the system identifies the company based on the department to which an employee is assigned. For example, Simon Schumacher is in department 10100, which is associated with the company CCB.

Select the Job Data 2 tab and enter 8001 or Simon Schumacher in the search record dialog box to retrieve a CCB row, for which the company is defined in the department table. Here, you can see that Simon works in department 00001, which identifies him as a CCB employee. If you click the prompt button next to the Account Code field, the system displays only those rows in the Account Code Table that are associated with USA, the setID for CCB.

Alternatively, if you access the job row for Joan Avery, an employee of VNB, and click the prompt button for the same Job Data 2 Account Code field, the system retrieves only values that are associated with CAN, the setID for VNB.