tbl_probationrating

5 rows


Description

Module: Performance/Confirmation Management - Probation Rating Master Scale
Purpose: Stores the defined rating scale and their specifications used across probation review forms within the organization.
Data: Captures the numeric value (if applicable) and the descriptive meaning (Specification) of each rating level (e.g., Number=4, Specification=“Exceeds Expectations”).
Process Usage:
- Form Population: Used to populate the selectable options for evaluators when scoring performance on a probation review form.
- Standardization: Ensures a consistent and standardized scoring mechanism across all reviews associated with a specific form.
- Linked to a specific form (FormID) for context and the company (CompID) for multi-tenant isolation.
Key Points:
- Rating Definition: Defines the criteria for performance assessment.
- The Number field provides the quantifiable score, while Specification provides the qualitative description.
Business Impact: Ensures fair, consistent, and structured evaluation of employee performance during the crucial probation period.

Columns

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

Primary key
Format: Long (auto-increment)
Used as: Unique identifier for this specific rating level.
formid int8 19 √ null
tbl_formdetail.formid Implied Constraint R

FK: public.tbl_FormDetail.id
Meaning: The ID of the specific probation review form that utilizes this rating scale.
number int4 10 √ null

The quantitative score or numeric value associated with this rating level (e.g., 1, 2, 3, 4, 5).
specification varchar 20 √ null

The descriptive label or meaning of the rating score (e.g., “Outstanding,” “Met Expectations,” “Unacceptable”).
createdby varchar 50 √ null

The user (Employee ID/Username) who created this rating level.
createddate timestamp 29,6 √ null

The date and time the rating level was originally created.
modifiedby varchar 50 √ null

The user (Employee ID/Username) who last modified this rating level.
modifieddate timestamp 29,6 √ null

The date and time the rating level definition was last modified.
compid int8 19 √ null

FK: public.tbl_CompanyDetail.id
Meaning: The ID of the company to which this rating scale belongs.

Indexes

Constraint Name Type Sort Column(s)
tbl_probationrating_pk_tbl_probationrating Primary key Asc ratid

Relationships

Close relationships within degrees of separation