tbl_probationcategory

8 rows


Description

Module: Probation Management - Probation Review Category Master
Purpose: Stores the high-level categories or sections used to group and organize questions within a structured employee probation assessment form.
Data: Captures the display name of the category (e.g., “Technical Competence,” “Cultural Fit”), its association with a specific form, and its active status.
Process Usage:
- Form Structuring: Used to group individual tbl_ProbationQuestion records, making the review form logical and easy to navigate.
- Scoring: Categories often represent weighted sections in the final probation score calculation.
- Linked to a list of rating options via probationRatingList (Implied FK).
Key Points:
- Organizational Structure: Defines the dimensions of performance being evaluated during probation.
- Multi-tenant setup via CompID.
Business Impact: Standardizes the framework for evaluating new employee performance, ensuring all key areas are assessed.

Columns

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

Primary key
Format: Long (auto-increment)
Used as: Unique identifier for this assessment category.
probationcatname varchar 100 √ null

The user-friendly display name of the category (e.g., “Quality of Work,” “Teamwork”).
compid int8 19 √ null

FK: public.tbl_CompanyDetail.id
Meaning: The ID of the company to which this probation category belongs.
createdby varchar 200 √ null

The user (Employee ID/Username) who created the category.
modifiedby varchar 200 √ null

The user (Employee ID/Username) who last modified the category.
createddate timestamp 29,6 √ null

The date and time the category was originally created.
modifieddate timestamp 29,6 √ null

The date and time the category definition was last modified.
description varchar 500 √ null
status bool 1 √ false

Boolean flag: Indicates if the category is currently active and available for use in probation forms.
formid int8 19 √ null
tbl_formdetail.formid Implied Constraint R

FK: public.tbl_FormDetail.id
Meaning: The ID of the overall master probation review form that utilizes this category.
weightage varchar 50 √ null
column1 varchar 50 √ null
column2 varchar 50 √ null

Indexes

Constraint Name Type Sort Column(s)
tbl_probationcategory_pk_tbl_probationcategory Primary key Asc probationcatid

Relationships

Close relationships within degrees of separation