Below is a list of mandatory validations that are automatically performed by the program:
Mandatory Validation Name |
Mandatory Validation Process |
Duplicate Between the Validation Database and the Master Database |
This validation compares each record in the given validation table and determines if the record already exists in the master database. |
Duplicate Within the Given Validation Table |
This validation compares each record in the given validation table and determines if there are any duplicate records within the validation table itself. |
Key Field Validation |
This validation determines whether all of the key fields for the given validation table are populated. |
Notes: Each key field must contain data for the record to be considered valid. Any duplicates found are rejected during the mandatory validations.