Understanding Column Relationships

For each data relationship, you must define the column pairs that relate to each other in the column set. You use the Column Relationships program (P00421) to define the basis and destination columns by effective date for each column set, as well as specify:

• The sequence in which the column pairs should be read and edited by the Update Data Relationships program (R00422).

• Whether the enforce rule applies to the destination column for the column pair.

• Whether a blank value is allowed in the destination column for the column pair.

The columns for value relationships must have edits at the data dictionary level. For example, assume that the basis column in a data relationship contains the data item RP12 and the destination column contains RP13. When you define basis and destination values for that relationship, you must enter values from UDC table 00/12 and UDC table 00/13, respectively. The basis and destination columns are edited based on the data dictionary rules for the respective data item. If you use the visual assist, the system displays valid codes from those UDC tables only.