•Worksheet Validation - The Item Form validates the data using lists of values, date formats, field lengths and some pre-defined field level validation.
•Upload Validation - The upload process will perform the worksheet validation above as well as return any errors when inserting into the interface tables.
•Concurrent Program Validation – When the concurrent programs run they perform validation and any errors or warning messages will be returned to the worksheet.
Data keyed directly into the worksheet (not via the Item Forms) will be validated when it is uploaded. If you wish to check anything before it is uploaded, simply open the form. Alternatively, you can run the upload process in ‘Validate Only’ mode.
