Defining BPS Reporting Units

To define BPS reporting units, use the Reporting Unit Table (BPS_REPORT_UNIT) component.

Page Name

Definition Name

Usage

BPS Activities Page (Business Payrolls Survey activities)

BPS_RU_TBL1

Specify the pay group and BPS activities that define a reporting unit.

BPS Locations Page (Business Payrolls Survey locations)

BPS_RU_TBL2

Specify the BPS locations that define a reporting unit.

A BPS reporting unit represents a group of employees within a company that Statistics Canada has selected for the survey. Each reporting unit, uniquely identified within a company by the reporting unit ID, corresponds to one Payroll record (Record Type 2) in the survey EDR file.

A reporting unit is defined by:

  • Business activities.

  • Business locations.

  • Pay frequencies of employees.

    (Statistics Canada refers to pay frequency as pay period type.)

Note: To ensure that each employee appears only once per survey, assign a unique combination of pay group, BPS activity, and tax location information for each reporting unit.

Use the BPS Reporting Unit table to establish the relationship between these criteria. For each BPS Reporting Unit record:

  • Define the required business activities and locations using the Tax Location Code and Activity ID fields.

  • Assign a pay group to ensure that each reporting unit includes only those employees with the same pay frequency (for example, biweekly or monthly) and pay period dates.

The system selects employees whose job data fulfills the criteria that is defined in the BPS Reporting Unit table. It extracts and reports their payroll information in the Payroll record of the EDR file.

This diagram shows the relationship of entities related to the BPS reporting unit:

Image: Illustration of entities related to the BPS reporting unit

This diagram shows the relationship of entities related to the BPS reporting unit.

Illustration of entities related to the BPS reporting unit

Use the BPS Activities (Business Payrolls Survey activities) page (BPS_RU_TBL1) to specify the pay group and BPS activities that define a reporting unit.

Navigation

Set Up HCM > Product Related > Payroll for North America > Business Payrolls Survey CAN > Reporting Unit Table > BPS Activities

Image: BPS Activities page

This example illustrates the fields and controls on the BPS Activities page.

BPS Activities page

Reporting Unit Information

Field or Control

Definition
Pay Group

Specify the pay group that represents the group of employees selected for the survey. Specify only one pay group for each reporting unit. This ensures that each reporting unit reports on employees of the same pay frequency and pay period dates.

Activity Information

Field or Control

Definition
Activity ID

Select the BPS activity that is required for reporting within the reporting unit. If this field is blank, the system reports all activities.

Use the BPS Locations (Business Payrolls Survey locations) page (BPS_RU_TBL2) to specify the BPS locations that define a reporting unit.

Navigation

Set Up HCM > Product Related > Payroll for North America > Business Payrolls Survey CAN > Reporting Unit Table > BPS Locations

Image: BPS Locations page

This example illustrates the fields and controls on the BPS Locations page.

BPS Locations page

Location Information

Field or Control

Definition
Tax Location Code

Define the tax locations required for reporting within the specified reporting unit. If this field is blank, the system reports all tax location codes.