PfEsiReportData

Documentation for the PfEsiReportData database schema.

Fields

Field	Data Type	Usage
companyId	`ObjectId`	Unique reference to company.
attendanceSalaryPairs	`ObjectId`	Timestamp/Date for attendanceSalaryPairs.
attendanceId	`ObjectId`	Unique reference to attendance.
salaryProcessId	`ObjectId`	Unique reference to salary Process.
employeeId	`ObjectId`	Unique reference to employee.
unitId	`ObjectId`	Unique reference to unit.
departmentId	`ObjectId`	Unique reference to department.
month	`String`	Stores the month data.
year	`String`	Stores the year data.
reportType	`String`	Stores the report type data.
isVoucher	`Boolean`	Stores the is voucher data.
sNo	`Date`	Stores the s no data.
monthName	`Date`	The name or title of the pfesireportdata.
yearValue	`Date`	Stores the year value data.
companyName	`Date`	The name or title of the pfesireportdata.
employeeCode	`Date`	Stores the employee code data.
employeeName	`Date`	The name or title of the pfesireportdata.
unitName	`Date`	The name or title of the pfesireportdata.
unitCode	`Date`	Stores the unit code data.
clientName	`Date`	The name or title of the pfesireportdata.
navisionCode	`Date`	Stores the navision code data.
branch	`Date`	Stores the branch data.
gender	`Date`	Stores the gender data.
meritalStatus	`Date`	Timestamp/Date for meritalStatus.
aadharNo	`Date`	Stores the aadhar no data.
dateOfBirth	`Date`	Timestamp/Date for dateOfBirth.
dateOfJoining	`Date`	Timestamp/Date for dateOfJoining.
fatherName	`Date`	The name or title of the pfesireportdata.
reportGeneratedDate	`Date`	Timestamp/Date for reportGeneratedDate.
companyPFNo	`Date`	Stores the company p f no data.
employeePFNo	`Date`	Stores the employee p f no data.
uanNo	`Date`	Stores the uan no data.
monthDays	`Date`	Stores the month days data.
workingDays	`Date`	Stores the working days data.
ncpDays	`Date`	Stores the ncp days data.
earnBasic	`Date`	Stores the earn basic data.
earnPFGross	`Date`	Stores the earn p f gross data.
pfWages	`Date`	Stores the pf wages data.
epsBasic	`Date`	Stores the eps basic data.
edliBasic	`Date`	Stores the edli basic data.
pfEmpCon	`Date`	Stores the pf emp con data.
accNo1	`Date`	Stores the acc no1 data.
accNo2	`Date`	Stores the acc no2 data.
accNo10	`Date`	Stores the acc no10 data.
accNo21	`Date`	Stores the acc no21 data.
accNo22	`Date`	Stores the acc no22 data.
pfEmployerCon	`Date`	Stores the pf employer con data.
pfRemarks	`Date`	Detailed notes or remarks.
pfRemark	`Date`	Detailed notes or remarks.
companyCodeNo	`Date`	Stores the company code no data.
employeeESINo	`Date`	Stores the employee e s i no data.
wDay	`Date`	Stores the w day data.
paidDays	`Date`	Unique reference to paid Days.
dividingFactorDay	`Date`	Unique reference to dividing Factor Day.
monthDay	`Date`	Stores the month day data.
totalSunday	`Date`	Stores the total sunday data.
esiDay	`Date`	Unique reference to esi Day.
grossWages	`Date`	Stores the gross wages data.
earnGrossWages	`Date`	Stores the earn gross wages data.
employeeCont	`Date`	Stores the employee cont data.
employerCont	`Date`	Stores the employer cont data.
otGrossAmount	`Date`	Monetary or numeric value.
earnOTWages	`Date`	Stores the earn o t wages data.
otDays	`Date`	Stores the ot days data.
otEsi	`Date`	Stores the ot esi data.
otEmployer	`Date`	Stores the ot employer data.
otHoursWages	`Date`	Stores the ot hours wages data.
otHours	`Date`	Stores the ot hours data.
othoursESI	`Date`	Stores the othours e s i data.
othoursEsiEmployer	`Date`	Stores the othours esi employer data.
nfhDays	`Date`	Stores the nfh days data.
nfhWages	`Date`	Stores the nfh wages data.
nfhEsi	`Date`	Stores the nfh esi data.
nfhEsiEmployer	`Date`	Stores the nfh esi employer data.
netNFH	`Date`	Stores the net n f h data.
totalWages	`Date`	Stores the total wages data.
reasonForLeaveESI	`Date`	Stores the reason for leave e s i data.
remarks	`Date`	Detailed notes or remarks.
calculatedAt	`Date`	Timestamp/Date for calculatedAt.

PfEsiPaidStatus PunchPendingReport