EmployeePunchDetails
Get employee punch details.
Columns
| Name | Type | References | Description |
| EmployeeId [KEY] | String |
Employees.EmployeeId | The Id of the Employee. |
| SegmentsPunchId [KEY] | String | A unique identifier assigned to each punch or time entry, ensuring that each entry is distinct, traceable, and easily referenced for tracking purposes. | |
| CompanyId | String | The Paylocity Company Id. This is the unique value provided by Paylocity to each specific Payroll Entity. | |
| BadgeNumber | Integer | The Time and Labor badge number. | |
| RelativeStart | Datetime | The relative DateTime for the beginning of the WorkedShift in the format yyyy-MM-ddThh:mm:ss. | |
| RelativeEnd | Datetime | The relative DateTime for the end of the WorkedShift in the format yyyy-MM-ddThh:mm:ss. | |
| SegmentsOrigin | String | The associated origin of the time entry. | |
| SegmentsDate | Date | The date the worked shift segment took place. In the case of overnight shifts, this is the date these worked hours apply to in payroll and can play a role in some overtime calculations. | |
| SegmentsPunchType | String | The type of punch recorded, indicating categories such as work or lunch break. | |
| SegmentsRelativeStart | Datetime | The relative DateTime of the beginning of this segment after payroll policy rules are applied. This value is Null if the segment began with a missed punch. | |
| SegmentsRelativeEnd | Datetime | The relative DateTime of the end of this segment after payroll policy rules are applied. This value is Null if the segment ended with a missed punch. | |
| SegmentsRelativeOriginalStart | Datetime | The relative DateTimeOffset of the beginning of this segment before payroll policy rules are applied. This value is Null if the segment began with a missed punch. | |
| SegmentsRelativeOriginalEnd | Datetime | The relative DateTime of the end of this segment before payroll policy rules are applied. This value is Null if the segment ended with a missed punch. | |
| SegmentsDurationHours | Double | The total hours worked by the employee for a particular punch or time entry, reflecting the duration of their work. | |
| SegmentsEarnings | Double | The total earnings accrued by the employee for the specific punch or time entry, including wages, bonuses, or additional compensation. | |
| SegmentsCostCenters | String | A list of cost centers, at most one per cost center level, that this segment of the worked shift is allocated to. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description | |
| TestFlag | Boolean | A Boolean value that, when set to 'true', returns mock data. |