Gencode Validation Options

Several different validation options or methods are available when setting up generic code tables.  These validations options include

No Validation – In this case, no gencode table is created and the system does not restrict the information that can be entered into the field (or the restriction is based on other factors such as the field type, or program code).

Standard Validation – In this case, a gencode table is set up for the field, and the field must be loaded with one of the values that are defined by the gencode data records (you must load the field and it must be loaded using one of the valid entries from the table data).

Optional Validation – In this case, a gencode table is set up for the field, but the operator has the option of loading the field with one of the values defined by the gencode data records or of leaving the field blank.  This option is enabled by creating a data record with a blank value in older versions of the system and by setting the Blanks allowed indicator in the gencode title record in newer (277+ and VDF) versions of the system.

Mandatory Entry – In this case, a gencode table is created which contains only a title record.  The title record is set up to indicate that data must be entered into the database field but the valid entries for the field are not defined (you must enter data in the field but the data that can be entered is not restricted).  The method used to enable this option depends of the system revision you are running.  In older versions of the system (pre-277 file release), , a gencode title record is created with the appropriate table name and the word "REQUIRED" is loaded into the data 1 field of the record.  In the newer versions of the system (277+ and VDF), the title record contains an Require Operator Data Entry indicator that can be set during creation.

More:

Gencode Record Format