PFData
Documentation for the PFData database schema.
Fields
| Field | Data Type | Usage |
|---|---|---|
| companyId | ObjectId | Unique reference to company. |
| original_filename | String | The name or title of the pfdata. |
| metadata | Mixed | Timestamp/Date for metadata. |
| 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. |
| sl_no | String | Stores the sl_no data. |
| uan | String | Stores the uan data. |
| name_as_per_return | String | The name or title of the pfdata. |
| name_as_per_uan_repository | String | The name or title of the pfdata. |
| gross_wages | String | Stores the gross_wages data. |
| wages_epf | String | Stores the wages_epf data. |
| wages_eps | String | Stores the wages_eps data. |
| wages_edli | String | Stores the wages_edli data. |
| contribution_remitted_ee | String | Stores the contribution_remitted_ee data. |
| contribution_remitted_eps | String | Stores the contribution_remitted_eps data. |
| contribution_remitted_er | String | Stores the contribution_remitted_er data. |
| contribution_remitted_refunds | String | Stores the contribution_remitted_refunds data. |
| ncp_days | String | Stores the ncp_days data. |
| empCode | String | Stores the emp code 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. |