VBS Job Offer Validation Using User-Defined Table (UDT) Value

Summary:

Hi all,

We are looking for guidance on implementing a UDT-based validation in VBS for the Redwood Create/Edit Job Offer page.

We maintain minimum wage rates in a User-Defined Table. The applicable minimum rate is determined by Location + Job + Effective Date.

Our requirement is to compare the Salary Amount entered on the Job Offer against the applicable minimum wage stored in the UDT. If the Salary Amount is below the UDT value, we need to display an Error and prevent the user from proceeding.

Example:

Location: L501862
Job: Busser
Proposed Start Date: 10/01/2026

UDT Minimum Rate: $12.50
Job Offer Salary Amount: $11.50

Expected Result:
Error – Salary Amount is below the applicable minimum wage.