SalaryEmployeeMaster
Documentation for the SalaryEmployeeMaster database schema.
Fields
| Field | Data Type | Usage |
|---|---|---|
| companyId | ObjectId | Unique reference to company. |
| unitId | ObjectId | Unique reference to unit. |
| recId | ObjectId | Unique reference to rec. |
| empCode | String | Stores the emp code data. |
| photo | String | Stores the photo data. |
| isHeadMapping | Boolean | Stores the is head mapping data. |
| isSalaryStopped | Boolean | Stores the is salary stopped data. |
| signature | String | Timestamp/Date for signature. |
| stationedAt | mongoose.Types.ObjectId | Timestamp/Date for stationedAt. |
| gender | String | Stores the gender data. |
| maritalStatus | String | Timestamp/Date for maritalStatus. |
| spouseName | String | The name or title of the salaryemployeemaster. |
| paymentMode | String | Stores the payment mode data. |
| leftStatus | String | Timestamp/Date for leftStatus. |
| reasonForLeave | String | Stores the reason for leave data. |
| leavingReason | String | Stores the leaving reason data. |
| manualEmpCode | String | Stores the manual emp code data. |
| empName | String | The name or title of the salaryemployeemaster. |
| fatherName | String | The name or title of the salaryemployeemaster. |
| motherName | String | The name or title of the salaryemployeemaster. |
| amount | Number | Monetary or numeric value. |
| otasper | String | Stores the otasper data. |
| totalEarnings | Number | Stores the total earnings data. |
| totalDeduction | Number | Stores the total deduction data. |
| grade | ObjectId | Stores the grade data. |
| religionId | ObjectId | Unique reference to religion. |
| categoryId | ObjectId | Unique reference to category. |
| cityId | ObjectId | Unique reference to city. |
| departmentId | ObjectId | Unique reference to department. |
| subdepartmentId | ObjectId | Unique reference to subdepartment. |
| roleId | ObjectId | Unique reference to role. |
| designationId | ObjectId | Unique reference to designation. |
| natureId | ObjectId | Unique reference to nature. |
| costCentreId | ObjectId | Unique reference to cost Centre. |
| immediateManagerId | ObjectId | Unique reference to immediate Manager. |
| reportingManagerId | ObjectId | Unique reference to reporting Manager. |
| bankId | ObjectId | Unique reference to bank. |
| bankAccountNumber | String | Stores the bank account number data. |
| ifscCode | String | Stores the ifsc code data. |
| panNumber | String | Stores the pan number data. |
| adhaarCardNumber | String | Stores the adhaar card number data. |
| referenceNo | String | Stores the reference no data. |
| dateOfBirth | Date | Timestamp/Date for dateOfBirth. |
| dateOfJoining | Date | Timestamp/Date for dateOfJoining. |
| dateOfConfirmation | Date | Timestamp/Date for dateOfConfirmation. |
| safStartDate | Date | Timestamp/Date for safStartDate. |
| contractEndDate | Date | Timestamp/Date for contractEndDate. |
| resignDate | Date | Timestamp/Date for resignDate. |
| employeeLeftStatus | String | Timestamp/Date for employeeLeftStatus. |
| leftDate | Date | Timestamp/Date for leftDate. |
| leftRemarks | String | Detailed notes or remarks. |
| transferStatus | Boolean | Timestamp/Date for transferStatus. |
String | Primary email address. | |
| basedOn | String | Stores the based on data. |
| currentTotalCompensation | Number | Timestamp/Date for currentTotalCompensation. |
| basicSalary | Number | Stores the basic salary data. |
| providentFundApplicable | Boolean | Unique reference to provident Fund Applicable. |
| employeeStateInsuranceApplicable | Boolean | Timestamp/Date for employeeStateInsuranceApplicable. |
| esiBasedOn | String | Stores the esi based on data. |
| esionnh | Boolean | Stores the esionnh data. |
| esiNo | String | Stores the esi no data. |
| esiOnOThours | Boolean | Stores the esi on o thours data. |
| pensionApplicable | Boolean | Stores the pension applicable data. |
| ac10NotApplicable | Boolean | Stores the ac10 not applicable data. |
| pfNo | String | Stores the pf no data. |
| voluntaryProvidentFundApplicable | Boolean | Unique reference to voluntary Provident Fund Applicable. |
| voluntaryProvidentFundType | String | Unique reference to voluntary Provident Fund Type. |
| voluntaryProvidentFundAmount | Number | Unique reference to voluntary Provident Fund Amount. |
| professionalTaxApplicable | Boolean | Stores the professional tax applicable data. |
| gratuityApplicable | Boolean | Timestamp/Date for gratuityApplicable. |
| safApplicable | Boolean | Stores the saf applicable data. |
| dependantApplicable | Boolean | Stores the dependant applicable data. |
| bonusApplicable | Boolean | Stores the bonus applicable data. |
| bonusBasedOn | String | Stores the bonus based on data. |
| lwfApplicable | Boolean | Stores the lwf applicable data. |
| leaveOnPortal | Boolean | Stores the leave on portal data. |
| totalExperience | Number | Stores the total experience data. |
| isHOD | Boolean | Stores the is h o d data. |
| password | String | Stores the password data. |
| isPasswordChanged | Boolean | Stores the is password changed data. |
| disputedApplicable | Boolean | Stores the disputed applicable data. |
| activeStatus | Boolean | Timestamp/Date for activeStatus. |
| remarks | String | Detailed notes or remarks. |
| siteAllowance | Number | Stores the site allowance data. |
| makeSalarySite | Boolean | Stores the make salary site data. |
| gpaAmount | Number | Monetary or numeric value. |
| trustDeduction | Number | Stores the trust deduction data. |
| gtliDeduction | Number | Unique reference to gtli Deduction. |
| companyPFNo | String | Stores the company p f no data. |
| uanNo | String | Stores the uan no data. |
| companyESINo | String | Stores the company e s i no data. |
| fooding | Number | Stores the fooding data. |
| appraisalApplicable | Boolean | Stores the appraisal applicable data. |
| appraisalReportingManagerApplicable | Boolean | Stores the appraisal reporting manager applicable data. |
| appraisalSiteManagerApplicable | Boolean | Stores the appraisal site manager applicable data. |
| MakeSalarySiteBases | Boolean | Stores the make salary site bases data. |
| appraisalFromDate | Date | Timestamp/Date for appraisalFromDate. |
| appraisalToDate | Date | Timestamp/Date for appraisalToDate. |
| previousRating | Number | Timestamp/Date for previousRating. |
| siteIncrementApplicable | Boolean | Stores the site increment applicable data. |
| lastPromotionDate | Date | Timestamp/Date for lastPromotionDate. |
| workingOnHO | Boolean | Stores the working on h o data. |
| recalculateHead | Boolean | Timestamp/Date for recalculateHead. |
| PFBasedOn | String | Stores the p f based on data. |
| PermanentContactNo | String | Stores the permanent contact no data. |
| PermanentAddress | String | Stores the permanent address data. |
| CurrentContactNo | String | Stores the current contact no data. |
| currentAddress | String | Stores the current address data. |
| approvingEmployeeId | ObjectId | Unique reference to approving Employee. |
| approveStatus | Boolean | Timestamp/Date for approveStatus. |
| foMobile | String | Contact phone number. |
| nomineeNumber | String | Stores the nominee number data. |
| foDesignation | String | Timestamp/Date for foDesignation. |
| foEmail | String | Primary email address. |
| 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. |
| expiryDate | Date | Timestamp/Date for expiryDate. |
| hostIP | String | Stores the host i p data. |
| hostName | String | The name or title of the salaryemployeemaster. |
| 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. |
| nomineeName | String | The name or title of the salaryemployeemaster. |
| relWithNominee | String | Stores the rel with nominee data. |
| vechileStatus | Boolean | Timestamp/Date for vechileStatus. |
| languageKnown | String | Stores the language known data. |
| jobType | String | Stores the job type data. |
| bloodGroup | String | Stores the blood group data. |
| qualification | String | Timestamp/Date for qualification. |
| correspondenceAddress | String | Stores the correspondence address data. |
| correspondenceAddress1 | String | Stores the correspondence address1 data. |
| correspondenceThana | String | Stores the correspondence thana data. |
| correspondenceDistrict | String | Stores the correspondence district data. |
| correspondenceCity | String | Stores the correspondence city data. |
| correspondenceState | String | Timestamp/Date for correspondenceState. |
| correspondencePin | String | Stores the correspondence pin data. |
| correspondenceContactNo | String | Stores the correspondence contact no data. |
| PermanentAddress1 | String | Stores the permanent address1 data. |
| PermanentThana | String | Stores the permanent thana data. |
| PermanentDistrict | String | Stores the permanent district data. |
| PermanentCity | String | Stores the permanent city data. |
| PermanentState | String | Timestamp/Date for PermanentState. |
| PermanentPin | String | Stores the permanent pin data. |
| serviceManType | String | Stores the service man type data. |
| height | String | Stores the height data. |
| weight | String | Stores the weight data. |
| bloodRelationEmp | Boolean | Timestamp/Date for bloodRelationEmp. |
| uniformLoanDeducted | Boolean | Stores the uniform loan deducted data. |
| traineeLoanDeducted | Boolean | Stores the trainee loan deducted data. |
| BillableType | String | Stores the billable type data. |