tbl_okr_review_questionaries

-1 rows


Description

Module: Objectives and Key results (OKR)
Purpose: Stores the individual question, configuration, and multi-rater responses for the qualitative section of an OKR/Performance review.
Data: Each row represents a specific question posed during the review, including the question title, weightage, and the value, percentage, and comments submitted by the employee (Self), M1, M2, and HR.
Process Usage:
- Linked to a main OKR review record to capture non-KR-specific performance data.
- Used to track and compare scores and qualitative feedback across different reviewers.
Key Points:
- Enables a holistic view of performance beyond just Key Result attainment.
- Critical for behavioral and competency assessments.
Business Impact: Provides the qualitative data necessary for final rating calibration and development planning.

Columns

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

Primary key
Format: Long (auto-increment)
Used as: Unique identifier for a single question response in a review.
review_id int8 19 null

FK: public.tbl_okr_review_master.id (or tbl_okr_review.id)
Meaning: The parent OKR/Performance review record to which this set of questions belongs.
index_number int4 10 null

The display order or index of the question within the review form.
question_title varchar 500 null

The text of the question asked during the review (e.g., “Demonstrates strong leadership skills”).
weightage float8 17,17 √ null

The relative importance (weight) assigned to this specific question/area.
answer_type varchar 20 √ null

The format expected for the answer.
Values: e.g., RATING_SCALE, TEXT, BOOLEAN.
self_value numeric 0 √ null

The rating/score value submitted by the Employee (Self) for this question.
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-assessment.
self_comment varchar 1000 √ null

The detailed commentary/justification provided by the employee.
self_attachment varchar 50 √ null

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

The rating/score value 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

The detailed commentary/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 rating/score value 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

The detailed commentary/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 rating/score value submitted by HR (typically for audit/final calibration).
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

The detailed commentary/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

Indexes

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

Relationships

Close relationships within degrees of separation