Value Types

Semantic Contract

Definitions

Column	Description
id	Unique identifier.
name	Value type name. Allowed values are Actuals, Budget, LE 3+9, LE 6+6, and LE 9+3.

Value Type	Description
Actuals	Recorded data of what has actually occurred.
Budget	Planned figures for the full fiscal year.
LE 3+9	Forecast based on Q1 actuals plus a projection for the remaining 9 months.
LE 6+6	Forecast based on Q1 + Q2 actuals plus a projection for the remaining 6 months.
LE 9+3	Forecast based on Q1 + Q2 + Q3 actuals plus a projection for the remaining 3 months.

Sample & Implementation

A list of Value Types
id	name
1	actuals
2	budget
3	le3-9
4	le6-6
5	le9-3

CREATE TABLE IF NOT EXISTS value_types (
    id INTEGER PRIMARY KEY,
    name VARCHAR NOT NULL UNIQUE CHECK (name IN ('actuals', 'budget', 'le3-9', 'le6-6', 'le9-3'))
)

Data Format

Field

Type

Dependencies

None.

Semantic Contract

Definitions

Sample & Implementation

Data Format

Dependencies

On this page