VALIDATE SYSTEM MAX VALUE 1
- Description
-
Verifies that values stored in the database do not exceed the specified maximum values before applying the distribution rules.
- Class
-
com.workbrain.app.modules.budgeting.rules.SystemMaxValueValidationRule
- Condition Class
-
None
- Parameters
-
This rule has the following parameters:
Parameter Description Default Values fcitSales_maxValue Default maximum value in the database for storing sales data. 999999999999.99999999 fcitSales_localizationId Column name on the Worksheet for storing sales data. Sales fcitAhr_maxValue Default maximum value in the database for storing AHR data. 99.99999999 fcitAhr_localizationId Column name on the Worksheet for storing AHR data. AHR fcitPayroll_maxValue Default maximum value in the database for storing payroll data. 99999999999.99999999 fcitPayroll_localizationId Column name on the Worksheet for storing payroll data. Payroll fcitPayrollPct_maxValue Default maximum value in the database for storing payroll percent data. 999.999999999999 fcitPayrollPct_localizationId Column name on the Worksheet for storing payroll percent data. Payroll Percent fcitSph_maxValue Default maximum value in the database for storing sales-per-hour data. 9999999999.99 fcitSph_localizationId Column name on the Worksheet for storing sales-per-hour data. SPH fcitHours_maxValue Default maximum value in the database for storing hours. 9999999999.99999999 fcitHours_localizationId Column name on the Worksheet for storing hours. Hours fcitMinHours_maxValue Default maximum value in the database for storing minimum hours. 9999999999.99 fcitMinHours_localizationId Column name on the Worksheet for storing minimum hours. Min Hours fcitVacHours_maxValue Default maximum value in the database for storing vacation hours. 9999999999.99999999 fcitVacHours_localizationId Column name on the Worksheet for storing vacation hours. Vacation Hours fcitHolHours_maxValue Default maximum value in the database for storing holiday hours. 9999999999.99999999 fcitHolHours_localizationId Column name on the Worksheet for storing holiday hours. Holiday Hours fcitOtherHours_maxValue Default maximum value in the database for storing other non-productive hours. 9999999999.99999999 fcitOtherHours_localizationId Column name on the Worksheet for storing other non-productive hours. Other Hours fcitProdHours_maxValue Default maximum value in the database for storing productive hours. 9999999999.99999999 fcitProdHours_localizationId Column name on the Worksheet for storing productive hours. Productive Hours fcitSalesTrd_maxValue Default maximum value in the database for storing sales trend data. 999999999999.99999999 fcitSalesTrd_localizationId Column name on the Worksheet for storing sales trend data. Sales Trend fcitPyrllTrd_maxValue Default maximum value in the database for storing payroll trend data. 99999999999.99999999 fcitPyrllTrd_localizationId Column name on the Worksheet for storing payroll trend data. Payroll Trend fcitStfReqHrs_maxValue Default maximum value in the database for storing staff requirement hours. 9999999999.99999999 fcitStfReqHrs_localizationId Column name on the Worksheet for storing staff requirement hours. Staff Requirement Hours fcitPrFactor_maxValue Default maximum value in the database for storing the productivity factor. 999999999999.99999999 fcitPrFactor_localizationId Column name on the Worksheet for storing the productivity factor. Productivity Factor fcitVarHrs_maxValue Default maximum value in the database for storing variable hours. 9999999999.99999999 fcitVarHrs_localizationId Column name on the Worksheet for storing variable hours. Variable Hours fcitEvtHrs_maxValue Default maximum value in the database for storing event hours. 9999999999.99999999 fcitEvtHrs_localizationId Column name on the Worksheet for storing event hours. Event Hours fcitVolDrvHrs_maxValue Default maximum value in the database for storing volume-driven hours. 9999999999.99999999 fcitVolDrvHrs_localizationId Column name on the Worksheet for storing volume-driven hours. Volume Driven Hours fcitSchFactor_maxValue Default maximum value in the database for storing the scheduling factor. 9.99999999 fcitSchFactor_localizationId Column name on the Worksheet for storing the scheduling factor. Scheduling Factor fcitSchHrs_maxValue Default maximum value in the database for storing the schedule hours. 9999999999.99999999 fcitSchHrs_localizationId Column name on the Worksheet for storing schedule hours. Schedule Hours fcitMaxHours_maxValue Default maximum value in the database for storing maximum hours. 9999999999.99 fcitMaxHours_localizationId Column name on the Worksheet for storing maximum hours. Max