employeeIncrement
Documentation for the employeeIncrement database schema.
Fields
| Field | Data Type | Usage |
|---|---|---|
| companyId | ObjectId | Unique reference to company. |
| empId | ObjectId | Unique reference to emp. |
| 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. |
| teamHead | ObjectId | Stores the team head data. |
| siteManager | ObjectId | Stores the site manager data. |
| foodDeduction | String | Stores the food deduction data. |
| effectiveSalary | Boolean | Stores the effective salary data. |
| costCentreId | ObjectId | Unique reference to cost Centre. |
| bankId | ObjectId | Unique reference to bank. |
| bankAccountNo | String | Stores the bank account no data. |
| basedOn | String | Stores the based on data. |
| newCityId | ObjectId | Unique reference to new City. |
| newUnitId | ObjectId | Unique reference to new Unit. |
| newDepartmentId | ObjectId | Unique reference to new Department. |
| newDesignationId | ObjectId | Unique reference to new Designation. |
| newNatureId | ObjectId | Unique reference to new Nature. |
| newClassId | ObjectId | Unique reference to new Class. |
| newCostCentreId | ObjectId | Unique reference to new Cost Centre. |
| newBankId | ObjectId | Unique reference to new Bank. |
| newBankAccountNo | String | Stores the new bank account no data. |
| newBasedOn | String | Stores the new based on data. |
| grade | ObjectId | Stores the grade data. |
| newGrade | ObjectId | Stores the new grade data. |
| pfApplicable | Boolean | Stores the pf applicable data. |
| gratuityApplicable | Boolean | Timestamp/Date for gratuityApplicable. |
| safetyAllowanceApplicable | Boolean | Stores the safety allowance applicable data. |
| depAllowanceApplicable | Boolean | Stores the dep allowance applicable data. |
| bonusApplicable | Boolean | Stores the bonus applicable data. |
| dated | Date | Timestamp/Date for dated. |
| effectiveFrom | Date | Stores the effective from data. |
| ctcBasic | Number | Stores the ctc basic data. |
| incrementPercentage | Number | Stores the increment percentage data. |
| incrementAmount | Number | Monetary or numeric value. |
| newCtcBasic | Number | Stores the new ctc basic data. |
| remarks | ObjectId | Detailed notes or remarks. |
| approvalId | ObjectId | Unique reference to approval. |
| reportingManager | ObjectId | Stores the reporting manager data. |
| siteAllowance | ObjectId | Stores the site allowance data. |
| newSiteAllowance | ObjectId | Stores the new site allowance data. |
| fooding | ObjectId | Stores the fooding data. |
| newFooding | ObjectId | Stores the new fooding 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. |
| status | String | Timestamp/Date for status. |
| isDeleted | Boolean | Stores the is deleted data. |
| deletedBy | ObjectId | Stores the deleted by data. |
| deletedTime | Date | Timestamp/Date for deletedTime. |