tbl_employeenomineehistory

-1 rows


Description

Module: Employee Profile
Purpose: To maintain a historical record of employee nominee details.
Process Usage:
- Stores nominee information for each employee along with approval status.
- Tracks whether nominee details are Approved, Rejected, or Pending by HR/Admin.
- Maintains remarks for rejected records.
Business Impact: Ensures transparency and traceability of employee nominee details across approval stages.

Columns

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

Primary key
Format: BIGSERIAL (auto-increment)
Used as: Unique identifier for each nominee history record.
companyid int4 10 null
tbl_companymaster.companyid Implied Constraint R

Company ID
Meaning: Identifies the company to which the employee belongs.
Usage: Links nominee record to the corresponding organization.
employeeid varchar 500 null
tbl_employee.employeeid Implied Constraint R

Employee ID
Meaning: References the employee associated with the nominee.
Usage: Connects nominee details to a specific employee record.
enomineename varchar 60 √ null

Nominee Name
Meaning: Full name of the nominee person.
Usage: Used for HR documentation, insurance, or benefit nominations.
enomineerelationship varchar 30 √ null

Nominee Relationship
Meaning: Describes the nominee’s relationship with the employee (e.g., Father, Mother, Spouse).
Source: Comes from lookup/mask list for standardized relationship values.
rejectreason varchar 200 √ null

Rejection Reason
Meaning: Stores remarks or comments provided by Admin/HR during rejection.
Usage: Helps track the reason for disapproval for audit or reference.
createddate timestamp 29,6 √ null
createdby varchar 200 √ null
modifieddate timestamp 29,6 √ null
modifiedby varchar 50 √ null
status varchar 20 √ null

Status
Meaning: Indicates the approval state of the nominee record.
Possible Values: Approved, Rejected, Pending
Usage: Used to filter and manage nominee approval workflow.

Indexes

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

Relationships

Close relationships within degrees of separation