VSTRS DB Retirement Report - File Layout and Data Mapping

The default file name of the VSTRS DB Retirement report is VT VSTRS DB Electronic Report_<Reporting Year>_<Reporting Quarter>.xlsx.

The following table shows the columns, names, descriptions, and data sources or valid values for the VSTRS DB Retirement report.

Column	Name	Description	Data Source or Valid Values
A	EmployerID	The employer’s identification number.	The field value is retrieved from the Employer ID field on the VT VSTRS DB Retirement Report - Load page.
B	Month	The month of the fiscal reporting year.	The valid value is the month of the Check Issue End Date on the VT VSTRS DB Retirement Report - Load page.
C	Year	The fiscal reporting year.	The field value is retrieved from the Year field on the Employee Information form of the VT VSTRS DB Retirement Report page.
D	RecordType	The type of record.	The field value is retrieved from the Detail Distribution table.
E	EmployeeID	The employee's VSTRS ID.	The field value is retrieved from the VSTRS Employee Id field on the Employee Information form of the VT VSTRS DB Retirement Report page.
F	LastName	The employee's last name.	The field value is retrieved from the Last Name field on the Employee Information form of the VT VSTRS DB Retirement Report page.
G	FirstName	The employee's first name.	The field value is retrieved from the First Name field on the Employee Information form of the VT VSTRS DB Retirement Report page.
H	ContractSalary	The employee’s contract salary.	The field value is retrieved from the Contract Salary field on the Employee Information form of the VT VSTRS DB Retirement Report page.
I	CurrentContribution	The employee's contribution amount.	The field value is retrieved from the Contribution field on the Employee Information form of the VT VSTRS DB Retirement Report page.
J	FTEPercent	The employee's Full-Time Equivalent (FTE) indicates the percent of time spent on the assignment as a decimal value.	The field value is retrieved from the FTE field on the Employee Information form of the VT VSTRS DB Retirement Report page.
K	HireDate	The employee's hire date.	The field value is retrieved from the Hire Date field on the Employee Information form of the VT VSTRS DB Retirement Report page.
L	RetireeFlag	Indicates whether the employee is a retired teacher.	The field value is retrieved from the Retired Teacher field on the Employee Information form of the VT VSTRS DB Retirement Report page.
M	BirthDate	The employee's birth date.	The field value is retrieved from the Birth Date field on the Employee Information form of the VT VSTRS DB Retirement Report page.
N	Gender	The employee's gender.	The field value is retrieved from the Gender field on the Employee Information form of the VT VSTRS DB Retirement Report page.
O	StreetAddress1	The employee's street address line 1.	The field value is retrieved from the Street 1 field on the Employee Information form of the VT VSTRS DB Retirement Report page.
P	StreetAddress2	The employee's street address line 2.	The field value is retrieved from the Street 2 field on the Employee Information form of the VT VSTRS DB Retirement Report page.
Q	City	The employee's city.	The field value is retrieved from the City field on the Employee Information form of the VT VSTRS DB Retirement Report page.
R	State	The employee's state.	The field value is retrieved from the State field on the Employee Information form of the VT VSTRS DB Retirement Report page.
S	ZipCode	The employee's zip code.	The field value is retrieved from the Zip Code field on the Employee Information form of the VT VSTRS DB Retirement Report page.
T	ContributionRate	The employee's contribution rate.	The field value is retrieved from the Contribution Rate field on the Employee Information form of the VT VSTRS DB Retirement Report page.
U	SalaryChangeCode	The code indicating the reason for a change in salary.	The field value is retrieved from the Salary Change Code field on the Employee Information form of the VT VSTRS DB Retirement Report page. Valid values: C - Contract Change X - Extracurricular/Extra Duties O - Other W - Workman's Comp E - Error Correction T - Termination, Retirement, Death B - Buyout M - Military Leave L - Legislative Leave Y - Disability S - Sabbatical
V	TerminationDate	The employee’s termination date.	The field value is retrieved from the Term/Lv Date field on the Defined Page 32001 - Vermont State Retirement page.
W	TerminationCode	The employee's termination or leave status.	The field value is retrieved from the Termination/ Leave field on the Employee Information form of the VT VSTRS DB Retirement Report page. Valid values: None Leave Terminated Start Workers Comp Return From Leave Disability Partial Year
X	JobCode	The employee's job title.	The field value is retrieved from the Job Title field on the Employee Information form of the VT VSTRS DB Retirement Report page.
Y	DaysWorked	The number of days the employee was paid.	The field value is retrieved from the Number of Days Paid field on the Employee Information form of the VT VSTRS DB Retirement Report page.
Z	GrossSalary	The employee's gross earnings for the quarter.	The field value is retrieved from the Gross Earnings field on the Employee Information form of the VT VSTRS DB Retirement Report page.