tbl_employeebankdetailhistory

-1 rows


Description

Module: Employee Profile
Purpose: Stores historical records of employee bank details.
Data: One row per change in employee bank details.
Process Usage:
- Tracks changes to employee bank details over time.
- Used for approval workflows where HR/admin can approve or reject updates.
Key Points:
- Maintains status and rejection reason for audit and compliance.
- Supports overriding future records and effective date tracking.
Business Impact: Ensures accurate banking information, compliance, and traceability for payroll processing.

Columns

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

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

Company ID
Format: INT4
Meaning: Company to which the employee belongs.
Usage: For multi-company setups to identify ownership.
employeeid varchar 500 null
tbl_employee.employeeid fk_tbl_employeebankdetailhistory_employeeid R

Employee ID
Format: VARCHAR(500)
Meaning: Employee to whom this bank detail belongs.
Usage: Links history record to the corresponding employee.
eaccountno varchar 30 √ null

Account Number
Format: VARCHAR(30)
Meaning: Employee bank account number.
Usage: Required for payroll deposits.
ebankname varchar 60 √ null

Bank Name
Format: VARCHAR(60)
Meaning: Name of the bank where the employee holds an account.
ebankbranchname varchar 60 √ null

Branch Name
Format: VARCHAR(60)
Meaning: Name of the bank branch for this account.
ebranchcode varchar 12 √ null

Branch Code
Format: VARCHAR(12)
Meaning: Bank branch code.
ifsccode varchar 2147483647 √ null

IFSC Code
Format: VARCHAR
Meaning: Indian Financial System Code of the branch for electronic transfers.
eaccounttype varchar 50 √ null

Account Type
Format: VARCHAR(50)
Meaning: Type of bank account, e.g., Savings, Current.
ebankpayee varchar 100 √ null

Payee Name
Format: VARCHAR(100)
Meaning: Name of the account holder.
status varchar 20 √ null

Record Status
Format: VARCHAR(20)
Possible Values: Approved, Rejected, Pending
Meaning: Approval workflow status of the bank detail update.
rejectreason varchar 200 √ null

Rejection Reason
Format: VARCHAR(200)
Meaning: Comments provided during approval or rejection.
createddate timestamp 29,6 √ null
createdby varchar 200 √ null
modifieddate timestamp 29,6 √ null
modifiedby varchar 50 √ null
effective_date date 13 null

Effective Date
Format: DATE
Meaning: Date from which the bank detail change is effective.
override_future_data text 2147483647 √ null

Override Future Data
Format: TEXT
Meaning: Stores any overridden future records if this update affects them.
remarks varchar 200 √ null

Remarks
Format: VARCHAR(200)
Meaning: Optional comments regarding the bank details update.
document_url text 2147483647 √ null

Document URL
Format: TEXT
Meaning: S3 path or file name of uploaded supporting document (e.g., cancelled cheque, passbook copy).

Indexes

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

Relationships

Close relationships within degrees of separation