tbl_formdetail

2 rows


Description

*Module: Performance Management System (PMS) - Form Master
Purpose: Stores the configuration details for various performance or review form templates (e.g., Annual Review Form, Probation Review Form).
Data: Defines the form’s name, key terminology (KRA/KPI labels), review flow, and whether weightages are used.
Process Usage:
- Used as a blueprint when initiating a new performance review or probation confirmation review.
- Links to PmsPerspective to define the sections/perspectives within the form.
Key Points:
- Centralizes form design, ensuring consistency across different performance cycles.
- LevelOfAssessment dictates the number of reviewers (Self, M1, M2, HR).
Business Impact: Foundation for all structured performance and confirmation reviews.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
formid bigserial 19 √ nextval('tbl_formdetail_formid_seq'::regclass)
pmsformprocess.formid Implied Constraint R
probationformstatus.formid Implied Constraint R
probationformstatuspmsnew.formid Implied Constraint R
tbl_formassign.formid Implied Constraint R
tbl_formassignv1.formid Implied Constraint R
tbl_formfinalrat.formid Implied Constraint R
tbl_masterformassign.formid Implied Constraint R
tbl_pms_prespective.formid Implied Constraint R
tbl_pms_sactionweightage.formid Implied Constraint R
tbl_pmscompetencytypemaster.formid Implied Constraint R
tbl_pmsglobalrating.formid Implied Constraint R
tbl_pmsgoallist.formid Implied Constraint R
tbl_pmskratypemaster.formid Implied Constraint R
tbl_probationcategory.formid Implied Constraint R
tbl_probationcategorypms.formid Implied Constraint R
tbl_probationquestion.formid Implied Constraint R
tbl_probationquestionpms.formid Implied Constraint R
tbl_probationrating.formid Implied Constraint R
tbl_probationratingnew.formid Implied Constraint R
tbl_probratingmaster.formid Implied Constraint R
tbl_probratingmasterpms.formid Implied Constraint R

Primary key
Format: Long (auto-increment)
Used as: Unique identifier for a specific review form template.
formname varchar 100 √ null

The user-friendly name of the form (e.g., “Annual Performance Review 2024”, “New Hire Confirmation Form”).
kralable varchar 50 √ null

The label/title used for Key Result Areas (KRAs) or Objectives within this form.
kpilable varchar 50 √ null

The label/title used for Key Performance Indicators (KPIs) or Metrics within this form.
createdby varchar 50 √ null

ID of the user who created the form template.
createddate timestamp 29,6 √ null

Timestamp of when the form template was created.
modifiedby varchar 50 √ null

ID of the user who last modified the form template.
modifieddate timestamp 29,6 √ null

Timestamp of when the form template was last modified.
status bool 1 √ null

Boolean flag: Indicates if the form template is currently active (true) or inactive (false).
compid int8 19 √ null

FK: public.tbl_CompanyDetail.CompID
Meaning: The company to which this form template belongs (for multi-tenancy).
isweightage bool 1 √ null

Boolean flag: Indicates whether the review elements in this form template require weightages.
levelofassessment int2 5 √ null

The number of review stages/raters required for this form.
Usage: e.g., 1 (Self only), 2 (Self, M1), 3 (Self, M1, M2), etc.
formtype varchar 50 √ null

Categorization of the form.
Values: e.g., “PMS”, “Confirmation”, “PIP”.
flag1 int4 10 √ null

A generic integer flag field for custom configuration or future use.
flag2 varchar 50 √ null
pmsapprove int4 10 √ null
column1 varchar 50 √ null
column2 varchar 50 √ null

Indexes

Constraint Name Type Sort Column(s)
tbl_formdetail_pk_formdetail Primary key Asc formid

Relationships

Close relationships within degrees of separation