tbl_employeelanguagehistory

-1 rows


Description

Module: Employee Profile
Purpose: Stores historical records of employee language proficiency details added or updated by employees.
Process Usage:
- When an employee adds or updates their language proficiency details, the record is stored here until reviewed by HR/Admin.
- Upon approval, the corresponding record is reflected in the main table tbl_employeelanguage.
Key Points:
- Tracks the approval workflow for employee-declared language skills.
- Maintains a record of what the employee submitted and what was approved/rejected.
- Ensures only verified language details are visible in the employee’s official profile.
Business Impact: Enhances data reliability in HR records by enforcing an approval process for language information.

Columns

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

Primary Key
Format: BIGSERIAL (auto-increment)
Usage: Unique identifier for each language history record.
elanguageid int8 19 √ null
tbl_employeelanguage.elanguageid fk__tbl_emplo__elang__31eb0842 R

Meaning: References the original record in tbl_employeelanguage.
Usage: Helps track which main table record this history entry belongs to.
employeeid varchar 20 √ null
tbl_employee_previous_pf.employeeid Implied Constraint R

Meaning: ID of the employee who added or updated this language record.
Usage: Identifies which employee the language proficiency details belong to.
ellanguagename varchar 100 √ null

Meaning: The language name selected by the employee (e.g., English, Hindi, Spanish).
Usage: Captures which language this record refers to.
elread bool 1 √ null

Meaning: Indicates whether the employee can read the specified language.
Type: Boolean (true/false).
Usage: Used to record the employee’s reading proficiency.
elwrite bool 1 √ null

Meaning: Indicates whether the employee can write the specified language.
Type: Boolean (true/false).
Usage: Used to record the employee’s writing proficiency.
elspeak bool 1 √ null

Meaning: Indicates whether the employee can speak the specified language.
Type: Boolean (true/false).
Usage: Used to record the employee’s speaking proficiency.
elnative bool 1 √ null

Meaning: Indicates whether the language is the employee’s native language.
Type: Boolean (true/false).
Usage: Helps identify the employee’s primary or first language.
status varchar 20 √ null

Meaning: Current approval status of the record.
Possible Values: Approved, Rejected, Pending.
Usage: Determines whether the record has been accepted, denied, or is awaiting review.
rejectreason varchar 200 √ null

Meaning: Remarks entered by HR/Admin when approving or rejecting the record.
Usage: Stores the reason for rejection or any comments provided during approval.
createddate timestamp 29,6 √ null
createdby varchar 50 √ null
modifieddate timestamp 29,6 √ null
modifiedby varchar 50 √ null

Indexes

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

Relationships

Close relationships within degrees of separation