Extended Functions of ASF › Defining Column Attributes › Mapping Considerations › Defining Automatic Editing Criteria

Defining Automatic Editing Criteria

Automatic editing can be used to edit and validate data being entered into a table. The following criteria can be defined for automatic editing:

1.Edit Table

An edit table defines a set of valid or invalid values or ranges of values for a column. The edit table is used to validate data added to the column. An edit table can contain either valid or invalid values:

• If the edit table contains valid values, data input in the column is valid only if it is listed in the table.
• If the edit table contains invalid values, data input in the column is valid only if it is not listed in the table.

2.Code Table

A code table defines values for encoding and decoding data. The code table is used to convert data typed in a column to its encoded form for storage and to decode the stored data for display.

Define Edit, Code Tables with IDD

Both edit and code tables must be defined through IDD. You can identify an edit or code table to ASF for a particular column by entering the table names in the Edit Table and/or Code Table field of the Extended Column Definition screen.