Field Validation Check List

Date Field Checks

• Assure that leap years are validated correctly and do not cause errors/miscalculations.

• Assure that month code 00 and 13 are validated correctly and do not cause errors/miscalculations.

• Assure that 00 and 13 are reported as errors.

• Assure that day values 00 and 32 are validated correctly and do not cause errors/miscalculations.

• Assure that Feb. 28, 29, 30 are validated correctly and do not cause errors/ miscalculations.

• Assure that Feb. 30 is reported as an error.

• Assure that century change is validated correctly and does not cause errors/ miscalculations.

• Assure that out of cycle dates are validated correctly and do not cause errors/miscalculations.

Numeric Fields

• Assure that lowest and highest values are handled correctly.

• Assure that invalid values are logged and reported.

• Assure that valid values are handles by the correct procedure.

• Assure that numeric fields with a blank in position 1 are processed or reported as an error.

• Assure that fields with a blank in the last position are processed or reported as an error an error.

• Assure that both + and - values are correctly processed.

• Assure that division by zero does not occur.

• Include value zero in all calculations.

• Include at least one in-range value.

• Include maximum and minimum range values.

• Include out of range values above the maximum and below the minimum.

• Assure that upper and lower values in ranges are handled correctly.

Alpha Field Checks

• Use blank and non-blank data.

• Include lowest and highest values.

• Include invalid characters and symbols.

• Include valid characters.

• Include data items with first position blank.

• Include data items with last position blank.