Data validation criteria
Data Validation enables you to validate data based on data type or the actual values within the record. You may specify the valid values for a field online or in an external file. Validation processes include alpha, alphanumeric, and numeric data checking. When invalid data is found in any of the fields of a record, a return code of 04 is set indicating that not all data was valid.
The following figure is displayed when you enter:
- Option 3.2 on the Primary Option Menu
- Option 3.2 on the Criteria Menu
- Option 2 on the Data Analysis Tools Menu.
Validation Criteria Screen
-------------------------------------------------------------------------------
File-AID/Data Solutions ------- Validation Criteria ---------------------------
COMMAND ===> SCROLL ===> PAGE
SET 1 OF 1 EMPLOYEE-MASTER-FILE GBL = N SEL = N
---- FIELD LEVEL/NAME ------- -FORMAT- RO --------- PARAMETERS -------------- +
******************************* TOP OF DATA ***********************************
5 EMP-NUMBER 5/AN
5 EMP-LAST-NAME 15/AN
5 EMP-FIRST-NAME 10/AN
5 EMP-MID-INIT 1/AN
5 FILLER 2/AN
5 EMP-TITLE 30/AN
5 EMP-PERSONAL-INFO SYNC 23/GRP
10 EMP-NATL-ID-NUMBER 9/NUM
10 FILLER 1/AN
10 EMP-DATE-OF-BIRTH 6/AN
10 EMP-DOB-REDEF REDEFINES EMP-DATE-OF-BIRTH
10 EMP-DOB-REDEF SYNC 6/GRP
15 EMP-DOB-MM 2/NUM
15 EMP-DOB-DD 2/NUM
Valid RO: TA = Table, LI = List, FM
Commands: SELect, View
Field Descriptions
The following table describes the fields on the Validation Criteria Screen:
Field | Description | |
|---|---|---|
Set | Identifies the set of criteria displayed. | |
01 Level Name | Name of the record file structure from layout. | |
GBL | Specifies whether one or more global fields have been attached to this set of criteria (N or Y). | |
SEL | Specifies whether selection criteria has been attached to this set of criteria (N or Y). | |
FIELD LEVEL/NAME | Name of the field from layout. | |
FORMAT | Length and type of field. | |
RO | Specify a relational operator. Possible values are: | |
TA | Validate using the table list data set. File-AID/Data Solutions displays the Field Validation using Table Dataset screen. | |
LI | Validate using the list data set. File-AID/Data Solutions displays the Field Validation using List screen. | |
FM | Field mask. For more information, see Field Mask. | |
Parameters | File-AID/Data Solutions displays the parameters that you entered on either the Field Validation using Table Dataset or Field Validation using List screen for each field specified for validation. | |
This section provides information about the following topics: