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. | 
Note: Each key field (required fields) must contain data for the record to be considered valid.