Pay Transparency Reporting for British Columbia, CA

The CSV file generated from this report enables employers to directly upload data into British Columbia’s Pay Transparency Reporting Tool. For a sample CSV report, employers can visit the official BC website.

Parameters

Parameter Name	Options	Description
Branch (Transaction)	List of available branches	Use this to filter by transaction's branch
Start Date (Accounting Period Date)
End Date (Accounting Period Date)
Hours Worked Type	List of Transactional Pay Codes	Use this filter to pull the results based on the selected transaction types
Ordinary Pay Type	List of Transactional Pay Codes	Use this filter to pull the results based on the selected transaction types
Special Salary Type	List of Transactional Pay Codes	Use this filter to pull the results based on the selected transaction types
Overtime Pay Type	List of Transactional Pay Codes	Use this filter to pull the results based on the selected transaction types
Bonus Pay Type	List of Transactional Pay Codes	Use this filter to pull the results based on the selected transaction types

Report Fields

Field Name	Description
GenderCode	Employee's Gender
HoursWorked	Total Hours Worked (Sum of Pay Units) for selected accounting period date range
OrdinaryPay	Item Pay for the selected transaction type from parameter "Ordinary Pay Type"
SpecialSalary	Item Pay for the selected transaction type from parameter "Special Salary Type"
OvertimeHours	Pay Units for the selected transaction type from parameter "Overtime Pay Type"
OvertimePay	Item Pay for the selected transaction type from parameter "Overtime Pay Type"
BonusPay	Item Pay for the selected transaction type from parameter "Bonus Pay Type"