NY Retirement Information - TRS Data Import - File Layout and Data Mapping

A

Employee Number

The employee’s identification (ID) number.

Not applicable

B

NYSTRS ID

The number assigned by the Teachers' Retirement System (TRS).

C

Employment Base

The number of days in a school year that employees are contracted for their primary assignment, including paid vacations.

Valid values:

• 200 = 10-Month

• 220 = 10.5/11-Month

• 240 = 12-Month

D

Employee Wage Type

Indicates the basis on which the employee is paid.

Valid values:

• H = Hourly

• D = Daily

• F = Fee based

E

Annual Base Salary Override

The annual compensation rate for the employee’s primary assignment.

This value overrides the Annual Base Salary value.

Not applicable

F

Standard Workday Hours

The number of hours in the Standard Full-Time Workday for the school district.

Not applicable

G

Full-Time / Part-Time Employee

Indicates whether the employee is full-time or part-time.

Valid values:

• F = Full-Time

• P = Part-Time

• R = Retired

H

TRS Plan Type

The type of TRS plan chosen by the employee.

This column is required for SUNY or community college employers.

Valid values:

• TRS = TRS Plan

• ORP = ORP Plan

I

ORP Plan Date

The date the employee chose the ORP plan.

This column must be populated if the value in the TRS Plan Type column is ORP.

Not applicable

J

Leave Code

The leave code corresponding to the employment status.

For valid leave codes, refer to the NY TRS Retirement Report - Setup - Leave Codes page.

Valid values:

• MIL = Military

• MAT = Maternity, Paternity, Child Care

• SAB = Sabbatical

• SCK = Sick

• PER = Personal

• XXX = Leave Codes of type Other set up on the NY TRS Retirement Report - Setup - Leave Codes page.

K

Leave Pay Percentage

The employee's pay percentage during leave.

The valid value range is 0 to 100.

L

Leave Start Date

The beginning date of the leave period.

Not applicable

M

Leave End Date

The ending date of the leave period.

Not applicable

N

Separation Code

The employee’s separation reason code.

If the value in this column is Other, you must populate the Other Separation Code column.

Valid values:

• RET = Retired

• TER = Terminated/Excessed

• RES = Resigned

• DEA = Death

• Other

Leave the field blank to imply the employee is not separated.

O

Other Separation Code

The first three characters of the Separation Reason Code.

If the value in the Separation Code column is Other, you must populate this column.

Not applicable

P

Separation Date

The employee’s last date worked.

If the Separation Code column is populated, you must populate this column.

Not applicable

Q

Tier

The employee's TRS membership tier classification.

Valid values:

• 1 = Tier 1 (Members who joined before July 1, 1973)

• 2 = Tier 2 (Members who joined between July 1, 1973, and July 26, 1976)

• 3 = Tier 3 (Members who joined between July 27, 1976, and August 31, 1983)

• 4 = Tier 4 (Members who joined between September 1, 1983, and December 31, 2009)

• 5 = Tier 5 (Members who joined between January 1, 2010, and March 31, 2012)

• 6 = Tier 6 (Members who joined on or after April 1, 2012)

R

Retired Date

The date the employee retired from the New York State Teachers' Retirement System (NYSTRS).

Not applicable

S

Retirement Number

The employee's unique retirement identification number assigned by the New York State Teachers' Retirement System (NYSTRS).

Not applicable