eSERS Enrollment Report - Detail (ED) Record - File Layout and Data Mapping

The following table lists the positions, lengths, field names, descriptions, and data sources or valid values for the Detail (ED) Record of the eSERS Enrollment report.

Position	Length	Field Name	Description	Data Source or Valid Values
1-2	2	Record Type	Identifies the record type.	The valid value is ED.
3-11	9	SSN	The employee's Social Security number.	Retrieved from the Social Security Number field on the New Hire Data form of the OH eSERS Enrollment Report page.
12-36	25	Last Name	The employee's last name.	Retrieved from the Last Name field on the New Hire Data form of the OH eSERS Enrollment Report page.
37-61	25	First Name	The employee’s first name.	Retrieved from the First Name field on the New Hire Data form of the OH eSERS Enrollment Report page.
62-86	25	Middle Name	The employee's middle name.	Retrieved from the Middle Name field on the New Hire Data form of the OH eSERS Enrollment Report page.
87-100	14	Name Prefix	The employee's name prefix or title.	Valid values: Ms. Mr. Mrs. Dr. Miss Sister Honorable Council Person Retrieved from the Prefix field on the New Hire Data form of the OH eSERS Enrollment Report page.
101-104	4	Name Suffix	The employee’s name suffix.	Valid values: JR. SR. I II III IV V MD CPA ESQ Retrieved from the Suffix field on the New Hire Data form of the OH eSERS Enrollment Report page.
105-109	5	State ID	The School Employees Retirement System (SERS) employer identification number assigned to the district.	Retrieved from the SERS Employer ID field on the Human Resources Profile - State page.
110-159	50	Street 1	The first line of the employee's address.	Retrieved from the Street Address field on the New Hire Data form of the OH eSERS Enrollment Report page.
160-209	50	Street 2	The second line of the employee's address.	Retrieved from the Street Address 2 field on the New Hire Data form of the OH eSERS Enrollment Report page.
210-219	10	Suite	The suite or apartment number associated with the employee's complete address.	Retrieved from the Suite field on the New Hire Data form of the OH eSERS Enrollment Report page.
220-269	50	City	The employee's city of residence.	Retrieved from the City field on the New Hire Data form of the OH eSERS Enrollment Report page.
270-271	2	State	The employee's state of residence.	Retrieved from the State field on the New Hire Data form of the OH eSERS Enrollment Report page.
272-280	9	Zip Code	The employee's zip code.	Retrieved from the Zip Code field on the New Hire Data form of the OH eSERS Enrollment Report page.
281-288	8	Date of Birth	The employee's date of birth.	Retrieved from the Date of Birth field on the New Hire Data form of the OH eSERS Enrollment Report page.
289-289	1	Gender	The employee's gender.	Valid values: M = Male F = Female Retrieved from the Gender field on the New Hire Data form of the OH eSERS Enrollment Report page.
290-297	8	Hire Date	The employee's SERS service date.	Retrieved from the Start Date field on the New Hire Data form of the OH eSERS Enrollment Report page.
298-299	2	Job Class	The SERS job classification code that identifies the employee's position type.	Valid values: 01 - Administrative 02 - Clerical/Secretarial 03 - Custodial/Maintenance 04 - Educational Aide 05 - Food Service 06 - Transportation 07 - School Board Member 08 - Supplemental 09 - Other Retrieved from the Job Class field on the New Hire Data form of the OH eSERS Enrollment Report page.
300-300	1	ARP	Indicates whether the employee is participating in an Alternative Retirement Plan instead of the traditional SERS defined benefit plan.	Valid values: Y N Retrieved from the ARP field on the New Hire Data form of the OH eSERS Enrollment Report page.
301-303	3	Marital Status	The employee's marital status for SERS reporting purposes.	Valid values: SIN - Single MAR - Married SEP - Separated DIV - Divorced WID - Widowed Retrieved from the Marital Status field on the New Hire Data form of the OH eSERS Enrollment Report page.
304-311	8	Filler	Enter zeros	The valid value is 00000000.
312-321	10	Phone Number	The employee's phone number.	Retrieved from the Phone Number field on the New Hire Data form of the OH eSERS Enrollment Report page.
322-371	50	Personal Email	The employee’s email address.	Retrieved from the Email field on the New Hire Data form of the OH eSERS Enrollment Report page.