tbl_okr_objectives_history

-1 rows


Description

Module: Objectives and Key results (OKR) Log
Purpose: Stores an immutable, historical snapshot of an Objective whenever its definition, ownership, status, or calculated progress changes in the main tbl_okr_objectives table.
Data: Captures the Objective name, period, target values, ownership, and key performance metrics (completion percentage, status) at the time of the change event.
Process Usage:
- A new record is created automatically when the parent Objective is updated, typically following a Key Result (KR) check-in or a manual Objective status change.
- Used for auditing goal modifications, analyzing progress trends over the cycle, and historical reporting.
Key Points:
- Immutability: Guarantees a time-stamped history of the Objective’s state.
- Objective Status Tracking: Tracks the Objective’s calculated progress based on its linked KRs over time.
Business Impact: Provides transparency and traceability for strategic goal management throughout the performance cycle.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('tbl_okr_objectives_history_id_seq'::regclass)

Primary key
Format: Long (auto-increment)
Used as: Unique identifier for a single historical snapshot/event.
objective_id int8 19 null
tbl_okr_objectives.id fk_tbl_okr_objectives R

FK: public.tbl_okr_objectives.id
Meaning: The ID of the original live Objective record that this history entry belongs to.
objective_name varchar 200 null

The name or high-level goal statement of the Objective at the time of the event.
period_type varchar 20 √ null

The duration type for the Objective (e.g., MONTHLY, QUARTERLY) at the time of the event.
start_date date 13 null

The start date for the Objective period.
end_date date 13 null

The end date for the Objective period.
description varchar 1000 √ null

Detailed description or context for the Objective at the time of the event.
target_based_on varchar 20 √ null

How the Objective’s progress is calculated (e.g., based on average KR completion, or based on KR weightage).
target_value numeric 0 √ null

The overall target value set for the Objective (often 100 or 1.0).
child_target_value numeric 0 √ null

The aggregated value of the contributing Key Results (KRs) linked to this Objective at the time of the event.
previous_value numeric 0 √ null

The Objective’s completion value prior to the latest update/check-in that created this history record.
completion_percentage float8 17,17 √ null

The calculated achievement percentage of the Objective (aggregated from KRs) after the update was applied.
completion_value numeric 0 √ null

The quantitative completion value of the Objective after the update was applied (usually 0 to 100).
department_id int8 19 √ null

FK: public.tbl_department.id
Meaning: The department responsible for the Objective at this snapshot time.
status varchar 20 √ null

The health/status of the Objective after the update was applied (e.g., ON_TRACK, OFF_TRACK).
objective_owners text 2147483647 √ null

JSON array of Employee IDs who were jointly accountable for this Objective at the time of the event.
createdby varchar 50 √ null
createddate timestamp 29,6 √ null
modifiedby varchar 50 √ null
modifieddate timestamp 29,6 √ null

Indexes

Constraint Name Type Sort Column(s)
pk_tbl_okr_objectives_history Primary key Asc id

Relationships

Close relationships within degrees of separation