Validation routines including range check, character check, length check, type check, format check, presence check, check digit

Set appropriate data types to fields including text, numeric (integer, decimal, currency), date/time, Boolean/logical