tbl_okr_monthwise_percentage

-1 rows


Description

Module: OKR
Purpose: Stores the planned target or achieved progress percentage for a specific Objective (O) for each month within the active OKR cycle. This enables time-phased tracking and calculation of progress over the quarter or year.
Data: Captures the unique objective ID, the specific month and year, and the corresponding percentage value (either planned weightage or achieved progress).
Process Usage:
- Monthly Progress: Used to aggregate and display the monthly contribution to the overall Objective progress.
- Forecasting/Target Setting: Can be used to store a planned distribution of effort/expected achievement across months (e.g., 20% in Month 1, 30% in Month 2, 50% in Month 3).
- Reporting: Essential for generating graphs and reports that visualize progress trends over time.
Key Points:
- Time-series Data: This table is crucial for time-based analysis of OKR performance.
- Linked directly to the master Objective table via objective_id.
Business Impact: Provides granular visibility into the execution cadence of goals, allowing managers to identify and correct deviations from the plan early.

Columns

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

Primary key
Format: Long (auto-increment)
Used as: Unique identifier for this specific monthly progress record.
objective_id int8 19 null

FK: public.tbl_okr_objective.id (Implied)
Meaning: The ID of the specific Objective (O) this monthly percentage value applies to.
month_year date 13 null

The specific month and year this progress record pertains to (e.g., the first day of the month: 2025-03-01).
percentage_value float8 17,17 √ null

The percentage value associated with the Objective for that month. This could be the planned weightage or the achieved progress for the month.
createdby varchar 50 √ null
createddate timestamp 29,6 √ null
modifiedby varchar 50 √ null
modifieddate timestamp 29,6 √ null

Indexes

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

Relationships

Close relationships within degrees of separation