tbl_okr_questionaries_master

-1 rows


Description

Module: Objectives and key results (OKR)
Purpose: Stores the definitions and settings for the standardized performance review questionnaires used to evaluate an employee’s OKR achievements at the end of a cycle (or during check-ins).
Data: Captures the template name, the required reviewers (self, Manager 1, Manager 2, HR), and the total count and weightage of the questions included.
Process Usage:
- Review Setup: Used by administrators to define the structure and scope of the OKR review process.
- Workflow Control: The is_ flags determine the mandatory participants in the multi-rater review workflow.
- Provides the metadata for generating the actual review forms whose questions are stored in a related detail table.
Key Points:
- Standardization: Ensures consistent and structured evaluation criteria across the organization.
- Multi-Rater Support: Configures the 360-degree review components.
Business Impact: Critical for fair and formalized OKR performance measurement and feedback.

Columns

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

Primary key
Format: Long (auto-increment)
Used as: Unique identifier for this OKR review questionnaire template.
template_name varchar 200 null

The unique name given to the review questionnaire template (e.g., “Standard Quarterly OKR Review,” “Mid-Year Assessment Form”).
is_self_review bool 1 √ null

Boolean flag: Indicates if a self-assessment/review is a required component of this template.
is_m1_review bool 1 √ null

Boolean flag: Indicates if the review by the direct reporting manager (M1) is required.
is_m2_review bool 1 √ null

Boolean flag: Indicates if the review by the second-level manager (M2, M1’s manager) is required.
is_hr_review bool 1 √ null

Boolean flag: Indicates if a final review/sign-off by an HR representative is required.
total_questions int4 10 √ null

The total number of questions included in this questionnaire template.
total_weightage float8 17,17 √ null

The sum of the weightage of all questions, used to calculate the final review score (should typically be 100).
is_delete bool 1 √ null

Soft-delete flag: Indicates if the questionnaire template has been logically deleted.
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_questionaries_master Primary key Asc id

Relationships

Close relationships within degrees of separation