Data Relationships Setup

Because of the complexity involved in data relationships setup, system administrators typically set up the data relationships and rules for each table. The system administrator should be responsible for:

• Activating the data relationships functionality for the F0006 and F5201 tables.

• Defining the column relationships between the supported columns for each table.

• Defining the subsequent default values (value relationships) for each column set.

• Determining whether to enforce the default rules for a destination column.

  • If rules are enforced, the destination column is protected from user input in the entry program. If the destination column has a non-blank value, the update program and entry program will overwrite the value with a new value.

  • If rules are not enforced, the destination column is input capable in the entry program. If the destination column has a non-blank value, the update program and the entry application will not overwrite the value with a new value; however, the user will be able to change the value.

• Determining whether to allow blank values in a destination column.

• Updating changes made to existing default rules for destination columns.

This process flow shows the programs that are used to set up data relationships, the data entry programs in which you can view data relationships, and the tables that are updated with data relationships rules:

See also: Setting Up Data Relationships.