Summary

External validation in PayGlobal enables you to validate a PayGlobal field against an external database. This operates in a similar way to internal (PayGlobal) code field validation, where values are matched against existing PayGlobal entities.

For example, Job Codes are checked against records in the Job entity. Instead of looking through local entity records, values can be matched against an external database.

As well as validation, a selective synchronisation can be set up so that if a match is found, fields can be updated with the current information.

The external validation process requires you to establish a connection, and then send an SQL (Structured Query Language) query to search the external database. Validation creates the link between the field value you enter in PayGlobal, and the external database.  PayGlobal then validates and retrieves your data.