ECS Help

Help

Student Exemption File Types/Required Data

Files transferred via ECS should follow the OPERS file format. To transfer an electronic form to OPERS, you'll have to take some steps to ensure you're submitting your data in the correct format.

RECORD FORMATS
Record Sequence
For each form included in a file, a set of records consisting of one or more employee records, followed by an employer summary record, is required. This group of records is known as a form and consists of all data accumulated for individual employees. Multiple forms may be placed in a single file.

Record Formats
Each entry is identified as being either optional or required. Required data must contain the data indicated in the prescribed format, or it is considered an error. Optional data will be used only if it passes the editing requirements indicated (for example, the Suffix must be one of the allowable values). All numeric data is in the display format, unsigned, with no embedded slashes or hyphens.

Student Exemption

EMPLOYEE RECORD FORMAT

FROM	TO	TYPE	COUNT	REQUIRED/ OPTIONAL	DESCRIPTION
01	01	Alpha	1	R	Record Type = "E"
02	06	Alpha	5	R	OPERS Form Type = F3
07	15	Num	9	R	Employee Social Security Number (No embedded dashes)
16	38	Alpha	23	O	Employee First Name
39	39	Alpha	1	O	Employee Middle Initial
40	67	Alpha	28	R	Employee Last Name
68	70	Alpha	3	O	Employee Name Suffix Values are: JR SR I II III IV V VI VII ESQ DDS MD
71	78	Num	8	R	Employment Begin Date Format = MMDDYYYY, where: MM = 2 position month DD = 2 position day YYYY = 4 position year
79	84	Num	6	R	OPERS Employer Code Format = XXXXYY, where: XXXX = Four digit OPERS employer code YY = Two digit OPERS suffix code
85	94	Num	10	R	Employee Mobile Telephone Number Format = 10 digit telephone number (No embedded dashes)
95	144	Alpha	50	R	Employee Email Address
145	145	Alpha	1	R	Paper Exception Values are: Y or N
146	183	Alpha	38	R	Address Line 1
184	221	Alpha	38	O	Address Line 2
222	259	Alpha	38	O	Address Line 3
260	277	Alpha	18	R	City
278	279	Alpha	2	R	State Code Values are: AL AK AS AZ AR CA CO CT DE DC FM FL GA GU HI ID IL IN IA KS KY LA ME MH MD MA MI MN MS MO MT NE NV NH NJ NM NY NC ND MP OH OK OR PW PA PR RI SC SD TN TX UT VT VI VA WA WV WI WY
280	284	Alpha	5	R	Zip Code - Numeric
285	288	Alpha	4	O	Zip Code plus 4

EMPLOYER SUMMARY RECORD FORMAT

FROM	TO	TYPE	COUNT	REQUIRED/ OPTIONAL	DESCRIPTION
01	01	Alpha	1	R	Record Type = "T"
02	06	Alpha	5	R	OPERS Form Type = F3
07	12	Num	6	R	OPERS Employer Code Format = XXXXYY, where: XXXX = Four digit OPERS employer code YY = Two digit OPERS suffix code