The OPS Data Collection option allows you to collect the required OPS information for the Public Bodies Report. This process generates a '.LST' file which reports information for reconciliation. This includes their salary, taxable benefits, expenses, EI, CPP and any amounts excluded.
Note: Responses to the prompts are saved as defaults for the next time the collection is run. The next time you are in this program, the system displays these defaults and prompts the following:
Is this Correct?
-
Enter 'Y' to accept the defaults.
-
Enter 'N' to change the responses to the prompts.
These changes are saved as the defaults for the next time the collection is run.
Use Live or Test payroll:
-
Enter 'L' to use a live payroll for the collection.
-
Enter 'T' to use a test payroll for the collection.
Payroll ID Number
-
Enter the ID number of the payroll to use for collection. Using the lookup will display all valid payroll ID numbers. A separate OPS Data Collection must be run for each payroll you wish to report on.
Enter Start Period
-
Enter the starting payroll period where the report is to begin.
Enter End Period
-
Enter the ending payroll period.
Pay Codes to Exclude
-
Enter up to 5 pay codes to exclude from the collection process. <Enter> to leave this field blank and include all pay codes.
Expense Pay Codes
-
Enter up to 5 pay codes that represent employee expenses. These codes are used by this collection process to separate employee salaries from expenses.
EI Deduction Codes
-
Enter up to 5 EI deduction codes.
CPP Deduction Codes
-
Enter up to 5 CPP deduction codes.
Taxable Benefit Codes
-
Enter up to 5 Taxable Benefit deduction codes (e.g., Medical, Group Life Insurance, interest on computer payback, etc.).
Use Employer Share or Benefit Amount
-
Enter 'B' to use the benefit amount as the Taxable Benefit code(s) to calculate the total amount of Taxable Benefits.
-
Enter 'S' to use the employer share.
Store by Employee # or by SIN #
-
Enter 'E' if OPS data is to be indexed by employee number
-
Enter 'S' if OPS data is to be indexed by SIN number.
Note: If you use SIN as your staff number or your staff number is the same as the vendor number used to pay employee expenses, then you should use 'E' employee number. Coordinate your choice here with your choice in the BAS data collection. Your goal is to report salaries and expenses on the same entry in the final report.
Select Elected Officials by Location or GL Number
-
Enter 'L' to determine if an employee is an elected official by checking the employee's location code. The location code appears on the Employees File Maintenance Screen in payroll.
-
If 'L' is entered the following prompt will appear:
Location Code for Elected Officials
-
Enter the payroll location code for elected officials.
-
Enter 'G' to determine if an employee is an elected official by specifying a GL number.
If 'G' is entered the following prompt will appear:
GL Number For Elected Officials
-
Enter a valid GL number. There are three ways the GL number can be matched to report elected officials.
-
GL on function line If there is a GL on the function line that matches, the employee will be reported.
-
Cost Centre If the function lines' GL field is blank, a cost centre is checked. If a pay code in the cost centre matches the employee's pay code, that is the GL that will be compared against the GL entered here. If no cost centre pay codes match the employee's pay code, the cost centre default GL is used.
-
Distribution Grid The Distribution Grid checks all associated Cost Centres for a matching GL. It uses the default GL on each Cost Center to try and match.
Note: All elected officials will be printed on the report regardless of whether they are over or under the minimum reported amount.
Position Desc by Occupation/Employee Type
-
Enter 'O' to print employee occupation code description on the report under the employee title.
-
Enter 'E' to print employees type description on the report under the employee title.