tbl_okr_template_assign

-1 rows


Description

Module: Objectives and Key results (OKR)
Purpose: Stores the current, active record for an OKR template assigned to a specific employee for a defined performance cycle.
Data: Contains the cycle dates, overall template details (name, weightage), the assignee, and the multi-step approval/review status.
Process Usage:
- Initiates an OKR cycle for an employee.
- Tracks the sequential sign-off status (Self, M1, M2, HR) of the assignment/review process.
Key Points:
- Represents a single, live OKR cycle for one employee.
- Crucial for managing the workflow and status of performance reviews.

Columns

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

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

The name of the OKR template assigned (e.g., “Annual Sales Goals”).
review_frequency varchar 20 √ null

The frequency of formal progress reviews for this cycle (e.g., QUARTERLY, ANNUALLY).
period_type varchar 20 √ null

The duration type of the OKR cycle (e.g., YEARLY, HALF_YEARLY).
start_date date 13 null

The start date of the performance cycle.
end_date date 13 null

The end date of the performance cycle.
assignee varchar 50 √ null

FK: public.tbl_employee.employeeid
Meaning: The Employee ID to whom this OKR template is assigned.
total_tasks int4 10 √ null

The total count of objectives and key results/tasks included in this assigned template.
total_weightage float8 17,17 √ null

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

Soft-delete flag: Indicates if the assignment has been logically deleted or cancelled.
createdby varchar 50 √ null
createddate timestamp 29,6 √ null
modifiedby varchar 50 √ null
modifieddate timestamp 29,6 √ null
assign_approval bool 1 √ false

Boolean flag: True if the initial assignment of the template requires approval by a manager/HR.
self bool 1 √ false

Boolean flag: True if the Self-Review step for this cycle is still pending.
m1 bool 1 √ false

Boolean flag: True if the Manager 1 (M1) review step is still pending.
m2 bool 1 √ false

Boolean flag: True if the Manager 2 (M2) review step is still pending.
hr bool 1 √ false

Boolean flag: True if the HR review/finalization step is still pending.
objective_name_label varchar 200 √ null

The custom label used for Objectives in this assignment (e.g., “Goal Area”).
key_result_name_label varchar 200 √ null

The custom label used for Key Results in this assignment (e.g., “Metric”).
reject_reason varchar 200 √ null

Stores the reason provided if the assignment or review was formally rejected by a reviewer.

Indexes

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

Relationships

Close relationships within degrees of separation