ECS Help

Help

Form A 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.

Form A

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 = FORMA
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	71	Alpha	1	R	Gender Values are: M if employee Male F if employee is Female U if employee Prefer Not to Say
72	79	Alpha	8	R	Employee Date of Birth Format = MMDDYYYY, where: MM = 2 position month DD = 2 position day YYYY = 4 position year
80	87	Alpha	8	R	Salary Begin Date Format = MMDDYYYY, where: MM = 2 position month DD = 2 position day YYYY = 4 position year
88	88	Num	1	R	Elected Official Indicator Values are: Y if employee an Elected Official N if employee is not an Elected Official
89	89	Alpha	1	R	Law Enforcement Position Indicator Values are: Y if employee is in a Law Enforcement position N if employee is not in a Law Enforcement position
90	90	Alpha	1	R (if Law Enforcement Position Indicator = Yes)	Part Time/Full Time Position Indicator Values are: P if employee is employed Part time F if employee is employed Full time
91	91	Alpha	1	R	Fire Fighter Training Indicator Values are: Y if Firefighting Training is required of employee N if Firefighting Training is not required of employee
92	92	Alpha	1	R	Address Type Values are: D if address is Domestic F if address is Foreign
93	130	Alpha	38	R	Address Line 1
131	168	Alpha	38	O	Address Line 2
169	206	Alpha	38	O	Address Line 3
207	224	Alpha	18	R	City
225	226	Alpha	2	R (if Domestic)	State Code (Only populate if address is domestic) 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
227	231	Alpha	5	R (if Domestic)	Zip Code - Numeric (Only populate if address is domestic)
232	235	Alpha	4	O	Zip Code plus 4 - Numeric (Only populate if address is domestic)
236	255	Alpha	20	O (if Foreign)	Province Name (Only populate if address is foreign)
256	257	Alpha	2	R (if Foreign)	Country Code (Only populate if address is foreign) Values are: AD - ABU DHABI AF - AFGHANISTAN AL - ALBANIA AG - ALGERIA AQ - AMERICAN SAMOA AN - ANDORRA AO - ANGOLA AV - ANGUILLA AY - ANTARCTICA AC - ANTIGUA AND BARBUDA AR - ARGENTINA AM - ARMENIA AA - ARUBA AT - ASHMORE AND CARTIER ISLANDS AS - AUSTRALIA AU - AUSTRIA AJ - AZERBAIJAN AZ - AZORES BF - BAHAMAS, THE BA - BAHRAIN FQ - BAKER ISLAND BI - BALEARIC ISLANDS BG - BANGLADESH BB - BARBADOS BS - BASSAS DE INDIA BO - BELARUS BE - BELGIUM BH - BELIZE BJ - BENIN BD - BERMUDA BT - BHUTAN BL - BOLIVIA BN - BONAIRE BK - BOSNIA-HERCEGOVINA BC - BOTSWANA BV - BOUVET ISLAND BR - BRAZIL IO - BRITISH INDIAN OCEAN TERRITORY VG - BRITISH VIRGIN ISLANDS BX - BRUNEI BU - BULGARIA UV - BURKINA FASO(UPPER VOLTA) BM - BURMA BY - BURUNDI CB - CAMBODIA CM - CAMEROON CA - CANADA RY - CANARY ISLANDS CV - CAPE VERDE CJ - CAYMAN ISLANDS CT - CENTRAL AFRICAN REPUBLIC CD - CHAD XX - CHANNEL ISLAND CI - CHILE CH - CHINA, PEOPLE'S REPUBLIC OF KT - CHRISTMAS ISLAND IP - CLIPPERTON ISLAND CK - COCOS (KEELING) ISLANDS CO - COLOMBIA CN - COMOROS CG - CONGO, DEMOCRATIC REPUBLIC OF(ZAIRE) CF - CONGO, REPUBLIC OF (BRAZZAVILLE) CW - COOK ISLANDS CR - CORAL SEA ISLANDS TERRITORY VP - CORSICA CS - COSTA RICA IV - COTE D'LVOIRE IVORY COAST) HR - CROATIA CU - CUBA CC - CURACAO CY - CYPRUS EZ - CZECH REPUBLIC DA - DENMARK DJ - DJIBOUTI DO - DOMINICA DR - DOMINICAN REPUBLIC DU - DUBAI TT - EAST TIMOR EC - ECUADOR EG - EGYPT ES - EL SALVADOR IE - ELEUTHERA ISLAND EL - ENGLAND EK - EQUATORIAL GUINEA ER - ERITREA EN - ESTONIA ET - ETHIOPIA EU - EUROPA ISLAND EE - EUROPEAN UNION FK - FALKLAND ISLANDS FO - FAROE ISLANDS FJ - FIJI FI - FINLAND FR - FRANCE FG - FRENCH GUIANA FP - FRENCH POLYNESIA FS - FRENCH SOUTHERN AND ANTARCTIC LANDS GB - GABON GA - GAMBIA GZ - GAZA STRIP, THE GG - GEORGIA GM - GERMANY GH - GHANA GI - GIBRALTAR GO - GLORIOSO ISLANDS GN - GREAT BRITAIN GR - GREECE GL - GREENLAND GJ - GRENADA GP - GUADELOUPE GQ - GUAM GT - GUATEMALA GK - GUERNSEY GV - GUINEA PU - GUINEA-BISSAU GY - GUYANA HA - HAITI HM - HEARD & MCDONALD ISLANDS HL - HOLLAND VA - HOLY SEE (VATICAN CITY STATE) HO - HONDURAS HI - HONG KONG HQ - HOWLAND ISLAND HU - HUNGARY IC - ICELAND IN - INDIA ID - INDONESIA IR - IRAN IZ - IRAQ EI - IRELAND, REPUBLIC OF FA - ISLAS OF MALVINAS IM - ISLE OF MAN IS - ISRAEL IT - ITALY JM - JAMAICA JN - JAN MAYEN JA - JAPAN DQ - JARVIS ISLAND JE - JERSEY JQ - JOHNSON ATOLL JO - JORDAN JU - JUAN DE NOVA ISLAND KZ - KAZAKHSTAN KE - KENYA KQ - KINGMAN REEF KR - KIRIBATI KN - KOREA, DEMOCRATIC PEOPLE'S OF (NORTH) KS - KOREA, REPUBLIC OF KO - KOSOVO KI - KURILE ISLANDS KU - KUWAIT KG - KYRGYZSTAN LA - LAOS LG - LATVIA LE - LEBANON LT - LESOTHO LI - LIBERIA LY - LIBYA LS - LIECHTENSTEIN LH - LITHUANIA LU - LUXEMBOURG MC - MACAO MK - MACEDONIA MA - MADAGASCAR MI - MALAWI MY - MALAYSIA MV - MALDIVES ML - MALI MT - MALTA RM - MARSHALL ISLANDS MB - MARTINIQUE MR - MAURITANIA MP - MAURITIUS MF - MAYOTTE MX - MEXICO FM - MICRONESIA, FEDERATED STATES OF MQ - MIDWAY ISLANDS MD - MOLDOVA MN - MONACO MG - MONGOLIA ME - MONTENEGRO MH - MONTSERRAT MO - MOROCCO MZ - MOZAMBIQUE WA - NAMIBIA NR - NAURU BQ - NAVASSA ISLAND NP - NEPAL NL - NETHERLANDS NT - NETHERLANDS ANTILLES NC - NEW CALEDONIA NH - NEW HEBRIDES NZ - NEW ZEALAND NU - NICARAGUA NG - NIGER NI - NIGERIA NE - NIUE NF - NORFOLK ISLAND ND - NORTHERN IRELAND CQ - NORTHERN MARIANA ISLANDS NO - NORWAY MU - OMAN PK - PAKISTAN PS - PALAU LQ - PALMYRA ATOLL PM - PANAMA PP - PAPUA NEW GUINEA PF - PARACEL ISLANDS PA - PARAGUAY PE - PERU RP - PHILIPPINES PC - PITCAIRN ISLAND PL - POLAND PO - PORTUGAL RQ - PUERTO RICO QA - QATAR RE - REUNION RO - ROMANIA RS - RUSSIA RW - RWANDA JP - RYUKYU ISLANDS SS - SAMOA SM - SAN MARINO TP - SAO TOME & PRINCIPE SK - SARAWAK SA - SAUDI ARABIA SD - SCOTLAND SG - SENEGAL RB - SERBIA SE - SEYCHELLES SL - SIERRA LEONE SN - SINGAPORE LO - SLOVAKIA SI - SLOVENIA BP - SOLOMON ISLAND SO - SOMALIA SF - SOUTH AFRICA SR - SOUTH AMERICA SX - SOUTH GEORGIA & SOUTH SANDWICH ISLANDS SP - SPAIN PG - SPRATLEY ISLANDS CE - SRI LANKA(CEYLON) SH - ST. HELENA SC - ST. KITTS ST - ST. LUCIA SB - ST. PIERRE & MIQUELON VC - ST. VINCENT AND THE GRENADINES SU - SUDAN NS - SURINAME SV - SVALBARD WZ - SWAZILAND SW - SWEDEN SZ - SWITZERLAND SY - SYRIA TW - TAIWAN TI - TAJIKISTAN TA - TAMIL NADU TZ - TANZANIA TH - THAILAND TO - TOGO TL - TOKELAU TN - TONGA TR - TORTOLA TD - TRINIDAD AND TOBAGO TE - TROMELIN ISLAND TS - TUNISIA TU - TURKEY TX - TURKMENISTAN TK - TURKS AND CAICOS ISLANDS TV - TUVALU UG - UGANDA UP - UKRAINE TC - UNITED ARAB EMIRATES UK - UNITED KINGDOM US - UNITED STATES OF AMERICA UY - URUGUAY UZ - UZBEKISTAN VU - VANUATU VT - VATICAN CITY VE - VENEZUELA VM - VIETNAM VQ - VIRGIN ISLANDS (U.S.) VI - VIRGIN ISLANDS(BRITISH) WQ - WAKE ISLAND WL - WALES WF - WALLIS & FUTANA WE - WEST BANK IW - WEST INDIES WI - WESTERN SAHARA WS - WESTERN SAMOA WN - WINDWARD ISLANDS YM - YEMEN YO - YUGOSLAVIA ZA - ZAMBIA ZI - ZIMBABWE
258	267	Alpha	10	O (if Foreign)	Postal Code (Only populate if address is foreign)
268	317	Alpha	50	O	Email Address

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 = FORMA
07	12	Num	6	R	OPERS Employer Code Format = XXXXYY, where: XXXX = Four digit OPERS employer code YY = Two digit OPERS suffix code

Once your file has been uploaded, click Continue for Verification.

The Verify Form page will be displayed. This page lets you review your data before submitting it to OPERS.

Additional verification may be required for some of the employees on the form you are submitting. This can occur when OPERS has previously received information for one of your employees that differs from what you have entered. Some common examples would be an updated salary begin date or a name change due to marital status.

If this occurs, you must click the Verify check box on each line after verifying that the information you entered is indeed correct. If the information is not correct, click the Back to Form to make corrections to the employee’s data.

Once you have made any necessary changes and/or verified the data is accurate, click Submit to OPERS.

Please Note: The form is not submitted to OPERS until the Submit to OPERS button is clicked and the Submitted Form page is displayed.

A warning message may come up on the Submitted Form page. A message displayed on the Submitted Form page is intended to provide you with information only and does not require any additional action by you. The Submitted Form page is your notification that the form has successfully been submitted to OPERS.

If you want a paper copy of the submitted form, the Submitted Form page gives you two options for printing the form: as a list, or by individual employee.

Please Note: Forms submitted online are accessible for two years from the date of submission. You can print forms anytime during the two years by locating the needed form within the submitted forms list and printing.

If you want to print the form as a list, click Print list.

If you want to print individual forms, you must click the Print button to the right of each employee record you wish to print.