The Unauthorized Records - Period Review report uses the Unauthorized Records topic to show pay data from timesheet records in Period Review that haven’t been authorized by a manager or an employee.
Fields
| Field Name | Group by | Sort Order | Totals |
|---|---|---|---|
| Employee Number | Yes | A to Z | |
| Employee Display Name | Ascending | ||
| Manager Authorized | |||
| Employee Time Entry Time Start | |||
| Authorized by Manager |
Custom Fields
Punch Date
The Punch Date custom field shows the employee time entry date. It uses the following expression:
EmployeePunch.TimeStart
Authorized by Manager
The Authorized by Manager custom field indicates if the manager authorized the record. It uses the following expression:
CASE WHEN EmployeePunch.ManagerAuthorized=1 THEN 'Yes' WHEN EmployeePayAdjust.ManagerAuthorized=1 THEN 'Yes' ELSE 'No' END
Actual In
The Actual In custom field shows the start time of the pay summary report. It uses the following expression:
CAST(EmployeePaySummary.TimeStart AS TIME)
Actual Out
The Actual Out custom field shows the end time of the pay summary report. It uses the following expression:
CAST(EmployeePaySummary.TimeEnd AS TIME)
Pay Date
The Pay Date custom field shows the employee pay date. It uses the following expression:
ISNULL(CONVERT(VARCHAR(10), EmployeePaySummary.PayDate, 120), '')
Authorized by Employee
The Authorized by Employee custom field indicates if the employee authorized the record. It uses the following expression:
CASE WHEN EmployeePunch.EmployeeAuthorized=1 THEN 'Yes' WHEN EmployeePayAdjust.EmployeeAuthorized=1 THEN 'Yes' ELSE 'No' END
Normal
The Normal custom field shows the pay summary hours where the Premium checkbox isn’t selected. It uses the following expression:
CASE WHEN EmployeePaySummary.IsPremium = 0 THEN EmployeePaySummary.NetHours ELSE 0 END
Other
The Other custom field shows the pay summary hours where the Premium checkbox is selected. It uses the following expression:
CASE WHEN EmployeePaySummary.IsPremium = 1 THEN EmployeePaySummary.NetHours ELSE 0 END