tbl_fndfline

-1 rows


Description

Module: HRMS Payroll & Full and Final (FnF) Settlement
Purpose: Stores the detailed line items—both earnings (additions) and deductions—that make up an employee’s final settlement calculation.
Data: Records element-specific amounts, days, and statutory contributions for the final month of employment.
Process Usage:
- Directly links to the FnF Header table (tbl_fndfheader) to form the complete final statement.
- Used by the payroll system to process the termination month’s salary and final dues.
Key Points:
- Critical for compliance and ensuring accurate settlement of all financial liabilities upon employee separation.
- Includes custom fields for complex or non-standard final payment elements.
Business Impact: Guarantees transparency and legal adherence in the employee separation process.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
fnflineid bigserial 19 √ nextval('tbl_fndfline_fnflineid_seq'::regclass)
tbl_fndflinetemp.fnflineid Implied Constraint R

Primary key
Format: Integer (auto-increment)
Used as: Unique identifier for a single line item in the final settlement.
fnfheaderid int8 19 √ null
tbl_fndfheader.fnfheaderid Implied Constraint R

FK: public.tbl_fndfheader.id
Meaning: Links this line item to the master final settlement record.
Dependency: Required for grouping all line items belonging to a single employee’s FnF.
fnfpayelementname varchar 50 √ null

Meaning: The descriptive name of the earning or deduction element (e.g., “Pro-rata Basic,” “Leave Encashment,” “Notice Period Deduction”).
Format: Varchar/Text.
fnfadddeduct varchar 15 √ null

Indicates whether the line item is an Addition (Earning) or a Deduction.
Format: Varchar (A/D).
fnfamount numeric 0 √ '0'::numeric

The calculated base amount for the pay element before considering days or final adjustments.
Format: Numeric.
employeecont numeric 0 √ '0'::numeric

The portion of the amount that represents the employee’s contribution to statutory funds (e.g., PF, ESI).
Format: Numeric.
employeeppf numeric 0 √ '0'::numeric

The employee’s specific contribution to the Public Provident Fund or a related retirement scheme.
Format: Numeric.
admincharge numeric 0 √ '0'::numeric

Any administrative fees or charges applied to this line item (e.g., bank transfer fees, processing charges).
Format: Numeric.
otheramount numeric 0 √ '0'::numeric

Any additional or miscellaneous amount relevant to this pay element.
Format: Numeric.
days numeric 0 √ null

The number of days used in the pro-rata calculation for this pay element (e.g., days worked, days of leave encashment).
Format: Numeric/Float.
actamount numeric 0 √ null

The final Actual Amount calculated for this line item, which contributes to the net final settlement total.
Formula: Derived from fnfamount, days, and other contributing columns.
comm1 numeric 0 √ null

Custom comment/remark 1 specific to this line item calculation.
Format: Varchar/Text.
comm2 numeric 0 √ null

Custom comment/remark 2.
Format: Varchar/Text.
comm3 numeric 0 √ null

Custom comment/remark 3.
Format: Varchar/Text.
comm4 numeric 0 √ null

Custom comment/remark 4.
Format: Varchar/Text.
comm5 int4 10 √ null

Custom comment/remark 5.
Format: Varchar/Text.
comm6 varchar 100 √ null

Custom comment/remark 6.
Format: Varchar/Text.
createddate timestamp 29,6 √ null

Timestamp of when the FnF line item was created.
Format: Timestamp with timezone.
createdby varchar 100 √ null

FK: public.tbl_userlogin.id or public.tbl_employee.employeeid
Meaning: The user who generated or entered this line item.
modifieddate timestamp 29,6 √ null

Timestamp of the last modification to the FnF line item.
Format: Timestamp with timezone.
modifiedby varchar 100 √ null

FK: public.tbl_userlogin.id or public.tbl_employee.employeeid
Meaning: The last user who modified this line item.
salarytype varchar 50 √ '''SALARY'''::character varying

The type of salary or pay structure this element belongs to (e.g., Fixed, Variable).
Format: Varchar/Text.
payelementid int8 19 √ null
tbl_employeepayelement.payelementid Implied Constraint R

FK: Reference to a pay element master table
Meaning: The ID of the corresponding element from the main payroll structure.
fnfmonth int4 10 √ null

The payroll month to which this FnF line item applies.
Format: Integer (1-12).
fnfyear int4 10 √ null

The payroll year to which this FnF line item applies.
Format: Integer (YYYY).
istaxpending bool 1 √ null

Flag indicating if tax calculation or deduction is still pending for this specific final settlement element.
Format: Boolean.

Indexes

Constraint Name Type Sort Column(s)
tbl_fndfline_pk_tbl_fndfline Primary key Asc fnflineid

Relationships

Close relationships within degrees of separation