This dataset contains data for State employees paid through the Centralized Payroll System. The data reflects payroll payments made to the employee for the calendar year through the date indicated. There are two types of records: MASTER and DETAIL. There is at least one MASTER and one DETAIL record per employee. Multiple DETAIL records for an employee will appear in the file for a specific year if the employee is paid by more than one department/agency or by more than one section during that calendar year. The sums for all of the departments/agencies appear in the columns with prefix “MASTER”. Additional information is in the attached dataset summary PDF (available on the [About] tab under "Attachments").
This dataset has the following 32 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| CALENDAR_YEAR | calendar_year | number | Four digit year representing the twelve month period starting with January and ending with December. Indicates the calendar year in which payments were actually made to the employee. Calendar year and calendar quarter together represent the end of the reporting period. | 2011 2010 2012 2013 2014 view top 100 |
| CALENDAR_QUARTER | calendar_quarter | number | Payroll data will be published quarterly. The single digit calendar quarter represents the end of the period that the data spans and not the actual quarter that the payment was made. For example, when calendar quarter is set to ‘2’, the data would include payments made from January through June for the given calendar year. Calendar year and calendar quarter together represent the end of the reporting period. | 4 1 view top 100 |
| AS_OF_DATE | as_of_date | calendar_date | The last day of the quarter of data represented in this dataset. | 2011-12-31T00:00:00.000 2010-12-31T00:00:00.000 2012-12-31T00:00:00.000 2013-12-31T00:00:00.000 2014-12-31T00:00:00.000 view top 100 |
| PAYROLL_ID | payroll_id | text | Randomly generated number that helps pair a master record with its detail record(s). | 24183 69732 58601 13659 71180 view top 100 |
| LAST_NAME | last_name | text | Last name of the employee at the end of the reporting period. | WILLIAMS SMITH JOHNSON BROWN JONES view top 100 |
| FIRST_NAME | first_name | text | First name of the employee at the end of the reporting period. The literal ‘none’ has been used when there is no first name on record. | MICHAEL JOHN ROBERT JOSEPH JAMES view top 100 |
| MIDDLE_INITIAL | middle_initial | text | Middle initial of the employee at the end of the reporting period. | null A M J L view top 100 |
| FULL_NAME | full_name | text | Full name of the employee at the end of the reporting period. | DAVIS, MICHAEL RODRIGUEZ, JENNIFER JONES, MICHAEL GALLAGHER, MICHAEL J RIVERA, CARLOS view top 100 |
| ORIGINAL_EMPLOYMENT_DTE | original_employment_dte | text | ORIGINAL EMPLOYMENT DATE | null 1/1/1995 8/25/2023 1/16/2024 1/27/2024 view top 100 |
| SALARY_HOURLY_RATE | salary_hourly_rate | number | Depending on the value in the column Compensation Method, the value in this column is either the annual salary, hourly rate or a daily rate for the employee at the end of the reporting period. When the compensation method is ‘Part Time’ the salary listed has been adjusted to represent the part time percentage. | 0 83030.16 92011.89 76393.06 40000 view top 100 |
| MASTER_DEPARTMENT_AGENCY_DESC | master_department_agency_desc | text | Discrete organization within the State of New Jersey associated with the employee at the end of the reporting period. | HUMAN SERVICES JUDICIARY CORRECTIONS LAW AND PUBLIC SAFETY CHILDREN AND FAMILIES view top 100 |
| MASTER_SECTION_DESC | master_section_desc | text | The area of the department to which the employee is assigned at the end of the reporting period. | STATE POLICE - ENLISTED PERSONNEL CENTRAL OFFICE JUDICIARY ANCORA PSYCHIATRIC HOSPITAL SOUTHERN REGION view top 100 |
| MASTER_TITLE_DESC | master_title_desc | text | The title is a descriptive name that identifies a position or group of positions with similar duties, responsibilities and qualifications. This is the title associated with the employee at the end of the reporting period. | SPECIAL SERVICES SENIOR CORRECTION OFFICER FAMILY SERVICE SPECIALIST 2 SR CRRECTNL POLC OFCR HUMAN SERVICES ASSISTANT view top 100 |
| EMPLOYEE_RELATIONS_GROUP | employee_relations_group | text | Classification indicating whether employee is aligned or not aligned with a union and what type of work that unit performs. This grouping determines what salary and benefits the employee receives. This is the employee relations group associated with the employee at the end of the reporting period. | PROFESSIONAL UNIT (CWA) - UNIT P PRIMARY LEVEL SUPERVISORS (CWA) - UNIT R HEALTH CARE AND REHABILITATION SERVICES (AFSCME) - UNIT H ADMINISTRATIVE AND CLERICAL SERVICES (CWA) - UNIT A LAW ENFORCEMENT, CORRECTIONS (PBA) - UNIT L view top 100 |
| COMPENSATION_METHOD | compensation_method | text | Identifies the basis by which an employee’s regular pay will be calculated. This is the compensation method associated with the employee at the end of the reporting period. | ANNUAL SALARY HOURLY None Listed PART TIME PER DIEM view top 100 |
| MASTER_YTD_REGULAR_PAY | master_ytd_regular_pay | number | The sum of wages for one or more departments/agencies that are earned by an employee for working a predetermined number of hours or days in a week as dictated by the employee’s title during the reporting period. | 0 27321.78 80846.97 84605.6 80027.67 view top 100 |
| MASTER_YTD_OVERTIME_PAYMENTS | master_ytd_overtime_payments | number | The sum of overtime wages for one or more departments/agencies by an employee during the reporting period. | 0 496.16 1819.2 1364.4 229.92 view top 100 |
| MASTER_YTD_ALL_OTHER_PAYMENTS | master_ytd_all_other_payments | number | The sum of wages for one or more departments/agencies that are earned by an employee not listed under regular pay or overtime payments during the reporting period. | 0 550 917.5 1000 450 view top 100 |
| MASTER_YTD_EARNINGS | master_ytd_earnings | number | Sum of all payments for the employee during the reporting period; that is, the sum of the previous three columns. | 0 49000 15000 300 30129.73 view top 100 |
| PAID_DEPARTMENT_AGENCY_DESC | paid_department_agency_desc | text | Discrete organization within the State of New Jersey that made payments to the employee. | null HUMAN SERVICES JUDICIARY CORRECTIONS LAW AND PUBLIC SAFETY view top 100 |
| PAID_SECTION_DESC | paid_section_desc | text | The area of the paid department that made payment to the employee. | null STATE POLICE - ENLISTED PERSONNEL CENTRAL OFFICE JUDICIARY ANCORA PSYCHIATRIC HOSPITAL view top 100 |
| REGULAR_PAY | regular_pay | number | Wages earned by an employee for working a predetermined number of hours or days in a week as dictated by the employee’s title. | 0 27321.78 80846.97 80027.67 84605.6 view top 100 |
| SUPPLEMENTAL_PAY | supplemental_pay | number | Wages paid to an employee that were not included in regular pay. In some existing state contracts, supplemental payments for overtime are required. Includes lump sum payments of unused vacation leave, compensatory time, and personal leave bank time. | 0 300 200 100 353.89 view top 100 |
| ONE_TIME_PAYMENTS | one_time_payments | number | Wages paid as bonus and one-time payments or shift differential for employees working night or evening shifts. | 0 450 650 1000 750 view top 100 |
| LEGISLATOR_OR_BACK_PAY | legislator_or_back_pay | number | Wages paid to an employee as determined by the Merit System Board or other legal decision. Also used for Legislators and Legislative Aides pay. | 0 49000 5000 10000 1000 view top 100 |
| OVERTIME_PAYMENTS | overtime_payments | number | Overtime wages. | 0 389.28 496.16 1819.2 2345.28 view top 100 |
| CLOTHING_UNIFORM_PAYMENTS | clothing_uniform_payments | number | Wages paid to eligible employees for clothing and uniform purchase and maintenance. | 0 550 700 1100 917.5 view top 100 |
| RETROACTIVE_PAY | retroactive_pay | number | Wages paid to an employee for a salary adjustment with a prior effective date. | 0 1255.5 2799.8 1042.2 1995 view top 100 |
| LUMP_SUM_PAY | lump_sum_pay | number | Wages paid to an employee upon retirement for any unused sick leave accrued. The maximum payout is $15,000 per employee. | 0 15000 64 39.51 43.1 view top 100 |
| CASH_IN_LIEU_MAINTENANCE | cash_in_lieu_maintenance | number | Contractual biweekly payment for State Police Employee Relations Groups. | 0 12626.12 13546.16 13624.84 14093.78 view top 100 |
| YTD_EARNINGS | ytd_earnings | number | Sum of all payments for the employee by paid_department_agency_desc and paid_section_desc during the reporting period. | 0 1167.69 49000 15000 300 view top 100 |
| RECORD_TYPE | record_type | text | Identifies master or detail record for an employee. | DETAIL MASTER view top 100 |