okr_key_result_custom_fields_assign

-1 rows


Description

Module: Objectives and key results (OKR)
Purpose: Stores the specific configuration of custom fields that are actively assigned to a particular OKR template assignment or cycle.
Data: This table largely mirrors the okr_key_result_custom_fields master table but links the field definition to an assigned instance of an OKR cycle (assigned_template_id).
Process Usage:
- Runtime Configuration: Used by the application to determine exactly which custom fields should be displayed and validated when an employee is working on a Key Result belonging to the specified assigned template/cycle.
- Immutability: Ensures that even if the master custom field definition changes, the custom fields for an already-assigned OKR cycle remain consistent.
Key Points:
- Assignment Context: The key difference from the master table is the linkage via assigned_template_id.
- Defines the custom data capture for live, in-progress goals.
Business Impact: Provides version control for goal-setting forms, ensuring data integrity within active performance cycles.

Columns

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

Primary key
Format: Long (auto-increment)
Used as: Unique identifier for this assigned custom field instance.
assigned_template_id int8 19 null

FK: ID of the assigned OKR cycle/template record (e.g., public.tbl_okr_template_assign.id).
Meaning: The specific live OKR assignment/cycle to which this custom field definition applies.
field_name varchar 255 null

The display name/label for the custom field in the assigned OKR form.
field_type varchar 255 null

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

Boolean flag: Indicates if this field is active for the current assigned template.
is_required bool 1 false

Boolean flag: Indicates if the field must be completed for KRs in the assigned template.
lookup_type_id int8 19 √ null

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

The descriptive name of the master list/lookup type used for this field.
description varchar 255 √ null

Additional instructions or help text for the user.
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_assign Primary key Asc id

Relationships

Close relationships within degrees of separation