tbl_okr_check_in

-1 rows


Description

Module: Objectives and key results (OKR)
Purpose: Stores every individual update, or ‘check-in,’ submitted by an employee to report progress on a specific Key Result (KR).
Data: Captures the date, the numeric value reported, the resulting percentage and status, and any accompanying comments or supporting documents (attachments).
Process Usage:
- Progress Tracking: Records the incremental steps taken to achieve a KR.
- The data is used to calculate the current completion status of the parent Key Result, which in turn updates the parent Objective.
- Provides a detailed audit trail of goal progress over the entire OKR cycle.
Key Points:
- Transactional Data: Each record is a time-stamped action (the progress update itself).
- Essential for tracking accountability and transparency in performance management.
Business Impact: Enables real-time visibility into goal achievement and supports structured performance review discussions.

Columns

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

Primary key
Format: Long (auto-increment)
Used as: Unique identifier for this single check-in transaction.
key_result_id int8 19 null

FK: public.tbl_okr_key_results.id
Meaning: The ID of the specific Key Result (KR) this check-in is updating.
check_in_date timestamp 29,6 null

The precise date and time the progress update was submitted by the user.
check_in_value numeric 0 √ null

The actual raw numeric value reported by the user in this single check-in (e.g., 5 for ‘5 more sales’).
check_in_value_percentage float8 17,17 √ null

The percentage completion achieved as a result of applying the check_in_value (how much the KR progressed).
check_in_status varchar 20 √ null

The calculated health status of the KR after this check-in was processed (e.g., ON_TRACK, OFF_TRACK).
comment varchar 1000 √ null

Mandatory or optional narrative provided by the user explaining the progress update or status.
attachments text 2147483647 √ null

JSON or string data containing links or references to files uploaded as evidence for the progress claimed.
is_delete bool 1 √ null

Soft-delete flag: Indicates if this check-in record has been logically deleted/reversed.
createdby varchar 50 √ null
createddate timestamp 29,6 √ null
modifiedby varchar 50 √ null
modifieddate timestamp 29,6 √ null
monthly_check_in_value numeric 0 √ null

The aggregated value of all check-ins submitted within the current month (used for time-bound progress analysis).
check_in_type varchar 50 √ null

The method of check-in (e.g., CUMULATIVE, MONTHLY) or the category of the update.
cumulative_check_in_value numeric 0 √ null

The total accumulated value of the KR after this check-in is applied.

Indexes

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

Relationships

Close relationships within degrees of separation