tbl_rating_scheme_detail

-1 rows


Description

Module: OKR (Objectives and Key Results)
Purpose: Stores the rating measurement slab details for OKR evaluation schemes.
Process Usage:
- Each OKR rating scheme consists of multiple slabs defining performance measurement ranges.
- Used when calculating employee OKR performance ratings based on numerical or percentage scores.
- Helps in mapping actual performance values to a qualitative rating label (e.g., Excellent, Good, Needs Improvement).
Key Points:
- Each record defines a value range (min–max) with an associated rating label and score.
- Color codes are used to visually represent performance levels in dashboards and reports.
Business Impact:
Provides structured and consistent rating definitions for OKR evaluation, ensuring transparency and standardization in performance measurement.

Columns

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

Primary Key
Format: BIGSERIAL
Usage: Unique identifier for each rating slab within a rating scheme.
scheme_id int8 19 null
tbl_rating_scheme_master.id tbl_rating_scheme_detail_scheme_id_fkey C

Rating Scheme ID
Meaning: References the parent rating scheme from tbl_rating_scheme_master.
Usage: Links each rating detail to its corresponding OKR rating scheme definition.
rating_code varchar 100 √ null

Rating Code
Meaning: Short system code representing the rating (e.g., EXC, AVG, LOW).
Usage: Used internally or in integrations to identify rating slabs.
rating_label varchar 100 √ null

Rating Label
Meaning: Human-readable rating name such as Excellent, Good, Average, etc.
Usage: Displayed in UI and reports to describe the rating level.
min_value numeric 5,2 √ null

Minimum Value
Meaning: Lower boundary of the performance range for this rating slab.
Usage: Defines the minimum score at which this rating becomes applicable.
max_value numeric 5,2 √ null

Maximum Value
Meaning: Upper boundary of the performance range for this rating slab.
Usage: Defines the highest score that qualifies for this rating.
rating_score int4 10 √ null

Rating Score
Meaning: Numeric score or weight assigned to this rating level.
Usage: Used for calculations, aggregations, and analytics in OKR evaluation.
color_code varchar 100 √ null

Color Code
Meaning: UI color value (e.g., HEX or RGB) representing the rating visually.
Usage: Used for visual differentiation in OKR dashboards, charts, and reports.
description text 2147483647 √ null

Description
Meaning: Additional details or interpretation for the rating slab.
Usage: Provides context or explanation of what the rating represents (e.g., performance behavior or expectations).
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_rating_scheme_detail_pkey Primary key Asc id

Relationships

Close relationships within degrees of separation