timesheet
Records employee work hours, tracking regular, overtime, and project-based time logs.
Columns
| Name | Type | References | Description |
| allocatedhours | String | Records the number of hours allocated to an employee for a specific period, helping track resource utilization. | |
| approvalstatus | String | Indicates the approval status of the timesheet, tracking whether it is pending, approved, or rejected. | |
| customform | String | Specifies the custom form used for the timesheet, allowing for organization-specific formatting and fields. | |
| employee | String | Identifies the employee associated with the timesheet, ensuring accurate payroll and work hour tracking. | |
| enddate | Date | Specifies the last date covered by the timesheet, marking the end of the recorded work period. | |
| externalid | String | Stores an external identifier for the timesheet, facilitating integration with third-party systems. | |
| id | Integer | Stores the unique identifier for the timesheet, ensuring proper tracking and management. | |
| iscomplete | Boolean | Indicates whether the timesheet is marked as complete. If the value is true, no further changes can be made. | |
| plannedhours | String | Specifies the number of hours initially planned for the employee, used for comparing actual vs. expected work time. | |
| rejectedhours | String | Records the number of hours that were rejected during the approval process, requiring adjustment or resubmission. | |
| startdate | Date | Specifies the first date covered by the timesheet, marking the beginning of the recorded work period. | |
| submittedhours | String | Indicates the total number of hours submitted for approval, providing insight into employee-reported work time. | |
| subsidiary | String | Links the timesheet to a specific subsidiary, ensuring proper financial reporting for multi-entity organizations. | |
| templatestored | String | Specifies the stored template associated with the timesheet, facilitating reuse of predefined work hour structures. | |
| totalhours | String | Calculates the total number of hours recorded in the timesheet, including approved and pending hours. | |
| trandate | Date | Records the transaction date for the timesheet, used for payroll and accounting purposes. | |
| workcalendarhours | String | Defines the standard number of hours according to the work calendar, serving as a reference for work schedule compliance. |