tbl_rating_scheme_master

-1 rows


Description

Module: Performance/OKR Management - Rating Scheme Master
Purpose: Stores the high-level definitions for various rating scales or evaluation schemes (e.g., 5-point scale, 3-point scale, OKR 0.0-1.0 achievement scale) used across the performance and goal management modules.
Data: Captures the unique name and a descriptive context for each defined rating scheme.
Process Usage:
- Selection: Allows administrators to select and assign a specific rating scheme to different performance reviews, OKR cycles, or employee groups.
- Configuration Linkage: This record serves as the header for a set of detailed rating levels (which would be stored in a related detail table like tbl_rating_scheme_detail).
Key Points:
- Standardization: Enables the organization to use multiple, standardized methods for evaluating performance.
- This table defines the type of scale, not the individual levels (e.g., Excellent, Good).
Business Impact: Ensures flexibility and consistency in performance appraisal and OKR scoring across the entire organization.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('tbl_rating_scheme_master_id_seq'::regclass)
tbl_rating_scheme_detail.scheme_id tbl_rating_scheme_detail_scheme_id_fkey C

Primary key
Format: Long (auto-increment)
Used as: Unique identifier for this specific rating scheme definition.
scheme_name varchar 100 √ null

The unique name given to the rating scheme (e.g., “Standard 5-Point Scale,” “OKR Achievement Score,” “Grit Scale”).
description text 2147483647 √ null

A detailed description or explanation of the rating scheme, its methodology, and its intended use.
is_active bool 1 √ null
createdby varchar 100 √ null
createddate timestamp 29,6 √ null
modifiedby varchar 100 √ null
modifieddate timestamp 29,6 √ null
keyresult_id int8 19 √ null

Indexes

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

Relationships

Close relationships within degrees of separation