tbl_employeequalification

-1 rows


Description

Module: Employee Profile
Purpose: Stores employee qualification records (degrees, diplomas, ongoing studies).
Data: One row is created per qualification entry for an employee.
Process Usage:
- Employees add qualification details via the profile UI; HR can review and approve changes.
- Records are used in background checks, profile completeness, and reporting.
Key Points:
- Captures institution, subject, duration, scores, and pursuit status.
- Supports auditability when combined with the history table.
Business Impact: Ensures reliable records of employee educational credentials for compliance, hiring verification, and talent management.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
equalificationid bigserial 19 √ nextval('tbl_employeequalification_equalificationid_seq'::regclass)
tbl_employeequalificationhistory.equalificationid fk__tbl_emplo__equal__3a1639ef R

Primary key
Format: BIGSERIAL (auto-increment)
Used as: Unique identifier for each employee qualification record.
employeeid varchar 20 √ null
tbl_employee_previous_pf.employeeid Implied Constraint R

Meaning: Employee identifier.
Format: VARCHAR(20)
Usage: Links the qualification to the employee profile (tbl_employee).
equalification varchar 40 √ null

Meaning: Qualification name or degree.
Format: VARCHAR(40)
Usage: Stores the qualification selected by the employee (e.g., B.Tech, MBA).
eqborduni varchar 100 √ null

Meaning: Board or University name.
Format: VARCHAR(100)
Usage: Institution that awarded the qualification.
eqschoolcollage varchar 100 √ null

Meaning: School or College name.
Format: VARCHAR(100)
Usage: Specific college or school attended for the qualification.
eqmainsubject varchar 100 √ null

Meaning: Main subject or specialization.
Format: VARCHAR(100)
Usage: Primary subject area for the qualification (e.g., Computer Science).
eqpassingyear varchar 100 √ null

Meaning: Passing / completion year.
Format: VARCHAR(100)
Usage: Year in which the qualification was completed or awarded.
eqpassingscore varchar 50 √ null

Meaning: Passing score or grade.
Format: VARCHAR(50)
Usage: Percentage/grade/marks obtained by the employee (if applicable).
eqdiscriptions varchar 300 √ null

Meaning: Description or notes about the qualification.
Format: VARCHAR(300)
Status: Present but not actively used in code.
jobspecifications int4 10 √ null

Meaning: Job specification reference (reserved).
Format: INTEGER
Status: Not used in current implementation.
qualificationlevel varchar 50 √ null

Meaning: Qualification level indicator (reserved).
Format: VARCHAR(50)
Status: currently not in use.
eqpassingmonth varchar 100 √ null

Meaning: Passing month.
Format: VARCHAR(100)
Usage: Month when the qualification was completed; used with passing year for full date context.
eqstartingyear varchar 100 √ null

Meaning: Starting year of the program.
Format: VARCHAR(100)
Usage: Indicates when the qualification course began.
eqstartingmonth varchar 100 √ null

Meaning: Starting month of the program.
Format: VARCHAR(100)
Usage: Complements starting year for timeline records.
eqpursuing bool 1 √ null

Meaning: Pursuing flag.
Format: BOOLEAN
Usage: True if the employee is still pursuing the qualification; otherwise false.

Indexes

Constraint Name Type Sort Column(s)
tbl_employeequalification_pk_tbl_employeequalification Primary key Asc equalificationid

Relationships

Close relationships within degrees of separation