GitHub
GitHub

Revenue Changes

Revenue facts on changes, defining price and volume per period, value type, and revenue type.

Facts

Definitions

ColumnDescription
period_idFactual reference to the period (links to periods).
revenue_type_idType of revenue change (links to revenue_types, e.g., New Booking, Upsell).
value_type_idType of value measured (links to value_types, e.g., actuals, budget).
nr_of_customersVolume variable with number of customers contributing to this revenue change.
value_per_customerPricing variable, with revenue per customer for this change.

Sample & Implementation

A list of Revenue Changes
period_id revenue_type_id value_type_id nr_of_customers value_per_customer
1121002300
CREATE TABLE IF NOT EXISTS revenue_changes (
    period_id INTEGER NOT NULL,
    revenue_type_id INTEGER NOT NULL,
    value_type_id INTEGER NOT NULL,
    nr_of_customers INTEGER NOT NULL,
    value_per_customer DOUBLE NOT NULL,
    FOREIGN KEY (period_id) REFERENCES periods(id),
    FOREIGN KEY (revenue_type_id) REFERENCES revenue_types(id),
    FOREIGN KEY (value_type_id) REFERENCES value_types(id),
    PRIMARY KEY (period_id, revenue_type_id, value_type_id)
)

Data Format

Field

Type

The primary key is formed by constrainst on periods, revenue types, and value types:
PRIMARY KEY (period_id, revenue_type_id, value_type_id)

Dependencies

On this page

Facts
Definitions
Sample & Implementation
Data Format
Dependencies