preview__dim_revenue_group


Description

A hierarchical categorization of revenues into a broad main_group and a finer grained sub_group.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
revenue_group_id int8 19 null
fct_revenue_invoice_based.revenue_group_id Implied Constraint R
preview__fct_revenue_invoice_based.revenue_group_id Implied Constraint R

The primary key of this table.
main_group varchar 256 √ null

Categorizing income into 3 broad types: * CHARGES_SALES: positive income of any contracts or services * DEDUCTION: mostly negative income reducing amounts made from CHARGES_SALES * FEES: mostly positive income made from penalties

Additionally UNCATEGORIZED might temporarily appear while new transaction types are being mapped.
sub_group varchar 256 √ null

Categorizing the main_group in finer details:

CHARGES_SALES
  • ADDITIONAL_CHARGE: Additional income related to contracts
  • ADDITIONAL_MODULE: Income of customers booking more modules to their main contract
  • DEPOSIT: Income of deposits (eg bottles)
  • FLAT_FEE: Income of fees, customers have to pay additionally to their main contract
  • MEMBERSHIP_FEE: Income of main contracts
  • REST_PERIOD_CONTRIBUTION: Income of charges made of customers putting their contract into an inactive “idle period”
  • SALE_OF_GOODS_AND_SERVICES: Income of selling a product (see product_name) or service (eg Shower 1x) with no product explicitly set up
  • STARTER_PACKAGE: Income of the initial/setup fee of a contract
DEDUCTION
  • CREDIT: Amount granted to someone, most often because of an illness
  • DEBT_CLAIM_REDUCTION: Amount discounting previous charges
  • DEBT_CLAIM_REVERSAL: Amount cancelling previous charges
  • DERECOGNITION: Loss of previous charges. A customer did not pay and the charge is written off as bad debt. Use this sub_group to measure bad debt in fct_revenue.
  • REFUND_OF_DEPOSIT: Loss of a deposit (eg bottles) being returned
  • VOUCHER_EXPIRATION: Income of a multi-purpose voucher being expired.
FEES
  • BANKING_FEE: Income/Cost of fees related to payments
  • DUNNING_PENALTY_FEE: Income of charges made to a customers not paying on time
  • OTHER_FEE: Income of charges like address-requests or compensations in case of damages
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