tbl_okr_key_results

-1 rows


Description

Module: Objectives and Key results (OKR)
Purpose: Stores the current, active, and measurable Key Results (KRs) assigned to an employee or department for a specific OKR cycle.
Data: Contains the KR definition, target values, progress tracking metrics (current value, latest check-in), ownership details, and current status.
Process Usage:
- Updated regularly through “check-in” actions by KR owners.
- Used to calculate current achievement percentage and weighted contribution to the overall Objective.
- Feeds data into the formal tbl_okr_review tables at the end of a review period.
Key Points:
- Tracks both the goal configuration and the dynamic progress/status.
- Differentiates between individual and group/departmental KRs.
Business Impact: Provides real-time visibility into performance against strategic goals and enables timely interventions.

Columns

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

Primary key
Format: Long (auto-increment)
Used as: Unique identifier for a specific Key Result instance.
key_result_name varchar 200 null

The detailed name or description of the measurable Key Result.
objective_id int8 19 √ null

FK: public.tbl_okr_objective.id
Meaning: The parent Objective this Key Result is linked to.
department_id int8 19 √ null

FK: public.tbl_department.id
Meaning: The department responsible for achieving this KR.
period_type varchar 20 √ null

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

The date when tracking for this KR began.
end_date date 13 null

The date when tracking for this KR is scheduled to end.
description varchar 1000 √ null

Detailed description or context for the Key Result.
measurement_type varchar 60 √ null

The method used to track progress (e.g., NUMERIC, PERCENTAGE, CURRENCY).
measurement_unit varchar 50 √ null

The unit of measure (e.g., $, %, Count, Hours).
current_value numeric 0 √ null

The starting baseline value for the KR.
target_value numeric 0 √ null

The final target value set for this Key Result.
past_check_in_limit int4 10 √ null

The maximum number of days into the past an owner is allowed to backdate a check-in.
key_result_owners text 2147483647 √ null

JSON array of Employee IDs who are jointly accountable for this KR (used for shared/departmental goals).
weightage float8 17,17 √ null

The weighted contribution of this KR to the overall Objective score.
latest_check_in_by varchar 50 √ null

The Employee ID of the person who submitted the last progress update (check-in).
latest_check_in_value numeric 0 √ null

The quantitative value reported in the latest progress update.
latest_check_in_date timestamp 29,6 √ null

The timestamp of the most recent progress update (check-in).
latest_check_in_percentage float8 17,17 √ null

The calculated achievement percentage based on the latest check-in value (relative to target).
latest_check_in_weighted_percentage float8 17,17 √ null

The calculated percentage contribution of the latest check-in to the overall Objective score (Percentage * Weightage).
latest_status varchar 20 √ null

The current status/health of the KR based on the latest check-in (e.g., ON_TRACK, NOT_STARTED, OFF_TRACK, DROPPED).
is_individual bool 1 √ null

Boolean flag: Indicates if this is an individual KR (true) or a shared/departmental KR (false).
template_field_id int8 19 √ null

FK: public.tbl_okr_template_fields_assign.id
Meaning: The ID of the template field from which this KR was originally assigned/derived.
createdby varchar 50 √ null
createddate timestamp 29,6 √ null
modifiedby varchar 50 √ null
modifieddate timestamp 29,6 √ null
pro_rata_target text 2147483647 √ null

JSON string storing the prorated target values over time (e.g., monthly targets).
is_monthly_review bool 1 √ null

Boolean flag: Indicates if a monthly review/check-in is mandatory for this KR.

Indexes

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

Relationships

Close relationships within degrees of separation