SalaryVersioning
Documentation for the SalaryVersioning database schema.
Fields
| Field | Data Type | Usage |
|---|---|---|
| attendanceId | ObjectId | Unique reference to attendance. |
| voucherId | ObjectId | Unique reference to voucher. |
| currentSalaryProcessId | ObjectId | Unique reference to current Salary Process. |
| versionNumber | Number | Stores the version number data. |
| revertReason | String | Stores the revert reason data. |
| revertedBy | ObjectId | Stores the reverted by data. |
| revertedAt | Date | Timestamp/Date for revertedAt. |
| companyId | ObjectId | Unique reference to company. |
| clientId | ObjectId | Unique reference to client. |
| empid | ObjectId | Unique reference to empid. |
| code | String | Stores the code data. |
| name | String | The name or title of the salaryversioning. |
| role | String | Stores the role data. |
| unit | ObjectId | Stores the unit data. |
| departmentId | ObjectId | Unique reference to department. |
| finId | ObjectId | Unique reference to fin. |
| cityId | ObjectId | Unique reference to city. |
| locationId | ObjectId | Unique reference to location. |
| 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. |
| month | String | Stores the month data. |
| year | String | Stores the year data. |
| dated | Date | Timestamp/Date for dated. |
| payDate | Date | Timestamp/Date for payDate. |
| effectDate | Date | Timestamp/Date for effectDate. |
| ctc | Number | Stores the ctc data. |
| basic | Number | Stores the basic data. |
| amount | Number | Monetary or numeric value. |
| perDay | Number | Stores the per day data. |
| totalEarnings | Number | Stores the total earnings data. |
| grossPay | Number | Stores the gross pay data. |
| rateGross | Number | Timestamp/Date for rateGross. |
| earnGross | Number | Stores the earn gross data. |
| grossTotal | Number | Stores the gross total data. |
| newGross | Number | Stores the new gross data. |
| newEarnGross | Number | Stores the new earn gross data. |
| salaryHeads | ObjectId | Stores the salary heads data. |
| companyHeadId | ObjectId | Unique reference to company Head. |
| salaryHeadId | ObjectId | Unique reference to salary Head. |
| headId | ObjectId | Unique reference to head. |
| description | String | Detailed notes or remarks. |
| rate | Number | Timestamp/Date for rate. |
| headType | String | Stores the head type data. |
| grossPart | Boolean | Stores the gross part data. |
| providentFundGrossPart | Boolean | Unique reference to provident Fund Gross Part. |
| employeeStateInsuranceGrossPart | Boolean | Timestamp/Date for employeeStateInsuranceGrossPart. |
| otGross | Boolean | Stores the ot gross data. |
| OTRateHours | Number | Timestamp/Date for OTRateHours. |
| deductionType | String | Stores the deduction type data. |
| shortDescription | String | Detailed notes or remarks. |
| displayOrder | Number | Stores the display order data. |
| headFixedId | ObjectId | Unique reference to head Fixed. |
| mapping | Boolean | Stores the mapping data. |
| formulaId | ObjectId | Unique reference to formula. |
| orderLevel | Number | Stores the order level data. |
| taxable | String | Stores the taxable data. |
| nonTaxableLimit | Number | Stores the non taxable limit data. |
| chapterVIType | String | Stores the chapter v i type data. |
| subofBillSubmission | Boolean | Stores the subof bill submission data. |
| underSection | String | Stores the under section data. |
| calculateInterest | Boolean | Timestamp/Date for calculateInterest. |
| interestPercentage | Number | Stores the interest percentage data. |
| parentHeadId | ObjectId | Unique reference to parent Head. |
| rounding | String | Stores the rounding data. |
| salaryRegisterShowFlag | Boolean | Stores the salary register show flag data. |
| active | Boolean | Stores the active data. |
| blockSummation | Boolean | Timestamp/Date for blockSummation. |
| AttendBonusRate | Number | Timestamp/Date for AttendBonusRate. |
| AttendBonusDaysLimit | Number | Timestamp/Date for AttendBonusDaysLimit. |
| presenceDependent | Boolean | Stores the presence dependent data. |
| EffectType | String | Stores the effect type data. |
| ImportDesc | String | Stores the import desc data. |
| remarks | String | Detailed notes or remarks. |
| esiGrossPart | Boolean | Stores the esi gross part data. |
| nfhgross | Boolean | Stores the nfhgross data. |
| esionnh | Boolean | Stores the esionnh data. |
| pfApp | Boolean | Stores the pf app data. |
| pf | Number | Stores the pf data. |
| voluntaryPF | Number | Stores the voluntary p f data. |
| ratePFGross | Number | Timestamp/Date for ratePFGross. |
| pfGross | Number | Stores the pf gross 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. |
| pfBasedOn | String | Stores the pf based on data. |
| pfPer | Number | Stores the pf per data. |
| pensionWages | Number | Stores the pension wages data. |
| ac1 | Number | Stores the ac1 data. |
| ac2 | Number | Stores the ac2 data. |
| ac10 | Number | Stores the ac10 data. |
| ac21 | Number | Stores the ac21 data. |
| ac22 | Number | Stores the ac22 data. |
| esiApp | Boolean | Stores the esi app data. |
| esiFlag | Boolean | Stores the esi flag data. |
| esi | Number | Stores the esi data. |
| rateESIGross | Number | Timestamp/Date for rateESIGross. |
| esiGross | Number | Stores the esi gross data. |
| esiEmr | Number | Stores the esi emr data. |
| esiType | String | Stores the esi type data. |
| esiGrossActual | Number | Stores the esi gross actual data. |
| esiGrossFullActual | Number | Stores the esi gross full actual data. |
| esiEmrPer | Number | Stores the esi emr per data. |
| esiPer | Number | Stores the esi per data. |
| profTax | Number | Stores the prof tax data. |
| professionalTax | Number | Stores the professional tax data. |
| ptGross | Number | Stores the pt gross data. |
| ptApplicable | Boolean | Stores the pt applicable data. |
| ptSlabId | ObjectId | Unique reference to pt Slab. |
| lwf | Number | Stores the lwf data. |
| lwfEmr | Number | Stores the lwf emr data. |
| lwfTotal | Number | Stores the lwf total data. |
| lwfApp | Boolean | Stores the lwf app data. |
| lwfSlabId | ObjectId | Unique reference to lwf Slab. |
| incTax | Number | Stores the inc tax data. |
| taxableIncome | Number | Stores the taxable income data. |
| cSurCharge | Number | Stores the c sur charge data. |
| otherSCharge | Number | Stores the other s charge data. |
| eCessCharge | Number | Stores the e cess charge data. |
| elDays | Number | Stores the el days data. |
| elAmount | Number | Monetary or numeric value. |
| elPF | Number | Stores the el p f data. |
| elVolPF | Number | Stores the el vol p f data. |
| attType | String | Timestamp/Date for attType. |
| lwp | Number | Stores the lwp data. |
| sl | Number | Stores the sl data. |
| doubleNH | Number | Stores the double n h 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 o t data. |
| otEsiGrossActual | Number | Stores the ot esi gross actual data. |
| otRateHours | Number | Timestamp/Date for otRateHours. |
| hoursOT | Number | Stores the hours o t data. |
| hoursOTEsi | Number | Stores the hours o t esi data. |
| netHoursOT | Number | Stores the net hours o t data. |
| hoursOTEsiEmr | Number | Stores the hours o t esi emr data. |
| otPfGross | Number | Stores the ot pf gross data. |
| otPf | Number | Stores the ot pf data. |
| otPfEmr | Number | Stores the ot pf emr data. |
| hoursOTPf | Number | Stores the hours o t pf data. |
| hoursOTPfEmr | Number | Stores the hours o t pf emr data. |
| nfhGross | Number | Stores the nfh gross data. |
| nfh | Number | Stores the nfh data. |
| nfhEsiGross | Number | Stores the nfh esi gross data. |
| nfhEsi | Number | Stores the nfh esi data. |
| nfhEsiEmr | Number | Stores the nfh esi emr data. |
| netNFH | Number | Stores the net n f h data. |
| nhAmt | Number | Stores the nh amt data. |
| nhEsiGross | Number | Stores the nh esi gross data. |
| nhEsi | Number | Stores the nh esi data. |
| nhEsiEmr | Number | Stores the nh esi emr data. |
| netNHAmt | Number | Stores the net n h amt data. |
| nhGross | Number | Stores the nh gross data. |
| nh | Boolean | Stores the nh data. |
| nhPfGross | Number | Stores the nh pf gross data. |
| nhPf | Number | Stores the nh pf data. |
| nhPfEmr | Number | Stores the nh pf emr data. |
| arrearAmt | Number | Stores the arrear amt data. |
| arrearPF | Number | Stores the arrear p f data. |
| arrearEsi | Number | Stores the arrear esi data. |
| arrearVolPF | Number | Stores the arrear vol p f data. |
| arrearProfTax | Number | Stores the arrear prof tax data. |
| loanAdv | Number | Stores the loan adv data. |
| loanDetails | ObjectId | Stores the loan details data. |
| loanId | ObjectId | Unique reference to loan. |
| loanCode | String | Stores the loan code data. |
| installmentAmount | Number | Monetary or numeric value. |
| balanceAmount | Number | Monetary or numeric value. |
| remainingInstallments | Number | Stores the remaining installments data. |
| installmentNumber | Number | Stores the installment number data. |
| installmentId | ObjectId | Unique reference to installment. |
| totalDeduction | Number | Stores the total deduction data. |
| validator | Number | Unique reference to validator. |
| message | Number | Stores the message data. |
| recoveryAmt | Number | Stores the recovery amt data. |
| dueRecoveryAmt | Number | Stores the due recovery amt data. |
| imprestRecovery | Number | Stores the imprest recovery data. |
| anyOtherDue | Number | Stores the any other due data. |
| bankAcctNo | String | Stores the bank acct no data. |
| bankId | ObjectId | Unique reference to bank. |
| ifceCode | String | Stores the ifce code data. |
| paymode | String | Stores the paymode data. |
| finalPay | Number | Stores the final pay data. |
| netPay | Number | Stores the net pay data. |
| netReimburse | Number | Stores the net reimburse data. |
| isProcessed | Boolean | Stores the is processed data. |
| isLocked | Boolean | Stores the is locked data. |
| lockedDate | Date | Timestamp/Date for lockedDate. |
| stopSalary | Boolean | Stores the stop salary data. |
| stopSalaryType | String | Stores the stop salary type data. |
| returnFlag | Boolean | Stores the return flag data. |
| processedVerified | Boolean | Stores the processed verified data. |
| billingVerified | Boolean | Stores the billing verified data. |
| billingDate | Date | Timestamp/Date for billingDate. |
| branchVerified | Boolean | Stores the branch verified data. |
| branchDate | Date | Timestamp/Date for branchDate. |
| accountVerified | Boolean | Stores the account verified data. |
| accountDate | Date | Timestamp/Date for accountDate. |
| reCalculateHead | Boolean | Timestamp/Date for reCalculateHead. |
| trustFlag | Boolean | Stores the trust flag data. |
| gpaFlag | Boolean | Stores the gpa flag data. |
| uniformFlag | Boolean | Stores the uniform flag data. |
| trainingFlag | Boolean | Stores the training flag data. |
| bonus | Number | Stores the bonus data. |
| attendBonusRate | Number | Timestamp/Date for attendBonusRate. |
| attendBonus | Number | Timestamp/Date for attendBonus. |
| noticePay | Number | Stores the notice pay data. |
| noticeType | String | Stores the notice type data. |
| noticeDays | Number | Stores the notice days data. |
| otherReimburse | Number | Stores the other reimburse data. |
| excessSalDays | Number | Stores the excess sal days data. |
| excessSalary | Number | Stores the excess salary data. |
| saf | Number | Stores the saf data. |
| gratuity | Number | Timestamp/Date for gratuity. |
| gpa | Number | Stores the gpa data. |
| trustDed | Number | Stores the trust ded data. |
| mandateAmt | Number | Timestamp/Date for mandateAmt. |
| referenceNo | String | Stores the reference no data. |
| accountTrans | String | Stores the account trans data. |
| mediStatus | String | Timestamp/Date for mediStatus. |
| gpaType | String | Timestamp/Date for gpaType. |
| insuranceType | String | Stores the insurance type data. |
| processedTrn | Boolean | Stores the processed trn data. |
| processedUni | Boolean | Stores the processed uni 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. |
| holdDate | Date | Timestamp/Date for holdDate. |
| holdRemark | String | Detailed notes or remarks. |
| tDated | Date | Timestamp/Date for tDated. |
| 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. |
| gtliDed | Number | Unique reference to gtli Ded. |
| attendanceType | String | Timestamp/Date for attendanceType. |
| dutyType | String | Stores the duty type data. |
| isVoucher | Boolean | Stores the is voucher data. |
| monthDays | Number | Stores the month days data. |
| attendanceDays | Number | Timestamp/Date for attendanceDays. |
| otDays | Number | Stores the ot days data. |
| othrs | Number | Stores the othrs data. |