Value Set — Defaults

Enter values in the Defaults fields only if you are entering new records for basis and destination values.

Default Effective As Of

Enter a default date to use in the Effective As Of field. The default date appears in the detail area after you enter the destination value and exit the row.

If you leave this field blank, you can manually enter the date in the Effective As Of field in the detail area for each record or let the system enter the Column Set Date as the default date.

Pre-Load Unmatched Basis Values

This check box appears on the Revise Value Relationships form only if the basis column value in the Column Set group box has a UDC edit.

Note: If you have entered records in the detail area of this form, click OK to write those records to the F00422 table before you select this check box and click Find. Otherwise, the system will write over the newly entered records.

Select this check box to display the unmatched UDC values for the basis column in the detail area. A UDC value is unmatched if it has not been previously selected for the column set. For example, if you select this check box and the Basis Column (in the header area) contains the data item RP12, the system will display the values for UDC table 00/12 that have not been previously selected for the column set. To add a basis value from the UDC table, enter a value in the Destination Value field of the record and click OK. Then click Find to review the records. If you do not add a basis value, the system does not write a record to the F00422 table if the Destination Value column is blank.

Note: If blanks are allowed for the column set (the Blanks Allowed check box in the header area is selected), select each of the records that you do not want to include in the column set and click Delete.You must delete the records manually; otherwise, the system includes them in the column set (because they are blank) and writes the records to the F00422 table. With the remaining basis values displayed, enter dates in the Effective As Of field. If you leave this field blank, the system uses the date in the Default Effective As Of field as the default when you click OK. If that field is blank, the system uses the date in the Column Set Date field as the default when you click OK.