The Time Record Details report expands on the information provided by the Time Records report–employee hours, wages, tips, sales information–and includes breaks and adjustments made to the time record.
The user role must have permission to access this report:
- By default, records are shown expanded at the job level to show detailed information for each employee.
- Record level hierarchy:
- Employee name
- Employee number
- Job
- Site number
- Breaks and adjustments
- Site number
- Job
- Employee number
- Employee name
- Record level hierarchy:
- Columns can be filtered to show a subset of records. (Timestamp column cannot be filtered.)
- Report can be exported to Excel, PDF or CSV formats.
Info | ||
---|---|---|
| ||
Note: An optional feature allows Admin users to select the number of decimal places to use when rounding employee hours on time record reports. See Employee Reports for more information. |
Operation
The Time Record Details report can be run by site(s), site group(s), job(s) and start and end date.
...
Site(s), Group(s), Job(s), Business Date | Select site(s), site group(s) and job(s); specify date range for report |
Site # | Site number |
Name | Employee name |
Emp # | Employee number |
Job | Job(s) assigned to employee |
Job External Code | External code for job type used in time record |
Clock -in | Clock-in date and time |
Clock-out | Clock-out date and time |
Reg Hrs | Total regular hours worked between clock-in and clock-out |
OT Hrs | Overtime hours worked |
DT Hrs | Double-time hours worked |
Total Hrs | Total hours: Regular + overtime + double time |
Reg. Wages | Wages based on pay rate and regular hours worked |
OT Wages | Wages based on overtime pay rate for overtime hours worked |
DT Wages | Wages based on double-time pay rate for double-time hours worked |
Total Wages | Total wages for all hours worked |
Pay Rate | Employee rate of pay |
Declared Tips | Tips declared |
Net Sales | Net sales |
Gross Sales | Gross sales |
Export Report | Save file in Excel, PDF or CSV format
|
EXPANDED ADJUSTMENT/BREAK DETAILThe following job permissions are required to perform certain types of adjustments:
| |
Record TypeThe type of record, e.g., Paid Break, Adjustment, etc. | Record types:
|
Clock-in | Clock-in date and time |
Clock-out | Clock-out date and time |
Clock-in Before Adj. | Clock-in date and time prior to adjustment |
Clock-in After Adj. | Clock-in date and time after adjustment |
Clock-out Before Adj. | Clock-out date and time prior to adjustment |
Clock-out After Adj. | Clock-out date and time after adjustment |
Break Type Before Adj. | Break types:
Break type before adjustment |
Break Type After Adj. | Break type after adjustment |
Job Before Adj. | Job before adjustment |
Job After Adj. | Job after adjustment |
Adjusted By | Name of user that performed the time record adjustment |
Reason | Adjustment reason (configure in Adjustments in ECM) |
Date/Time Adj. | Date and time adjustment was performed |
Record Deleted | Shows if a record was deleted (Yes/No) |
Acknowledgment | Status of adjustment acknowledgment by employee:
|
Note: The clock-in data is stored in the cloud on ECM when a user clocks in, but is not immediately shown on the Time Records report when there is only a clock-in record. The Time Records report will display this data when there is a clock-in AND a clock-out record.
Related articles
Time Records: Acknowledge Adjustments
Time Records Adjustments reportReferences:
State of California - Department of Industrial Relations FAQ: https://www.dir.ca.gov/dlse/faq_overtime.htm