TRS Pension Report | PowerSchool Atrieve

The TRS Pension Report creates the report and electronic file for submission to the Montana Teachers Retirement division. The TRS report requires the Montana Pension Profile to be completed. This process requires the logical SRB$EXPOrT be defined in the payroll's LOGICALS.COM file. The SRB$EXPOrT logical defines the location where the electronic file will be created.

This process allows new teachers pension reports to be generated. All reported pension information might then be changed as necessary through the TRS/PERS Pension Record Changes. When pension information has been changed through the pension record changes, a new printed report and tape file may then be recreated through the reprint option on this process.

Changes made through the pension record changes does not affect the actual payroll history information. When changes to the actual payroll history is required, this step should be done first and the pension report should then be re-run using the generation option.

The pension electronic file created by both phases of this option is created at the location defined by the logical SRB$EXPOrT. The electronic file is named TTAP####. YPP, where #### is the payroll ID code (Payroll Master profile) and YPP is the starting pay period given during the running of this process. The electronic pension file contains the employees address and email information as is defined on the employee's master screen.

The electronic pension file format is:

Detail Record

Field #
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32

Field Name
Agency No
Reporting Month
Reporting Year
Record Type
Action Code
Member Status Code
SSN
Last Name
First Name
Middle Init
Regular Earnings
Monthly Contribution
Monthly Hours
Monthly FTE
Termination Pay Contribution
Term. Pay Option
Add'l Contribution
Add'l Employer Contribution
Employer Term Pay Contrib.
Filler 1
Address Line 1
Address Line 2
Address Line 3
City
State
Zip Code + 4
Home Phone
Work Phone
Work Extension
Cell Phone
Email Address
Filler 2

Start Pos
1
7
9
11
12
13
14
23
43
63
64
73
82
87
90
99
100
109
118
127
181
211
241
271
291
293
303
313
323
328
338
388

Length
6
2
2
1
1
1
9
20
20
1
9
9
5
3
9
1
9
9
9
54
30
30
30
20
2
10
10
10
5
10
50
124

Type
Char
Char
Char
Char
Char
Char
Char
Char
Char
Char
Numeric (9,2)
Numeric (9,2)
Numeric (5,2)
Numeric (3,2)
Numeric (9,2)
Char
Numeric (9,2)
Numeric (9,2)
Numeric (9,2)
Char
Char
Char
Char
Char
Char
Char
Char
Char
Char
Char
Char
Char

Notes

1=Detail
A=Add N=Normal T=Term
Full, Hourly, Part-time, Working-Retired TIAA, Reemployed Retired

Emp term pay Contribution amount

Reserved for future use

With area code, no special characters
With area code, no special characters

With area code, no special characters

Reserved for future use

Summary Record: Summary record totals do not include Working Retired.

Field #
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23

Field Name
Agency No
Reporting Month
Reporting Year
Record Type
Reporting Month (1)
Reporting Year (1)
Reporting Month (2)
Reporting Year (2)
Reporting Month (3)
Reporting Year (3)
FTE Fulltime Hours
Total FTE (F & P)
Total Hours
Total Earnings
Total Employee Contribution
Total Employer Contribution
Total Add'l Employee Contrib
Total Add'l Employer Contrib
Total Employer Term Pay Contr
Total TIAA Earnings
Total TIAA Contributions
Total Due
Total Remitted

Start Pos
1
7
9
11
23
25
27
29
31
33
35
40
47
56
67
78
89
100
111
122
133
144
155

Length
6
2
2
1
2
2
2
2
2
2
5
7
9
11
11
11
11
11
11
11
11
11
11

Type
Char
Char
Char
Char
Char
Char
Char
Char
Char
Char
Numeric (5,2)
Numeric (7,2)
Numeric (9,2)
Numeric (11,2)
Numeric (11,2)
Numeric (11,2)
Numeric (11,2)
Numeric (11,2)
Numeric (11,2)
Numeric (11,2)
Numeric (11,2)
Numeric (11,2)
Numeric (11,2)

Notes

2=Summary

# of hours in report period = to 1 FTE

Employee Total Contribution
Employer Total Contribution
Additional employee contribution
Additional employer contribution
Total Employer Term Pay Contribution

NOTE: The initial run of this report (detected by the absence of the file PRBO0T.DAT located at the definition of the logical SRB$OPSDAT0) will generate all employees as new or with a status of 'A'. This pension history file records the pay period, employee's earnings, contributions, status and FTE for the last five generation runs of the pension report. This information is used to compare the current pension information against the last reported pension information to determine who is new, terminated or changed etc. Due to this process some caution should be taken to ensure the correct pay start period and sequence of start periods is used when running this report.

NOTE: This option is forced to batch.

Generate New Report/Reprint Report

Enter 'R' to reprint a previously generated pension report. The option to reprint a pension report allows the pension information to be changed as needed through the Pension Record Changes, and then recreate both the electronic file and the report with the changes included.
Enter 'G' to generate a new pension report. At the end of each month this option is run to generate a pension listing with the new pension information. This option will override previously generated pension information.

Enter Start Pay Period

Enter a 3 character pay period to define the starting pay period for a range of periods to be reported. Use look-up for valid pay periods. The system will automatically add the current year for display.

Enter End Pay Period

Enter a 3 character pay period to define the ending pay period for a range of periods to be reported. Use look-up for valid pay periods.

The system will automatically add the current year for display.

Enter file Date

Enter a 4-charactermonth and year to indicate the month for this report.

Omit Reporting ZERO Pension Records

Enter Y to omit employees with zero pensionable earnings and contributions. The employee will be omitted from the report and the electronic file. A TRS pension record will be created which would allow changes through TRS Pension Record Changes.
Enter N to include employees on the pension report and electronic file, even when the employee has zero pensionable earnings and zero contributions.

Sort Report by Employee SSN Or Name

Enter 'S' to generate the report in employee social security number order.
Enter 'N' to generate the report in employee name order.

Pension Report for Multiple Months

Enter "N' if the pension report is being produced for a single month.
Enter 'Y' if this report includes more than one-month worth of information.

Enter File Date for Second Month

Enter a 4-charactermonth year combination which defines the second month of pension information that has been included on this report.
Enter 4 zeros if a second month of pension information was not included.

Enter File Date for Third Month

Enter a 4-charactermonth year combination which defines the third month of pension information that has been included on this report.
Enter 4 zeros if a third month of pension information has not been included.

Enter the File Date for FOURTH Month

Enter a 4-charactermonth year combination which defines the fourth month of pension information that has been included on this report.
Enter 4 zeros if a fourth month of pension information has not been included.

Employees that are terminated must be listed for one month charged with zero earnings and contributions before being listed as terminated. Once listed as terminated an employee will be omitted from the report.

The FTE is taken from the employee's pension credit for employees with a master function line pay type of 'F'ixed, 'A'nnual or 'L'ump Sum only.

The PART Hours are the hours worked for the pay period for employees with master function line pay type of 'H'ourly, 'S'alaried or 'P'art Time.

The report lists the following:

Employee name, number and grid number
Old values of salary, hours and contract, if applicable
New value of salary, hours and contract, if applicable

The Work Status is:

blank for full-time positions with a full FTE
'P' for full-time positions with an FTE of less than 1.00
'H' for all non full-time positions (employees with a pay type of H, P, or S on their master function line)
W for Working retired employees (NOTE: Montana Pension Profile documentation)
R for Reemployed Retired employees (NOTE: Montana Pension Profile documentation)

The TRANS Code is:

'A' for employees being reported for the first time.
'T' for employees who will not be reported after this report.
'C' for employees that have had a change in status, earnings, contribution or FTE (FTE is only applicable for full-time) since the last pension report.
blank for active employee's who has not changed since last report.