SlidingScaleBuckets


Description

Sliding scale billing buckets that define income-based fee structures and payment tiers for agencies that use sliding scale billing based on client financial circumstances.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
pkID int identity 4 null

Primary key - SlidingScaleBuckets unique identifier for each record

Name nvarchar 500 null

Bucket name - Descriptive name of the sliding scale bucket

NumFrom int 4 null

Range start - Starting value for the income or criteria range

NumTo int 4 null

Range end - Ending value for the income or criteria range

Price money 21,4 null

Bucket price - Fee or rate charged for this sliding scale bucket

Indexes

Constraint Name Type Sort Column(s)
PK_SlidingScaleBuckets Primary key Asc pkID

Relationships