tbl_okr_review

-1 rows


Description

Module: Objectives and Key results (OKR)
Purpose: Stores the progress and performance review data for each individual Key Result (KR) within an OKR cycle.
Data: One row represents the review progress for one specific KR for a specific review period, including scores, comments, and attachments from all reviewers.
Process Usage:
- Populated with baseline KR data at the start of the review period.
- Updated incrementally by the employee and various managers as review steps are completed.
Key Points:
- Contains detailed review data for calculating final achievement scores.
- Multiple columns for each reviewer (_value, _percentage, _comment, etc.).
Business Impact: Provides the raw, auditable data used to assess performance against strategic objectives.

Columns

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

Primary key
Format: Long (auto-increment)
Used as: Unique identifier for a single Key Result (KR) review instance.
master_id int8 19 null

FK: public.tbl_okr_review_master.id
Meaning: The parent review cycle record for this detail.
key_result_id int8 19 √ null

FK: public.tbl_okr_key_result.id
Meaning: The specific Key Result this row is reviewing.
field_name varchar 200 null

The name or description of the Key Result.
field_type varchar 20 √ null

The type of KR field/metric.
Values: e.g., OBJECTIVE, KEY_RESULT.
is_self_review bool 1 √ null

Boolean flag: Is a self-review required for this KR?
is_m1_review bool 1 √ null

Boolean flag: Is a Manager 1 (M1) review required for this KR?
is_m2_review bool 1 √ null

Boolean flag: Is a Manager 2 (M2) review required for this KR?
is_hr_review bool 1 √ null

Boolean flag: Is an HR review required for this KR?
review_frequency varchar 20 √ null

The review frequency assigned to this specific KR.
period_type varchar 20 √ null

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

The start date applicable to this KR’s review period.
end_date date 13 null

The end date applicable to this KR’s review period.
measurement_type varchar 60 √ null

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

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

The latest, most up-to-date recorded value/progress achieved against the KR.
target_value numeric 0 √ null

The goal or target value set for this Key Result for the period.
weightage float8 17,17 √ null

The relative importance (weight) of this Key Result to the overall objective/score.
department_id int8 19 √ null

FK: public.tbl_department.id
Meaning: The department associated with the KR (usually the employee’s or objective’s department).
self_value numeric 0 √ null

The final progress value submitted by the Employee (Self).
self_percentage float8 17,17 √ null

The calculated achievement percentage based on the self-submitted value.
self_id varchar 50 √ null

ID of the reviewer (Employee ID) who performed the self-review.
self_comment varchar 1000 √ null

Comments, justifications, or explanations provided by the employee during self-review.
self_attachment varchar 50 √ null

File path/ID for supporting documentation uploaded by the employee.
m1_value numeric 0 √ null

The progress value/score submitted by Manager 1 (M1).
m1_percentage float8 17,17 √ null

The calculated achievement percentage based on M1’s submitted value.
m1_id varchar 50 √ null

ID of the reviewer (Employee ID) who performed the M1 review.
m1_comment varchar 1000 √ null

Comments/feedback provided by Manager 1.
m1_attachment varchar 50 √ null

File path/ID for supporting documentation uploaded by Manager 1.
m2_value numeric 0 √ null

The progress value/score submitted by Manager 2 (M2).
m2_percentage float8 17,17 √ null

The calculated achievement percentage based on M2’s submitted value.
m2_id varchar 50 √ null

ID of the reviewer (Employee ID) who performed the M2 review.
m2_comment varchar 1000 √ null

Comments/feedback provided by Manager 2.
m2_attachment varchar 50 √ null

File path/ID for supporting documentation uploaded by Manager 2.
hr_value numeric 0 √ null

The progress value/score submitted by HR.
hr_percentage float8 17,17 √ null

The calculated achievement percentage based on HR’s submitted value.
hr_id varchar 50 √ null

ID of the reviewer (Employee ID) who performed the HR review.
hr_comment varchar 1000 √ null

Comments/final notes provided by HR.
hr_attachment varchar 50 √ null

File path/ID for supporting documentation uploaded by HR.
createdby varchar 50 √ null
createddate timestamp 29,6 √ null
modifiedby varchar 50 √ null
modifieddate timestamp 29,6 √ null
self_training_id text 2147483647 √ null

ID of any required/suggested training linked during the self-review.
m1_training_id text 2147483647 √ null

ID of any required/suggested training linked during the M1 review.
m2_training_id text 2147483647 √ null

ID of any required/suggested training linked during the M2 review.
hr_training_id text 2147483647 √ null

ID of any required/suggested training linked during the HR review.
measurement_config_id int8 19 √ null

FK: ID of the measurement configuration setup.
reviewer_weightage text 2147483647 √ null

A JSON string or formatted string defining the weightage assigned to each reviewer (e.g., Self: 20%, M1: 60%, HR: 20%).
is_completed bool 1 √ false

Boolean flag: Indicates if the review for this specific KR is fully completed across all required reviewers.
pro_rata_target text 2147483647 √ null

The prorated target value for the period, used for mid-cycle reviews or if the KR started late.
is_monthly_review bool 1 √ null

Boolean flag: Indicates if this specific KR is subject to monthly reviews.

Indexes

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

Relationships

Close relationships within degrees of separation