The Teachers Regulation Branch Process is designed to create both a report of dues paid and an extract file list of certificate holders suitable for transmission to the TRB. Please refer to the TRB Employers Area User Manual for details and instructions on certificate verification and dues submissions.
The TRB extract files ######.CSV is created at SRB$OPSWRK and contains the following information:
-
Last Name
-
Certification Number (if available)
-
Birth date (formatted as YYYY-MM-DD or YYYY/MM/DD)
The TRB Employers Area User Manual states "We suggest the following naming convention. If you are a school district, the district number should be part of the name e.g. SD005-FEES2014-15. If you are an independent school or authority, the name of the authority/school should be part of the name, e.g. SCHOOLName-FEES2014-15. The maximum number of characters is 20."
This submission to TRB pulls the Teachers Certification number from the atrieveHR system based on the setting from the Display atrieveHR Certificate field of the User Specific Parameter Profile. The Certification number will remain blank in the extract file if this setting is not defined or the Teacher does not have a Certificate Number defined in the atrieveHR system.
Report Based on Range of Pay Periods or YTD Balance
-
Enter 'P' to define a range of pay periods to have the deduction amount accumulated from the employee's history. Only employees that had the deduction code taken for the range of pay periods will be included in the extract file
-
Enter 'Y' to pull the deduction amount as defined on the employee's deduction master.
When Selection is by Range of 'P'AY Periods:
Enter Starting Period for Dues Paid
-
Enter the staring pay period for a range of history periods to accumulate the dues amount.
Enter Ending Period for Dues Paid
-
Enter the ending pay period for a range of history periods to accumulate the dues amount.
Enter Teacher Regulation Deduction Codes
-
Enter the applicable deduction codes for collection of Teachers dues.
Report All or Selected Employees
Sort by Employee Number or Name
-
Enter 'E' to produce the report in employee number order.
-
Enter 'N' to produce the report in employee name order.
Report No Contributions, Omit, only Report
-
Enter 'N' to report all employees including those active employees with no contribution. Employees without a contribution amount will not be included in the extract listing to be sent to TRB.
-
Enter 'Y' to omit the reporting of employees with no contribution amount.
-
Enter 'O' to only report those active employees with no contribution amount.
Include Generation of Export File
-
Enter 'Y' to generate the export file to be submitted to TRB.
-
Enter 'N' to omit the creation of the export file.
The report lists the following:
-
Employee number and name
-
Employee status
-
Certification number
-
Birthdate formatted as submitted to TRB.
-
Contribution amount
-
Omission flag
-
Certificate Number
-
Total employees reported
-
Total employees exported
-
Total employees omitted from extract