Unauthorized Records

The Unauthorized Records report uses the Unauthorized Records topic to show employees who have pay details that haven’t been authorized by a manager or by the employee. It contains details about employees, jobs, clock entries, and authorizations.

Fields

Fields included in the report template

Field Name	Group by	Sort Order	Totals
Employee Number	Yes	A to Z
Employee Name		Ascending
Pay Date		Z to A
Location
Department
Job
Actual In
Actual Out
Authorized by Manager
Authorized by Employee
Pay Code
Pay Category
Normal
Other
Amount

Custom Fields

Pay Date

The Pay Date custom field displays the employee pay date. It uses the following expression:

ISNULL(CONVERT(VARCHAR(10), EmployeePaySummary.PayDate, 120), '')

Actual In

The Actual In custom field displays 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 displays the end time of the pay summary report. It uses the following expression:

CAST(EmployeePaySummary.TimeEnd AS TIME)

Authorized by Manager

The Authorized by Manager custom field indicates if the manager authorized the record. It uses the following expression:

CASE
    WHEN ISNULL(EmployeePunch.ManagerAuthorized, 0) = 0 THEN 'No'
    ELSE 'Yes'
END

Authorized by Employee

The Authorized by Employee custom field indicates if the employee authorized the record. It uses the following expression:

CASE
    WHEN ISNULL(EmployeePunch.EmployeeAuthorized, 0) = 0 THEN 'No'
    ELSE 'Yes'
END

Normal

The Normal custom field displays 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 displays 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

Filters

The template includes the following filters: