tbl_fndfheader

-1 rows


Description

Module: Full and Final (FnF)
Purpose: Stores the high-level details and configuration of an employee’s final Full and Final settlement calculation upon separation.
Data: Contains employee separation details, the payroll period for settlement, total gross earnings, final status, and summary amounts for encashment/recovery.
Process Usage:
- A single record is generated when the FnF process is initiated for a separating employee.
- Acts as the parent record for tbl_FndFLine which stores component-wise breakup.
- Used by payroll to process the final disbursement and by audit for verification.
Key Points:
- Centralizes the complex logic (formulas, days, amounts) for leave encashment and notice period shortfall.
- Ensures compliance and accurate final payouts.
Business Impact: Guarantees timely and accurate final settlements, minimizing disputes and legal risks.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
fnfheaderid bigserial 19 √ nextval('tbl_fndfheader_fnfheaderid_seq'::regclass)
tbl_fndfheaderhistory.fnfheaderid Implied Constraint R
tbl_fndfheadertemp.fnfheaderid Implied Constraint R
tbl_fndfline.fnfheaderid Implied Constraint R
tbl_fndflinetemp.fnfheaderid Implied Constraint R

Primary key
Format: Long (auto-increment)
Used as: Unique identifier for a specific FnF settlement record.
employeeid varchar 20 √ null
tbl_employee_previous_pf.employeeid Implied Constraint R

FK: public.tbl_employee.employeeid
Meaning: The identifier of the separated employee.
fnfyear int4 10 √ null

The payroll year for which the FnF settlement is being processed.
fnfmonth int4 10 √ null

The payroll month for which the FnF settlement is being processed (1-12).
fnfattendance numeric 0 √ '0'::numeric

The number of days considered as attendance/worked days in the final payroll month for the FnF calculation.
fnfdate timestamp 29,6 √ null

The date on which the FnF calculation record was generated/finalized.
fnfgross numeric 0 √ '0'::numeric

The total calculated Gross Pay amount for the partial month/period of the FnF settlement.
processby varchar 50 √ null

The user or system ID that processed/finalized the FnF calculation.
leavingdate timestamp 29,6 √ null

The employee’s actual last working day (used as the cutoff for calculations).
fnfstatus varchar 50 √ null

The overall status of the FnF calculation.
Values: e.g. " Recover", " Waive OFF".
component1 varchar 50 √ null

A generic String field for custom/legacy FnF data storage.
component2 varchar 50 √ null

A generic String field for custom/legacy FnF data storage.
component3 varchar 50 √ null

A generic String field for custom/legacy FnF data storage.
createddate timestamp 29,6 √ null
createdby varchar 100 √ null
modifieddate timestamp 29,6 √ null
modifiedby varchar 100 √ null
fnfrecover varchar 100 √ null

Configuration setting: Specifies how the notice period shortfall should be handled/recovered. Expected values are RECOVER,WAIVE_OFF,PARTIAL_WAIVE_OFF,PAYMENT,ADJUSTMENT_AGAINST_LEAVE
leaveencashmentformula varchar 100 √ null

The specific payroll formula used to calculate the Leave Encashment amount.
Common Formula Examples:
- BASIC_26 / GROSS_26 / CTC_26: Uses a salary component amount divided by 26 days.
- BASIC_30 / GROSS_30 / CTC_30: Uses a salary component amount divided by 30 days.
- BASIC_12_365 / GROSS_12_365 / CTC_12_365: Uses an annualized component divided by 365 days.
encashableleaves numeric 0 √ null

The final number of leave days eligible for encashment.
noticeperiodshortfalldays numeric 0 √ null

The final calculated number of days the employee was short of the required notice period.
shortfallformula varchar 100 √ null

The specific payroll formula used to calculate the Notice Period Shortfall recovery amount. .
Common Formula Examples:
- BASIC_26 / GROSS_26 / CTC_26: Uses a salary component amount divided by 26 days.
- BASIC_30 / GROSS_30 / CTC_30: Uses a salary component amount divided by 30 days.
- BASIC_12_365 / GROSS_12_365 / CTC_12_365: Uses an annualized component divided by 365 days.
leaveencashmentactualamount numeric 0 √ null

The raw calculated amount for Leave Encashment based on the formula.
leaveencashmentfinalamount numeric 0 √ null

The final, rounded, or adjusted amount of Leave Encashment to be paid.
shortfallactualamount numeric 0 √ null

The raw calculated amount for Notice Period Shortfall recovery.
shortfallfinalamount numeric 0 √ null

The final, rounded, or adjusted amount for Notice Period Shortfall recovery.
leaveencashmentactualpayeffect varchar 100 √ null

Indicates how the ActualAmount affects pay (e.g., ADDITION, DEDUCTION).
leaveencashmentfinalpayeffect varchar 100 √ null

Indicates how the FinalAmount affects pay (e.g., ADDITION).
shortfallactualpayeffect varchar 100 √ null

Indicates how the ActualAmount affects pay (e.g., DEDUCTION, ADDITION/PAYMENT).
shortfallfinalpayeffect varchar 100 √ null

Indicates how the FinalAmount affects pay (e.g., DEDUCTION).
fnf_effected_data text 2147483647 √ null

JSON data string storing which payroll components and transaction IDs were processed/impacted by the FnF calculation.
Data Structure (FNFEffectDataDTO):
- Stores lists of IDs for Rejected and Approved liabilities, arrears, and adjustments.
- Lists of IDs for salary components Held or marked as Company Contribution.
- Gratuity Account Mapping ID (gratuityAccountMapping).
- Posting Dates (postedInFNF) and Disbursement Dates (disbursedInFNF) for the FnF period.
- Final calculated Professional Tax (PT) amount in FnF (ptInFNF).
leave_encashment_recovery_data text 2147483647 √ null

JSON data string containing the detailed breakdown of all leave encashment and recovery line items.
Data Structure (List of FndFLeaveEncashmentRecoveryDTO):
- Stores an array of objects, one for each relevant Leave Code.
- Key Details Per Leave Code:
- leaveCodeName: Name of the leave type (e.g., PL, SL, CL).
- remainingLeaveBalance: The employee’s total balance before separation calculations.
- proratedBalance: Leave balance adjusted for the separation date.
- encashableRecoverableBalanceOnSeparation: The final balance designated for encashment (credit) or recovery (debit).
- encashableOnSeparation: Boolean flag indicating if this specific leave type is eligible for FnF encashment/recovery.
- Leave Type (leaveType) and Sub Type (leaveSubType) categorization.

Indexes

Constraint Name Type Sort Column(s)
tbl_fndfheader_pk_tbl_fndfheader Primary key Asc fnfheaderid

Relationships

Close relationships within degrees of separation