tbl_okr_config

-1 rows


Description

Module: OKR
Purpose: Stores the global, tenant-specific settings and rules that govern the Objectives and Key Results (OKR) management process.
Data: Captures critical configuration parameters such as who manages the OKR process (hr_ids), when the annual/company cycle begins, the maximum achievable rating limit, and the weightage given to different reviewers.
Process Usage:
- Process Control: Dictates the fundamental parameters for OKR creation, review timing, and scoring calculations.
- System Limits: The max_final_percentage_limit ensures that final employee OKR scores adhere to organizational rating guidelines (e.g., preventing scores over 100%).
- Assignment: The hr_ids field is used to identify the responsible administrators/HR personnel for OKR oversight.
Key Points:
- Global Settings: These configurations apply organization-wide or to a specific tenant company.
- Flexibility in defining the review structure (reviewer_weightage).
Business Impact: Standardizes the OKR methodology, ensures consistency in performance goal setting, and controls the final scoring outcomes.

Columns

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

Primary key
Format: Long (auto-increment)
Used as: Unique identifier for this specific OKR configuration record (likely only one per tenant).
hr_ids text 2147483647 √ null

A string (likely comma-separated Employee IDs) of the HR personnel or administrators responsible for managing the OKR process end-to-end.
company_cycle_start_month int4 10 √ null

The calendar month number (1-12) when the official company-wide OKR cycle (usually annual) begins.
is_active bool 1 √ null

Boolean flag: Indicates if this specific OKR configuration rule set is currently active and being used by the system.
createdby varchar 50 √ null
createddate timestamp 29,6 √ null
modifiedby varchar 50 √ null
modifieddate timestamp 29,6 √ null
max_final_percentage_limit numeric 5,2 √ null

The maximum allowed percentage limit for an employee’s final, calculated OKR achievement score/rating (e.g., 100.0 or 120.0).
reviewer_weightage text 2147483647 √ null

A JSON or string structure defining the weightage assigned to different reviewers in the final OKR score calculation (e.g., {“Manager”: “60%”, “Self”: “40%”}).

Indexes

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

Relationships

Close relationships within degrees of separation