tbl_employeequalificationhistory

-1 rows


Description

Module: Employee Profile
Purpose: Maintains the historical record of qualifications added or updated by employees.
Data: Stores qualification details submitted by employees, pending HR/Admin approval.
Process Usage:
- When an employee adds or edits qualification details, the record is first saved here.
- HR/Admin reviews the record, approves or rejects it, and then approved data reflects in tbl_employeequalification.
Key Points:
- Supports qualification approval workflow.
- Tracks changes to educational details before they are finalized.
- Maintains remarks for rejected or modified entries.
Business Impact: Ensures that only verified education details are stored in the main qualification record, improving data reliability and audit tracking.

Columns

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

Primary key
Format: BIGSERIAL (auto-increment)
Used as: Unique identifier for each qualification history record.
equalificationid int8 19 √ null
tbl_employeequalification.equalificationid fk__tbl_emplo__equal__3a1639ef R

Reference ID
Format: BIGINT
Meaning: Foreign key reference to tbl_employeequalification.equalificationid.
Usage: Links the qualification history record to its corresponding main qualification record.
employeeid varchar 20 √ null
tbl_employee_previous_pf.employeeid Implied Constraint R

Employee ID
Format: VARCHAR(20)
Meaning: Identifies the employee to whom this qualification record belongs.
Usage: Used to map qualifications to the respective employee profile.
equalification varchar 40 √ null

Qualification
Format: VARCHAR(40)
Meaning: Name of the qualification or degree selected by the employee.
Usage: Indicates the education qualification being recorded.
eqborduni varchar 100 √ null

Board/University
Format: VARCHAR(100)
Meaning: Board or university name where the qualification was obtained.
Usage: Used for verifying authenticity and academic details.
eqschoolcollage varchar 100 √ null

School/College
Format: VARCHAR(100)
Meaning: Name of the school or college attended by the employee.
Usage: Provides the institution details for the qualification record.
eqmainsubject varchar 100 √ null

Main Subject
Format: VARCHAR(100)
Meaning: The main subject or specialization of the qualification.
Usage: Helps identify the focus area of the employee’s education.
eqpassingyear varchar 100 √ null

Passing Year
Format: VARCHAR(100)
Meaning: Year in which the qualification was completed.
Usage: Important for academic timeline verification.
eqpassingscore varchar 50 √ null

Passing Score
Format: VARCHAR(50)
Meaning: The score, percentage, or grade obtained by the employee.
Usage: Used for qualification assessment and HR verification.
eqdiscriptions varchar 300 √ null

Description
Format: VARCHAR(300)
Meaning: currently not in use.
jobspecifications int4 10 √ null

Job Specifications
Format: INTEGER
Meaning: currently not in use.
qualificationlevel varchar 50 √ null

Qualification Level
Format: VARCHAR(50)
Meaning: currently not in use.
status varchar 20 √ null

Record Status
Format: VARCHAR(20)
Possible Values: Approved, Rejected, Pending.
Meaning: Indicates whether the qualification record has been reviewed and approved by HR/Admin.
Usage: Controls visibility of qualification in the main qualification table.
rejectreason varchar 200 √ null

Rejection Reason
Format: VARCHAR(200)
Meaning: HR/Admin remarks explaining why the record was rejected.
Usage: Provides transparency and feedback for rejected qualification records.
createddate timestamp 29,6 √ null
createdby varchar 200 √ null
modifieddate timestamp 29,6 √ null
modifiedby varchar 50 √ null
eqpassingmonth varchar 100 √ null

Passing Month
Format: VARCHAR(100)
Meaning: Month in which the qualification was completed.
Usage: Used with year to form a complete passing timeline.
eqstartingyear varchar 100 √ null

Starting Year
Format: VARCHAR(100)
Meaning: Year in which the employee started the qualification course.
Usage: Helps build a full academic history timeline.
eqstartingmonth varchar 100 √ null

Starting Month
Format: VARCHAR(100)
Meaning: Month when the qualification began.
Usage: Complements the year for accurate duration tracking.
eqpursuing bool 1 √ null

Pursuing Flag
Format: BOOLEAN
Meaning: Indicates whether the employee is still pursuing this qualification.
Usage: Useful to track ongoing educational programs.

Indexes

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

Relationships

Close relationships within degrees of separation