tbl_okr_category

-1 rows


Description

Module: OKR
Purpose: Stores the high-level categories, themes, or strategic pillars (e.g., Finance, Customer Success, Product Innovation) under which organizational and individual Objectives (Os) are classified.
Data: Captures the unique ID and the name of the strategic category.
Process Usage:
- Alignment & Grouping: Used to categorize objectives for better strategic alignment, filtering, and reporting.
- Goal Setting: Provides a standardized list of strategic focus areas when employees and managers create new objectives.
- Reporting: Allows leadership to analyze the distribution of objectives across different strategic areas of the business.
Key Points:
- Master Data: This table is maintained by administrators to define the structure for goal classification.
- It imposes a strategic framework on the OKR creation process.
Business Impact: Ensures all OKRs are relevant to defined strategic priorities and facilitates clearer organizational reporting and alignment.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('tbl_okr_category_id_seq'::regclass)
tbl_okr_training.category_id tbl_okr_training_category_id_fkey C

Primary key
Format: Long (auto-increment)
Used as: Unique identifier for this specific OKR category.
name varchar 255 null

The name of the OKR category (e.g., “Revenue Growth,” “Operational Efficiency,” “People Development”).
createdby varchar 100 √ null
createddate timestamp 29,6 √ null
modifiedby varchar 100 √ null
modifieddate timestamp 29,6 √ null

Indexes

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

Relationships

Close relationships within degrees of separation