timeoffrequest
Stores records of employee time-off requests, including approval status and requested dates.
Columns
| Name | Type | References | Description |
| approvalstatus | String | Indicates the approval status of the time-off request, tracking whether it is pending, approved, or denied. Helps managers and HR teams monitor leave approvals. | |
| creationdate | String | Records the date when the time-off request was created, providing a timestamp for submission tracking. Useful for auditing and tracking employee leave history. | |
| employee | String | Identifies the employee who submitted the time-off request, ensuring that leave records are accurately linked to individuals. | |
| enddate | Date | Specifies the last date of the requested time off, marking the end of the employee’s absence. | |
| externalid | String | Stores an external identifier for the time-off request, facilitating integration with third-party HR and payroll systems for better record synchronization. | |
| id | Integer | Stores the unique identifier for the time-off request, ensuring proper tracking and management within the system. | |
| internalid | Integer | Represents the internal system-generated identifier for the time-off request, used for database operations and backend processes. | |
| isautodeletetimeentry | Boolean | Indicates whether associated time entries should be automatically deleted when the time-off request is approved. If the value is true, the system removes overlapping time entries, preventing double counting of work hours. | |
| message | String | Stores any additional comments or notes submitted with the time-off request. Employees may use this field to provide reasons for the leave or communicate special circumstances. | |
| startdate | Date | Specifies the first date of the requested time off, marking the beginning of the employee’s leave period. |