GitHub
GitHub

Value Types

Value types semantic contract, definition of actual values and different budget dimensions.

Semantic Contract

Definitions

ColumnDescription
idUnique identifier for the period.
nameValue type name. Allowed values are Actuals, Budget, LE 3+9, LE 6+6, and LE 9+3.
Value TypeDescription
ActualsRecorded data of what has actually occurred.
BudgetPlanned figures for the full fiscal year.
LE 3+9Forecast based on Q1 actuals plus a projection for the remaining 9 months.
LE 6+6Forecast based on Q1 + Q2 actuals plus a projection for the remaining 6 months.
LE 9+3Forecast based on Q1 + Q2 + Q3 actuals plus a projection for the remaining 3 months.

Sample & Implementation

A list of Value Types
idname
1actuals
2budget
3le3-9
4le6-6
5le9-3
CREATE TABLE IF NOT EXISTS value_types (
    id INTEGER PRIMARY KEY,
    name VARCHAR NOT NULL CHECK (name IN ('actuals', 'budget', 'le3-9', 'le6-6', 'le9-3'))
)

Data Format

Field

Type

Dependencies

  • None.

On this page

Semantic Contract
Definitions
Sample & Implementation
Data Format
Dependencies