SalaryComparisonReport
Documentation for the SalaryComparisonReport database schema.
Fields
| Field | Data Type | Usage |
|---|---|---|
| companyId | ObjectId | Unique reference to company. |
| branchId | ObjectId | Unique reference to branch. |
| month | Number | Stores the month data. |
| min | Number | Stores the min data. |
| max | Number | Stores the max data. |
| year | Number | Stores the year data. |
| unitId | ObjectId | Unique reference to unit. |
| officeName | String | The name or title of the salarycomparisonreport. |
| code | String | Stores the code data. |
| locname | String | The name or title of the salarycomparisonreport. |
| prevMonth | Number | Stores the prev month data. |
| prevYear | Number | Stores the prev year data. |
| prevStrength | Number | Stores the prev strength data. |
| prevNetPay | Number | Stores the prev net pay data. |
| prevWDays | Number | Stores the prev w days data. |
| prevOTDays | Number | Stores the prev o t days data. |
| prevNetOT | Number | Stores the prev net o t data. |
| prevNetHRSOT | Number | Stores the prev net h r s o t data. |
| prevNFH | Number | Stores the prev n f h data. |
| prevVoucherAmt | Number | Stores the prev voucher amt data. |
| prevTakeHome | Number | Stores the prev take home data. |
| prevCTC | Number | Stores the prev c t c data. |
| currMonth | Number | Stores the curr month data. |
| currYear | Number | Stores the curr year data. |
| currStrength | Number | Stores the curr strength data. |
| currWDays | Number | Stores the curr w days data. |
| currOTDays | Number | Stores the curr o t days data. |
| currNetOT | Number | Stores the curr net o t data. |
| currVoucherAmt | Number | Stores the curr voucher amt data. |
| currTakeHome | Number | Stores the curr take home data. |
| currCTC | Number | Stores the curr c t c data. |
| totalTRF | Number | Stores the total t r f data. |
| remainingSalary | Number | Stores the remaining salary data. |
| pendingSalaryNoOfEmp | Number | Stores the pending salary no of emp data. |
| calculatedAt | Date | Timestamp/Date for calculatedAt. |
| createdBy | ObjectId | Timestamp/Date for createdBy. |
| updatedBy | ObjectId | Timestamp/Date for updatedBy. |