tbl_probationquestion

38 rows


Description

Module: Probation/Confirmation - Probation Review Question Master
Purpose: Stores the definitions and properties for every question used in the standardized employee probation review/assessment forms.
Data: Captures the question text, category, weightage for scoring, and flags indicating if it’s a parent question or requires an open-ended response.
Process Usage:
- Form Generation: Used by the application to dynamically build the structured probation assessment form.
- Scoring: The Weightage and Per fields are used in the calculation of the final probation review score.
- Establishes a hierarchy where one question can be a parent to others (e.g., “Overall Performance” parent to “Quality of Work”).
Key Points:
- Essential for standardizing the evaluation criteria during an employee’s probation period.
- Linked to a specific form and category to organize the review structure.
Business Impact: Ensures fair, consistent, and structured evaluation of new employees during their probation.

Columns

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

Primary key
Format: Long (auto-increment)
Used as: Unique identifier for this question definition.
probationcatid int8 19 √ null

FK: public.tbl_ProbationCategory.id
Meaning: The category or section (e.g., Job Knowledge, Soft Skills) this question belongs to.
question varchar 1000 √ null

The full text of the question presented to the reviewer.
description varchar 1000 √ null

Additional guidelines or detailed instructions for answering this question.
status bool 1 √ null

Boolean flag: Indicates if the question is currently active and included in new forms.
createdby varchar 200 √ null

The Employee ID or username of the person who created the question.
createddate timestamp 29,6 √ null

The date and time the question was originally created in the system.
weightage numeric 0 √ null

The numerical weight assigned to this question for calculating the overall assessment score.
parentqid int8 19 √ null

FK: public.tbl_ProbationQuestion.QuestionID
Meaning: If this is a sub-question, this is the ID of its parent question.
isparent bool 1 √ null

Boolean flag: Indicates if this question acts as a parent header for other sub-questions.
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 contains this question.
per int4 10 √ null

The maximum score or percentage point achievable for this question.
compid int8 19 √ null

FK: public.tbl_CompanyDetail.id
Meaning: The company to which this question template belongs.
openended bool 1 false

Boolean flag: Indicates if the question requires a free-text/narrative answer rather than a rating/score.

Indexes

Constraint Name Type Sort Column(s)
tbl_probationquestion_pk_tbl_probationquestion Primary key Asc questionid

Relationships

Close relationships within degrees of separation