tbl_okr_template_fields_assign

-1 rows


Description

Module: Objectives and Key results (OKR)
Purpose: Stores the specific Key Results (KRs) and Objectives that are part of a defined, reusable OKR template.
Data: Each row represents one KR or Objective, detailing its name, labels, target values, review configuration, and weightage.
Process Usage:
- Used when assigning goals to an employee; these records are copied to the live review tables (tbl_okr_review) to start a new cycle.
- Acts as the configuration layer for goal setting, defining what will be measured and how it will be reviewed.
Key Points:
- Defines the multi-rater requirement (is_self_review, is_m1_review, etc.) for each goal.
- Contains all standard goal metadata (measurement type, frequency, weightage).
Business Impact: Provides the structured, standardized content for annual or cyclical performance goals across the organization.

Columns

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

Primary key
Format: Long (auto-increment)
Used as: Unique identifier for a single Objective/Key Result defined within the template.
template_id int8 19 null

FK: public.tbl_okr_template.id
Meaning: The parent reusable OKR template this goal is associated with.
field_name varchar 200 null

The custom name or description of the specific Key Result (KR).
field_type varchar 20 √ null

Defines the nature or category of the goal/item being assigned.
Values:
- OBJECTIVE / COMPANY_OBJECTIVE / DEPARTMENT_OBJECTIVE: High-level goals set for an individual, department, or the company.
- KEY_RESULT: A measurable metric tied to an Objective.
- QUESTIONNAIRE: A qualitative assessment question.
- DAILY_TASK: A routine or tactical item.
- TRAINING: A mandatory training or development goal.
is_self_review bool 1 √ null

Boolean flag: Is employee self-review required?
is_m1_review bool 1 √ null

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

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

Boolean flag: Is HR review required?
review_frequency varchar 20 √ null

How often the progress on this KR should be formally reviewed (e.g., MONTHLY, QUARTERLY).
period_type varchar 20 √ null

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

The start date for tracking progress on this specific KR.
end_date date 13 null

The end date for tracking progress on this specific KR.
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 initial starting value for the KR (often 0 or the current baseline).
target_value numeric 0 √ null

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

The weightage assigned to this KR, indicating its contribution to the overall goal score.
department_id int8 19 √ null

FK: public.tbl_department.id
Meaning: The department to which this objective/KR is primarily relevant (used for template filtering/assignment).
is_delete bool 1 √ null

Soft-delete flag: Indicates if this goal has been logically deleted from the template.
createdby varchar 50 √ null
createddate timestamp 29,6 √ null
modifiedby varchar 50 √ null
modifieddate timestamp 29,6 √ null
objective_name varchar 200 √ null

The main Objective text to which the Key Result belongs.
objective_name_label varchar 200 √ null

A custom label or short name for the Objective for display purposes.
key_result_name_label varchar 200 √ null

A custom label or short name for the Key Result for display purposes.
measurement_config_id int8 19 √ null

FK: ID of the measurement configuration setup/scale.
measurement_unit_config text 2147483647 √ null

JSON or string detailing advanced configuration for the measurement unit (e.g., range, scale options).
reviewer_weightage text 2147483647 √ null

A JSON string defining the weighted contribution of each reviewer’s score (e.g., M1: 60%, HR: 40%).
pro_rata_target text 2147483647 √ null

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

Boolean flag: Indicates if a monthly review is required for this specific KR.

Indexes

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

Relationships

Close relationships within degrees of separation