tbl_employeecertificationhistory

-1 rows


Description

Module: Employee Profile
Purpose: Stores historical records of employee certifications and trainings.
Process Usage:
- When an employee adds or updates a certification or training record, it is stored here until approved by HR/Admin.
- Once the record is approved, it is reflected in the main table tbl_employeecertification.
Key Points:
- Tracks all certification and training submissions with approval status.
- Maintains approval/rejection reasons for audit and HR review.
- Enables controlled updates to employee certification data.
Business Impact: Ensures data accuracy and accountability for employee qualifications and training records.

Columns

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

Primary Key
Format: BIGSERIAL (auto-increment)
Used as: Unique identifier for each certification or training history record.
ecertificationid int8 19 √ null
tbl_employeecertification.ecertificationid fk_tbl_employeecertificationhistory R

Meaning: References the corresponding main record in tbl_employeecertification.
Usage: Links this historical record to the original certification entry for tracking and synchronization.
employeeid varchar 20 √ null
tbl_employee_previous_pf.employeeid Implied Constraint R

Meaning: Employee ID of the individual who uploaded the certification or training details.
Usage: Identifies the employee associated with this certification record.
ecertificate varchar 100 √ null

Meaning: Name of the certification or training selected by the employee (from lookup list).
Usage: Displays the certification or training title as entered in the employee profile.
ecertifyby varchar 100 √ null

Meaning: Issuing authority or organization that certified the employee.
Usage: Captures who provided or verified the certification/training.
ecyear int4 10 √ null

Meaning: Year of completion or passing for the certification/training.
Usage: Indicates when the employee achieved the certification or completed the training.
ecscore varchar 50 √ null

Meaning: Score, grade, or marks obtained in the certification or training, if applicable.
Usage: Used for evaluation and qualification verification purposes.
status varchar 20 √ null

Meaning: Approval status of the certification/training record.
Possible Values: Approved, Rejected, Pending.
Usage: Determines whether the record is active in the main table or awaiting HR/Admin review.
rejectreason varchar 200 √ null

Meaning: Remarks or reasons entered by HR/Admin during rejection or approval.
Usage: Helps track decisions and maintain a record of communication regarding changes.
createddate timestamp 29,6 √ null
createdby varchar 50 √ null
modifieddate timestamp 29,6 √ null
modifiedby varchar 50 √ null
type varchar 255 √ null

Meaning: Specifies whether the record is a Certification or Training.
Possible Values: Certification, Training.
Usage: Used to categorize and filter records in the employee profile and reports.

Indexes

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

Relationships

Close relationships within degrees of separation