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" |
Comments
0 commentsPlease sign in to leave a comment.