dim_rate_code


Description

Rate codes (tags) that can be assigned to rates for categorization and filtering purposes.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
rate_code_id int8 19 null
bridge_rate_to_rate_code.rate_code_id erp_v2_bridge_rate_to_rate_code_rate_code_id__erp_v2_dim_rate_code_rate_code_id_fkey_dd41198c328b R

The primary key, represent the id of a rate_code
description varchar 65535 √ null

The Rate Code Description. Defaults to ‘UNKNOWN’ when not provided.
name varchar 255 √ null

The rate code name
color_hex varchar 7 √ null

Hex color code used to visually represent the rate code in UIs (e.g. #FF5733).
active bool 1 √ null

Whether the rate code is currently available for assignment to new rates.
archived bool 1 √ null

Whether the rate code has been permanently archived (kept for history).
last_updated timestamptz 35 √ null

System column. UTC Timestamp at which entry was calculated (lags shortly behind source system).
data_landing_time timestamptz 35 getdate()

System column. UTC timestamp assigned when a table batch is applied on Redshift. It represents warehouse landing order at table-batch granularity, not source event order. Usable to filter for incremental extractions.

Relationships

Close relationships within degrees of separation