IPERS-Covered Wages and Contributions by Membership Group, Employer and FY

data.iowa.gov | Last Updated 14 Mar 2017

The dataset contains information on IPERS-covered wages, employer contributions and employee contributions by membership group, employer and fiscal year. An employer may have more than one membership group. Count of employers is before modifications due to GASB 68.

Tags: covered wages, employer contributions, employee contributions

This dataset has the following 15 columns:

Column NameAPI Column NameData TypeDescriptionSample Values
Fiscal Yearfinancial_yearnumberThe fiscal year for which the covered wages and contributions are associated with. The fiscal year runs from July 1 to June 30 and is named for the calendar year for which it ends.
Employer Codeemployer_codenumberUnique employer code
Membership Groupmembership_grouptextTheir are three membership groups: Regular, Protection Occupations, and Sheriff/Deputy. Regular members: Non-public safety employees making up 95 percent of IPERS’ membership. Includes education-related employees, legislators and elected officials, licensed health care professionals, and many others. Protection Occupations: State conservation peace officers, state correctional officers, city marshals/police officers, airport firefighters, airport safety officers, state DOT peace officers (traffic/weight), firefighters (in cities excluded from Chapter 410 or 411), fire prevention inspectors/peace officers, state airport security officers, county conservation peace officers, emergency medical service providers, county jailers and detention officers working as jailers, county attorney investigators, National Guard installation security officers, insurance special investigators, and parole peace officers. Sheriff/Deputy: Sheriffs and deputy sheriffs employed by county governments.
Employer Typeemployer_typetextEmployer type places the employers contributing to IPERS into the following categories: cities, counties, education (i.e. school districts an AEAs), health (i.e. mental health, hospitals, medical centers, health centers, home care), other (i.e. econonmic development agencies, housing agencies, community action agencies, transit agencies, etc.), state, and utilities.
Employer Nameemployer_nametextName of employer contributing to IPERS
Addressemployer_locationtextStreet address or PO Box belonging to the employer
CitycitytextCity the employer is located
StatestatetextState the employer is located
Zip Codezip_codetextZip Code where the employer is located.
County FIPScounty_fipstextA five-digit code for counties based on Federal Information Processing Standards Publication - FIPS 55-DC3 (December 1994) , Guideline: Codes for Named Populated Places, Primary County Divisions, and Other Locational Entities of the United States, Puerto Rico, and the Outlying Areas (withdrawn February 8, 2005)
County Namecounty_nametextCounty employer located
Covered Wagescovered_wages_by_grpmoneySum of covered wages within membership group and employer for the fiscal year.
Employer Contributionsemployer_contributions_by_grpmoneySum of employer contributions during fiscal year for employees within the membership group
Employee Contributionsemployee_contributions_by_grpmoneySum of employee contributions within membership group for the fiscal year.
Employer LocationlocationlocationLocation of the employer participating in IPERS based on mailing address. Where address contains only PO Box Number, lat/long where based on city, state and zip code only - and would not represent a precise location of the employer.