okr_key_result_custom_fields

-1 rows


Description

Module: Objectives and key results (OKR)
Purpose: Stores the definitions for dynamic, non-standard data fields that are added to the Key Result (KR) entity in the OKR framework.
Data: Captures the field’s name, data type, required status, and any associated lookup list for fields based on a fixed set of values.
Process Usage:
- Form Generation: Used to render organization-specific input fields when an employee creates or edits a Key Result.
- Validation: Enforces mandatory fields (is_required) and data types (field_type).
- Linked to a specific OKR template (template_id) to ensure the custom fields only appear in cycles based on that template.
Key Points:
- Extensibility: Allows for deep customization of the OKR tracking process beyond standard metrics.
- Fields defined here collect extra contextual or supplementary data for each Key Result.
Business Impact: Enables the organization to capture all necessary data points related to Key Result achievement, improving the quality and relevance of goal tracking.

Columns

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

Primary key
Format: Long (auto-increment)
Used as: Unique identifier for this custom field definition.
field_name varchar 255 null

The user-facing label or display name for the custom field (e.g., “Dependency Team,” “Risk Level”).
field_type varchar 255 null

The data type of the field (e.g., TEXT, DROPDOWN).
is_active bool 1 true

Boolean flag: Indicates if this custom field is currently active and available for use in new Key Results.
is_required bool 1 false

Boolean flag: Indicates if the field must be populated when a Key Result is created or updated.
lookup_type_id int8 19 √ null

FK: public.tbl_lookup_type.id (Implied)
Meaning: The ID of the master list/lookup type that provides the selectable values for this field (if it is a dropdown/selection type).
lookup_type_name varchar 255 √ null

The descriptive name of the master list/lookup type used for this field (e.g., “KR_STATUS_OPTIONS”).
description varchar 255 √ null

Additional guidelines, instructions, or detailed context for the user filling out this field.
template_id int8 19 null

FK: public.tbl_okr_template.id
Meaning: The ID of the OKR template to which this custom field definition is attached.
createddate timestamp 29,6 √ null
createdby varchar 50 √ null
modifieddate timestamp 29,6 √ null
modifiedby varchar 50 √ null

Indexes

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

Relationships

Close relationships within degrees of separation