Unit
Documentation for the Unit database schema.
Fields
| Field | Data Type | Usage |
|---|---|---|
| anyId | ObjectId | Unique reference to any. |
| clientId | ObjectId | Unique reference to client. |
| employeeId | ObjectId | Unique reference to employee. |
| empCode | String | Stores the emp code data. |
| month | Number | Stores the month data. |
| year | Number | Stores the year data. |
| financialYearId | ObjectId | Unique reference to financial Year. |
| attendanceDays | Number | Timestamp/Date for attendanceDays. |
| nfhDays | Number | Stores the nfh days data. |
| monthDays | Number | Stores the month days data. |
| validator | String | Unique reference to validator. |
| dutyType | String | Stores the duty type data. |
| unit | ObjectId | Stores the unit data. |
| _id | String | Unique reference to _id. |
| unitName | String | The name or title of the unit. |
| unitCode | String | Stores the unit code data. |
| location | String | Timestamp/Date for location. |
| state | String | Timestamp/Date for state. |
| branch | String | Stores the branch data. |
| region | String | Stores the region data. |
| designationId | ObjectId | Unique reference to designation. |
| employeeName | String | The name or title of the unit. |
| otdays | Number | Stores the otdays data. |
| othrs | Number | Stores the othrs data. |
| remarks | String | Detailed notes or remarks. |
| fullDays | Number | Stores the full days data. |
| present | Number | Stores the present data. |
| sickLeave | Number | Stores the sick leave data. |
| leaveWithoutPay | Number | Stores the leave without pay data. |
| nationalHoliday | Number | Unique reference to national Holiday. |
| doubleNationalHoliday | Number | Unique reference to double National Holiday. |
| weeklyOff | Number | Stores the weekly off data. |
| lateHours | Number | Timestamp/Date for lateHours. |
| presentBeforeIncrement | Number | Stores the present before increment data. |
| presentAfterIncrement | Number | Stores the present after increment data. |
| specialPaidDays | Number | Unique reference to special Paid Days. |
| incomeTax | Number | Stores the income tax data. |
| cessSurcharge | Number | Stores the cess surcharge data. |
| educationCessCharge | Number | Timestamp/Date for educationCessCharge. |
| nonFunctionalHolidays | Number | Unique reference to non Functional Holidays. |
| overTimeRate | Number | Timestamp/Date for overTimeRate. |
| otRate | Number | Timestamp/Date for otRate. |
| weeklyDutyDays | Number | Stores the weekly duty days data. |
| lunchDeduction | Number | Stores the lunch deduction data. |
| transportDeduction | Number | Stores the transport deduction data. |
| loanDeduction | Number | Stores the loan deduction data. |
| medicalInsuranceDeduction | Number | Stores the medical insurance deduction data. |
| isProcessed | Boolean | Stores the is processed 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. |
| hostIp | String | Stores the host ip data. |
| hostName | String | The name or title of the unit. |
| insertedDate | Date | Timestamp/Date for insertedDate. |
| attendanceType | ObjectId | Timestamp/Date for attendanceType. |
| 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. |