tbl_employeelanguage

-1 rows


Description

Module: HRMS Employee Information & Skills
Purpose: Stores the detailed records of all languages an employee is proficient in, along with their skill levels (read, write, speak).
Data: Records the language name and a boolean or rating scale for each skill type.
Process Usage:
- Used by recruiting and staffing teams to identify employees with specific language skills for projects or roles.
- Populates the language section of an employee’s professional profile.
Key Points:
- Essential for global organizations or those serving multilingual client bases.
- Includes a flag to identify the employee’s native language.
Business Impact: Enhances internal talent matching and improves organizational capability assessment.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
elanguageid bigserial 19 √ nextval('tbl_employeelanguage_elanguageid_seq'::regclass)
tbl_employeelanguagehistory.elanguageid fk__tbl_emplo__elang__31eb0842 R

Primary key
Format: Integer (auto-increment)
Used as: Unique identifier for a single language proficiency record.
employeeid varchar 20 √ null
tbl_employee_previous_pf.employeeid Implied Constraint R

FK: public.tbl_employee.employeeid
Meaning: The ID of the employee whose language skills are being recorded.
Format: Integer/Varchar.
ellanguagename varchar 100 √ null

The name of the language (e.g., Spanish, French, Mandarin, Hindi).
Format: Varchar/Text.
elread bool 1 √ false

Indicates the employee’s proficiency level in reading the language (e.g., Boolean, or a rating value like Basic, Proficient, Expert).
Format: Boolean/Varchar.
elwrite bool 1 √ false

Indicates the employee’s proficiency level in writing the language.
Format: Boolean/Varchar.
elspeak bool 1 √ false

Indicates the employee’s proficiency level in speaking/conversing in the language.
Format: Boolean/Varchar.
elnative bool 1 √ false

Flag indicating whether this language is the employee’s native or mother tongue.
Format: Boolean.

Indexes

Constraint Name Type Sort Column(s)
tbl_employeelanguage_pk_tbl_employeelanguage Primary key Asc elanguageid

Relationships

Close relationships within degrees of separation