ECS Help

Help

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.

ARP-2

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 = ARP2
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	Alpha	8	O	Employee Date of Birth Format = MMDDYYYY, where: MM = 2 position month DD = 2 position day YYYY = 4 position year
79	86	Alpha	8	R	Employee ARP Eligible Date Format = MMDDYYYY, where: MM = 2 position month DD = 2 position day YYYY = 4 position year
87	92	Num	6	R	OPERS Employer Code Format = XXXXYY, where: XXXX = Four digit OPERS employer code YY = Two digit OPERS suffix code
93	93	Alpha	1	R	Foreign Address Indicator Values are: D if Address is Domestic F if Address is Foreign
94	131	Alpha	38	R	Address Line 1
132	169	Alpha	38	O	Address Line 2
170	207	Alpha	38	O	Address Line 3
208	225	Alpha	18	R	City
226	227	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
228	232	Alpha	5	R (if Domestic)	Zip Code - Numeric (Only populate if address is domestic)
233	236	Alpha	4	O	Zip Code plus 4 - Numeric (Only populate if address is domestic)
237	256	Alpha	20	O	Province Name (Only populate if address is foreign)
257	258	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
259	268	Alpha	10	O	Postal Code (Only populate if address is foreign)

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