tbl_okr_template_fields

-1 rows


Description

Module: Objectives and Key results (OKR)
Purpose: Stores the master library of all available Objectives and Key Result (KR) definitions that can be selected and configured when creating any specific OKR template.
Data: Contains generic definitions, default targets, and review settings for potential goals/metrics.
Process Usage:
- Acts as the source library from which items are selected and copied into tbl_okr_template_fields_assign for use in a specific template.
- Facilitates the creation and reuse of standardized organizational goals.
Key Points:
- Represents a pool of potential goals, not goals assigned to a template.
- Defines the default properties for objective naming, measurement, and review processes.
Business Impact: Ensures consistency and standardization of goal language and metrics across all OKR templates.

Columns

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

Primary key
Format: Long (auto-increment)
Used as: Unique identifier for a single master Objective/Key Result definition in the library.
template_id int8 19 null

FK: public.tbl_okr_template.id (Likely the parent template ID or a default global template ID)
Meaning: The template, if applicable, that this field master belongs to. May be NULL or a specific system template ID if global.
field_name varchar 200 null

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

Defines the nature or category of the goal/item (e.g., KEY_RESULT, OBJECTIVE, QUESTIONNAIRE).
is_self_review bool 1 √ null

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

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

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

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

The default frequency at which progress on this KR should be formally reviewed.
period_type varchar 20 √ null

The default duration type for the KR (e.g., MONTHLY, QUARTERLY).
period_range varchar 50 √ null

A string or JSON defining the default allowable range or duration for the goal period.
measurement_type varchar 60 √ null

The default method used to track progress (e.g., NUMERIC, PERCENTAGE).
measurement_unit varchar 50 √ null

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

The default initial starting value for the KR (often 0).
target_value numeric 0 √ null

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

The default weightage assigned to this KR/Objective definition.
department_id int8 19 √ null

FK: public.tbl_department.id
Meaning: The department to which this field master is primarily relevant (or NULL if globally relevant).
is_delete bool 1 √ null

Soft-delete flag: Indicates if this master field has been logically removed from the library.
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 default custom label or short name for the Objective.
key_result_name_label varchar 200 √ null

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

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

JSON or string detailing advanced default configuration for the measurement unit.
reviewer_weightage text 2147483647 √ null

A JSON string defining the default weighted contribution of each reviewer’s score.
pro_rata_target text 2147483647 √ null

JSON string storing the default prorated target values over time.
is_monthly_review bool 1 √ null

Default flag: Indicates if a monthly review is required.

Indexes

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

Relationships

Close relationships within degrees of separation