tbl_employeereferenceshistory

-1 rows


Description

Module: Employee Profile
Purpose: Stores history of employee reference details.
Data: One row is created for each historical version of an employee reference record.
Process Usage:
- Tracks changes to employee reference information over time.
- Captures status, approvals, and rejection reasons.
Key Points:
- Links to the main reference table (tbl_employeereferences) via emprefid.
- Provides an audit trail for HR approval/rejection process.
Business Impact: Ensures proper tracking and approval of employee references, supports compliance and auditing.

Columns

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

Primary key
Format: BIGSERIAL (auto-increment)
Used as: Unique identifier for each history record.
emprefid int8 19 √ null
tbl_employeereferences.emprefid fk_tbl_employeereferenceshistory R

Reference ID
Format: BIGINT
FK: public.tbl_employeereferences.emprefid
Meaning: Links the history record to the original reference record.
Usage: Identifies which reference record this history entry belongs to.
employeeid varchar 20 null
tbl_employee_previous_pf.employeeid Implied Constraint R

Employee ID
Format: VARCHAR(20)
Meaning: The employee to whom the reference belongs.
Usage: Tracks which employee’s reference was updated.
name varchar 50 null

Reference Name
Format: VARCHAR(50)
Meaning: Name of the reference person.
Usage: Captures historical versions of reference names.
address varchar 2147483647 √ null

Reference Address
Format: VARCHAR
Meaning: Address of the reference person.
Usage: Tracks historical address changes.
phoneno varchar 15 √ null

Reference Phone Number
Format: VARCHAR(15)
Meaning: Landline number of the reference person.
Usage: Captures historical contact numbers.
mobileno varchar 15 √ null

Reference Mobile Number
Format: VARCHAR(15)
Meaning: Mobile number of the reference person.
Usage: Tracks historical mobile numbers.
email varchar 100 √ null

Reference Email
Format: VARCHAR(100)
Meaning: Email of the reference person.
Usage: Captures historical email changes.
com1 varchar 2147483647 √ null

Not Used column
Kept for schema consistency with main table.
com2 varchar 2147483647 √ null

Not Used column
Kept for schema consistency with main table.
com3 varchar 2147483647 √ null

Not Used column
Kept for schema consistency with main table.
com4 varchar 2147483647 √ null

Not Used column
Kept for schema consistency with main table.
com5 varchar 2147483647 √ null

Not Used column
Kept for schema consistency with main table.
com6 varchar 2147483647 √ null

Not Used column
Kept for schema consistency with main table.
com7 varchar 2147483647 √ null

Not Used column
Kept for schema consistency with main table.
com8 varchar 2147483647 √ null

Not Used column
Kept for schema consistency with main table.
com9 varchar 2147483647 √ null

Not Used column
Kept for schema consistency with main table.
com10 varchar 2147483647 √ null

Not Used column
Kept for schema consistency with main table.
status varchar 20 √ null

Record Status
Format: VARCHAR(20)
Possible Values: Approved, Rejected, Pending
Meaning: Status of the history record during approval workflow.
Usage: Determines whether the change has been approved or rejected.
rejectreason varchar 200 √ null

Rejection Reason
Format: VARCHAR(200)
Meaning: Remarks provided by HR or admin during approval/rejection.
Usage: Tracks reasons for rejected updates.
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_employeereferenceshistory_pk_tbl_employeereferenceshistory Primary key Asc id

Relationships

Close relationships within degrees of separation