Data ValidationSTD_2020v1

Percentage Field Range Validation

Ensures fields representing percentages contain values between 0 and 100.

Owner: Unassigned

Updated: 10/31/2025

Business Rule

Percentages outside this range indicate calculation errors or data corruption.

Technical Implementation

Database constraint: CHECK (percentage >= 0 AND percentage <= 100). Frontend validation with clear error messages.

Examples

Good practices vs common violations

Good Examples

Efficiency: 85.5%

Margin: 15.2%

Uptime: 99.9%

Poor Examples (Violations)

Efficiency: 150%

Margin: -5%

Uptime: 1000%

Additional Information

Target Industries

All

Status

active

Local Network

DQ Improvements

Data quality dimensions improved by this standard

Validity

high

The degree to which data values comply with rules.

Type: prevents

Plausibility

high

The degree to which data values match knowledge of the real world.

Type: prevents

Quick Stats

Related KPIs0

DQ Improvements2

Versionv1

API Access

GET /api/standards/percentage-field-range-validation