Table: dim_adjustment

Type: Dimension Columns: 5

Description

Adjustment information. The data grain is individual adjustment at the business level.

Columns

Column Name Description
adjustment_id

Unique identifier for the adjustment

business_id

Unique identifier for the business

adjustment

The name of the adjustment

adjustment_type

Indicates whether the fee is for a daily basis or a flat rate (e.g., monthly, weekly, etc.); enumerated: 'Session' or 'Flat Rate'

current_status

Indicates whether the adjustment is currently activate; enumerated: 'Activate' or 'Archived'