Entering Information into Validated Fields

Many fields only accept codes from a defined list of values (LOV). Most codes and their associated descriptions in an LOV are defined on a validation form.

You can access the LOV for a Code/Description field by either clicking the Search button or by double-clicking in the field.

Some validation forms contain more than just the valid codes and their associated descriptions. For example, the Site Code Validation Form (STVSITE) includes address information. When an LOV is called from a specific field, only information that is relevant to the current form is displayed in the LOV.

The code/description lookup feature helps you enter information into validated fields. With this feature you can:

  • Enter a complete code or description
  • Look up a code or description based on a partial entry
  • Display the entire LOV and select a code

If you look up a code/description or display the entire LOV, you can refine your search by entering search criteria or use a drill-down search.

To enter a complete code or description in a field with an LOV:

  1. Enter the full code (for example, A005) or full description (for example, Registration).
  2. Press ENTER. The code and description appear. Depending on the field, the cursor may automatically skip to the next field.

To look up a code or description in a field with an LOV:

  1. Enter as much of the code or description as you know. Use the Oracle wildcard % to represent any number of unspecified characters.

Example:    Enter S% to search for all codes and descriptions that start with “S”.

    1. Press ENTER to display the code and description list.
      • If one match is found, the code and description are returned, and this procedure ends.
      • If more than one match is found, the Search Results window appears with all matches. Continue with step 3.
      • If no matches are found, the auto hint displays an error message. Return to step 1 to enter another code or description.
    2. Scroll (if necessary) to the desired value in the Search Results window and double-click it or press the ENTER key. The window closes, and the selected value is returned to the code field.

 

To display the entire LOVs for a field with an LOV:

  1. Double-click the Code field, or click the Search button.
  2. If more than one form or window is associated with the field, an Option List appears. Click the option that displays the LOV. Otherwise, the LOV appears automatically.
  3. Scroll (if necessary) to the desired value in the LOV and double-click it. The LOV closes, and the selected value is returned to the Code field.

To refine your search within an LOV or Search Results window:

  1. Click the Find field in the LOV or Search Results window and enter your search criteria.
    • Use the Oracle wildcard % to represent any number of unspecified characters.
    • Use the Oracle wildcard _ to represent one occurrence of an unspecified character. You can use both wildcards in the same search string.
      • Examples:
        • Enter A% to search for all codes and descriptions that start with “A”.
        • Enter _AID to search for all four-character codes that end with “AID”.
  2. Click the Find button or press ENTER.
  3. Scroll (if necessary) to the desired value in the LOV and double-click it. The LOV closes, and the selected value is returned to the Code field.

To use a drill-down search in an LOV or Search Results window:

  1. Double-click the Code field, or click the Search button to launch the LOV or Search Results field.
  2. Press the first character of your search string, in this case (M). The list displays all codes that begin with that character.
  3. Press the next character in the string — (A). The list displays all codes that begin with the two characters entered.
  4. Keep adding characters to reduce the list of matches. By pressing the R key we have narrowed our choices down to two.

When you see the code you want, double-click it or press ENTER. The code is returned to the field. Or you could continue pressing characters to reduce the list to one match, which will be automatically returned the code to the field.