tbl_okr_review_master

-1 rows


Description

Module: Objectives and Key results (OKR)
Purpose: Stores the summary and overall status of an employee’s Objective and Key Results (OKR) review cycle.
Data: Contains high-level information like the review period, total tasks, overall weightage, and the current status of each reviewer (Self, M1, M2, HR).
Process Usage:
- A new record is created when an OKR review period starts.
- Used to track the progress of the multi-level review workflow.
- Calculates the final overall review percentage after all steps are complete.
Key Points:
- Acts as the parent record for the tbl_okr_review details.
- Statuses (self_status, m1_status, etc.) govern the workflow flow.
Business Impact: Essential for managing performance review cycles, determining final scores, and feeding into appraisal processes.

Columns

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

Primary key
Format: Long (auto-increment)
Used as: Unique identifier for a specific OKR review cycle record.
template_assign_id int8 19 null

FK: public.tbl_okr_template_assign.id
Meaning: The ID of the assigned OKR template/goals that this review is based upon.
Dependency: Links the review instance back to the employee’s goals.
employee_id varchar 50 √ null

FK: public.tbl_employee.employeeid
Meaning: The employee whose OKRs are being reviewed.
review_frequency varchar 20 √ null

The defined frequency of this review cycle.
Values: MONTHLY, QUARTERLY, HALF_YEARLY, YEARLY.
start_date date 13 null

The official start date of the performance review period (e.g., first day of the quarter).
end_date date 13 null

The official end date of the performance review period (e.g., last day of the quarter).
total_tasks int4 10 √ null

The total number of Key Results (KRs), Questionnaires, Daily Task, Training, Objectives included in this review cycle.
total_weightage float8 17,17 √ null

The sum of weightages of all Key Results (KRs), Questionnaires, Daily Task, Training, Objectives included in this review.
self_status varchar 20 √ null

The current workflow status of the Self-Review stage.
Values: PENDING, COMPLETED, NOT_APPLICABLE.
m1_status varchar 20 √ null

The current workflow status of the Manager 1 (M1) Review stage.
Values: PENDING, COMPLETED, NOT_APPLICABLE.
m2_status varchar 20 √ null

The current workflow status of the Manager 2 (M2) Review stage (if applicable).
Values: PENDING, COMPLETED, NOT_APPLICABLE.
hr_status varchar 20 √ null

The current workflow status of the HR Review stage (Audit/Finalization).
Values: PENDING, COMPLETED, NOT_APPLICABLE.
final_review_percentage float8 17,17 √ null

The final, overall achievement percentage across all Key Results for the period, calculated after the entire review process is completed.
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_review_master Primary key Asc id

Relationships

Close relationships within degrees of separation