tbl_okr_template_questionaries

-1 rows


Description

Module: Objectives and key results (OKR)
Purpose: Stores the detailed list of questions that compose a specific OKR Review Questionnaire Template, defining the content, expected response type, and scoring weight for each question.
Data: Captures the question text, its sequential order (index_number), its scoring weight, and the allowed answer format (e.g., RATING, TEXT).
Process Usage:
- Template Definition: Used by HR/Admin to define the structured content of the review form.
- Provides the source data for creating the active review forms when an OKR cycle is launched.
Key Points:
- Question Content: This table defines what is asked.
- Links to the master questionnaire header via master_id (likely tbl_okr_questionaries_master.id).
Business Impact: Ensures consistent and quantitative scoring during the OKR performance review process.

Columns

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

Primary key
Format: Long (auto-increment)
Used as: Unique identifier for this specific question within the template.
master_id int8 19 null

FK: public.tbl_okr_questionaries_master.id
Meaning: The ID of the parent master questionnaire template this question belongs to.
index_number int4 10 null

The display order or sequence number of the question within the template.
question_title varchar 500 null

The full text or title of the question to be presented in the review form.
weightage float8 17,17 √ null

The numerical weight assigned to this question for calculating the overall review score.
answer_type varchar 20 √ null

The required format of the response (e.g., RATING_SCALE, FREE_TEXT, YES_NO).
is_delete bool 1 √ null

Soft-delete flag: Indicates if this question has been logically deleted from the master template.
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_template_questionaries Primary key Asc id

Relationships

Close relationships within degrees of separation