Controlling Data Sets

The system filters the field options available to the user in the transaction components based on the tableset controls you set up. For example, when a user is creating a job data record for a new worker and selects the drop down list for the Job Code field, the system filters the available options by determining the following:

  1. What business unit is this person's job data record in?

    USA

  2. What table controls data for this field (Job Code)?

    JOBCODE_TBL

  3. What record group is that table in?

    HR_02

  4. What set ID is assigned to that record group for this business unit?

    SHARE

  5. What rows in the control table (Job Code Table) are keyed by that set ID?

    1. The system looks only for the job code with the SHARE set ID values.

    2. The system makes available to the user only the rows keyed by the SHARE set ID.

This diagram shows the tableset controls for the USA business unit and illustrates how the system determines which job code values to display for that business unit, as described above:

Retrieving valid control table values for a field based on business unit tableset control setIDs

If the user were accessing a field whose control table was in record group HR_01, the system would display the values keyed by the set ID USA from the corresponding control table. The data the system makes available to the user depends on the set ID specified in the TableSet Control component for the record group that contains the control table the user is accessing.