Data ValidationSTD_2007v1

Positive Numeric Values Only

Ensures numeric fields that represent quantities, prices, or measurements contain only positive values.

Owner: Unassigned

Updated: 10/31/2025

Business Rule

Negative values in quantity, price, or measurement fields indicate data entry errors or system issues.

Technical Implementation

Implement database constraint: CHECK (value > 0). Add frontend validation before submission.

Examples

Good practices vs common violations

Good Examples

Quantity: 100

Price: 49.99

Weight: 250.5

Poor Examples (Violations)

Quantity: -10

Price: -5.00

Weight: 0

Additional Information

Target Industries

All

Status

active

Local Network

DQ Improvements

Data quality dimensions improved by this standard

Appropriateness

high

The degree to which the format is suitable for use.

Type: prevents

Plausibility

high

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

Type: prevents

Validity

high

The degree to which data values comply with rules.

Type: prevents

Quick Stats

Related KPIs0

DQ Improvements3

Versionv1

API Access

GET /api/standards/positive-numeric-values-only