YourMoney Active Pension Members

data.nj.gov | Last Updated 20 Mar 2018

The data file reflects data for employees who are active members in a state pension system as reported by the employer. It lists the salary eligible for pension credit for the four most recent calendar quarters reported as well as attributes that describe the status of the member for pension purposes. Additional information is in the attached dataset summary PDF (available on the [About] tab under "Attachments").

Tags: pension, employee, active

This dataset has the following 21 columns:

Column NameAPI Column NameData TypeDescriptionSample Values
AS_OF_DATEas_of_datecalendar_dateThe last day of the four quarters of data represented in this dataset.
MEMBER_LAST_NAMEmember_last_nametextThe last name of the member at the end of the reporting period.
MEMBER_FIRST_NAMEmember_first_nametextThe first name of the member at the end of the reporting period.
MEMBER_MImember_mitextThe middle initial of the member at the end of the reporting period.
ENROLLMENT_DATEenrollment_datecalendar_dateThe date that the member enrolled in the pension fund.
EMPLOYER_NAMEemployer_nametextThe name of the employer reporting at the end of the reporting period.
LOCATION_CODElocation_codenumberThe code that identifies the location of the employer reporting at the end of the reporting period.
LOCATION_NAMElocation_nametextThe county in which the employer reporting at the end of the reporting period is located, or REGIONAL, or STATEWIDE.
PENSION_FUND_IDpension_fund_idnumberThe identifier of the pension fund for which this data is being reported.
PENSION_FUND_NAMEpension_fund_nametextThe name of the pension fund for which this data is being reported.
PENSION_GROUP_IDpension_group_idtextThe identifier of the pension subgroup if applicable, or N.
PENSION_GROUP_NAMEpension_group_nametextThe name of the pension subgroup if applicable, or NOT APPLICABLE.
VETERAN_STATUSveteran_statustextThe veteran status of the member for pension purposes.
SERVICE_YEARS_QTYservice_years_qtynumberThe full years of service in the pension fund credited to the member.
SERVICE_MONTHS_QTYservice_months_qtynumberThe months of service in the pension fund for the most recent partial year credited to the member.
TOTAL_MONTHS_QTYtotal_months_qtynumberThe total months of service in the pension fund credited to the member (where each full year of service equals twelve months).
CURRENT_EMPLOYER_SALARY_AMTcurrent_employer_salary_amtmoneyThe salary eligible for pension credit reported by the current employer for the current location during the most recent four quarters.
ALL_EMPLOYERS_SALARY_AMTall_employers_salary_amtmoneyThe total salary eligible for pension credit reported by all employers for all locations during the most recent four quarters.
25_YEAR_DATE_25_year_datecalendar_dateThe date upon which a member achieved twenty-five years of pension service, otherwise blank.
20_YEAR_STATUS_20_year_statustextThe status that indicates whether the member is exempt from Chapter 78. “YES” indicates the member attained 20 years of service before the Chapter 78 effective date (June 28, 2012) and is exempt from allowance-based health benefit premium calculations if the member retires with at least 25 years of service. All other members are “NO”.
MEMBERSHIP_TIERmembership_tiernumberThe category of retirement benefits available based on the pension fund enrollment date of the member.