tbl_okr_template

-1 rows


Description

Module: Objectives and Key results (OKR)
Purpose: Stores the definitions and core metadata for all reusable Objectives and Key Results (OKR) templates. These templates define the goal structure and period settings before being assigned to employees.
Data: Captures the template name, frequency, duration, custom labels for Objectives and KRs, and the total summary of goals and weightage contained within the template.
Process Usage:
- Templates are created by HR/Admin users to standardize goal-setting across departments or roles.
- Used as the source for creating new, assigned OKR cycles in tbl_okr_template_assign.
Key Points:
- This table holds the template header; the detailed structure (the actual Objectives and KRs) is likely stored in a related detail table.
- Critical for organizational goal alignment and consistent performance management.
Business Impact: Enables scalable and standardized deployment of the OKR framework.

Columns

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

Primary key
Format: Long (auto-increment)
Used as: Unique identifier for the master OKR template.
template_name varchar 200 null

The unique name given to the template (e.g., “Annual Sales Goals 2025,” “IT Quarterly Objectives”).
review_frequency varchar 20 √ null

The frequency at which progress checks/reviews should occur for cycles based on this template (e.g., MONTHLY, QUARTERLY).
period_type varchar 20 √ null

The designated duration type for the template (e.g., YEARLY, QUARTERLY, HALF_YEARLY).
period_range varchar 50 √ null

A text field specifying the template’s standard date range or period (e.g., “Q1”, “FY 2026”).
total_tasks int4 10 √ null

The total number of Objectives and Key Results/tasks contained within this template.
total_weightage float8 17,17 √ null

The sum of the weightage of all goals defined in the template (should typically total 100).
is_delete bool 1 √ null

Soft-delete flag: Indicates if the template is logically deleted and unavailable for new assignments.
createdby varchar 50 √ null
createddate timestamp 29,6 √ null
modifiedby varchar 50 √ null
modifieddate timestamp 29,6 √ null
objective_name_label varchar 200 √ null

The custom label used for the Objective field within cycles created from this template (e.g., “Strategic Priority,” “Goal”).
key_result_name_label varchar 200 √ null

The custom label used for the Key Result field within cycles created from this template (e.g., “Metric,” “Deliverable”).

Indexes

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

Relationships

Close relationships within degrees of separation