Job Offer Validation Using User-Defined Table (UDT) for Minimum Wage

Summary:

We are looking for guidance on implementing a minimum wage validation on the Redwood Create/Edit Job Offer page using VBS Business Rules. We currently maintain minimum wage rates in a User-Defined Table.

The applicable minimum rate is determined based on:

• Location
• Job / Job Code
• Effective Date

Our requirement is to validate the Salary Amount entered on the Job Offer against the applicable minimum rate in the UDT.

For example:

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

BI_MIN_RATE_ALLOWED returns: $12.50

Salary Amount entered on offer: $11.50

Expected result:
Block the offer and display an error that the salary
is below the applicable minimum wage.