SalaryEmployeeArrear
Documentation for the SalaryEmployeeArrear database schema.
Fields
| Field | Data Type | Usage |
|---|---|---|
| mpanyId | ObjectId | Unique reference to mpany. |
| dated | Date | Timestamp/Date for dated. |
| month | String | Stores the month data. |
| year | String | Stores the year data. |
| financialYearId | ObjectId | Unique reference to financial Year. |
| employeeId | ObjectId | Unique reference to employee. |
| cityId | ObjectId | Unique reference to city. |
| unitId | ObjectId | Unique reference to unit. |
| departmentId | ObjectId | Unique reference to department. |
| designationId | ObjectId | Unique reference to designation. |
| natureId | ObjectId | Unique reference to nature. |
| classId | ObjectId | Unique reference to class. |
| costCentreId | ObjectId | Unique reference to cost Centre. |
| arrearType | String | Stores the arrear type data. |
| numberOfDays | Number | Stores the number of days data. |
| ratePfGross | Number | Timestamp/Date for ratePfGross. |
| providentFundGross | Number | Unique reference to provident Fund Gross. |
| pensionWages | Number | Stores the pension wages data. |
| providentFund | Number | Unique reference to provident Fund. |
| voluntaryProvidentFund | Number | Unique reference to voluntary Provident Fund. |
| accounts | Number | Stores the accounts data. |
| account1 | Number | Stores the account1 data. |
| account10 | Number | Stores the account10 data. |
| account2 | Number | Stores the account2 data. |
| account21 | Number | Stores the account21 data. |
| account22 | Number | Stores the account22 data. |
| rateEsiGross | Number | Timestamp/Date for rateEsiGross. |
| esiGross | Number | Stores the esi gross data. |
| esi | Number | Stores the esi data. |
| esiEmployer | Number | Stores the esi employer data. |
| professionalTax | Number | Stores the professional tax data. |
| incomeTax | Number | Stores the income tax data. |
| csurCharge | Number | Stores the csur charge data. |
| otherSCharge | Number | Stores the other s charge data. |
| eCessCharge | Number | Stores the e cess charge data. |
| otGross | Number | Stores the ot gross data. |
| nfhgross | Number | Stores the nfhgross data. |
| ot | Number | Stores the ot data. |
| otEsiGross | Number | Stores the ot esi gross data. |
| otEsi | Number | Stores the ot esi data. |
| otEsiEmr | Number | Stores the ot esi emr data. |
| netOt | Number | Stores the net ot data. |
| rateGross | Number | Timestamp/Date for rateGross. |
| earningGross | Number | Stores the earning gross data. |
| totalEarnings | Number | Stores the total earnings data. |
| totalDeductions | Number | Stores the total deductions data. |
| remarks | String | Detailed notes or remarks. |
| isIncrement | Boolean | Stores the is increment data. |
| addOnAmount | Number | Monetary or numeric value. |
| fromDate | Date | Timestamp/Date for fromDate. |
| toDate | Date | Timestamp/Date for toDate. |
| netPay | Number | Stores the net pay data. |
| salaryProcessed | Boolean | Stores the salary processed data. |
| isLocked | Boolean | Stores the is locked data. |
| pfGrossActual | Number | Stores the pf gross actual data. |
| pfGrossFullActual | Number | Stores the pf gross full actual data. |
| pfGrossCom | Number | Stores the pf gross com data. |
| esiGrossActual | Number | Stores the esi gross actual data. |
| esiGrossFullActual | Number | Stores the esi gross full actual data. |
| esiPer | Number | Stores the esi per data. |
| esiEmrPer | Number | Stores the esi emr per data. |
| insertedUserId | ObjectId | Unique reference to inserted User. |
| updatedUserId | ObjectId | Unique reference to updated User. |
| insertedDateId | Date | Unique reference to inserted Date. |
| updatedDateId | Date | Unique reference to updated Date. |
| isDeleted | Boolean | Stores the is deleted data. |
| status | Boolean | Timestamp/Date for status. |
| deletedBy | ObjectId | Stores the deleted by data. |
| deletedTime | Date | Timestamp/Date for deletedTime. |