tbl_employeeguarantorshistory

-1 rows


Description

Module: Employee Profile
Purpose: Stores history of guarantor details for employees.
Data: One row per update or modification of a guarantor record.
Process Usage:
- Tracks modifications to guarantor information.
- Maintains status and rejection reasons for approval workflows.
Key Points:
- Supports audit and rollback of guarantor data.
Business Impact: Ensures HR compliance and traceability of guarantor changes.

Columns

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

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

Foreign key
Format: BIGINT
References: tbl_employeeguarantors(empguarid)
Meaning: Links history record to the original guarantor record.
employeeid varchar 20 null
tbl_employee_previous_pf.employeeid Implied Constraint R

Employee ID
Format: VARCHAR(20)
Meaning: References the employee associated with the guarantor record.
name varchar 50 null

Guarantor Name
Format: VARCHAR(50)
Meaning: Name of the guarantor for this historical entry.
officeaddress varchar 2147483647 √ null

Office Address
Format: VARCHAR
Meaning: Guarantor office location at the time of change.
homeaddress varchar 2147483647 √ null

Home Address
Format: VARCHAR
Meaning: Guarantor home address at the time of change.
officephoneno varchar 15 √ null

Office Phone Number
Format: VARCHAR(15)
Meaning: Guarantor office number at the time of change.
mobileno varchar 15 √ null

Mobile Number
Format: VARCHAR(15)
Meaning: Guarantor mobile number at the time of change.
email varchar 100 √ null

Email Address
Format: VARCHAR(100)
Meaning: Guarantor email at the time of change.
com1 varchar 2147483647 √ null
com2 varchar 2147483647 √ null
com3 varchar 2147483647 √ null
com4 varchar 2147483647 √ null
com5 varchar 2147483647 √ null
com6 varchar 2147483647 √ null
com7 varchar 2147483647 √ null
com8 varchar 2147483647 √ null
com9 varchar 2147483647 √ null
com10 varchar 2147483647 √ null
status varchar 20 √ null

Approval Status
Format: VARCHAR(20)
Possible Values: Pending, Approved, Rejected
Usage: Indicates current status of this historical record.
rejectreason varchar 200 √ null

Rejection Reason
Format: VARCHAR(200)
Meaning: Reason provided during rejection of this record.
createddate timestamp 29,6 √ null

Record creation timestamp
Format: TIMESTAMP
Usage: When this historical entry was created.
createdby varchar 50 √ null

Record created by
Format: VARCHAR(50)
Usage: User who created this history record.
modifieddate timestamp 29,6 √ null

Record modification timestamp
Format: TIMESTAMP
Usage: When this historical entry was last modified.
modifiedby varchar 50 √ null

Record modified by
Format: VARCHAR(50)
Usage: User who last modified this history record.

Indexes

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

Relationships

Close relationships within degrees of separation