ESIData
Documentation for the ESIData database schema.
Fields
| Field | Data Type | Usage |
|---|---|---|
| companyId | ObjectId | Unique reference to company. |
| original_filename | String | The name or title of the esidata. |
| metadata | Mixed | Timestamp/Date for metadata. |
| summary | Mixed | Stores the summary data. |
| month | Number | Stores the month data. |
| min | Number | Stores the min data. |
| max | Number | Stores the max data. |
| year | Number | Stores the year data. |
| employee_data | String | Timestamp/Date for employee_data. |
| sno | String | Stores the sno data. |
| is_disable | String | Stores the is_disable data. |
| ip_number | String | Stores the ip_number data. |
| ip_name | String | The name or title of the esidata. |
| no_of_days | Number | Stores the no_of_days data. |
| total_wages | Number | Stores the total_wages data. |
| ip_contribution | Number | Stores the ip_contribution data. |
| reason | String | Stores the reason data. |
| uploadedBy | ObjectId | Stores the uploaded by data. |
| uploadDate | Date | Timestamp/Date for uploadDate. |
| isProcessed | Boolean | Stores the is processed data. |
| processingStatus | String | Timestamp/Date for processingStatus. |
| processingNotes | String | Stores the processing notes data. |
| 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. |