tbl_employeeexperiencehistory

-1 rows


Description

Module: Employee Profile
Purpose: Stores the history of employee past experience records added or updated by employees.
Data: Each record represents a change or submission in the employee’s experience details.
Process Usage:
- Employees submit new or updated experience entries.
- HR reviews and either approves or rejects these records.
- Once approved, data reflects in tbl_employeeexperience (the main table).
Key Points:
- Tracks organization, designation, duration, and salary on leaving.
- Maintains auditability of all employee experience updates.
Business Impact: Enables HR to verify and manage accurate historical work experience information for employees, essential for validation, appraisal, and background checks.

Columns

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

Primary key
Format: BIGSERIAL (auto-increment)
Usage: Unique identifier for each experience history record.
eexperienceid int8 19 √ null
tbl_employeeexperience.eexperienceid fk__tbl_emplo__eexpe__3645a90b R

Meaning: Reference to main employee experience record.
Foreign Key: tbl_employeeexperience.eexperienceid
Usage: Tracks which master record this history entry is associated with.
employeeid varchar 20 √ null
tbl_employee_previous_pf.employeeid Implied Constraint R

Meaning: Employee identifier.
Format: VARCHAR(20)
Usage: Indicates which employee the experience history belongs to.
eeorganization varchar 100 √ null

Meaning: Organization name.
Format: VARCHAR(100)
Usage: Stores the name of the company/organization where the employee previously worked.
eedesignation varchar 100 √ null

Meaning: Designation or role.
Format: VARCHAR(100)
Usage: Title or position held by the employee in that organization.
eestartdate timestamp 29,6 √ null

Meaning: Start date of employment.
Format: TIMESTAMP
Usage: Indicates when the employee began working with the organization.
eeenddate timestamp 29,6 √ null

Meaning: End date of employment.
Format: TIMESTAMP
Usage: Indicates when the employee left the organization.
eesalaryonleaving numeric 0 √ null

Meaning: Last drawn salary at the time of leaving.
Format: NUMERIC
Usage: Captures employee salary when they left the organization (for reference and validation).
eereasonforleaving varchar 200 √ null

Meaning: Reason for leaving.
Format: VARCHAR(200)
Usage: Describes why the employee left the previous organization.
status varchar 20 √ null

Meaning: Approval status.
Format: VARCHAR(20)
Possible Values: Pending, Approved, Rejected
Usage: Indicates review status of the submitted experience record.
Behavior: When Approved, the data is reflected in tbl_employeeexperience (main table).
rejectreason varchar 200 √ null

Meaning: Remarks or reason for rejection.
Format: VARCHAR(200)
Usage: Stores HR comments when rejecting a record.
createddate timestamp 29,6 √ null
createdby varchar 200 √ null
modifieddate timestamp 29,6 √ null
modifiedby varchar 50 √ null

Relationships

Close relationships within degrees of separation