tbl_okr_objectives

-1 rows


Description

Module: Objectives and Key results (OKR)
Purpose: Stores the current, live definitions and aggregated progress metrics for all high-level Objectives (O) in the Objectives and Key Results (OKR) framework.
Data: Contains the Objective name, period, ownership, and calculated progress figures (completion percentage, status) derived from the linked Key Results (KRs).
Process Usage:
- Objectives are created manually or from templates, defining the strategic focus.
- The completion_percentage and completion_value fields are periodically updated by the system based on the aggregated progress of the associated Key Results.
Key Points:
- Represents the strategic “What” aspect of the OKR framework.
- Acts as the parent record for multiple Key Result records (tbl_okr_key_results).
Business Impact: Provides the central view for tracking strategic goal achievement across the organization, departments, and individuals.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('tbl_okr_objectives_id_seq'::regclass)
tbl_okr_objectives_history.objective_id fk_tbl_okr_objectives R

Primary key
Format: Long (auto-increment)
Used as: Unique identifier for the live Objective record.
objective_name varchar 200 null

The name or statement of the high-level goal (Objective).
period_type varchar 20 √ null

The duration type for the Objective (e.g., MONTHLY, QUARTERLY, YEARLY).
start_date date 13 null

The official start date for tracking progress on this Objective.
end_date date 13 null

The official end date for tracking progress on this Objective.
description varchar 1000 √ null

Detailed context, rationale, or scope for the Objective.
target_based_on varchar 20 √ null

Defines the rule used to aggregate progress from linked KRs (e.g., based on average completion, or weighted average).
target_value numeric 0 √ null

The ultimate goal target for the Objective (typically 100 or 1.0).
child_target_value numeric 0 √ null

The aggregated value contributed by the linked Key Results toward the Objective’s target_value.
previous_value numeric 0 √ null

The Objective’s completion value from the start of the cycle or the previous review period (baseline).
completion_percentage float8 17,17 √ null

The calculated achievement percentage of the Objective (0.0 to 100.0), derived from the progress of its Key Results.
completion_value numeric 0 √ null

The quantitative completion value achieved for the Objective (e.g., 75.5 if 75.5% complete).
department_id int8 19 √ null

FK: public.tbl_department.id
Meaning: The department to which this Objective primarily belongs.
status varchar 20 √ null

The current health status of the Objective (e.g., ON_TRACK, OFF_TRACK, ACHIEVED).
objective_owners text 2147483647 √ null

JSON data string containing the list of Employee IDs who are jointly accountable for this Objective.
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 Primary key Asc id

Relationships

Close relationships within degrees of separation